Question

JAVA中删除数据库数据，根据数组删除，怎么写。 方法：public void delete(int[] ids) {

Answer 1

public void delete(int[] id) throws SQLException{
//假定conn ps 都获取到
Connection conn=null;
StringBuffer sql=new StringBuffer("delete from school where id in(");
for (int i = 0; i < id.length; i++) {
if (i==id.length-1)
sql.append(id[i]+")");
else
sql.append(id[i]+",");
}
PreparedStatement ps=conn.prepareStatement(sql.toString());
ps.execute();
}

Answer 2

挑灯夜读这个任务竟然要回答20个问题，NND,