listgoodid.java

还是超市系统

package listgoodid;

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

public class Listgoodid extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			req.setCharacterEncoding("GBK");
			db.ConnOracle conn = new db.ConnOracle();
			ResultSet rs = null;
			ResultSet rs1 = null;
			String id = req.getParameter("id");
			
			HttpSession session = req.getSession();//先得到session
			session.setAttribute("id",id);
			
			try{
				String sql = "select max(good_id)  as maxgoodid  from table_good where dept_id="+id;
				rs = conn.query(sql);
				//String sql1 = "select good_name from table_good where good_id="+rs.getInt("maxgoodid");
				//rs = conn.query(sql1);
				
				req.setAttribute("r",rs);
				//req.setAttribute("r1",rs1);
					getServletConfig().getServletContext().getRequestDispatcher("/pages/listgoodid.jsp").forward(req,res);
				
			}catch(Exception e){
				e.printStackTrace();
			}
		}
		public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
}