使用预准备语句将java数组值插入mysql [英] inserting java array values into mysql by using prepared statement

问题描述

嗨朋友在我的代码中我通过使用JSP页面中的request.getParameterValues（）以数组的形式接收值，并且我将它传递给getter setter从那里传递到DAO但我不知道如何插入值通过使用预准备语句将每个arrary元素放入数据库中。我的疑问是如何为我的代码每次迭代插入备注，数量，startTime，endTime

Hi friends in my code I am receciving the values by using request.getParameterValues() from JSP page in the form of array and im passing it to getter setter from there im passing to DAO but i dont know how to insert the values of each arrary element into the database by using prepared statement . my doubt is how to insert remarks,quantity,startTime, endTime for each iteration my code is

  Servlet Code : 

  String[] remarks = request.getParameterValues("txtRemarks");
  String[] quantity = request.getParameterValues("txtQty");
  String[] startHrs = request.getParameterValues("txtStartTime");
  String[] endHrs = request.getParameterValues("txtEndtime");

  getter setter :

  public String[] getremarks() {  
  return getremarks;  
  }  
  public void setremarks(String[] newremarks) {  
  remarks = newremarks;  
  } 

 UserDAO :


         String query = "insert into table(remarks,quantity,startTime,endTime) values (?,?,?,?) "
         currentCon = ConnectionManager.getConnection();
         ps = currentCon.prepareStatement(query);
         rs = ps.executeQuery();

推荐答案

tmarwen代码可以正常工作，你只需要替换尝试如下所示

tmarwen code will works fine, you just replace the try like below

try {
    insertStatement = con.prepareStatement(insertString);
    insertStatement.setString(1, remark);
    insertStatement.setString(1, quantity);
    insertStatement.setString(1, startTime);// use setTimestamp() if it is a timestamp
    insertStatement.setString(1, endTime);
    insertStatement.executeUpdate();
  } catch (SQLException e ) {
      System.out.println(e.getMessage());
  } finally {
    if (insertStatement != null) {
      insertStatement.close();
    } if (con != null) {         
      con.close();
    }
  }
response.sendRedirect("servlet/jsp");//Where ever you require to redirect

这篇关于使用预准备语句将java数组值插入mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！