typebuynote.java

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

package com.myservlet.buy;

import java.io.*;
import java.sql.*;
import java.util.ArrayList;
import java.util.Collection;
import javax.servlet.*;	
import javax.servlet.http.*;
import com.dbconn.*;
import com.mybean.*;

public class TypeBuyNote extends HttpServlet{
	
	/**
	 * 
	 */
	private static final long serialVersionUID = -6167796500339474902L;
	
	private void performTask(HttpServletRequest req, HttpServletResponse resp)
		throws ServletException, IOException{
		
		String pageNo = req.getParameter("page");
		if (pageNo == null){
			pageNo = "1";
		}
		int	intPageNo = Integer.parseInt(pageNo);

		String	type = req.getParameter("type");		
		//tname = handleString(tname);

		if(null != req.getParameter("type")){
			type = req.getParameter("type");
			req.getSession(true).setAttribute("type", type);
		}
		else{				
			if(null != req.getSession(true).getAttribute("type")){
				type = (String)req.getSession(true).getAttribute("type");
			}
		}
			
		String sql = Pages.limitQuery9(((intPageNo - 1) * Pages.PAGE_SIZE + 1), (intPageNo * Pages.PAGE_SIZE), type);
		sql = new String(sql.getBytes("ISO8859-1"), "gbk");
		System.out.println(sql);
		ConnManager connManager = new ConnManager();
		Connection conn = connManager.getConnection("market");  		
		PreparedStatement ps = null;
		ResultSet rs = null;
		   		 
		try{
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
		
			Collection col = new ArrayList();
			
			while(rs.next()){					
				BuyBean buy= new BuyBean();	
			
				buy.setId(rs.getString("id"));
				buy.setCode(rs.getString("code"));
				buy.setTname(rs.getString("tname"));
				buy.setAmount(rs.getInt("amount"));
				buy.setOpid(rs.getInt("opid"));
				buy.setTime(rs.getInt("time"));
				buy.setRemark(rs.getString("remark"));
			
				col.add(buy);
			}			
			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 buy,goods WHERE buy.goodsid=goods.id AND type='"+type+"'";
		strSql = new String(strSql.getBytes("ISO8859-1"), "gbk");
		System.out.println(strSql);
		int allRecords = Pages.allRecords(strSql);	//所有记录数

		Pages pages = new Pages(intPageNo, allRecords, "TypeBuyNote?id=3", req);	
		String page = pages.allString();	//获取返回分页操作字符串
		req.setAttribute("page", page);
		String totals=String.valueOf(pages.getTotals());
		req.setAttribute("totals", totals);
			
		RequestDispatcher reqDispatcher = req.getRequestDispatcher("buy/buyNoteList.jsp");	//将结果返回到指定页面
		reqDispatcher.forward(req, resp);	

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