1.获取数据库自动生成的键值
1 package com.rong.jielong;
2
3 import java.sql.Connection;
4 import java.sql.DriverManager;
5 import java.sql.PreparedStatement;
6 import java.sql.ResultSet;
7 import java.sql.SQLException;
8 import java.sql.Statement;
9
10 public class Test11 {
11
12 /**
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 String user = "rjl";
22 String password = "123";
23 Connection conn = DriverManager.getConnection(url, user, password);
24 // MySQL自动生成的键值可先用null填补位置
25 String sql = "insert into user values(null,?,?,?)";
26
27 // 创建一个默认 PreparedStatement 对象，该对象能获取自动生成的键，适合insert语句搜索
28 PreparedStatement ps = conn.prepareStatement(sql,
29 Statement.RETURN_GENERATED_KEYS);
30
31 ps.setString(1, "hhh");
32 ps.setInt(2, 22);
33 ps.setString(3, "www");
34 int count = ps.executeUpdate();
35 if (count > 0) {
36 // 获取自动生成的键值-----结果集
37 ResultSet rs = ps.getGeneratedKeys();
38 while (rs.next()) {
39 int autoKey = rs.getInt(1);
40 System.out.println(autoKey);
41 }
42 } else {
43 System.out.println("获取失败！");
44 }
45 } catch (ClassNotFoundException e) {
46 e.printStackTrace();
47 } catch (SQLException e) {
48 e.printStackTrace();
49 }
50
51 }
52
53 }
