fwxxaction.java

实现一个简易的租房系统

package com.wepull.zf.web.action;

import java.sql.Connection;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import javax.sql.DataSource;

import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.actions.DispatchAction;
import org.omg.CORBA.Request;

import com.wepull.zf.dao.IFWXXDAO;
import com.wepull.zf.dao.IUserDAO;
import com.wepull.zf.dao.jdbcImpl.FWXXDAO;
import com.wepull.zf.dao.jdbcImpl.UserDAO;
import com.wepull.zf.entity.FWLX;
import com.wepull.zf.entity.FWXX;
import com.wepull.zf.entity.User;
import com.wepull.zf.web.form.FWXXForm;
import com.wepull.zf.web.form.LoginForm;

public class FWXXAction extends DispatchAction {

	public ActionForward home(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "success";
		return mapping.findForward(forward);

	}

	public ActionForward toPost(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "toPost";
		Connection con = null;
		try {
			con = this.getDataSource(request).getConnection();
			IFWXXDAO dao = new FWXXDAO(con);
			List<FWLX> fwlxs = dao.findAllFWLX();
			request.setAttribute("fwlxs", fwlxs);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (con != null && !con.isClosed()) {
					con.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return mapping.findForward(forward);

	}

	public ActionForward toConfirmPost(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		String forward = "toConfirmPost";
		return mapping.findForward(forward);
	}

	public ActionForward doPost(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		request.setCharacterEncoding("UTF-8");
		String forward = "doPost";
		FWXXForm fForm=(FWXXForm) form;
		Connection con = null;
		try {
			con = this.getDataSource(request).getConnection();
			IFWXXDAO dao = new FWXXDAO(con);
			FWXX fwxx=fForm.getFwxx();
			SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd");
			String date=sdf.format(new Date());
			fwxx.setDate(date);
			HttpSession session=request.getSession();
			LoginForm lForm=(LoginForm) session.getAttribute("loginForm");
			fwxx.setUid(lForm.getUser().getUid());
			boolean flag = dao.save(fwxx);
			int fwid=fwxx.getFwid();
			request.setAttribute("id",fwid );

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (con != null && !con.isClosed()) {
					con.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return mapping.findForward(forward);
	}
	
	public ActionForward searchMyFWXX(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "my";
		Connection con = null;
		String strPage=request.getParameter("page");
		int page=1;
		if(strPage!=null){
			page=Integer.parseInt(strPage);
		}
		int pageSize=3;
		try {
			con = this.getDataSource(request).getConnection();
			IFWXXDAO dao = new FWXXDAO(con);
			HttpSession session=request.getSession();
			LoginForm lForm=(LoginForm) session.getAttribute("loginForm");
			int uid=lForm.getUser().getUid();
			List<FWXX> list=dao.findAll(uid, page, pageSize);
			request.setAttribute("list", list);
//			request.setAttribute("fwlxs", fwlxs);
			int totalPages=dao.getTotalPages(uid,pageSize);
			request.setAttribute("totalPages", totalPages);
			request.setAttribute("page", page);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (con != null && !con.isClosed()) {
					con.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return mapping.findForward(forward);
	}
	
	public ActionForward doList(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "doList";
		Connection con = null;
		String strPage=request.getParameter("page");
		int page=1;
		if(strPage!=null){
			page=Integer.parseInt(strPage);
		}
		int pageSize=3;
		try {
			con = this.getDataSource(request).getConnection();
			IFWXXDAO dao = new FWXXDAO(con);
			List<FWXX> houses=dao.findAll( page, pageSize);
			int totalPages=dao.getTotalPages(pageSize);
			request.setAttribute("houses", houses);
			request.setAttribute("totalPages", totalPages);
			request.setAttribute("page", page);

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			try {
				if (con != null && !con.isClosed()) {
					con.close();
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return mapping.findForward(forward);
	}
	
	
	public ActionForward toDel(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "doDel";
		Connection con=getDataSource(request).getConnection();
		IFWXXDAO dao=new FWXXDAO(con);
		int fwid=Integer.parseInt(request.getParameter("id"));
		boolean flag=dao.del(fwid);
		System.out.println(flag+">>>>>>>>>>>>");
		return mapping.findForward(forward);

	}
	
	public ActionForward toEdit(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response)
			throws Exception {
		String forward = "doEdit";
		Connection con=getDataSource(request).getConnection();
		IFWXXDAO dao=new FWXXDAO(con);
		int fwid=Integer.parseInt(request.getParameter("id"));
		FWXX house=dao.findById(fwid);
		request.setAttribute("fwxx", house);
		return mapping.findForward(forward);

	}
}