获取结果集数量
boolean res = resultSet.last(); //移到最后一行
int count = resultSet.getRow(); //得到当前行号,也就是记录数
resultSet.beforeFirst(); //如果还要用结果集,就把指针再移到初始化的位置
获取插入记录 id
preparedStatement = conn.prepareStatement(sql, Statement.RETURN_GENERATED_KEYS);
...
preparedStatement.executeUpdate();
ResultSet resultSet = preparedStatement.getGeneratedKeys();
if (resultSet.next()) {
int id = resultSet.getInt(1);
}
批量插入:
for (Element element : elements) {
...
preparedStatement.setInt(1, imgId);
preparedStatement.setString(2, url);
preparedStatement.addBatch();
}
preparedStatement.executeBatch();
preparedStatement.close();
参考:
http://blog.csdn.net/u014726937/article/details/51741617
http://www.cnblogs.com/kahreman/archive/2012/08/06/2625827.html