query.java

来自「仓库管理系统,适合各种行业的仓库管理系统」· Java 代码 · 共 42 行

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 Query 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);
			List<RefundDTO> list=dao.queryInformation();
			
			request.setAttribute("list",list);
			
			redirect="/caiWuGuanLi/query.jsp";
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return redirect;
	}

}