TEWueD4A

1package com.example.lab7;
2
3import androidx.appcompat.app.AlertDialog;
4import androidx.appcompat.app.AppCompatActivity;
5
6import android.content.Context;
7import android.content.DialogInterface;
8import android.content.Intent;
9import android.database.sqlite.SQLiteDatabase;
10import android.os.Bundle;
11import android.view.View;
12import android.widget.Button;
13import android.widget.EditText;
14import android.widget.Toast;
15
16public class MainActivity extends AppCompatActivity {
17    EditText leftNameET;
18    EditText leftDeptET;
19    EditText leftYearET;
20    Button leftAddButton;
21    EditText rightNameET;
22    EditText rightDeptET;
23    EditText rightYearET;
24    Button rightAddButton;
25    Button viewDBButton;
26    public static SQLiteDatabase leftSqlDB;
27    public static SQLiteDatabase rightSqlDB;
28
29    @Override
30    protected void onCreate(Bundle savedInstanceState) {
31        super.onCreate(savedInstanceState);
32        setContentView(R.layout.activity_main);
33        leftSqlDB = openOrCreateDatabase("LeftDB", Context.MODE_PRIVATE, null);
34        leftSqlDB.execSQL(
35                "create table if not exists leftTable(id varchar, dept varchar, year varchar);"
36        );
37
38        rightSqlDB = openOrCreateDatabase("RightDB", Context.MODE_PRIVATE, null);
39        rightSqlDB.execSQL(
40                "create table if not exists rightTable(id varchar, dept varchar, year varchar);"
41        );
42        leftNameET = findViewById(R.id.leftNameET);
43        leftDeptET = findViewById(R.id.leftDeptET);
44        leftYearET = findViewById(R.id.leftYearET);
45
46
47        rightNameET = findViewById(R.id.rightNameET);
48        rightDeptET = findViewById(R.id.rightDeptET);
49        rightYearET = findViewById(R.id.rightYearET);
50
51
52
53        leftAddButton = findViewById(R.id.leftAddButton);
54        leftAddButton.setOnClickListener(new View.OnClickListener(){
55            @Override
56            public void onClick(View v){
57
58                if(leftNameET.getText().toString().matches("") || leftDeptET.getText().toString().matches("") || leftYearET.getText().toString().matches("")){
59                    Toast.makeText(getApplicationContext(), R.string.incomplete, Toast.LENGTH_SHORT).show();
60                }
61                else {
62                    leftSqlDB.execSQL("INSERT INTO leftTable values('" + leftNameET.getText() + "', '" + leftDeptET.getText() + "', '" + leftYearET.getText() + "');");
63                    AlertDialog.Builder alertDialog = new AlertDialog.Builder(MainActivity.this);
64                    alertDialog.setTitle("The following student has been added");
65                    alertDialog.setMessage("Name: " + leftNameET.getText() + " Dept: " + leftDeptET.getText() + " Year: " + leftYearET.getText() + "\n");
66                    alertDialog.setNeutralButton("CLOSE", new DialogInterface.OnClickListener() {
67                        @Override
68                        public void onClick(DialogInterface dialog, int which) {
69
70                        }
71                    });
72                    alertDialog.show();
73
74                }
75                leftNameET.setText("");
76                leftDeptET.setText("");
77                leftYearET.setText("");
78            }
79        });
80        rightAddButton = findViewById(R.id.rightAddButton);
81        rightAddButton.setOnClickListener(new View.OnClickListener(){
82            @Override
83            public void onClick(View v){
84
85                if(rightNameET.getText().toString().matches("") || rightDeptET.getText().toString().matches("") || rightYearET.getText().toString().matches("")){
86                    Toast.makeText(getApplicationContext(), R.string.incomplete, Toast.LENGTH_SHORT).show();
87                }
88                else {
89                    rightSqlDB.execSQL("INSERT INTO rightTable values('" + rightNameET.getText() + "', '" + rightDeptET.getText() + "', '" + rightYearET.getText() + "');");
90                    AlertDialog.Builder alertDialog = new AlertDialog.Builder(MainActivity.this);
91                    alertDialog.setTitle("The following student has been added");
92                    alertDialog.setMessage("Name: " + rightNameET.getText() + " Dept: " + rightDeptET.getText() + " Year: " + rightYearET.getText() + "\n");
93                    alertDialog.setNeutralButton("CLOSE", new DialogInterface.OnClickListener() {
94                        @Override
95                        public void onClick(DialogInterface dialog, int which) {
96
97                        }
98                    });
99                    alertDialog.show();
100
101                }
102
103
104                rightNameET.setText("");
105                rightDeptET.setText("");
106                rightYearET.setText("");
107            }
108        });
109        viewDBButton = findViewById(R.id.viewDBButton);
110        viewDBButton.setOnClickListener(new View.OnClickListener(){
111            @Override
112            public void onClick(View v){
113                Intent intent = new Intent(MainActivity.this, ViewActivity.class);
114
115                startActivity(intent);
116            }
117        });
118    }
119}