showdayexpense.java

还是超市系统

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

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

import test.bean.*;
import javax.servlet.*;
import javax.servlet.http.*;


/**获得从日历中传来的日期参数
 * @version 0.1
 * @author kyle
 * @date 20060801 pm 14:05
 */
public class ShowDayExpense extends HttpServlet{

	public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		//Connection conn ;
		//Statement stmt ;
		//ResultSet rs ;
		
		int currentPage;
		int totalPage;
		int totalItem;
		HashMap m;
		Table t;
		
		SetPage_Oracle  s = new SetPage_Oracle();
		
		s.setSql("SELECT b.bill_id ,g.good_name , g.good_price , b.good_amount , d.dept_name , v.vender_name , b.bill_day , b.bill_due_day FROM table_good g ,table_dept d ,table_vender v ,table_bill b WHERE b.good_id=g.good_id AND b.dept_id=d.dept_id AND b.vender_id=v.vender_id AND b.bill_day=to_date('"+req.getParameter("date")+"','YYYY-MM-DD')");
		System.out.println("select g.good_name,g.good_price,b.good_amount,d.dept_name,v.vender_name,b.bill_day from table_good g ,table_dept d ,table_vender v ,table_bill b where b.good_id=g.good_id and b.dept_id=d.dept_id and b.vender_id=v.vender_id and b.bill_day='"+req.getParameter("date")+"'");
		
		s.setCSql("select count(bill_id) as totalItem from table_bill where bill_day=to_date('"+req.getParameter("date")+"','YYYY-MM-DD')");
		System.out.println("select count(bill_id) as totalItem from table_bill where bill_day='"+req.getParameter("date")+"'");
		
		s.setUrl("jdbc:oracle:thin:@localhost:1521:SMarket");
		
		s.setTotalPage(8);
		totalPage = s.getTotalPage();
		
		req.setAttribute("totalPage",new Integer(totalPage));
		
		try{
		    //currentPage = Integer.parseInt(req.getParameter("currentPage"));
		    if(req.getParameter("currentPage")==null){
		    	currentPage=1;
		    }else{
		    	currentPage = Integer.parseInt(req.getParameter("currentPage"));
		    	  if(currentPage >= totalPage){
		    		  currentPage = totalPage;
		    	  }else if(currentPage < 1){
		    		  currentPage = 1;
		    	  }
		    }
		    System.out.println("this inside the servlet:"+currentPage);
		    m = (HashMap)s.getMap(currentPage,8, 6);
		    req.setAttribute("currentPage",new Integer(currentPage));
		
		//m = (HashMap)s.getMap(currentPage, 4, 6);
		
		HttpSession session = req.getSession();
		
		for(int i = 1;i<=8;i++){
			if(m.isEmpty())break;
			Integer j = new Integer(i);
			//System.out.println(m.get(j).getClass());
			t = (Table)m.get(j);
			System.out.println(t);
			if(t == null){
				//System.out.println(t);
				break;
			}
		    {	
		    	req.setAttribute("0",j);
		    	
		    	req.setAttribute(""+i+""+1,t.getGoodName());//getAttribute(i1);
		    	session.setAttribute(""+i+""+1,t.getGoodName());
		    	
		    	req.setAttribute(""+i+""+2,t.getDeptName());//getAttribute(i1);
		    	session.setAttribute(""+i+""+2,t.getDeptName());
		    	
		    	req.setAttribute(""+i+""+3,t.getVenderName());//getAttribute(i1);
		    	session.setAttribute(""+i+""+3,t.getVenderName());
		    	
		    	req.setAttribute(""+i+""+4,new Integer(t.getGoodAmount()));//getAttribute(i1);
		    	session.setAttribute(""+i+""+4,new Integer(t.getGoodAmount()));
		    	
		    	req.setAttribute(""+i+""+5,new Float(t.getGoodPrice()));//getAttribute(i1);
		    	session.setAttribute(""+i+""+5,new Float(t.getGoodPrice()));
		    	
		    	req.setAttribute(""+i+""+6,t.getBillDay());//getAttribute(i1);
		    	session.setAttribute(""+i+""+6,t.getBillDay());
		    	
		    	req.setAttribute(""+i+""+7,t.getBillDueDay());//getAttribute(i1);
		    	session.setAttribute(""+i+""+7,t.getBillDueDay());
		    	
		    	req.setAttribute(""+i+""+8,new Integer(t.getGoodId()));//getAttribute(i1);
		    	session.setAttribute(""+i+""+8,new Integer(t.getGoodId()));
		    }
		}
		}catch(Exception e){
			e.printStackTrace();
		}
		
		getServletConfig().getServletContext().getRequestDispatcher("/pages/showdetail.jsp").forward(req,res);
	}
	public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		
		doGet(req,res);
	}
}