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;
	}
	
}