selectdao.java

北大青鸟的租房网练习文件

package com.newer.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Date;
import java.util.Vector;

import com.newer.common.DBUtil;
import com.newer.entity.FwxxVO;
import com.newer.entity.SelectVO;

public class SelectDao {
	public Vector getFwxxByCondition(SelectVO svo){
		Vector vc=new Vector();
		//设置SQL语句
		StringBuffer sqltemp=new StringBuffer();
		sqltemp.append("select * from tbl_fwxx where 1=1 ");
		if(svo.getQxid()!=0){
			sqltemp.append("and qxid="+svo.getQxid());
		}
		if(svo.getJdid()!=0){
			sqltemp.append(" and jdid="+svo.getJdid());
		}
		if(svo.getZj()>=0&&svo.getZj1()>svo.getZj()){
			sqltemp.append(" and zj between "+svo.getZj()+" and "+svo.getZj1());
		}
		if(svo.getShi()!=0){
			sqltemp.append(" and shi="+svo.getShi());
		}
		if(svo.getTing()!=0){
			sqltemp.append(" and ting="+svo.getTing());
		}
		if(svo.getLxid()!=0){
			sqltemp.append(" and lxid="+svo.getLxid());
		}
		//求两个日期之间的天数差距还存在问题
		if(svo.getDate()!=0){
			Date date=new Date();
		}
		String sql=sqltemp.toString();
		System.out.println(sql);
		Connection conn=DBUtil.getConn();
		PreparedStatement pstmt=null;
		
		try {
			
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				FwxxVO fwxxvo=new FwxxVO();
				fwxxvo.setFwid(rs.getInt("fwid"));
				fwxxvo.setUid(rs.getInt("uid"));
				fwxxvo.setQxid(rs.getInt("qxid"));
				fwxxvo.setJdid(rs.getInt("jdid"));
				fwxxvo.setLxid(rs.getInt("lxid"));
				fwxxvo.setShi(rs.getInt("shi"));
				fwxxvo.setTing(rs.getInt("ting"));
				fwxxvo.setFwxx(rs.getString("fwxx"));
				fwxxvo.setZj(rs.getFloat("zj"));
				fwxxvo.setTitle(rs.getString("title"));
				fwxxvo.setDate(rs.getString("date"));
				fwxxvo.setTelephone(rs.getString("telephone"));
				fwxxvo.setLxr(rs.getString("lxr"));
				vc.add(fwxxvo);		
			}
			rs.close();
			pstmt.close();
			conn.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return vc;
	}

}