buyservlet.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 BuyServlet extends HttpServlet
{
	public String accept;
	public int g_id;
	public int bid;
	public int gid;
	public int bnum;
	public double bprice;
	public double tprice;
	public int fid;
	public String buydate;
	public String paydate;
	public int emp_id;
	public String note;
	public String gname;
	public String unit;
	public String otime;
	
	public void doGet(HttpServletRequest request,HttpServletResponse response)
	       throws ServletException,IOException{
		response.setContentType("text/html;charset=GBK");
		request.setCharacterEncoding("GBK");
		PrintWriter out = response.getWriter();
		accept = request.getParameter("jump");
		javabean.OracleBean conn = new javabean.OracleBean();
		//rs是搜寻商品表GOODS后的结果集
		ResultSet rs = conn.query("SELECT * FROM goods");
		HttpSession session = request.getSession();
		ResultSet rs1 = conn.query("SELECT MAX(f_id) AS maxfid FROM factory");
        //获得SESSION
		String note = (String)session.getAttribute("note");
		try{
					
	    	if(accept.equals("老商品采购添加"))
		    	getServletConfig().getServletContext().getRequestDispatcher("/addold.jsp").forward(request,response);
		    else if(accept.equals("新商品采购添加"))
	     		getServletConfig().getServletContext().getRequestDispatcher("/addnew.jsp").forward(request,response);
	    	else if(accept.equals("保存")){
	    		if(note=="agree"||note.equals("agree")){
					String fname = (String)session.getAttribute("fname");         //供货商名字
					String fpname = (String)session.getAttribute("fpname");       //供货商联系人
					String f_tel1 = (String)session.getAttribute("f_tel");        //供货商联系电话
					int f_tel = Integer.parseInt(f_tel1);
					String f_add = (String)session.getAttribute("f_add");         //供货商联系地址
					rs1.next();
					try{
                    String fida =""+rs1.getInt("maxfid");
					if(fida==null||fida.equals("")){
						fida=""+10001;
						fid = Integer.parseInt(fida);
					}
					else{
						fid = Integer.parseInt(fida)+1;
					}
					}catch(Exception e){
						e.printStackTrace();
					}
					String sql1 = "INSERT INTO factory VALUES(";
			    	sql1 += fid;
					sql1 += ",'" + fname + "',";
					sql1 += "'" + fpname + "',";
					sql1 += f_tel;
					sql1 += ",'" + f_add + "')";
					System.out.println(sql1);
					conn.update(sql1);
				}
				//从buy中获得参数
	    		otime = (String)session.getAttribute("otime");                  //商品过期时间
	    		gname = (String)session.getAttribute("gname");                  //商品名称
	    		unit = (String)session.getAttribute("unit");                    //商品单位
	    		bid = Integer.parseInt(request.getParameter("bid"));            //采购编号   
	    		gid = Integer.parseInt(request.getParameter("gid"));            //商品编号
	    		bnum = Integer.parseInt(request.getParameter("bnum"));          //商品数量
	    		bprice = Double.parseDouble(request.getParameter("bprice"));    //商品单价
	    		tprice = bprice*bnum;                                           //商品总价
	    		ResultSet rsf = conn.query("SELECT MAX(F_ID) AS maxfid FROM factory");
	    		rsf.next();
	    		fid = rsf.getInt("maxfid")+1;                                   //供货商编号
	    		
	    		buydate = (String)session.getAttribute("buydate");              //采购日期
	    		String emp_id1 = (String)session.getAttribute("emp_id");       
	    		emp_id = Integer.parseInt(emp_id1);                             //员工编号
	    		note = (String)session.getAttribute("note");
                //将获得参数插入采购表（buy）
	    		String sql = "INSERT INTO buy VALUES(";
	    		sql += bid;       									    
	    		sql += gid;												
	    		sql += bnum;											
	    		sql += bprice;											
	    		sql += tprice;											
	    		sql += fid;												
	    		sql += "to_date('"+buydate+"','YYYY-MM-DD')";			
	    		sql += emp_id;		                        			
	    		sql += "to_date('"+paydate+"','YYYY-MM-DD'))";		        	//结算日期
	    		conn.update(sql);
	    		
				String sql2 = "INSERT INTO goods VALUES(";
				sql2 += gid;
				sql2 += "'"+gname+"'";
				sql2 += "'"+unit+"'";
				sql2 += bnum;
				sql2 += "to_date('"+otime+"','YYYY-MM-DD')";
				sql2 += 0 ;
				conn.update(sql2);
				getServletConfig().getServletContext().getRequestDispatcher("/buy.jsp").forward(request,response);
	    	}			
	    	else if(accept.equals("退出"))
	    		getServletConfig().getServletContext().getRequestDispatcher("/login.html").forward(request,response);
		
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response)
    throws ServletException,IOException{
		doGet(request,response);
	}

}