jdbc 6.0

1.获取数据库自动生成的键值

package com.rong.jielong;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Test11 {

    /**
     * 获取数据库自动生成的键值
     * 
     * @author 容杰龙
     */
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/rjl";
            String user = "rjl";
            String password = "123";
            Connection conn = DriverManager.getConnection(url, user, password);
            // MySQL自动生成的键值可先用null填补位置
            String sql = "insert into user values(null,?,?,?)";

            // 创建一个默认 PreparedStatement 对象，该对象能获取自动生成的键，适合insert语句搜索
            PreparedStatement ps = conn.prepareStatement(sql,
                    Statement.RETURN_GENERATED_KEYS);

            ps.setString(1, "hhh");
            ps.setInt(2, 22);
            ps.setString(3, "www");
            int count = ps.executeUpdate();
            if (count > 0) {
                // 获取自动生成的键值-----结果集
                ResultSet rs = ps.getGeneratedKeys();
                while (rs.next()) {
                    int autoKey = rs.getInt(1);
                    System.out.println(autoKey);
                }
            } else {
                System.out.println("获取失败！");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

}