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();