qq_35787129 2016-08-04 02:17 采纳率: 0%
浏览 1196

无法写入数据库,求大神帮忙解决啊,急急急,感激不尽啊!!!!!!!!

package com.servlet;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import com.Bean.*;

public class addaction extends HttpServlet
{
public void doPost(HttpServletRequest request,HttpServletResponse response)
throws IOException,ServletException
{
response.setContentType("text/html;charset=gb2312");
request.setCharacterEncoding("GBK");
PrintWriter out=response.getWriter();

    boolean flag=false;

    String gdbID ,gname,gpricestr,gnumstr,gmaker,gintro;

    gdbID=request.getParameter("gdbID");
    gname=request.getParameter("gname");
    gpricestr=request.getParameter("gprice");
    gnumstr=request.getParameter("gnum");
    gmaker=request.getParameter("gmaker");
    gintro=request.getParameter("gintro");

    System.out.println(gdbID);
    System.out.println(gname);
    System.out.println(gpricestr);
    System.out.println(gnumstr);
    System.out.println(gmaker);
    System.out.println(gintro);



    int gprice=Integer.parseInt(gpricestr);
    int gnum=Integer.parseInt(gnumstr);
    dbconn dbcon=new dbconn();

    String insertStr="insert into goodsInfo(gdbID,gname,gprice,gnum,gmaker,gintro) values";
    insertStr=insertStr+"('"+gdbID+"',";
    insertStr=insertStr+"('"+gname+"',";
    insertStr=insertStr+""+gprice+",";
    insertStr=insertStr+""+gnum+",";
    insertStr=insertStr+"'"+gmaker+"',";
    insertStr=insertStr+"'"+gintro+"')";

    //out.println(insertStr);
    try
    {
        flag=dbcon.executeUpdate(insertStr);
        dbcon.destory();
    }
    catch(Exception e)
    {
        out.println(e.getMessage());
    }
    if(flag)
    {
        out.println("<script language=\"javascript\">alert(\"添加成功\");window.history.go(-1);</script>");
        /*getServletConfig().getServletContext().getRequestDispatcher("/listaction").forward(request,response);*/

    }
    else
    {
        getServletConfig().getServletContext().getRequestDispatcher("/error.jsp").forward(request,response);

    }
}

}

  • 写回答

5条回答

  • threenewbee 2016-08-04 02:43
    关注


    flag=dbcon.executeUpdate(insertStr);
    下断点,看拼接的sql是否正确,参数、参数类型。
    out.println(e.getMessage());
    是否输出错误信息。

    评论

报告相同问题?

悬赏问题

  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥30 用arduino开发esp32控制ps2手柄一直报错
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题