showgood.java

还是超市系统

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

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

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

import test.bean.SetPage_Oracle_g;
import test.bean.Good;

/**将已经存在的和将要订购的货物分页显示
 * @version 0.1
 * @author kyle	
 * @date 20060802 am 10:19
 */
public class ShowGood extends HttpServlet{

	public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException ,IOException{
		//Connection conn ;
		//Statement stmt ;
		//ResultSet rs ;
		
		int currentPage;
		int totalPage = 0;
		int totalItem = 0;
		HashMap m;
		Good t;
		
		SetPage_Oracle_g  s = new SetPage_Oracle_g();
		
		s.setSql("SELECT g.good_id , g.good_name , g.good_price , g.good_unit , d.dept_name , v.vender_name , g.good_message FROM table_good g ,table_dept d ,table_vender v  WHERE g.dept_id=d.dept_id AND g.vender_id=v.vender_id ");
		System.out.println("SELECT g.good_name , g.good_price , g.good_unit , d.dept_name , v.vender_name , g.good_message FROM table_good g ,table_dept d ,table_vender v  WHERE g.dept_id=d.dept_id AND g.vender_id=v.vender_id  ");
		
		s.setCSql("SELECT count(good_id) as totalItem FROM table_good");
		System.out.println("SELECT count(good_id) as totalItem FROM table_good");
		
		s.setUrl("jdbc:oracle:thin:@localhost:1521:SMarket");
		
		s.setTotalPage(8);
		totalPage = s.getTotalPage();
		req.setAttribute("date",req.getParameter("date"));
		
		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"));
		    	  System.out.println("this is in the Servlet of ShowGood"+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();
		session.setAttribute("date",req.getParameter("date"));
		
		for(int i = 1;i<=8;i++){
			if(m.isEmpty())break;
			Integer j = new Integer(i);
			//System.out.println(m.get(j).getClass());
			t = (Good)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 Float(t.getGoodPrice()));//getAttribute(i1);
		    	session.setAttribute(""+i+""+4,new Float(t.getGoodPrice()));
		    	
		    	req.setAttribute(""+i+""+5,t.getGoodUnit());//getAttribute(i1);
		    	session.setAttribute(""+i+""+5,t.getGoodUnit());
		    	
		    	req.setAttribute(""+i+""+6,t.getGoodMessage());//getAttribute(i1);
		    	session.setAttribute(""+i+""+6,t.getGoodMessage());
		    	
		    	req.setAttribute(""+i+""+7,new Integer(t.getGoodId()));//getAttribute(i1);
		    	session.setAttribute(""+i+""+7,new Integer(t.getGoodId()));
		    }
		}
		}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);
	}
}