timebuynote.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 TimeBuyNote extends HttpServlet{

	/**
	 * 
	 */
	private static final long serialVersionUID = 4341178384122672841L;
	
	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	time = req.getParameter("time");		

		if(null != req.getParameter("time")){
			time = req.getParameter("time");
			req.getSession(true).setAttribute("time", time);
		}
		else{				
			if(null != req.getSession(true).getAttribute("time")){
				time = (String)req.getSession(true).getAttribute("time");
			}
		}
			
		String sql = Pages.limitQuery4(((intPageNo - 1) * Pages.PAGE_SIZE + 1), (intPageNo * Pages.PAGE_SIZE), Integer.parseInt(time));
		//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()){					
				SellBean sell = new SellBean();	
			
				sell.setId(rs.getString("id"));
				sell.setCode(rs.getString("code"));
				sell.setTname(rs.getString("tname"));
				sell.setAmount(rs.getString("amount"));
				sell.setOpid(rs.getString("opid"));
				sell.setTime(rs.getInt("time"));
				sell.setRemark(rs.getString("remark"));
			
				col.add(sell);
			}		
			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 time='"+time+"'";
		//strSql = new String(strSql.getBytes("ISO8859-1"), "gbk");
		System.out.println(strSql);
		int allRecords = Pages.allRecords(strSql);	//所有记录数

		Pages pages = new Pages(intPageNo, allRecords, "TimeBuyNote?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);
	}
}