checkservlet.java

该源代码实现了系统的进货

package servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;


import dataBase.DataBase;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import operation.SaleCheckOperation;

import entity.SaleInfo;

public class CheckServlet extends HttpServlet {
	public final static String jdkDateFormat = "yyyy-MM-dd";
	private ResultSet rs;
	private DataBase db;
	private Connection conn;

	/**
	 * Constructor of the object.
	 */
	public CheckServlet() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}

	/**
	 * The doGet method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to get.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		doPost(request,response);
	}

	/**
	 * The doPost method of the servlet. <br>
	 *
	 * This method is called when a form has its tag value method equals to post.
	 * 
	 * @param request the request send by the client to the server
	 * @param response the response send by the server to the client
	 * @throws ServletException if an error occurred
	 * @throws IOException if an error occurred
	 */
	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		request.setCharacterEncoding("GB2312");
		response.setContentType("text/html;charset=gb2312");
		//java.sql.Date sqldate = null;
		String startyear = request.getParameter("startyear");//取得开始时间的年份
		String startmonth = request.getParameter("startmonth");//取得开始时间的月份
		String startdate = request.getParameter("startdate");//取得开始时间的日期
		
		String endyear = request.getParameter("endyear");//取得结束时间的年份
		String endmonth = request.getParameter("endmonth");//取得结束时间的月份
		String enddate = request.getParameter("enddate");//取得结束时间的日期
		
		String starttime = startyear+"-"+startmonth+"-"+startdate;//获得完整的开始时间
		String endtime = endyear+"-"+endmonth+"-"+enddate;//获得完整的结束时间
		
		//System.out.println(starttime);
		/*SimpleDateFormat dateFormat = new SimpleDateFormat(jdkDateFormat);
		Date date = null;
		try {
			date=dateFormat.parse(starttime);
			sqldate = new java.sql.Date(date.getTime());
			//System.out.println(sqldate);	
		} catch (ParseException e1) {
			// TODO 自动生成 catch 块
			e1.printStackTrace();
		}
		*/
		/*if(starttime.equals(endtime))
		{
			System.out.println("equals");
		String sql = "select * from saleinfo where SaleDate='"+starttime+"'";
		db = new DataBase();
		
		 rs = db.getResult(sql);
		}
		else
		{
			System.out.println("not equals");
			String sql = "select * from saleinfo where SaleDate between '"+starttime+"' and '"+endtime+"'";
			db = new DataBase();
			
			 rs = db.getResult(sql);
		}
		Collection ret = new ArrayList();
		try {
			while(rs.next())
			{
				SaleInfo saleInfo = new SaleInfo();
				saleInfo.setSaleID(rs.getString("SaleID"));
				saleInfo.setProductID(rs.getInt("ProductID"));
				saleInfo.setCustomerID(rs.getInt("CustomerID"));
				saleInfo.setSaleQuantity(rs.getInt("SaleQuantity"));
				saleInfo.setSalePrice(rs.getFloat("SalePrice"));
				saleInfo.setSaleSum(rs.getFloat("SaleSum"));
				saleInfo.setSaleDate(rs.getDate("SaleDate"));
				saleInfo.setChargeman(rs.getString("Chargeman"));
				saleInfo.setSaleNotice(rs.getString("SaleNotice"));
				ret.add(saleInfo);
				
			}
			rs.close();
			db.close();
		} catch (SQLException e) {
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}*/
		SaleCheckOperation sco = new SaleCheckOperation();//实例化一个SaleCheckOperation类
		Collection ret = sco.getSaleInfoArrayList(starttime, endtime);//调用getSaleInfoArrayList()方法来返回符合的结果集，并将结果集存入Collection中返回
		
		 request.setAttribute("ret", ret);//将ret对象设为request的属性，名称也为ret
			RequestDispatcher requestDispatcher = request.getRequestDispatcher("/MyJsp.jsp");
			requestDispatcher.forward(request, response);//实现页面的跳转，跳转到ShwoSale.jsp页面
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void init() throws ServletException {
		// Put your code here
	}

}