travelagencydao.java

java+mapxtreme 开发校园房管系统

package com.oyc.mapxtreme.dao;

import java.util.List;

import com.oyc.mapxtreme.beans.TravelAgencyBean;
import com.oyc.wakeup.Session;

/**
 * 旅行社dao,操作表tb_travelAgency
 * @author 三峡大学理学院 欧阳超
 *
 */
public class TravelAgencyDAO {
	
	/** 数据库会话对象 **/
	private Session sess=null;
	
	/**
	 * 构造器:根据数据库会话来创建一个通讯录管理器
	 * @param sess 数据库会话对象
	 */
	public TravelAgencyDAO(Session sess){
		this.sess=sess;
	}
	
	/**
	 * 根据旅行社ID取得旅行社Bean
	 * @param taID 旅行社ID
	 * @return
	 */
	public TravelAgencyBean getTravelById(int taID){
		List list = null;
		try {
			String sql = "select * from tb_travelAgency where taID=" + taID;
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return (TravelAgencyBean) list.get(0);
		}else{
			return null;
		}
	}
	
	/**
	 * 搜索与关键字配置的旅行社Bean
	 * @param taName 旅行社名称
	 * @return
	 */
	public List searchTravelByName(String taName){
		List list = null;
		try {
			String sql = "select * from tb_travelAgency where taName like '%"+ taName +"%'";
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return list;
		}else{
			return null;
		}
	}
	
	public List searchTravelByIDAry(int[] taIDAry){
		List list = null;
		//组装sql语句
		String sql = "select * from tb_travelAgency where ";
		for(int i=0; i<taIDAry.length; i++){
			sql += "taID=" + taIDAry[i] + " or ";
		}
		sql = sql.substring(0, sql.length()-4);
		
		try {
			list = sess.query(sql, TravelAgencyBean.class);
		} catch (Exception e) {
			e.printStackTrace();
		}
		if(list != null && list.size() > 0){
			return list;
		}else{
			return null;
		}
	}

}