String sql="delete from table where id in(0";
String id[]=要删除的ID数组;
for(int i=0;i<id.length;i++)
{
sql+=","+id[i];
}
sql+=")";
PreparedStatement ps=conn.prepareStatement(sql);
ps.execute();
拼sql语句 批量删除
最新推荐文章于 2022-08-22 14:16:23 发布
String sql="delete from table where id in(0";
String id[]=要删除的ID数组;
for(int i=0;i<id.length;i++)
{
sql+=","+id[i];
}
sql+=")";
PreparedStatement ps=conn.prepareStatement(sql);
ps.execute();