Android Mssql JDBC Bağlantısı

Android Mssql JDBC Bağlantısı

Kütüphane Eklemesi Gerekir...

<uses-permission android:name="android.permission.INTERNET" />

<LinearLayout
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:orientation="vertical">

        <TextView
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:text="Giriş Ekranı"
            android:gravity="center_horizontal"
            android:textSize="34sp"
            android:id="@+id/textView"
            android:layout_alignParentTop="true"
            android:layout_centerHorizontal="true"
            android:layout_marginTop="50dp" />

        <EditText
            android:id="@+id/et_user"
            android:layout_width="match_parent"
            android:layout_height="70dp"
            android:layout_marginTop="50dp"
            android:hint="TCNO/VERGINO" />

        <EditText
            android:id="@+id/et_sifre"
            android:layout_width="match_parent"
            android:layout_height="70dp"
            android:ems="10"
            android:hint="Şifre"
            android:inputType="textPassword" />

        <Button
            android:id="@+id/btn_giris"
            android:layout_width="match_parent"
            android:layout_height="70dp"
            android:layout_marginTop="40dp"
            android:text="Giriş" />



    </LinearLayout>
    <ProgressBar
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:id="@+id/p_bar"
        app:layout_constraintBottom_toBottomOf="parent"
        app:layout_constraintLeft_toLeftOf="parent"
        app:layout_constraintRight_toRightOf="parent"
        app:layout_constraintTop_toTopOf="parent"
        />




Main ACtivity
import android.os.AsyncTask;
import android.os.StrictMode;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ProgressBar;
import android.widget.Toast;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.xml.transform.Result;

public class MainActivity extends AppCompatActivity {
    Button btnGiris;
    EditText etKullanici,etSifre;
    ProgressBar progressBar;


    Connection sqlBaglanti;
    String un, pass, db, ip;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        btnGiris = (Button) findViewById(R.id.btn_giris);
        etKullanici = (EditText) findViewById(R.id.et_kullanici);
        etSifre = (EditText) findViewById(R.id.et_sifre);
        progressBar = (ProgressBar) findViewById(R.id.p_bar);


        progressBar.setVisibility(View.GONE);


        ip = "192.168.2.1";
        db = "DATABASE";
        un = "user";
        pass = "123456*";

        btnGiris.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {

            }
        });

    }

    public class GirisKontrol extends AsyncTask<String, String, String> {
        String z = "";
        Boolean isSuccess = false;

        @Override
        protected void onPreExecute() {

            progressBar.setVisibility(View.VISIBLE);
        }

        @Override
        protected String doInBackground(String... strings) {

            String kullanici = etKullanici.getText().toString();
            String sifre = etSifre.getText().toString();

            if (kullanici.trim().equals("") || sifre.trim().equals("")) {
                z = "Kullanıcı adi veya sifre yanlış";
            } else {

                try {
                    sqlBaglanti = connectionclass(un, pass, db, ip);
                    if (sqlBaglanti == null) {
                        z = "İnterneti Kontrol edin";
                    } else {
                        String sqlSorgu = "Select *from musteri_iletisim where tcno_vergino_ref ='" + kullanici.toString() + "' and sifre ='" + sifre.toString() + "'";
                        Statement stmt = sqlBaglanti.createStatement();
                        ResultSet rs = stmt.executeQuery(sqlSorgu);
                        if (rs.next()) {
                            z = "Giriş Başarılı";
                            isSuccess = true;
                            sqlBaglanti.close();
                        } else {
                            z = "Giriş Başarısız";
                            isSuccess = false;
                        }
                    }
                } catch (Exception ex) {
                    isSuccess = false;
                    z = ex.getMessage();
                }
            }
            return z;
        }

        @Override
        protected void onPostExecute(String s) {
            progressBar.setVisibility(View.GONE);
            Toast.makeText(MainActivity.this, s, Toast.LENGTH_SHORT).show();
            if (isSuccess) {
                Toast.makeText(MainActivity.this, "Bağlantı Başarılı", Toast.LENGTH_SHORT).show();
            }

        }
    }

    public Connection connectionclass(String un, String pass, String db, String ip) {
        StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
        StrictMode.setThreadPolicy(policy);
        Connection connection = null;
        String ConnectionURL = null;
        try {
            Class.forName("net.sourceforge.jtds.jdbc.Driver");
            ConnectionURL = "jdbc:jtds:sqlserver://"+ip+db+";user=" + un + ";password=" + pass + ";";
            connection = DriverManager.getConnection(ConnectionURL);
        } catch (SQLException se) {
            Log.e("error here 1:", se.getMessage());
        } catch (ClassNotFoundException e) {
            Log.e("error here 2:", e.getMessage());
        } catch (Exception e) {
            Log.e("error here 3:", e.getMessage());
        }
        return  connection;
    }
}