学习笔记——base标签、加密方式、JDBC、将java中添加的数据增加到数据库中

 1 Scanner input = new Scanner(System.in);
 2 System.out.println("请输入姓名：");
 3 String ename = input.next();
 4 
 5 System.out.println("请输入薪资：");
 6 double salary = input.nextDouble();
 7 
 8 System.out.println("请输入出生日期：");
 9 String birthday = input.next();
10 
11 System.out.println("请输入性别：");
12 String gender = input.next();
13 
14 System.out.println("请输入手机号码：");
15 String tel = input.next();
16 
17 
18 System.out.println("请输入邮箱：");
19 String email = input.next();
20 
21 
22 input.close();
23 
24 String url = "jdbc:mysql://localhost:3306/数据库?serverTimezone=UTC";
25 Connection conn = DriverManager.getConnection(url, "数据库的用户名", "数据库的连接密码");
26 
27 String sql = "INSERT INTO t_employee(ename,salary,birthday,gender,tel,email,hiredate) VALUES(?,?,?,?,?,?,?)";
28 PreparedStatement pst = conn.prepareStatement(sql);
29 
30 pst.setObject(1,ename);
31 pst.setObject(2,salary);
32 pst.setObject(3,birthday);
33 pst.setObject(4,gender);
34 pst.setObject(5,tel);
35 pst.setObject(6,email);
36 pst.setObject(7,new Date());
37 
38 int len = pst.executeUpdate();
39 System.out.println(len>0?"添加成功":"添加失败");
40 pst.close();
41 conn.close();