showdeptdaybill.java

还是超市系统

/**@(#)ShowDeptDayBill.java*/
package test.expense;

import java.io.IOException;
import java.sql.*;

import javax.servlet.*;
import javax.servlet.http.*;

/**显示部门当天的支出
 * @version 0.1
 * @author Administrator
 * @date 20060803 pm 17:01
 */
public class ShowDeptDayBill extends HttpServlet{

     public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		Connection conn;
		Statement stmt;
		ResultSet rs;
		
		
		try{
			Class.forName("oracle.jdbc.driver.OracleDriver");
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:SMarket","scott","tiger");
			stmt = conn.createStatement();
			
			System.out.println(req.getParameter("date"));
			rs = stmt.executeQuery("SELECT dept_id,money,bill_day FROM table_dept_bill WHERE bill_day=to_date('"+req.getParameter("date")+"','YYYY-MM-DD')");
			int i = 0;
			if(rs!=null){
				while(rs.next()){
					i++;
					req.setAttribute("0",new Integer(i));
					System.out.println("this*************"+i);
					req.setAttribute(""+i+""+1,new Integer(rs.getInt("dept_id")));
					req.setAttribute(""+i+""+2,new Float(rs.getFloat("money")));
					req.setAttribute(""+i+""+3,rs.getDate("bill_day"));
					//req.setAttribute("0",new Integer(i));
				}
				
				getServletConfig().getServletContext().getRequestDispatcher("/pages/listdeptbill.jsp").forward(req,res);
			}else{
				
				getServletConfig().getServletContext().getRequestDispatcher("/pages/fail.html").forward(req,res);
			}
		}catch(Exception e){
			e.printStackTrace();
		}
		//getServletConfig().getServletContext().getRequestDispatcher("/pages/showgood.jsp").forward(req,res);
	}
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
}