Blood-Bank-Management-System/Donor.java at main · aparnasdev/Blood-Bank-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
package bb_management;

import java.sql.*;
import java.util.*;

public class Donor implements User {
	private Connection connect = null;
    private Statement statement = null;
    private PreparedStatement preparedStatement = null;
    private ResultSet resultSet = null;
    Scanner obj = new Scanner(System.in);
	public void add() throws Exception {
		try {
        	Class.forName("org.postgresql.Driver");
        	connect = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BLOODBANKMANAGEMENTSYSTEM", "postgres", "amma1234");
    		preparedStatement = connect.prepareStatement("INSERT INTO DONOR VALUES (?, ?, ?, ?, ?, ?)");
    		System.out.println("Enter donor id: ");
    		String did = obj.next();
    		System.out.println("Enter donor name: ");
    		String dname = obj.next();
    		System.out.println("Enter donor age: ");
    		int dage = obj.nextInt();
    		System.out.println("Enter donor sex: ");
    		String dsex = obj.next();
    		System.out.println("Enter donor street: ");
    		String dstreet = obj.next();
    		System.out.println("Enter donor city: ");
    		String dcity = obj.next();
    		preparedStatement.setString(1, did);
    		preparedStatement.setString(2, dname);
    		preparedStatement.setInt(3, dage);
    		preparedStatement.setString(4, dsex);
    		preparedStatement.setString(5, dstreet);
    		preparedStatement.setString(6, dcity);
    		preparedStatement.executeUpdate();
        } catch (Exception e) {
            throw e;
        } finally {
            close();
        }
	}
	public void delete(String did) throws Exception {
		try {
        	Class.forName("org.postgresql.Driver");
        	connect = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BLOODBANKMANAGEMENTSYSTEM", "postgres", "amma1234");
    		preparedStatement = connect.prepareStatement("DELETE FROM DONOR WHERE DID = ?");
    		preparedStatement.setString(1, did);
    		preparedStatement.executeUpdate();
        } catch (Exception e) {
            throw e;
        } finally {
            close();
        }
	}
	public void edit(String did) throws Exception {
		try {
			Class.forName("org.postgresql.Driver");
        	connect = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BLOODBANKMANAGEMENTSYSTEM", "postgres", "amma1234");
    		preparedStatement = connect.prepareStatement("UPDATE DONOR SET DNAME = ?, DAGE = ?, "
    				+ "DSEX = ?, DSTREET = ?, DCITY = ? WHERE DID = ?");
    		preparedStatement.setString(6, did);
    		System.out.println("Enter donor name: ");
    		String dname = obj.next();
    		System.out.println("Enter donor age: ");
    		int dage = obj.nextInt();
    		System.out.println("Enter donor sex: ");
    		String dsex = obj.next();
    		System.out.println("Enter donor street: ");
    		String dstreet = obj.next();
    		System.out.println("Enter donor city: ");
    		String dcity = obj.next();
    		preparedStatement.setString(1, dname);
    		preparedStatement.setInt(2, dage);
    		preparedStatement.setString(3, dsex);
    		preparedStatement.setString(4, dstreet);
    		preparedStatement.setString(5, dcity);
    		preparedStatement.executeUpdate();
        } catch (Exception e) {
            throw e;
        } finally {
            close();
        }
	}
	public void search(String did) throws Exception {
		try {
        	Class.forName("org.postgresql.Driver");
        	connect = DriverManager.getConnection("jdbc:postgresql://localhost:5432/BLOODBANKMANAGEMENTSYSTEM", "postgres", "amma1234");
    		preparedStatement = connect.prepareStatement("SELECT * FROM DONOR WHERE DID = ?");
    		preparedStatement.setString(1, did);
    		resultSet = preparedStatement.executeQuery();
            writeResultSet(resultSet);
        } catch (Exception e) {
            throw e;
        } finally {
            close();
        }
	}
	private void writeResultSet(ResultSet resultSet) throws SQLException {
        while (resultSet.next()) {
            String id = resultSet.getString("DID");
            String name = resultSet.getString("DNAME");
            int age = resultSet.getInt("DAGE");
            String sex = resultSet.getString("DSEX");
            String street = resultSet.getString("DSTREET");
            String city = resultSet.getString("DCITY");
            System.out.println("ID: " + id);
            System.out.println("NAME: " + name);
            System.out.println("AGE: " + age);
            System.out.println("SEX: " + sex);
            System.out.println("STREET: " + street);
            System.out.println("CITY: " + city);
        }
    }
	private void close() throws SQLException {
    	if (resultSet != null) {
    		resultSet.close();
    	}
    	if (preparedStatement != null) {
    		preparedStatement.close();
    	}
    	if (statement != null) {
    		statement.close();
    	}
    	if (connect != null) {
    		connect.close();
    	}
    }
}