package com.wanmei.meishu;
import java.sql.*;
public class OpSqliteDB {
private String url;
private Connection connection;
OpSqliteDB(String url) {
this.url = url;
}
//主要是参数Statement.RETURN_GENERATED_KEYS和方法getGeneratedKeys()的使用
Integer saveData( String sql){
try {
Class.forName("org.sqlite.JDBC");
if(connection == null) {
connection = DriverManager.getConnection(url);
}
/*
//显式设置Statement.RETURN_GENERATED_KEYS也可以
PreparedStatement preparedStatement=connection.prepareStatement("insert into class (name,sid)values(?,?)",Statement.RETURN_GENERATED_KEYS);
preparedStatement.executeUpdate();
resultSet=preparedStatement.getGeneratedKeys();
if(resultSet.next()){
id=resultSet.getInt(1);
}
return id;
*/
//测试使用的是sqlite,自增主键,这样也能获取到自动生成的主键
Statement statement = connection.createStatement();
statement.executeUpdate(sql);
ResultSet resultSet=statement.getGeneratedKeys();
if(resultSet.next()){
return resultSet.getInt(1);
}
}catch (SQLException e){
e.printStackTrace();
}catch (ClassNotFoundException e){
e.printStackTrace();
}
return -1;
}
}
看Statement的源码注释如下
/**
* Retrieves any auto-generated keys created as a result of executing this
* <code>Statement</code> object. If this <code>Statement</code> object did
* not generate any keys, an empty <code>ResultSet</code>
* object is returned.
*
*<p><B>Note:</B>If the columns which represent the auto-generated keys were not specified,
* the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
*
* @return a <code>ResultSet</code> object containing the auto-generated key(s)
* generated by the execution of this <code>Statement</code> object
* @exception SQLException if a database access error occurs or
* this method is called on a closed <code>Statement</code>
* @throws SQLFeatureNotSupportedException if the JDBC driver does not support this method
* @since 1.4
*/
ResultSet getGeneratedKeys() throws SQLException;
意为,如果没有Statement没有生产任何key,则返回空ResultSet