查询条件是一个list

/**
* 查询路段管理
* @author ecy
* @return
*/	
	@Override
	public ArrayList<Road> queryRoadList(Connection conn, Road road) throws SQLException {
		PreparedStatement pst = null;
		ResultSet rs = null;
		Road r = null;
		ArrayList<Road> roadList = new ArrayList<Road>();

		String sqlWhere = ""; 
		String queryStockInfoListSQL = "SELECT t1.*,t2.ROAD_TYPE_NAME FROM SNOW_ROAD t1,SNOW_ROAD_type t2 " +
				"where t1.status = 1 and t1.ROAD_TYPE_ID = t2.ROAD_TYPE_ID ";

		if(!"".equals(road.getStart_stake()) && null != road.getStart_stake() && !"".equals(road.getEnd_stake()) && null != road.getEnd_stake()){
			queryStockInfoListSQL +=  " and to_number(t1.start_stake) >= "+road.getStart_stake()+" and to_number(t1.end_stake) <= "+road.getEnd_stake()+"";
		}
		if(road.getTaskRoadCodeList()!=null){
			sqlWhere = " and ROAD_NUM in (";
			for(int i=0;i<road.getTaskRoadCodeList().size();i++){
				sqlWhere += "'"+road.getTaskRoadCodeList().get(i).getRoadCode()+"'"+",";
			}

			if(sqlWhere.length() > 0){
				sqlWhere = sqlWhere.substring(1,sqlWhere.length()-1)+")"; 
				queryStockInfoListSQL = queryStockInfoListSQL + sqlWhere;
			}
		}
		queryStockInfoListSQL += " order by t1.CREATE_TIME";

		pst = DBCommon.getPsm(conn, queryStockInfoListSQL);
		rs = DBCommon.getRs(pst, queryStockInfoListSQL);

		while(rs.next()){
			r = new Road();
			r.setRoad_id(rs.getString("ROAD_ID"));  
			r.setRoad_type_id(rs.getString("ROAD_TYPE_ID")); 
			r.setRoad_type_name(rs.getString("ROAD_TYPE_NAME")); 
			r.setDept_id(rs.getString("DEPT_ID")); 
			r.setRoad_name(rs.getString("ROAD_NAME")); 
			r.setRoad_num(rs.getString("ROAD_NUM")); 
			r.setStart_stake(rs.getString("START_STAKE")); 
			r.setEnd_stake(rs.getString("END_STAKE")); 
			r.setRoad_direction(rs.getString("ROAD_DIRECTION")); 
			r.setCreatepersonid(rs.getString("CREATE_PERSON_ID")); 
			r.setCreatetime(rs.getString("CREATE_TIME")); 
			r.setUpdatepersonid(rs.getString("UPDATE_PERSON_ID")); 
			r.setUpdatetime(rs.getString("UPDATE_TIME")); 
			r.setStatus(rs.getString("STATUS")); 
			r.setMemo(rs.getString("REMARKS"));  
			try {
				r.setPointListString(get_pointsString(rs.getString("ROAD_ID")));
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
			roadList.add(r);
		}

		if(rs!=null){
			rs.close();
		}

		if(pst!=null){
			pst.close();
		}

		return roadList;
	}