showbookgood.java

还是超市系统

package showbookgood;

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.ConnOracle;

public class Showbookgood extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			
			db.ConnOracle conn = new db.ConnOracle();
			ResultSet rs = null;
			String count = req.getParameter("goodcounts");//得到book.jsp传过来的商品订购数量
			
			HttpSession session = req.getSession();
			session.getAttribute("goodId");//从book.jsp中接收来goodId,用来判断是哪个部门
			
			try{
				
				String sql = "select * from table_good where good_id="+session.getAttribute("goodId");
				rs = conn.query(sql);
				
				session.setAttribute("rs",rs);
				req.setAttribute("count",count);
			}catch(Exception e){e.printStackTrace();}
			
			getServletConfig().getServletContext().getRequestDispatcher("/pages/showbook.jsp").forward(req,res);
		}
		
	public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}