2MqRwFxA

1//SQL code to initialize the user table
2//create table users (
3//        id SERIAL PRIMARY KEY,
4//        patientfirstname varchar(128) NOT NULL,
5//        patientlastname varchar(128) NOT NULL,
6//        email varchar(128) NOT NULL,
7//        diabetestype varchar(128) NOT NULL,
8//        insulintype varchar(128) NOT NULL,
9//        admintype varchar(128) NOT NULL,
10//        phonenumber varchar(32),
11//        address varchar(128) NOT NULL,
12//        doctorphonenumber varchar(128) NOT NULL
13//        );
14//insert into patients (patientfirstname,patientlastname,phonenumber) values('Jo nes','Bill','07755678899');
15
16
17import java.sql.*;
18import java.util.ArrayList;
19
20public class login {
21    public login() {
22    }
23
24    public void checkLogin(ArrayList<String> list) throws SQLException {
25        String email = list.get(0);
26        String password = list.get(1);
27
28        String dbUrl = "jdbc:postgresql://localhost:5432/postgres";
29        Connection conn = DriverManager.getConnection(dbUrl, "postgres", "**steak2424");
30
31        //Checking if email exists in database
32        String queryCheckEmail = "SELECT * from patients WHERE givenname ='%\"+email+\"%';";
33
34        Statement st = conn.createStatement();
35        ResultSet rsemail = st.executeQuery(queryCheckEmail);
36
37        if (rsemail.absolute(1)) {
38            System.out.println("email exists");
39            return;
40        } else {
41            System.out.println("Invalid email - Register?");
42        }
43
44        //Checking for password
45        String queryCheckPwd = "SELECT password from patients WHERE givenname ='%\"+password+\"%';";
46        ResultSet rspwd = st.executeQuery(queryCheckPwd);
47        String entryPwd = rspwd.getString("password");
48        if (password == entryPwd) {
49            System.out.println("User credentials match.");
50        } else {
51            System.out.println("Email and password do not match.");
52        }
53    }
54}