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

Question

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

    }
}

}

Answer 1

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