// 增删改
public void update(String sql, Object... params)
{
Connection conn = getConn();
PreparedStatement pstmt = null;
try
{
pstmt = conn.prepareStatement(sql);
setParams(pstmt, params);
pstmt.executeUpdate();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
close(null, pstmt, null);
}
}
// 增删改
public void update(String sql, Object... params)
{
Connection conn = getConn();
PreparedStatement pstmt = null;
try
{
pstmt = conn.prepareStatement(sql);
setParams(pstmt, params);
pstmt.executeUpdate();
}
catch (SQLException e)
{
e.printStackTrace();
}
finally
{
close(null, pstmt, conn);
}
}
问题描述:当更新的数据量200多条的时候出现更新只是操作几条数据而已。