批量加入记录

String[] checkboxvalue=request.getParameterValues("display");
  Class.forName("oracle.jdbc.driver.OracleDriver");
  Connection conn= DriverManager.getConnection("jdbc:oracle:thin:@211.99.189.101:1521:sid","user","weytega");
  PreparedStatement  pstmt = conn.prepareStatement("insert into tbl_partnerstat_displaytrade values(seq_Partnerstat_displaytrade.nextVal,'"+ wapid +"',?,1)");
  for(int i=0;i<checkboxvalue.length;i++)
  {
    try{
       pstmt.setString(1, checkboxvalue[i].toString());
       pstmt.addBatch();
    }
    catch(Exception e)
    {
     System.out.println(e.toString());
    }

  }
  pstmt.executeBatch();