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