简单记录下，爬虫项目中需要用到的，细节代码就不贴出来了。
/**
* 增加、删除、改
* @param sql
* @param params
* @return
* @throws SQLException
*/
public static Integer updateByPreparedStatement(String sql, List<Object>params)throws SQLException{
int result = -1;
pstmt = connection.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
int index = 1;
if(params != null && !params.isEmpty()){
for(int i=0; i<params.size(); i++){
pstmt.setObject(index++, params.get(i));
}
}
result = pstmt.executeUpdate();
ResultSet rs = pstmt.getGeneratedKeys();
Integer key = null;
if(rs.next()) {
key = rs.getInt(1);
}
return key;
}
