checkincome.java

来自「还是超市系统」· Java 代码 · 共 36 行

package checkincome;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import oracle.OracleBean;

public class Checkincome extends HttpServlet{
	
	public void doGet(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			
			oracle.OracleBean conn = new oracle.OracleBean();
			ResultSet rs = null;
			HttpSession session = req.getSession();
		  
			
			try{
				String sql = "select * from table_dayincome where dept_id="+  req.getParameter("id");
				rs = conn.query(sql);
				
				session.setAttribute("rs",rs);
			}catch(Exception e){
				e.printStackTrace();
			}
			getServletConfig().getServletContext().getRequestDispatcher("/supermaket/checkincome.jsp").forward(req,res);
		}
	
	public void doPost(HttpServletRequest req,HttpServletResponse res)
		throws ServletException,IOException{
			doGet(req,res);
		}
		
}