关于删除的方法！

String[] sid = request.getParameterValues("selectFlag");

UserManager.getInstance().deleteUser(sid);

//for(int i=0; i<sid.length; i++) {

// UserManager.getInstance().deleteUser(sid[i]);

//}

}

/**

* 用数组实现删除 sql = select from t_user where user_id in ('b001', 'b002',

)

* @param userIds

public void deleteUser(String[] userIds) {

StringBuffer sbStr = new StringBuffer();

for(int i=0; i<userIds.length; i++) {

sbStr.append("'")

.append(userIds[i])

.append("',");

}

String sql = "delete from t_user where user_id in (" + sbStr.substring(0, sbStr.length()-1) + ")";

System.out.println("sql= " + sql);

Connection conn = null;

Statement stmt = null;

try {

conn = DB.getConn();

stmt = conn.createStatement();

stmt.executeUpdate(sql);

} catch(SQLException e) {

e.printStackTrace();

} finally {

DB.close(stmt);

DB.close(conn);

}

posted on 2009-03-04 17:57 Johnhe 阅读(124) 评论(0) 编辑收藏所属分类: Jdbc

随笔分类