goodadd.java

一个购物网站

package goodsList;
import dataDisposal.*;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import java.util.*;
public class GoodAdd extends HttpServlet implements Servlet {
	public void doGet(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
			String goodid=request.getParameter("goodId");
			goodid=new String(goodid.getBytes("iso-8859-1"),"gb2312");
			
			String goodname=request.getParameter("goodName");
			goodname=new String(goodname.getBytes("iso-8859-1"),"gb2312");
			
			String goodprice=request.getParameter("goodPrice");
			goodprice=new String(goodprice.getBytes("iso-8859-1"),"gb2312");
			
			String goodnum=request.getParameter("goodNum");
			goodnum=new String(goodnum.getBytes("iso-8859-1"),"gb2312");
			
			String goodDetail=request.getParameter("goodDetail");
			goodDetail=new String(goodDetail.getBytes("iso-8859-1"),"gb2312");			
			
			String path=request.getParameter("goodPath");
			path=new String(path.getBytes("iso-8859-1"),"gb2312");
			
			GoodListBean goodListBean=new GoodListBean();
			boolean flag=false;
			String sql="insert into goodsInfo (goodId,goodName,goodPrice,goodNum,goodDetail,goodPath)"+
				 "values ('"+goodid+"','"+goodname+"',"+goodprice+","+goodnum+",'"+goodDetail+"','"+path+"')";
				 
			ServletContext application = getServletConfig().getServletContext();	  

			try {
				flag=goodListBean.updateGood(sql);
			} catch (Exception e) {
				System.out.println("GoodList error!");
			
			}
			sql="";
			ArrayList goodsList=null;
			
			sql = "select * from goodsInfo order by tradeTimes desc " ;
			
			GoodsListBean goodsListBean = new GoodsListBean();
			goodsList = goodsListBean.getList(sql);
			
			synchronized(application){
				application.setAttribute("goodsList",goodsList);
			}
			
			
			application.getRequestDispatcher("/GoodList").forward(request,response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws ServletException, IOException {
			doGet(request,response);
	}
}