querytime.java

仓库管理系统,适合各种行业的仓库管理系统

package com.refund.action;

import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

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

import com.bean.DAO.RefundDAO;
import com.bean.DTO.RefundDTO;
import com.database.DataSourceFactory;
import com.servlet.AbstractAction;

public class QueryTime extends AbstractAction {

	@Override
	public String process(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException {
		
		String redirect=null;
			Connection con;
			try {
				con = DataSourceFactory.getDataSource().getConnection();
				RefundDAO dao=new RefundDAO(con);
				String starttime=request.getParameter("starttime");
				String overtime=request.getParameter("overtime");
				if(starttime!=null&&overtime!=null){
				List<RefundDTO> list=dao.queryTime(starttime,overtime);
				
				request.setAttribute("list",list);
				request.setAttribute("starttime",starttime);
				request.setAttribute("overtime",overtime);
				
				
				request.setAttribute("list",list);
				}
				redirect="/caiWuGuanLi/query.jsp";
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			
			return redirect;
		
	}

}