ZhuFang.zip_廉租房_租房_租房管理系统_贫困 系统

package com.struts.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import com.struts.dao.impl.HouseNewDaoImpl; import com.struts.entity.HouseNews; public class HouseNewDao implements HouseNewDaoImpl { Connection conn = null; PreparedStatement met = null; ResultSet set = null; public int addHouse(HouseNews house) { String sql = "insert into TBL_FWXX values(?,?,?,?,?,?,?,?,?,?,?,?)"; int a = 0; Object[] o = { house.getUid(), house.getQxid(), house.getJdid(), house.getLxid(), house.getShi(), house.getTing(), house.getFwxx(), house.getZj(), house.getTitle(), house.getDate(), house.getTelephone(), house.getLxr() }; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); for (int i = 0; i < o.length; i++) { met.setObject(i + 1, o[i]); } a = met.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(null, met, conn); } return a; } public int deleHuse(int id) { String sql = "delete from TBL_FWXX where fwid=?"; int a = 0; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); met.setInt(1, id); a = met.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(null, met, conn); } return a; } public List<HouseNews> findList() { List<HouseNews> listHouse = new ArrayList<HouseNews>(); String sql = "select * from TBL_FWXX"; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); set = met.executeQuery(); while (set.next()) { HouseNews houseNew = new HouseNews(); houseNew.setFwid(set.getInt("fwid")); houseNew.setUid(set.getInt("uid")); houseNew.setQxid(set.getInt("qxid")); houseNew.setJdid(set.getInt("jdid")); houseNew.setLxid(set.getInt("lxid")); houseNew.setShi(set.getInt("shi")); houseNew.setTing(set.getInt("ting")); houseNew.setFwxx(set.getString("fwxx")); houseNew.setZj(set.getDouble("zj")); houseNew.setTitle(set.getString("title")); houseNew.setDate(set.getTimestamp("date").toString()); houseNew.setTelephone(set.getString("telephone")); houseNew.setLxr(set.getString("lxr")); listHouse.add(houseNew); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(set, met, conn); } return listHouse; } public int updateHouse(HouseNews house) { String sql = "update TBL_FWXX set uid=?,qxid=?,jdid=?,lxid=?,shi=?,ting=?,fwxx=?,zj=?,title=?,date=?,telephone=?,lxr=? where fwid=?"; int a = 0; Object[] o = { house.getUid(), house.getQxid(), house.getJdid(), house.getLxid(), house.getShi(), house.getTing(), house.getFwxx(), house.getZj(), house.getTitle(), house.getDate(), house.getTelephone(), house.getLxr(),house.getFwid() }; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); for (int i = 0; i < o.length; i++) { met.setObject(i + 1, o[i]); //免于转型 } a = met.executeUpdate(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(null, met, conn); } return a; } public List<HouseNews> listpage(int page) { int curentPage = 0; if (page > 1) { curentPage = (page - 1) * 10; } List<HouseNews> listHouse = new ArrayList(); String sql = "select top 10 * from TBL_FWXX where fwid not in(select top " + curentPage + " fwid from TBL_FWXX order by date desc) order by date desc"; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); set = met.executeQuery(); while (set.next()) { HouseNews houseNew = new HouseNews(); houseNew.setFwid(set.getInt("fwid")); houseNew.setUid(set.getInt("uid")); houseNew.setQxid(set.getInt("qxid")); houseNew.setJdid(set.getInt("jdid")); houseNew.setLxid(set.getInt("lxid")); houseNew.setShi(set.getInt("shi")); houseNew.setTing(set.getInt("ting")); houseNew.setFwxx(set.getString("fwxx")); houseNew.setZj(set.getDouble("zj")); houseNew.setTitle(set.getString("title")); houseNew.setDate(set.getTimestamp("date").toString()); houseNew.setTelephone(set.getString("telephone")); houseNew.setLxr(set.getString("lxr")); listHouse.add(houseNew); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(set, met, conn); } return listHouse; } public HouseNews findHouse(int fwid) { HouseNews houseNew = new HouseNews(); String sql = "select * from TBL_FWXX where fwid=?"; try { conn = BaseDao.getConn(); met = conn.prepareStatement(sql); met.setInt(1, fwid); set = met.executeQuery(); while (set.next()) { houseNew.setFwid(set.getInt("fwid")); houseNew.setUid(set.getInt("uid")); houseNew.setQxid(set.getInt("qxid")); houseNew.setJdid(set.getInt("jdid")); houseNew.setLxid(set.getInt("lxid")); houseNew.setShi(set.getInt("shi")); houseNew.setTing(set.getInt("ting")); houseNew.setFwxx(set.getString("fwxx")); houseNew.setZj(set.getDouble("zj")); houseNew.setTitle(set.getString("title")); houseNew.setDate(set.getTimestamp("date").toString()); houseNew.setTelephone(set.getString("telephone")); houseNew.setLxr(set.getString("lxr")); } } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { BaseDao.closeAll(set, met, conn); } return houseNew; } /* * 采用List集合接受查询 */ public List<HouseNews> searchHouse(HouseNews house,double lastZj) { List<HouseNews> list =new ArrayList(); String sql = "select * from TBL_FWXX where 1=1"; if(!house.getTitle().trim().equals("")&&!house.getTitle().equals("请输入关键字")){ sql+=" and title like '%"+house.getTitle()+"%' "; }if(house.getQxid()!=0){ sql+=" and qxid="+house.getQxid(); }if(house.getJdid()!=0){ sql+=" and jdid="+house.getJdid(); }if(lastZj!=0.0){ sql+=" and zj between "+house.getZj()+" and "+lastZj; }if(house.getShi()!=0){ sql+=" and shi="+house.getShi(); }if(house.getTing()!=0){ sql+=" and ting="+house.getTing(); }if(house.getLxid()!=0){ sql+=" and lxid="+house.getLxid(); }if(!house.getDate().equals("0")){ sql+=" and date between dateadd(dd,-"+(Integer.parseInt(house.getDate())+1)+",getdate()) and getdate()"; } sql+=" order by date desc"; System.out.println(sql); try{ conn = BaseDao.getConn(); met = conn.prepareStatement(sql); set = met.executeQuery(); while (set.next()) { HouseNews houseNew = new HouseNews(); houseNew.setFwid(set.getInt("fwid")); houseNew.setUid(set.getInt("uid")); houseNew.setQxid(set.getInt("qxid")); houseNew.setJdid(set.getInt("jdid")); houseNew.setLxid(set.getInt("lxid")); houseNew.setShi(set.getInt("shi")); houseNew.setTing(set.getInt("ting")); houseNew.setFwxx(set.getString("fwxx")); houseNew.setZj(set.getDouble("zj")); houseNew.setTitle(set.getString("title")); houseNew.setDate(set.getTimestamp("date").toString()); houseNew.setTelephone(set.getString("telephone")); houseNew.setLxr(set.getString("lxr")); list.add(houseNew); } }catch(Exception e){ e.printStackTrace(); }finally{ BaseDao.closeAll(set, met, conn); } return list; } public List<HouseNews> searchHouse(HouseNews house,double lastZj,int page) { int crentPage=0; if(page>1){ crentPage=(page-1)*20; } List<HouseNews> list =new ArrayList(); String sql = "select top 20 * from TBL_FWXX whe