public ArrayList delete(String tableName, HashMap map) {
ArrayList list = new ArrayList();
ArrayList selectName = new ArrayList();
PreparedStatement stm = null;
ResultSet rs = null;
try {
String strSql = "delete " + tableName + "";
String strWhere = " WHERE 1 = 1";
Iterator ite = map.entrySet().iterator(); while (ite.hasNext()) {
Map.Entry mapEntry = (Map.Entry) ite.next();
String keyName = (String) mapEntry.getKey();
Object tmpObj = map.get(keyName);
if (tmpObj != null && "".equals(tmpObj)) {
strWhere = " and " + keyName + " like %" + tmpObj + "%";
}
selectName.add(keyName);
} stm = connection.prepareStatement(strSql); int i = stm.executeUpdate();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
} if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
e.getMessage();
}
}
}
return list;
}
ArrayList list = new ArrayList();
ArrayList selectName = new ArrayList();
PreparedStatement stm = null;
ResultSet rs = null;
try {
String strSql = "delete " + tableName + "";
String strWhere = " WHERE 1 = 1";
Iterator ite = map.entrySet().iterator(); while (ite.hasNext()) {
Map.Entry mapEntry = (Map.Entry) ite.next();
String keyName = (String) mapEntry.getKey();
Object tmpObj = map.get(keyName);
if (tmpObj != null && "".equals(tmpObj)) {
strWhere = " and " + keyName + " like %" + tmpObj + "%";
}
selectName.add(keyName);
} stm = connection.prepareStatement(strSql); int i = stm.executeUpdate();
} catch (SQLException e) {
System.out.println(e.getMessage());
} finally {
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
System.out.println(e.getMessage());
}
} if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
e.getMessage();
}
}
}
return list;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货