表结构:
create table test(
id varchar2(32) primary key,
name varchar2(32)
);import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
public static void main(String[] args) {
PreparedStatement pst = null;
ResultSet rs = null;
Connection conn = ConnectionManager.getConnection();
String sql = "insert into test(id,name) values(?,?)";
try {
//String generatedColumns[] = { "ID" }; //获得指定ID
pst = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS); // 指定返回生成的主键
pst.setString(1, "123x");
pst.setString(2, "test");
int ii = pst.executeUpdate();
// 检索对象生成的键
rs = pst.getGeneratedKeys();
if (rs.next()) {
System.out.println("数据主键:" + rs.getString(1));
}
ConnectionManager.closeAll(rs, pst, conn); // 关闭资源
} catch (SQLException e) {
e.printStackTrace();
}
}
}以下是JDBC辅助类,不是本文重点import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ConnectionManager {
public static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
public static final String URL = "jdbc:oracle:thin:@localhost:1521/orcl";
public static final String USERNAME = "root";
public static final String PASSWORD = "root";
static{
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection() {
Connection conn = null;
try {
conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);
}catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeResultSet(ResultSet rs) {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void closeStatement(Statement st) {
if (st != null) {
try {
st.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void closeConnection(Connection conn) {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static void closeAll(ResultSet rs,Statement sta,Connection conn){
closeConnection(conn);
closeStatement(sta);
closeResultSet(rs);
}
}
控制台打印:数据主键:AAAT2zAANAAACalAAB而我们的主键是ID值为123x.那打印的AAAT2zAANAAACalAAB是什么玩意呢,使用rs.getObject(1)在控制台打印,显示如下:
其实是test表的ROWID字段值
![](https://img.laitimes.com/img/__Qf2AjLwojIjJCLyojI0JCLicmbw5SOkR2Y5AjZjNDNlFDOmZDZiVzMhRmZkdDOmNjZ3gTZh9CX0JXZ252bj91Ztl2Lc52YucWbp5GZzNmLn9Gbi1yZtl2Lc9CX6MHc0RHaiojIsJye.png)
如果要获得指定的ID字段值 可以用如下方法:String generatedColumns[] = { "ID" };
pst = conn.prepareStatement(sql, generatedColumns);
原文:http://blog.csdn.net/itmyhome1990/article/details/41600309