基于jsp做的一个租房系统

package com.newer.struts.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import com.newer.struts.bean.FwxxBean; public class FwxxDao extends JdbcTempateDao<FwxxBean> { private Connection con = null; private PreparedStatement ps = null; private ResultSet rs = null; public FwxxDao() { super(FwxxBean.class); } /** * 根据FWID查询 * @param id * @return */ public ArrayList selectById(String id){ String sql="select * from tbl_fwxx where fwid=?"; Object[]values={id}; return toBean(sql, values); } /** * 返回总记录数 */ public int getCount(FwxxBean fb,double zjend,String fwlx) { String sql = "select count(*) from tbl_fwxx where 1=1"; if (null !=fb.getTitle() && !"".equals(fb.getTitle())) { sql+=" and title like '%"+fb.getTitle()+"%' "; } if(fb.getQxid() !=0){ sql +="and qxid=" + fb.getQxid(); } if(fb.getJdid() !=0){ sql +="and jdid=" + fb.getJdid(); } if(fb.getZj() !=0 && zjend !=0){ sql +="and zj between " +fb.getZj()+" and " +zjend; } if(fb.getShi() !=0){ sql +="and shi=" +fb.getShi(); } if(fb.getTing() !=0){ sql +="and ting=" +fb.getTing(); } if(fwlx !=null && !fwlx.equals("")){ String lx = fwlx.substring(0,fwlx.lastIndexOf(",")); sql += "and lxid in("+lx+")"; } if(fb.getDate() !=null && Integer.parseInt(fb.getDate())!=0 ){ sql +="and date between getdate()-" + fb.getDate()+" and getdate()"; } System.out.println(sql); Object[] values = {}; return getInt(sql,values); } /** * 查询全部 */ public ArrayList<FwxxBean> getAllCate(int currentPage, int everyPage, String title) { int index = (currentPage - 1) * everyPage; String sql = "select top " + everyPage + " * from tbl_fwxx where fwid not in(select top " + index + " fwid from tbl_fwxx) "; if (null != title && !title.trim().equals("")) { sql = "select top " + everyPage + " * from tbl_fwxx where fwid not in(select top " + index + " fwid from tbl_fwxx where title like '%"+title+"%') and title like '%"+title+"%'"; } // System.out.println(title); // System.out.println(sql); Object[] obj = {}; return toBean(sql, obj); } /** * 高级查询 */ public ArrayList getAll(int currentPage,int everyPage,FwxxBean fb, double zjend,String fwlx){ System.out.println(fb.getDate()); String sql="select top " +everyPage +"* from tbl_fwxx where fwid not in(select top " +(currentPage -1)*everyPage +" fwid from tbl_fwxx where 1=1 "; if(null !=fb.getTitle() &&!"".equals(fb.getTitle())){ sql +="and title like '%"+fb.getTitle()+"%'"; } if(fb.getQxid() !=0){ sql +="and qxid=" + fb.getQxid(); } if(fb.getJdid() !=0){ sql +="and jdid=" + fb.getJdid(); } if(fb.getZj() !=0 && zjend !=0){ sql +="and zj between " +fb.getZj()+" and " +zjend; } if(fb.getShi() !=0){ sql += "and shi=" + fb.getShi(); } if(fb.getTing() !=0){ sql +="and ting=" + fb.getTing(); } String lx = ""; String xx = ""; if(fwlx !=null &&!fwlx.equals("")){ lx = fwlx.substring(0,fwlx.lastIndexOf(",")); sql +="and lxid in("+lx+")"; } if(fb.getDate() !=null && Integer.parseInt(fb.getDate())!=0 ){ sql += "and date between getdate()-" + fb.getDate() +" and getdate()"; } sql +=" order by fwid)"; if(null != fb.getTitle() && !"".equals(fb.getTitle())){ sql +="and title like '%"+fb.getTitle()+"%'"; } if(fb.getQxid() !=0){ sql +="and qxid=" + fb.getQxid(); } if(fb.getJdid() !=0){ sql += "and jdid=" + fb.getJdid(); } if(fb.getZj() !=0 && zjend !=0){ sql +="and zj between " + fb.getZj()+" and "+zjend; } if(fb.getShi() !=0){ sql +="and shi=" + fb.getShi(); } if(fb.getTing() !=0){ sql +="and ting=" +fb.getTing(); } if(fwlx !=null && !fwlx.equals("")){ lx = fwlx.substring(0,fwlx.lastIndexOf(",")); sql +="and lxid in("+lx+")"; } if(fb.getDate() !=null && Integer.parseInt(fb.getDate())!=0){ sql += "and date between getdate()-" + fb.getDate() +" and getdate()"; } System.out.println(sql); Object[] values = {}; return toBean(sql, values); } /** * 根据Uid查询 */ public ArrayList getByUid(int currentPage,int everyPage,String uid){ String sql = "select top "+everyPage +" * from tbl_fwxx where fwid not in(select top " +(currentPage -1) * everyPage +" fwid from tbl_fwxx where uid="+uid+") and uid =" +uid+""; System.out.println(sql); Object[] values = {}; return toBean(sql, values); } /** * 根据Uid得到总记录数 */ public int getCount(String uid){ String sql = "select count(*) from tbl_fwxx where uid=?"; Object[] values = {uid}; return getInt(sql,values); } /** * 修改 */ // public boolean update(FwxxBean nb){ // String sql = "update tbl_fwxx set " // } /** * 根据标题模糊查询 */ public ArrayList<FwxxBean> getFwxxList(String title) { String sql = "select * from tbl_fwxx where 1=1"; if (null != title && !title.trim().equals("")) { sql += " and title like '%" + title + "%'"; } sql += " order by date desc"; Object[] obj = {}; return toBean(sql, obj); } /** * 添加发布信息 * @param args */ public boolean addFwxx(FwxxBean fb){ String sql = "insert into tbl_fwxx values(?,?,?,?,?,?,?,?,?,?,?,?)"; Object[] obj = {fb.getUid(),fb.getJdid(),fb.getQxid(),fb.getLxid(), fb.getShi(),fb.getTing(),fb.getFwxx(),fb.getZj(), fb.getTitle(),fb.getDate(),fb.getTelephone(),fb.getLxr()}; return isTrue(sql, obj); } /** * 得到室 * @param args */ public ArrayList getShi(){ String sql = "select shi from tbl_fwxx"; Object[] obj = {}; return toBean(sql, obj); } /** * 得到厅 * @param args */ public ArrayList getTing(){ String sql = "select ting from tbl_fwxx"; Object[] obj = {}; return toBean(sql, obj); } /** * 删除 * @param id * @return */ public boolean deleteById(String id){ String sql="delete from tbl_fwxx where fwid=?"; Object[]values={id}; return isTrue(sql, values); } public static void main(String[] args) { //System.out.println(new FwxxDao().getCount("")); } }