JdbcSingleton/JdbcSingletonDemo.java at master · dahal4/JdbcSingleton · 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
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package jdbcSingleton;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

/**
 *
 * @author manish
 */
public class JdbcSingletonDemo {

    static int count = 1;
    static int choice;

    public static void main(String[] args) throws IOException {
        JdbcSingleton jdbc = JdbcSingleton.getInstance();
        BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
        do {
            System.out.println("DATABASE OPERATIONS");
            System.out.println(" --------------------- ");
            System.out.println(" 1. Insertion ");
            System.out.println(" 2. View      ");
            System.out.println(" 3. Delete    ");
            System.out.println(" 4. Update    ");
            System.out.println(" 5. Exit      ");

            System.out.print("\n");
            System.out.print("Please enter your choice: ");

            choice = Integer.parseInt(br.readLine());
            switch (choice) {

                case 1: {
                    System.out.println("Enter the employee id:");
                    int eid = Integer.parseInt(br.readLine());
                    System.out.print("Enter the employee name : ");
                    String username = br.readLine();
                    System.out.print("Enter employee age: ");
                    int age = Integer.parseInt(br.readLine());

                    try {
                        int i = jdbc.insert(eid, username, age);
                        if (i > 0) {
                            System.out.println((count++) + " Data has been inserted successfully");
                        } else {
                            System.out.println("Data has not been inserted ");
                        }

                    } catch (Exception e) {
                        System.out.println(e);
                    }

                    System.out.println("Press Enter key to continue...");
                    System.in.read();

                }//End of case 1
                break;
                //view
                case 2: {

                    try {
                        jdbc.view();
                    } catch (Exception e) {
                        System.out.println(e);
                    }
                    System.out.println("Press Enter key to continue...");
                    System.in.read();

                }//End of case 2
                break;
                //delete
                case 3: {
                    System.out.print("Enter the employee id,  you want to delete: ");
                    int userid = Integer.parseInt(br.readLine());

                    try {
                        int i = jdbc.delete(userid);
                        if (i > 0) {
                            System.out.println((count++) + " Data has been deleted successfully");
                        } else {
                            System.out.println("Data has not been deleted");
                        }

                    } catch (Exception e) {
                        System.out.println(e);
                    }
                    System.out.println("Press Enter key to continue...");
                    System.in.read();

                }//End of case 3
                break;
                case 4: {
                    System.out.print("Enter the employee id,  you want to update: ");
                    int eid = Integer.parseInt(br.readLine());
                    System.out.print("Enter the new name: ");
                    String name = br.readLine();
                    System.out.print("Enter the new age ");
                    int age = Integer.parseInt(br.readLine());

                    try {
                        int i = jdbc.update(eid, name, age);
                        if (i > 0) {
                            System.out.println((count++) + " Data has been updated successfully");
                        }

                    } catch (Exception e) {
                        System.out.println(e);
                    }
                    System.out.println("Press Enter key to continue...");
                    System.in.read();

                }// end of case 4
                break;

                default:
                    return;
            }
        } while (choice != 4);

    }

}