测试脚本如下：

1  create table test12 (3      id int primary key auto_increment,4      name varchar(20)5 );

 

测试代码：

package me.tanlei.demo;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import me.tanlei.jdbc.jdbcUtils;public class Test {   public static void main(String[] args) {    Connection connection=null;    PreparedStatement pStatement=null;    ResultSet resultSet=null;        try {        connection=jdbcUtils.getConnection();       String sql="insert into test1(name) values(?)";       pStatement=connection.prepareStatement(sql);       pStatement.setString(1, "aaa");       pStatement.executeUpdate();       //获取数据库自动生成的主键       resultSet=pStatement.getGeneratedKeys();       if(resultSet.next()) {           System.out.println(resultSet.getInt(1));       }    } catch (SQLException e) {        // TODO Auto-generated catch block        e.printStackTrace();    }finally {        jdbcUtils.release(connection, pStatement, resultSet);    }    }}