Jkti1Ndc

1/////DatabaseHelper.java 
2
3
4public class DatabaseHelper  extends SQLiteOpenHelper{
5   private  static  final int db_version=2;
6   private  static  final String db_Name="SosyalMedyaDB.db";
7   private  static  final String db_table="Kisi";
8
9   private  static  final int Index_UserName=0;
10   private  static  final int Index_UserPassword=1;
11
12//Db Create 
13
14private static final String DATABASE_CREATE = "CREATE TABLE "Kisi" (
15`isim` TEXT NOT NULL, `parola` TEXT, `email` TEXT, `cinsiyet` TEXT, `tarih` 
16TEXT, `resim` INTEGER, " +
17        "`url` TEXT )";
18SQLiteDatabase db;
19public  DatabaseHelper(Context context)
20{
21    super(context,db_Name,null,db_version);
22 }
23 @Override
24 public void onCreate(SQLiteDatabase db) {
25    db.execSQL(DATABASE_CREATE);
26    this.db=db;
27  }
28public  String searchPass(String usName)
29 {
30   db=this.getReadableDatabase();
31   String query="select * from "+db_table;
32   Cursor cursor=db.rawQuery(query,null);
33   String a,b;
34   b="not found";
35   if(cursor.moveToFirst())
36   {
37       do {
38           a = cursor.getString(Index_UserName);
39           b=cursor.getString(Index_UserPassword);
40           if (a.equals(usName))
41           {
42               b = cursor.getString(Index_UserPassword);
43               db.close();
44       break;
45       }}
46           while (cursor.moveToNext());
47       }
48       return  b;
49   }
50 @Override
51   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) 
52 {
53    db.execSQL("DROP TABLE IF EXISTS "+db_table);
54    this.onCreate(db);
55  }
56 }
57
58
59 //////Login.java
60
61 public class Login extends AppCompatActivity {
62   EditText name,pass;
63   ArrayList<Kisi> uyeler;
64   String loginIsim, loginPass;
65   Intent intent;
66   DatabaseHelper dbHelper=new DatabaseHelper(this);
67   Button btnLogin;
68   String userName, userPassword;
69    @Override
70      protected void onCreate(Bundle savedInstanceState) {
71      super.onCreate(savedInstanceState);
72      setContentView(R.layout.activity_login);
73
74     name = (EditText) findViewById(R.id.loginName);
75     pass = (EditText) findViewById(R.id.password);
76     loginIsim = name.getText().toString();
77     loginPass = pass.getText().toString();
78      }
79    public void onClick(View v) {
80    switch (v.getId()) {
81        case R.id.girisBtn:
82            Log.w(".............. ","");
83           String password = dbHelper.searchPass(loginIsim);
84            Log.w("string password  ","................");
85   //Password Contol
86          if (loginPass.equals(password)) {
87              Log.w("Ä°f",".............................................");
88                intent = new Intent(this, HomePage.class);
89                startActivity(intent);
90            } else {
91                Log.w("come", "else");
92            }
93            break;
94        case R.id.uyeBtn:
95            intent = new Intent(this, Register.class);
96            startActivity(intent);
97            break;
98      }}}