java - 通过单击 JSP 中的按钮插入 MySQL 数据库

Question

以下代码是向MySQL数据库中插入数据。

但是代码并没有通过点击发送按钮向数据库中插入数据。

    <%
    Class.forName("com.mysql.jdbc.Driver");
    conn = DriverManager.getConnection(CONN_STRING, USERNAME, PASSWORD);

    if(request.getParameter("send")!=null){
        String scom=request.getParameter("scompany");
        String porderno=request.getParameter("pono");
        String bdate=request.getParameter("date");
        String drug1=request.getParameter("d1");
        String qty1=request.getParameter("q1");


        //getting todaydate
        Date date = new Date();
        Timestamp timestamp = new Timestamp(date.getTime());

        String sql = "INSERT INTO purchaseorderinfo SET Supplier ='"+scom+"', PONo='"+porderno+"', ExpectedDate='"+bdate+"', PODate='"+timestamp+"' ";
        pst=conn.prepareStatement(sql);


        if((scom!=null && scom.length()>0)
            && (porderno!=null && porderno.length()>0)
            && (bdate!=null && bdate.length()>0)
            && (drug1!=null && drug1.length()>0)
            && (qty1!=null && qty1.length()>0)){

            pst.execute();
          %>
          <script language="javascript">
                alert("Send sucess");
          </script>
          <%    
        }
    }
%>

这是我的发送按钮；

<div class="col-md-8">
    <form action="adminpg-purchaseorder.jsp" method="post" id="login-form" role="form" style="display: block">
        <div class="form-group">
            <div class="row">
                <div class="col-sm-6 col-sm-offset-3">
                    <input type="submit" name="send" id="submit" tabindex="1" class="form-control btn btn-login" value="Send">
                </div>
            </div>
        </div>    
    </form>
</div>

如何修复这段向数据库插入数据的代码？

Answer 1

您的INSERT 查询是错误的。它类似于 UPDATE 查询。改变它

String sql = "INSERT INTO purchaseorderinfo SET Supplier ='"+scom+"', PONo='"+porderno+"', ExpectedDate='"+bdate+"', PODate='"+timestamp+"' ";

到

String sql = "INSERT INTO purchaseorderinfo(Supplier,PONo,ExpectedDate,PODate)
      VALUES('"+scom+"', '"+porderno+"', '"+bdate+"', '"+timestamp+"' ";