java web房屋出租系统项目

package com.blf.action; import java.io.IOException; import java.util.ArrayList; import java.util.List; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.blf.dao.RoomDAO; import com.blf.dao.imple.RoomDAOimple; import com.blf.entity.Roominfo; import com.blf.util.Dateutil; public class RoomAction extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } /****** * 增加租房信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void addroom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String pid = request.getParameter("pid"); String title=request.getParameter("title"); String qx = request.getParameter("qx"); String jd = request.getParameter("jd"); String shi = request.getParameter("shi"); String ting = request.getParameter("ting"); String type = request.getParameter("type"); String price = request.getParameter("price"); String per = request.getParameter("per"); String tel = request.getParameter("tel"); String remark =request.getParameter("remark"); String date = request.getParameter("date"); Roominfo room = new Roominfo(); room.setPid(Integer.parseInt(pid)); room.setTitle(title); room.setQx(qx); room.setJd(jd); room.setShi(Integer.parseInt(shi)); room.setTing(Integer.parseInt(ting)); room.setType(type); room.setPrice(new Float(price)); room.setPer(per); room.setTel(tel); room.setDate(Dateutil.getDateFormStr(date)); room.setRemark(remark); RoomDAO dao = new RoomDAOimple(); int res = dao.addroom(room); if(res==1){ response.sendRedirect("index.jsp"); }else{ response.sendRedirect("orrer.jsp"); } } /****** * 获得租房列表信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void listRoom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { RoomDAO dao = new RoomDAOimple(); List<Roominfo> list =dao.findall(); request.setAttribute("room",list); request.getRequestDispatcher("list.jsp").forward(request, response); } /****** * 根据房屋编号获得房屋信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void getRoomByid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String hid = request.getParameter("hid"); RoomDAO dao = new RoomDAOimple(); Roominfo room = dao.GetroominfoByid(Integer.parseInt(hid)); request.setAttribute("room",room); request.getRequestDispatcher("detail.jsp").forward(request, response); } /*********** * * @param request * @param response * @throws ServletException * @throws IOException */ public void findroomBypid(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String pid = request.getParameter("pid"); RoomDAO dao = new RoomDAOimple(); List<Roominfo> list = dao.findroomBypid(Integer.parseInt(pid)); request.setAttribute("room",list); request.getRequestDispatcher("my.jsp").forward(request, response); } /********* * 删除房屋信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void deleteroom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String hid = request.getParameter("hid"); String pid = request.getParameter("pid"); RoomDAO dao = new RoomDAOimple(); dao.deleteroom(Integer.parseInt(hid)); response.sendRedirect("RoomAction?method=findroomBypid&pid="+pid); } /******* * 修改房屋信息准备 * @param request * @param response * @throws ServletException * @throws IOException */ public void updateroomui(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String hid = request.getParameter("hid"); RoomDAO dao = new RoomDAOimple(); Roominfo room =dao.GetroominfoByid(Integer.parseInt(hid)); request.setAttribute("room",room); request.getRequestDispatcher("updateui.jsp").forward(request, response); } /******* * 修改房屋信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void updateroom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String pid = request.getParameter("pid"); String hid = request.getParameter("hid"); String title=request.getParameter("title"); String qx = request.getParameter("qx"); String jd = request.getParameter("jd"); String shi = request.getParameter("shi"); String ting = request.getParameter("ting"); String type = request.getParameter("type"); String price = request.getParameter("price"); String per = request.getParameter("per"); String tel = request.getParameter("tel"); String date = request.getParameter("date"); String remark =request.getParameter("remark"); Roominfo room = new Roominfo(); room.setPid(Integer.parseInt(pid)); room.setHid(Integer.parseInt(hid)); room.setTitle(title); room.setQx(qx); room.setJd(jd); room.setShi(Integer.parseInt(shi)); room.setTing(Integer.parseInt(ting)); room.setType(type); room.setPrice(new Float(price)); room.setPer(per); room.setTel(tel); room.setDate(Dateutil.getDateFormStr(date)); room.setRemark(remark); RoomDAO dao = new RoomDAOimple(); dao.updateroom(room); response.sendRedirect("RoomAction?method=findroomBypid&pid="+Integer.parseInt(pid)); } /******** * 迷糊查询房屋信息 * @param request * @param response * @throws ServletException * @throws IOException */ public void selectRoom(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { request.setCharacterEncoding("GBK"); String name = request.getParameter("name"); RoomDAO dao = new RoomDAOimple(); List<Roominfo> list = dao.SelectRoom(name); request.setAttribute("room",list); request.getRequestDispatcher("login.jsp").forward(request, response); } /******* * 高级查询 * @param request * @param response * @throws ServletException * @throws IOException */ public void selectRoom1(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String name=request.getParameter("name"); String qx = request.getParameter("qxid"); String jd = request.getParameter("jdid"); String price1 = request.getParameter("zj"); String price2 = request.getParameter("zj1"); String shi1 = request.getParameter("shi"); int shi = new Integer(shi1); String ting1 = request.getParameter("ting"); int ting = new Integer(ting1); String[] type = request.getParameterValues("type"); String sql = "select * from t_house where "; if(name!=null){ sql = sql+"(h_title like ?)"; } if("0".equals(qx)){ }else{ if(name!=null){ sql=sql+" and (h_qx="+qx+") "; }else{ sql=sql+" (h_qx="+qx+") "; } } if("0".equals(jd)){ }else{ if("0".equals(qx)&&name==null){ sql = sql+" (h_jd="+jd+") "; }else{ sql = sql+"and (h_jd="+jd+") "; } } if(shi!=0){ if("0".equals(qx)&&"0".equals(jd)&&name==null){ sql = sql+"(h_shi="+shi+") "; }else{ sql = sql+" and (h_shi="+shi+