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; } }
Android Mssql JDBC Bağlantısı
Kaydol:
Kayıtlar (Atom)
ip = "192.168.2.1";
YanıtlaSildb = "DATABASE";
un = "user";
pass = "123456*";
Bunları neye göre yazdınız?
Kardeşim gerçekten Allah razı olsun.
YanıtlaSil