title: JDBC筆記
date: 2017-02-24 22:20:15
tags: JDBC
JDBC筆記
- JDBC獲取新插入數(shù)據(jù)自動生成的ID
public static <T> T executeInsert(String sql, ResultSetHandler<T> resultSetHandler,Object...param){
Connection connection = ConnectionManage.getConnection();
QueryRunner runner = new QueryRunner();
try {
return runner.insert(connection,sql,resultSetHandler,param);
} catch (SQLException e) {
e.printStackTrace();
}
finally {
close(connection);
}
return null;
}
//返回自動生成的鍵值
- ConnectionManager類
public class ConnectionMananger {
public static Connection getConnection(){
try {
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql:///RUNOOB","root","****");
return connection;
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}
