android sqlite tutorial for beginners

1 public void update( View view)
2    {
3        String u1 = updateold.getText().toString();
4        String u2 = updatenew.getText().toString();
5        if(u1.isEmpty() || u2.isEmpty())
6        {
7            Message.message(getApplicationContext(),"Enter Data");
8        }

1public void addUser(View view)
2    {
3        String t1 = Name.getText().toString();
4        String t2 = Pass.getText().toString();
5        if(t1.isEmpty() || t2.isEmpty())
6        {
7            Message.message(getApplicationContext(),"Enter Both Name and Password");
8        }

1package com.example.sqliteoperations;
2
3import android.support.v7.app.AppCompatActivity;
4import android.os.Bundle;
5import android.view.View;
6import android.widget.EditText;
7
8public class MainActivity extends AppCompatActivity {
9    EditText Name, Pass , updateold, updatenew, delete;
10    myDbAdapter helper;
11    @Override
12    protected void onCreate(Bundle savedInstanceState) {
13        super.onCreate(savedInstanceState);
14        setContentView(R.layout.activity_main);
15        Name= (EditText) findViewById(R.id.editName);
16        Pass= (EditText) findViewById(R.id.editPass);
17        updateold= (EditText) findViewById(R.id.editText3);
18        updatenew= (EditText) findViewById(R.id.editText5);
19        delete = (EditText) findViewById(R.id.editText6);
20
21        helper = new myDbAdapter(this);
22    }
23    public void addUser(View view)
24    {
25        String t1 = Name.getText().toString();
26        String t2 = Pass.getText().toString();
27        if(t1.isEmpty() || t2.isEmpty())
28        {
29            Message.message(getApplicationContext(),"Enter Both Name and Password");
30        }
31        else
32        {
33            long id = helper.insertData(t1,t2);
34            if(id<=0)
35            {
36                Message.message(getApplicationContext(),"Insertion Unsuccessful");
37                Name.setText("");
38                Pass.setText("");
39            } else
40            {
41                Message.message(getApplicationContext(),"Insertion Successful");
42                Name.setText("");
43                Pass.setText("");
44            }
45        }
46    }
47
48    public void viewdata(View view)
49    {
50        String data = helper.getData();
51        Message.message(this,data);
52    }
53
54    public void update( View view)
55    {
56        String u1 = updateold.getText().toString();
57        String u2 = updatenew.getText().toString();
58        if(u1.isEmpty() || u2.isEmpty())
59        {
60            Message.message(getApplicationContext(),"Enter Data");
61        }
62        else
63        {
64            int a= helper.updateName( u1, u2);
65            if(a<=0)
66            {
67                Message.message(getApplicationContext(),"Unsuccessful");
68                updateold.setText("");
69                updatenew.setText("");
70            } else {
71                Message.message(getApplicationContext(),"Updated");
72                updateold.setText("");
73                updatenew.setText("");
74            }
75        }
76
77    }
78    public void delete( View view)
79    {
80        String uname = delete.getText().toString();
81        if(uname.isEmpty())
82        {
83            Message.message(getApplicationContext(),"Enter Data");
84        }
85        else{
86            int a= helper.delete(uname);
87            if(a<=0)
88            {
89                Message.message(getApplicationContext(),"Unsuccessful");
90                delete.setText("");
91            }
92            else
93            {
94                Message.message(this, "DELETED");
95                delete.setText("");
96            }
97        }
98    }
99}