Main

1	import android.database.Cursor;
2	import android.support.v7.app.AlertDialog;
3	import android.support.v7.app.AppCompatActivity;
4	import android.os.Bundle;
5	import android.view.View;
6	import android.widget.Button;
7	import android.widget.EditText;
8	import android.widget.Toast;
9
10
11	public class MainActivity extends AppCompatActivity {
12
13	    DatabaseHelper myDb;
14	    EditText editTextId, editName,editSurname,editMarks;
15	    Button btnAddData, btngetData, btnUpdate, btnDelete, btnviewAll;
16
17	    @Override
18	    protected void onCreate(Bundle savedInstanceState) {
19	        super.onCreate(savedInstanceState);
20	        setContentView(R.layout.activity_main);
21	        myDb = new DatabaseHelper(this);
22
23	        editTextId = (EditText) findViewById(R.id.editText_id);
24	        editName = (EditText) findViewById(R.id.editText_name);
25	        editSurname = (EditText) findViewById(R.id.editText_surname);
26	        editMarks = (EditText) findViewById(R.id.editText_Marks);
27	        btnAddData = (Button) findViewById(R.id.button_add);
28	        btngetData = (Button) findViewById(R.id.button_view);
29	        btnviewAll = (Button) findViewById(R.id.button_viewAll);
30	        btnUpdate = (Button) findViewById(R.id.button_update);
31	        btnDelete = (Button) findViewById(R.id.button_delete);
32	        AddData();
33	        getData();
34	        updateData();
35	        deleteData();
36	        viewAll();
37	    }
38
39	    public void AddData(){
40	        btnAddData.setOnClickListener(new View.OnClickListener() {
41	            @Override
42	            public void onClick(View v) {
43	                boolean isInserted=myDb.insertData(editName.getText().toString(), editSurname.getText().toString(),
44	                        editMarks.getText().toString());
45	                if(isInserted == true)
46	                    Toast.makeText(MainActivity.this,"Data Inserted",Toast.LENGTH_LONG).show();
47	                else
48	                    Toast.makeText(MainActivity.this,"Data could not be Inserted",Toast.LENGTH_LONG).show();
49	            }
50	        });
51	    }
52
53	    public void getData() {
54	        btngetData.setOnClickListener(new View.OnClickListener() {
55	            @Override
56	            public void onClick(View v) {
57	                String id = editTextId.getText().toString();
58
59	                if(id.equals(String.valueOf(""))){
60	                    editTextId.setError("Enter id to get data");
61	                    return;
62	                }
63	                Cursor res = myDb.getData(id);
64	                String data = null;
65	                if (res.moveToFirst()) {
66
67	                    data = "Id:"+res.getString(0)+"\n"+
68	                            "Name :"+ res.getString(1)+"\n\n"+
69	                            "Surname :"+ res.getString(2)+"\n\n"+
70	                            "Marks :"+ res.getString(3)+"\n\n";
71	                }
72	                showMessage("Data", data);
73	            }
74	        });
75	    }
76
77	    public void viewAll(){
78	        btnviewAll.setOnClickListener(new View.OnClickListener() {
79	            @Override
80	            public void onClick(View v) {
81	                Cursor res=myDb.getAllData();
82	                if(res.getCount() == 0) {
83	                    // show message
84	                    showMessage("Error","Nothing found");
85	                    return;
86	                }
87	                StringBuffer buffer=new StringBuffer();
88	                while(res.moveToNext()){
89	                    buffer.append("Id:"+res.getString(0)+"\n");
90	                    buffer.append("Name :"+ res.getString(1)+"\n\n");
91	                    buffer.append("Surname :"+ res.getString(2)+"\n\n");
92	                    buffer.append("Marks :"+ res.getString(3)+"\n\n");
93	                }
94	                showMessage("Data",buffer.toString());
95	            }
96	        });
97	    }
98
99	    public void updateData(){
100	        btnUpdate.setOnClickListener(
101	                new View.OnClickListener() {
102	                    @Override
103	                    public void onClick(View v) {
104	                        boolean isUpdate = myDb.updateData(editTextId.getText().toString(),
105	                                editName.getText().toString(),
106	                                editSurname.getText().toString(),editMarks.getText().toString());
107	                        if(isUpdate == true)
108	                            Toast.makeText(MainActivity.this,"Data Update",Toast.LENGTH_LONG).show();
109	                        else
110	                            Toast.makeText(MainActivity.this,"Data could not be Updated",Toast.LENGTH_LONG).show();
111	                    }
112	                }
113	        );
114	    }
115
116	    public void deleteData() {
117	        btnDelete.setOnClickListener(
118	                new View.OnClickListener() {
119	                    @Override
120	                    public void onClick(View v) {
121	                        Integer deletedRows = myDb.deleteData(editTextId.getText().toString());
122	                        if(deletedRows > 0)
123	                            Toast.makeText(MainActivity.this,"Data Deleted",Toast.LENGTH_LONG).show();
124	                        else
125	                            Toast.makeText(MainActivity.this,"Data could not be Deleted",Toast.LENGTH_LONG).show();
126	                    }
127	                }
128	        );
129	    }
130
131	    private void showMessage(String title, String message) {
132	        AlertDialog.Builder builder= new AlertDialog.Builder(this);
133	        builder.create();
134	        builder.setCancelable(true);
135	        builder.setTitle(title);
136	        builder.setMessage(message);
137	        builder.show();
138	    }
139	}