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);
}
}
}
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);
}
}
}