?? kumi.java
字號:
package com.dut.logic.db;
import java.sql.Date;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import com.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.util.DataTypeCheck;
public class Kumi {
private int nen; //smallint
private int hagaki_id; //smallint
private int kumi_kubun; //smallint
private int s_kumi;
private int e_kumi;
private Date insert_date;
private Date update_date; //datetime
public int getE_kumi() {
return e_kumi;
}
public void setE_kumi(int e_kumi) {
this.e_kumi = e_kumi;
}
public int getHagaki_id() {
return hagaki_id;
}
public void setHagaki_id(int hagaki_id) {
this.hagaki_id = hagaki_id;
}
public Date getInsert_date() {
return insert_date;
}
public void setInsert_date(Date insert_date) {
this.insert_date = insert_date;
}
public int getKumi_kubun() {
return kumi_kubun;
}
public void setKumi_kubun(int kumi_kubun) {
this.kumi_kubun = kumi_kubun;
}
public int getNen() {
return nen;
}
public void setNen(int nen) {
this.nen = nen;
}
public int getS_kumi() {
return s_kumi;
}
public void setS_kumi(int s_kumi) {
this.s_kumi = s_kumi;
}
public Date getUpdate_date() {
return update_date;
}
public void setUpdate_date(Date update_date) {
this.update_date = update_date;
}
/**
* 該方法用于獲得Kumi表的List
* @param sqlstr
* @return
* @author 楊麗娟 2004-04-16
*/
public static List getKumiData(String sqlstr){
List KumiList = new ArrayList();
BatchDBConnectionUtil con = new BatchDBConnectionUtil();
ResultSet rs = con.executeQuery(sqlstr);
/*
* 以下代碼用于封裝List
*/
try {
while(rs.next()){
Kumi KM = new Kumi();
int nen = Integer.parseInt(rs.getString("NEN"));
KM.setNen(nen);
int hagaki_id = Integer.parseInt(rs.getString("HAGAKI_ID"));
KM.setHagaki_id(hagaki_id);
int kumi_kubun = Integer.parseInt(rs.getString("KUMI_KUBUN"));
KM.setKumi_kubun(kumi_kubun);
int s_kumi = Integer.parseInt(rs.getString("S_KUMI"));
KM.setS_kumi(s_kumi);
int e_kumi = Integer.parseInt(rs.getString("E_KUMI"));
KM.setE_kumi(e_kumi);
Date insert_date = DataTypeCheck.StringtoDate(rs.getString("INSERT_DATE"));
KM.setInsert_date(insert_date);
Date update_date = DataTypeCheck.StringtoDate(rs.getString("UPDATE_DATE"));
KM.setUpdate_date(update_date);
KumiList.add(KM);
}
} catch (NumberFormatException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
con.close();
return KumiList;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -