生成自动的主键值

来源：互联网发布：淘宝直通车在哪里看编辑：程序博客网时间：2024/06/02 23:42

package com.yucheng.jdbc;

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

import org.junit.Test;

public class JdbcTest {

   /**
   * 得到主键值
   */
   @Test
   public void testGetKeyValue() {

       Connection conn=null;
       PreparedStatement preStatement=null;
       ResultSet resultSet=null;
       try {
           conn=JDBCTools.getConnecition();
           String sql="insert into person(name) values(?)";
           preStatement=conn.prepareStatement(sql,
                   Statement.RETURN_GENERATED_KEYS);

           preStatement.setString(1, "meimei");

           preStatement.executeUpdate();

           resultSet=preStatement.getGeneratedKeys();
           if(resultSet.next()){
               System.out.println(resultSet.getObject(1));
           }

       } catch (Exception e) {
           e.printStackTrace();
       }finally{
           JDBCTools.release(preStatement, conn, resultSet);
       }
   }

}

0 0