DBUtil之删除数据

/** * 实现满足条件的删除单条数据 * @param con * @param sql * @param param * @return */ public static int remove(Connection con,String sql,Object... param) throws Exception{ ps = con.prepareStatement(sql); for (int i=0;i<param.length;i++) { ps.setObject(i+1, param); } return ps.executeUpdate(); } /** * 根据单个字段实现批量删除 * @param con * @param sql * @param param * @return * @throws Exception */ public static int remove(Connection con,StringBuffer sql,Set<Object> ids) throws Exception{ Iterator<Object> iterator= ids.iterator(); while(iterator.hasNext()){ sql.append(iterator.next()+","); } sql.delete(sql.length()-1, sql.length()); sql.append(")"); ps = con.prepareStatement(sql.toString()); return ps.executeUpdate(); }