goodslist.java

jsp超市管理系统系统,是用经典的MVC设计模式开发的非常适合初学者学习。

package com.myservlet.goods;

import java.io.*;
import java.sql.*;
import java.util.*;
import javax.servlet.*;	
import javax.servlet.http.*;
import com.dbconn.ConnManager;
import com.mybean.Pages;
import com.mybean.Goods;

public class GoodsList extends HttpServlet{

	/**
	 * @author LiPeng
	 */
	private static final long serialVersionUID = 5428320550342516628L;

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException{
		performTask(req, resp);
	}

	public void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException{
		performTask(req, resp);
	}

	private void performTask(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException{
		
		String dotype = req.getParameter("dotype");
		
		if(null != req.getParameter("dotype")){
			dotype = req.getParameter("dotype");
			req.getSession(true).setAttribute("dotype", dotype);
		}
		else{				
			if(null != req.getSession(true).getAttribute("dotype")){
				dotype = (String)req.getSession(true).getAttribute("dotype");
			}
		}
		
		String pageNo = req.getParameter("page");
		if (pageNo == null){
			pageNo = "1";
		}
		int	intPageNo = Integer.parseInt(pageNo);

		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");  		
		PreparedStatement ps = null;
		ResultSet rs = null;
			   		 
		try{
			String sql = Pages.limitQuery(((intPageNo - 1) * Pages.PAGE_SIZE + 1), (intPageNo * Pages.PAGE_SIZE));
			//System.out.println(sql);
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			
			Collection col = new ArrayList();
				
			while(rs.next()){					
				Goods goods= new Goods();	
				
				goods.setId(rs.getInt("id"));
				goods.setCode(rs.getString("code"));
				goods.setTname(rs.getString("tname"));
				goods.setAmount(rs.getInt("amount"));
				goods.setBprice(rs.getFloat("bprice"));
				goods.setSprice(rs.getFloat("sprice"));
				goods.setType(rs.getString("type"));
				//goods.setMaker(rs.getString("maker"));
				//goods.setArea(rs.getString("area"));
				//goods.setRemark(rs.getString("remark"));
				
				col.add(goods);
			}			
			req.setAttribute("col", col);				
		}
		catch(SQLException e){
			e.printStackTrace();
		}
		finally{
			try{
				rs.close();
				ps.close();
				conn.close();
			}
			catch(SQLException e){
				System.out.println(e);
			}
			connManager.releaseConnection("oracle", conn);
		}
						
		String strSql = "SELECT count(*) FROM goods";
		int allRecords = Pages.allRecords(strSql);	//所有记录数
		
		Pages pages = new Pages(intPageNo, allRecords, "GoodsList?id=1", req);	
		String page = pages.allString();	//获取返回分页操作字符串
		req.setAttribute("page", page);
		String totals=String.valueOf(pages.getTotals());
		req.setAttribute("totals", totals);
		if((dotype != null) && (dotype.equals("goods"))){
			RequestDispatcher reqDispatcher = req.getRequestDispatcher("goods/goodsList.jsp?dotype=goods");	//将结果返回到指定页面
			reqDispatcher.forward(req, resp);	
		}
		else if((dotype != null) && (dotype.equals("buy"))){
			RequestDispatcher reqDispatcher = req.getRequestDispatcher("buy/buy.jsp?dotype=buy");	//将结果返回到指定页面
			reqDispatcher.forward(req, resp);	
		}	
		else if((dotype != null) && (dotype.equals("sell"))){
			RequestDispatcher reqDispatcher = req.getRequestDispatcher("sell/sell.jsp?dotype=sell");	//将结果返回到指定页面
			reqDispatcher.forward(req, resp);	
		}
	}
}