-
Notifications
You must be signed in to change notification settings - Fork 0
/
Jdbc_connection.java
56 lines (44 loc) · 1.45 KB
/
Jdbc_connection.java
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
package internshala.jdbc;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
public class Jdbc_connection
{
public static void main(String[] args) {
// TODO Auto-generated method stub
try {
Class.forName("com.mysql.cj.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/employee_mgmt","root","$20AZ3530Mos");
PreparedStatement psmt = con.prepareStatement("insert into employee values(?,?,?)");
//to read the user input
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));
while(true)
{
System.out.println("Employee no:");
int eno = Integer.parseInt(br.readLine());
System.out.println("Employee name:");
String name = br.readLine();
System.out.println("Employee salary:");
int salary = Integer.parseInt(br.readLine());
psmt.setInt(1, eno);
psmt.setString(2, name);
psmt.setInt(3, salary);
int count = psmt.executeUpdate();
if(count > 0)
System.out.println(count +" record inserted");
else
System.out.println("No record found");
System.out.println("Do you want to continue ");
String ch = br.readLine();
if(ch.equalsIgnoreCase("no"))
break;
}
}
catch(Exception e)
{
System.out.println(e);
}
}
}