Help me please -- Very Urgent

• • Reply

  13 years ago

  by surjyob

  Surjyo Bhattacharya

  , India

  Joined 13 years ago

  Hi,
  Iam new to Java. I want to insert multiple values to database from two multiple select box in jsp page. Followong is my code. By this i can insert single value only....
          
  String[] s14 = request.getParameterValues("prodName");
  String[] s15 = request.getParameterValues("natureName");
  String s16 = request.getParameter("compId");
  
  PreparedStatement prStmt = con.prepareStatement("Insert into comp_prod (comp_id, pro_id, nat_id) values (?,?,?)");
   prStmt.setString(1, s16);
  
  for (int i = 0; i < s14.length; i++)
          {
          prStmt.setString(2, s14[i]);
          }
  
  for (i = 0; i < s15.length; i++)
          {
          prStmt.setString(3, s15[i]);
          }
  prStmt.executeUpdate();   
  
  Anyu one please help me. Its very urgent for me..
   

  Report abuse