JB4CW6LC

1package com.example.patrickprakash.sqlite_android;
2
3import android.content.Intent;
4import android.database.Cursor;
5import android.database.sqlite.SQLiteDatabase;
6import android.support.v7.app.AlertDialog;
7import android.support.v7.app.AppCompatActivity;
8import android.os.Bundle;
9import android.view.View;
10import android.widget.Button;
11import android.widget.EditText;
12import android.widget.Toast;
13
14public class SqlActivity extends AppCompatActivity implements View.OnClickListener {
15    private Button insertbtn;
16    private Button updatebtn;
17    private Button viewbtn;
18    private Button deletebtn;
19    private EditText idtxt;
20    private EditText unametxt;
21    private EditText rollnotxt;
22    private String username,rollno,userid;
23    @Override
24    protected void onCreate(Bundle savedInstanceState) {
25        super.onCreate(savedInstanceState);
26        setContentView(R.layout.activity_sql);
27
28        //Button Initializer
29        insertbtn = findViewById(R.id.insertbtn);
30        updatebtn = findViewById(R.id.updatebtn);
31        viewbtn = findViewById(R.id.viewbtn);
32        deletebtn = findViewById(R.id.deletebtn);
33
34        //Edittext Intializer
35        idtxt = findViewById(R.id.idtxt);
36        unametxt = findViewById(R.id.unametxt);
37        rollnotxt = findViewById(R.id.rollnotxt);
38
39
40
41        insertbtn.setOnClickListener(this);
42        updatebtn.setOnClickListener(this);
43        viewbtn.setOnClickListener(this);
44        deletebtn.setOnClickListener(this);
45
46    }
47
48    @Override
49    public void onClick(View v) {
50        switch (v.getId()) {
51            case R.id.insertbtn:
52                username = unametxt.getText().toString();
53                rollno = rollnotxt.getText().toString();
54                userid = idtxt.getText().toString();
55                String insertsql = "insert into student values ('" + userid + "','" + username + "','" + rollno + "');";
56                String createsql = "create table if not exists student (id varchar(20),username varchar(20),rollno varchar(20));";
57                SQLiteDatabase sqLiteDatabase = openOrCreateDatabase("student.db", MODE_PRIVATE, null);
58                try {
59                    sqLiteDatabase.execSQL(createsql);
60                    /* Toast.makeText(this, "Table creation success", Toast.LENGTH_SHORT).show();*/
61                } catch (Exception e) {
62                    e.printStackTrace();
63                    /*Toast.makeText(this, "Table creation not success", Toast.LENGTH_SHORT).show();*/
64                }
65
66                try {
67                    sqLiteDatabase.execSQL(insertsql);
68                    Cursor resultset = sqLiteDatabase.rawQuery("select * from student", null);
69                    if (resultset.getCount() > 0) {
70                        resultset.moveToFirst();
71                        while (resultset.moveToNext()) {
72                            String name = resultset.getString(Integer.parseInt("1"));
73                            showMessage("Details",name);
74                        }
75                    }
76                    Toast.makeText(this, "Insertion Successful", Toast.LENGTH_SHORT).show();
77                } catch (Exception e) {
78                    e.printStackTrace();
79                    Toast.makeText(this, "Insertion Failed", Toast.LENGTH_SHORT).show();
80                }
81
82                break;
83
84            case R.id.updatebtn:
85                username = unametxt.getText().toString();
86                rollno = rollnotxt.getText().toString();
87                userid = idtxt.getText().toString();
88                String createsql1 = "create table if not exists student(id varchar(20),username varchar(20),rollno varchar(20));";
89                String updatesql = "update student set id = '" + userid + "', rollno = '" + username + "', rollno = '" + rollno + "' ;";
90                SQLiteDatabase sqLiteDatabase1 = openOrCreateDatabase("student.db", MODE_PRIVATE, null);
91                try {
92                    sqLiteDatabase1.execSQL(createsql1);
93                    /* Toast.makeText(this, "Table creation success", Toast.LENGTH_SHORT).show();*/
94                } catch (Exception e) {
95                    e.printStackTrace();
96                    Toast.makeText(this, "Table creation not success", Toast.LENGTH_SHORT).show();
97                }
98
99                try {
100                    sqLiteDatabase1.execSQL(updatesql);
101                    Toast.makeText(this, "Updation Successful", Toast.LENGTH_SHORT).show();
102                } catch (Exception e) {
103                    e.printStackTrace();
104                    Toast.makeText(this, "Updation Failed", Toast.LENGTH_SHORT).show();
105                }
106
107                break;
108
109            case R.id.viewbtn:
110                startActivity(new Intent(SqlActivity.this, ListActivity.class));
111                break;
112
113            case R.id.deletebtn:
114
115                break;
116
117        }
118
119
120        }
121    private void showMessage (String error, String msg){
122
123        AlertDialog.Builder builder = new AlertDialog.Builder(this);
124        builder.setCancelable(true);
125        builder.setTitle(error);
126        builder.setMessage(msg);
127        builder.show();
128    }
129}