jdbc 4.0
时间：2021-07-01 10:21:17
帮助过：8人阅读
package com.rong.jielong;
2
3 import java.sql.Connection;
4 import java.sql.Date;
5 import java.sql.DriverManager;
6 import java.sql.PreparedStatement;
7 import java.sql.Time;
8 import java.sql.Timestamp;
9 import java.util.Calendar;
10 import java.util.Properties;
11
12 public class Test7 {
13
14 /**
15 * @author 容杰龙
16 */
17 public static void main(String[] args) {
18 try {
19 Class.forName("com.mysql.jdbc.Driver"
);
20 String url="jdbc:mysql://localhost:3306/rjl"
;
21 Properties info=
new Properties();
22 info.setProperty("user", "rjl"
);
23 info.setProperty("password", "123"
);
24 Connection conn =
DriverManager.getConnection(url, info);
25 String sql="insert into time values(?,?,?,?,?)"
;
26 //java.util.Date包含的信息有 年-月-日 时：分：秒
27 PreparedStatement ps =
conn.prepareStatement(sql);
28 //数据库的date类型 2017-11-04 =======java.sql包的Date
29 ps.setDate(1,
new Date(
new java.util.Date().getTime()));
30
31 //数据库的time类型 21:22:19=======java.sql包的Time
32 ps.setTime(2,
new Time(
new java.util.Date().getTime()));
33
34 //数据库的timestamp类型 2017-11-04 21:22:19======java.sql包的Timestamp
35 ps.setTimestamp(3,
new Timestamp(
new java.util.Date().getTime()));
36
37 //数据库的datatime类型 2017-11-04 21:22:19======java.sql包的Timestamp
38 ps.setTimestamp(4,
new Timestamp(
new java.util.Date().getTime()));
39
40 //数据库的year类型 2017========java的无符号整数
41 ps.setInt(5
, Calendar.getInstance().get(Calendar.YEAR));
42
43 int count =
ps.executeUpdate();
44 if (count>0
) {
45 System.out.println("添加成功！"
);
46 }
else{
47 System.out.println("添加失败！"
);
48 }
49
50 ps.close();
51 conn.close();
52 }
catch (Exception e) {
53 e.printStackTrace();
54 }
55 }
56
57 }
2.读取数据库各种时间
1 package com.rong.jielong;
2
3 import java.sql.Connection;
4 import java.sql.Date;
5 import java.sql.DriverManager;
6 import java.sql.PreparedStatement;
7 import java.sql.ResultSet;
8 import java.sql.Time;
9 import java.sql.Timestamp;
10
11 public class Test8 {
12
13 /**
14 * @author 容杰龙
15 */
16 public static void main(String[] args) {
17 try {
18 Class.forName("com.mysql.jdbc.Driver");
19 String url = "jdbc:mysql://127.0.0.1:3306/rjl";
20 String user = "rjl";
21 String password = "123";
22 Connection conn = DriverManager.getConnection(url, user, password);
23 // 取第一条数据
24 String sql = "select * from time limit 0,1";
25 PreparedStatement ps = conn.prepareStatement(sql);
26 ResultSet rs = ps.executeQuery();
27 while (rs.next()) {
28 // 从查询的结果集中获取时间对象
29 Date date = rs.getDate("date");
30 Time time = rs.getTime("time");
31 Timestamp timestamp = rs.getTimestamp("timestamp");
32 Timestamp datetime = rs.getTimestamp("datetime");
33
34 int year = rs.getInt("year");
35
36 System.out.println(date + "###" + time + "###" + timestamp
37 + "###" + datetime + "###" + year);
38 // 输出2017-11-04###21:22:19###2017-11-04 21:22:19.0###2017-11-04
39 // 21:22:19.0###2017
40 }
41 } catch (Exception e) {
42 e.printStackTrace();
43 }
44
45 }
46
47 }
jdbc 4.0
标签：long new auth select resultset class mes com 4.0
