DpiBtXvP

1public class Database extends SQLiteOpenHelper{
2
3public static final String DATABASE_NAME = "Login.db";
4public static final String TABLE_NAME = "Depot";
5public static final String COL_1 = "Name";
6public static final String COL_2 = "Username";
7public static final String COL_3 = "Password";
8public static final String COL_4 = "E_Mail";
9
10public Database(Context context)
11{
12    super(context, DATABASE_NAME, null, 1);
13
14}
15
16@Override
17public void onCreate(SQLiteDatabase db)
18{
19    db.execSQL("create table  "+ TABLE_NAME + "(" +COL_1 + "TEXT," + COL_2 + "TEXT," + COL_3 + "TEXT" + COL_4 + "TEXT" + ");");
20}
21
22@Override
23public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
24{
25    db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
26    onCreate(db);
27}
28public boolean insert_table(String name, String username , String E_mail , String password)
29{
30
31    SQLiteDatabase db=this.getWritableDatabase();
32    ContentValues contentValues=new ContentValues();
33    contentValues.put(COL_1,name);
34    contentValues.put(COL_2,username);
35    contentValues.put(COL_3,password);
36    contentValues.put(COL_4,E_mail);
37    long result = db.insert(TABLE_NAME,null,contentValues);
38    if (result==-1)
39        return false;
40    else
41        return true;
42}
43	
44public class SignUp extends AppCompatActivity
45{
46Database db;
47EditText ed1,ed2,ed3,ed4;
48@Override
49protected void onCreate(Bundle savedInstanceState)
50{
51    super.onCreate(savedInstanceState);
52    setContentView(R.layout.activity_sign_up);
53    db=new Database(this);
54}
55public void register(View V)
56{
57    boolean result = 
58 db.insert_table(ed1.getText().toString(),ed2.getText().toString(),
59 ed3.getText().toString(),ed4.getText().toString());
60    if(result==true)
61        Toast.makeText(getBaseContext(),"Account created 
62  successfully",Toast.LENGTH_LONG).show();
63    else
64        Toast.makeText(getBaseContext(),"Account not 
65   created",Toast.LENGTH_LONG).show();
66
67    Intent intent=new Intent(this , Depot.class);
68    startActivity(intent);
69}
70
71}
72	
73public class MainDatabase extends SQLiteOpenHelper
74{
75    public MainDatabase(Context context, String name, SQLiteDatabase.CursorFactory factory, int version)
76    {
77        super(context, name, null, version);
78        Log.d("MyProject :", "Database Goes here....n");
79    }
80
81    @Override
82    public void onCreate(SQLiteDatabase db)
83    {
84        // You can have multiple table create queries here, It will not create if exists already
85
86        db.execSQL( "CREATE TABLE DONOTREPEAT(ID INTEGER PRIMARY KEY AUTOINCREMENT, REMEMBER TEXT);");
87
88        Log.d("INSTAPROMO :", "Table DONOTREPEAT created or Exists already....n");
89    }
90
91    @Override
92    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
93    {
94        Log.v("INSTAPROMO :", "KIND ATTENTION DATABASE VERSION CHANGED.....!!");
95    }
96
97}
98	
99MainDatabase mDbHelper = new MainDatabase(MainActivity.this, "IPDB", null,1);
100SQLiteDatabase Write_db = mDbHelper.getWritableDatabase();
101
102long Rows = DatabaseUtils.queryNumEntries(Write_db, "DONOTREPEAT");
103
104if(Rows == 0)
105{
106    Log.d(TAG, "DONOTREPEAT rows count is zero...Inserting...");
107
108    ContentValues Time_Row = new ContentValues();
109    Time_Row.putNull("ID");
110    Time_Row.put("REMEMBER", "String_to_entered");
111
112    Write_db.beginTransaction();
113    long Inserted = Write_db.insert("DONOTREPEAT", null, Time_Row);
114    Write_db.setTransactionSuccessful();
115    Write_db.endTransaction();
116
117    if(Inserted != 1)
118    {
119        Log.d(TAG, "FAILURE : DONOTREPEAT INSERTION : "+Inserted+" INSERTED ROWS ONLYn");
120    }
121    else
122    {
123        Log.d(TAG, "SUCCESS : INSERTED ROW INTO DONOTREPEAT ....n");
124    }
125 }
126 else
127 {
128     Log.d(TAG, "DONOTREPEAT ROW having initial value...");
129 }
130 Write_db.close();
131 mDbHelper.close();