addold.java

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

package superMarket;

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

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 AddOld extends HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
    throws ServletException,IOException{
		response.setContentType("text/html;charset=GBK");
		request.setCharacterEncoding("GBK");
		//从addold1页面获得参数
		String b_id = request.getParameter("bid");                      //采购编号
		String gname = request.getParameter("gname");                   //商品名称
		String b_price = request.getParameter("b_price");               //采购单价
		String unit = request.getParameter("unit");                     //单位
		String fname = request.getParameter("fname");                   //供货商名字
		String b_num = request.getParameter("b_num");                   //采购数量
		String paydate = request.getParameter("paydate");               //结算日期
	    System.out.print(b_num);
		javabean.OracleBean conn = new javabean.OracleBean();
		String sql = "SELECT g_id FROM goods WHERE GNAME = '" + gname +"'";
		ResultSet rs = conn.query(sql);
		try {
			rs.next();
			//将参数传给buy页面
			System.out.println(rs.getString("g_id"));
			int g_ida = Integer.parseInt(rs.getString("g_id"))+1;
			String g_id =""+g_ida;
			double totalprice = Double.parseDouble(b_price)*Double.parseDouble(b_num);
			String tprice = ""+totalprice;
			HttpSession session = request.getSession();
			session.setAttribute("g_id",g_id);
			session.setAttribute("bid",b_id);
			session.setAttribute("gname",gname);
			session.setAttribute("b_price",b_price);
			session.setAttribute("unit",unit);
			session.setAttribute("b_num",b_num);
			session.setAttribute("totalprice",tprice);
			session.setAttribute("fname",fname);
			session.setAttribute("paydate",paydate);
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		getServletConfig().getServletContext().getRequestDispatcher("/buy.jsp").forward(request,response);
	}
	
	public void doPost(HttpServletRequest request,HttpServletResponse response)
	       throws ServletException,IOException{
		doGet(request,response);
	}

}