?? travelagencydao.java
字號:
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;
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -