4kHgp9Ji

1public DataBaseHelper(Context context) {
2        super(context, DATABASE_NAME, null, version);
3    }
4
5    @Override
6    public void onCreate(SQLiteDatabase db) {
7
8            String q = "CREATE TABLE IF NOT EXISTS " + TABLE_NAMETRY + "(" +
9                    COL_ID + " INTEGER PRIMARY KEY, " + COL_NAME + " TEXT, " + COL_PHONE + " TEXT " + ")";`enter code here`
10            db.execSQL(q);
11    }
12    @Override
13
14    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
15        db.execSQL("DROP table if exist "+TABLE_NAMETRY);
16        onCreate(db);
17    }
18
19    public boolean insertData(String name,String no)
20    {
21        SQLiteDatabase db = this.getWritableDatabase();
22        ContentValues contentvalue = new ContentValues();
23        contentvalue.put(COL_NAME,name);
24        contentvalue.put(COL_PHONE,no);
25       long result = db.insert(TABLE_NAMETRY,null,contentvalue);
26        if(result==-1)
27        return false;
28        else
29            return true;
30    }
31	
32ublic class MainActivity extends AppCompatActivity {
33    DataBaseHelper mydb;
34    EditText name,no;
35    Button b1;
36    TextView t1;
37
38    @Override
39    protected void onCreate(Bundle savedInstanceState) {
40        super.onCreate(savedInstanceState);
41        setContentView(R.layout.activity_main);
42        mydb=new DataBaseHelper(this);
43
44        name=(EditText)findViewById(R.id.name);
45        no=(EditText)findViewById(R.id.no);
46        t1=(TextView)findViewById(R.id.t1);
47        b1=(Button)findViewById(R.id.b1);
48
49        b1.setOnClickListener(new View.OnClickListener() {
50            @Override
51            public void onClick(View view) {
52                Toast.makeText(MainActivity.this, "Adding Data", Toast.LENGTH_SHORT).show();
53                AddData();
54            }
55        });
56    }
57    public void AddData()
58    {
59        boolean check= mydb.insertData(name.getText().toString(),no.getText().toString());
60        if(check==true)
61            t1.setText("data submitted");
62        else
63            t1.setText("data not submitted");
64
65    }
66}