fyNYtUpu

1SQLiteDatabase sampleDB =  this.openOrCreateDatabase(SAMPLE_DB_NAME, MODE_PRIVATE, null);
2          Cursor c = sampleDB.rawQuery("SELECT Password FROM " +
3                  "password" +
4                  " where Username = 'clicklock'", null);
5	
6public void onCreate(Bundle savedInstanceState)
7    {
8        super.onCreate(savedInstanceState);
9        setContentView(R.layout.main);
10        logm("App started");
11
12        String chreturn=Make_db();
13        Toast.makeText(getApplicationContext(),chreturn,Toast.LENGTH_LONG).show();
14
15        checkDataBase();       
16
17}
18
19 public String Make_db()
20    {
21   String errormsg = "";
22   SQLiteDatabase sampleDB =  this.openOrCreateDatabase(SAMPLE_DB_NAME, MODE_PRIVATE, null);
23   try {
24        sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
25                PASSWORD +
26                " (Username VARCHAR, Password VARCHAR);");
27
28        sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +            PHOTO + " (photoname VARCHAR, photopath VARCHAR,id INTEGER PRIMARY KEY);");
29           msg ="DatabaseCreated";
30       } catch (SQLiteException se ) {
31        Log.e(getClass().getSimpleName(), "Could not create or Open the database");
32        msg ="Not Done Error With Database";
33       }
34 return msg;
35
36   }
37   public  String checkDataBase() {
38
39    try
40    {
41        SQLiteDatabase sampleDB =  this.openOrCreateDatabase(SAMPLE_DB_NAME, MODE_PRIVATE, null);
42      Cursor c = sampleDB.rawQuery("SELECT Password FROM " +
43              "password" +
44              " where Username = 'clicklock'", null);
45
46      String password_db = c.getString(c.getColumnIndex("password"));
47        if(password_db=="")
48        {
49
50            Intent i = new Intent(CameraLaunch.this, MyNewScreen.class);                
51            startActivity(i);               
52        }
53        else if(password_db=="123123")
54        {               
55            Intent i = new Intent(CameraLaunch.this, MyNewScreen.class);                
56            startActivity(i);       
57        }
58
59
60      return "working";
61    }
62     catch (SQLiteException se ) {
63         Log.e(getClass().getSimpleName(), "Could not create or Open the database");
64         Make_db();
65         return "Could not create or Open the database";
66     }        
67}