jsp+js实例批量删除数据

作者：袖梨 2022-07-02

jsp+js实例批量删除数据

jsp获取数据存入数据，然后生成合法sql语句
String action =request.getParameter("action");
String[] name=request.getParameterValues("box");
String deng="";
String spl=",";
if( action == null )
{
action="my";
}
if( action.equals("deleteall") && name != null )
{
int length = name.length-1;
for(int i=0;i<=length;i++)
{
    if( i == length )
  {
   deng = deng+name[i];
  }else{
   deng = deng+name[i]+spl;
  }
}
Statement stmt_dxh=conn.createStatement();
String Sql="delete from hl_jobbook where ID in("+deng+")";
int den=stmt_dxh.executeUpdate(Sql);
  if (den>0){
   out.print("");
  }
stmt_dxh.close();