addnew.java

还是超市管理系统 和刚才那个不一样

package superMarket;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

/**
 * author EvilSun 
 * version 1.0 2006-08-04
 * 
 */

public class AddNew extends HttpServlet{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	       throws ServletException,IOException{
		response.setContentType("text/html;charset=GBK");
		request.setCharacterEncoding("GBK");
		
		javabean.OracleBean conn = new javabean.OracleBean();
		ResultSet rs = conn.query("SELECT MAX(b_id) AS maxid FROM buy");
		ResultSet rs1 = conn.query("SELECT MAX(g_id) AS maxgid FROM goods");
		String g_id = null;
		try{
			//从addnew页面获取参数
			rs.next();
			rs1.next();
			String bid = (String)request.getParameter("bid");
			//g_id是定义的商品编号
			
			if(g_id==null||g_id.equals(""))
				 g_id = "" + 10001;
			else 
				g_id = ""+(rs1.getInt("maxgid")+1);
			//unit是定义的商品单位
			String unit = (String)request.getParameter("unit");
			//gname是定义的商品名称
			String gname = (String)request.getParameter("gname");
			
			//anprice是定义的商品采购的单价
			String bprice = request.getParameter("bprice");
			//fname是定义的供货商的名称
			String fname = (String)request.getParameter("fname");
			//otime是定义的商品的过期日期
			String otime = (String)request.getParameter("otime");
			//b_num是定义的商品采购的数量
			String b_num = (String)request.getParameter("b_num");
			//paydate是定义的商品采购的结算日期
			String paydate = (String)request.getParameter("paydate");
			//fpname是定义的供货商联系人
			String fpname = (String)request.getParameter("fpname");
			//f_tel是定义的供货商的联系电话
			String f_tel = (String)request.getParameter("f_tel");
			//f_add是定义的供货商的联系地址
			String f_add = (String)request.getParameter("f_add");
			//tprice是采购的总价
			double totalprice = Double.parseDouble(bprice)*Double.parseDouble(b_num);
			String tprice = ""+totalprice;

			HttpSession session = request.getSession();
			session.setAttribute("bid",bid);
			session.setAttribute("unit", unit);
			session.setAttribute("g_id", g_id);
			session.setAttribute("gname", gname);
			session.setAttribute("b_price", bprice);
			session.setAttribute("fname", fname);
			session.setAttribute("otime", otime);
			session.setAttribute("b_num", b_num);
			session.setAttribute("paydate", paydate);
			session.setAttribute("fpname", fpname);
			session.setAttribute("f_tel", f_tel);
			session.setAttribute("f_add", f_add);
			session.setAttribute("totalprice", tprice);

			//将上面的参数传递给buy页面
			getServletConfig().getServletContext().getRequestDispatcher("/buy.jsp").forward(request,response);
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)
    throws ServletException,IOException{
		doGet(request,response);
	}

}