package com.dut.logic.db;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import com.dut.dao.BatchDBConnectionUtil;
import com.dut.logic.logic.InputCheckUtil;
import com.dut.logic.util.DataTypeCheck;
import com.dut.logic.util.StringUtil;


public class Tousen {
	
	private int nen;			// smallint
	private int hagaki_id;		// smallint
	private String hagaki_mei;
	private int toukyu_id; 		// samllint
	private String toukyu_mei;
	private String tousen_no; 	// char
	private Date insert_date; 
	private Date update_date; 	// datetime
	
	static BatchDBConnectionUtil BU1 = new BatchDBConnectionUtil();// Date Lianjie
	
	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 getNen() {
		return nen;
	}
	public void setNen(int nen) {
		this.nen = nen;
	}
	public int getToukyu_id() {
		return toukyu_id;
	}
	public void setToukyu_id(int toukyu_id) {
		this.toukyu_id = toukyu_id;
	}
	public String getTousen_no() {
		return tousen_no;
	}
	public void setTousen_no(String tousen_no) {
		this.tousen_no = tousen_no;
	}
	public Date getUpdate_date() {
		return update_date;
	}
	public void setUpdate_date(Date update_date) {
		this.update_date = update_date;
	}
	public String getHagaki_mei() {
		return hagaki_mei;
	}
	public void setHagaki_mei(String hagaki_mei) {
		this.hagaki_mei = hagaki_mei;
	}
	public String getToukyu_mei() {
		return toukyu_mei;
	}
	public void setToukyu_mei(String toukyu_mei) {
		this.toukyu_mei = toukyu_mei;
	}
	
	/**
	 * 該函數用于獲得Tousen表的結果集List
	 * @param sqlstr
	 * @return List
	 * @author 楊麗娟 2006-04-13
	 */
	public static List getTousenDate(String sqlstr){
		List TousenList = new ArrayList();
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(sqlstr);
		try {
			while(rs.next()){
				Tousen TU = new Tousen();
				
				int nen = Integer.parseInt(rs.getString("NEN"));
				TU.setNen(nen);
				
				int hagaki_id = Integer.parseInt(rs.getString("HAGAKI_ID"));
				TU.setHagaki_id(hagaki_id);
				
				int toukyu_id = Integer.parseInt(rs.getString("TOUKYU_ID"));
				TU.setToukyu_id(toukyu_id);
				
				String tousen_no = StringUtil.trans_date(rs.getString("TOUSEN_NO"));
				TU.setTousen_no(tousen_no);
				
				Date insert_date = DataTypeCheck.StringtoDate(rs.getString("INSERT_DATE"));
				TU.setInsert_date(insert_date);
				
				Date update_date = DataTypeCheck.StringtoDate(rs.getString("UPDATE_DATE"));
				TU.setUpdate_date(update_date);
				
				TousenList.add(TU);
			}
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return TousenList;
	}
	
}