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.StringUtil;

public class Hagakicd {

	private int hagaki_id; // smallint

	private String hagaki_mei; // varchar

	private Date insert_date;

	private Date update_date; // datetime

	public int getHagaki_id() {
		return hagaki_id;
	}

	public void setHagaki_id(int hagaki_id) {
		this.hagaki_id = hagaki_id;
	}

	public String getHagaki_mei() {
		return hagaki_mei;
	}

	public void setHagaki_mei(String hagaki_mei) {
		this.hagaki_mei = hagaki_mei;
	}

	public Date getInsert_date() {
		return insert_date;
	}

	public void setInsert_date(Date insert_date) {
		this.insert_date = insert_date;
	}

	public Date getUpdate_date() {
		return update_date;
	}

	public void setUpdate_date(Date update_date) {
		this.update_date = update_date;
	}


	/**
	 * 獲取頁書區分的id和名字的List
	 * 
	 * @return list
	 * @author 王楠楠 2006-04-10
	 */
	public static List haga_mei_list() {
		BatchDBConnectionUtil dbc = new BatchDBConnectionUtil();
		ResultSet res = dbc
				.executeQuery("select HAGAKI_MEI,HAGAKI_ID from HAGAKICD order by HAGAKI_ID asc");
		List list = new ArrayList();
		try {
			while (res.next()) {
				Hagakicd haga = new Hagakicd();
				haga.setHagaki_mei(StringUtil.trans_date(res
						.getString("hagaki_mei")));
				System.out.println("hagaki_mei  = === >"
						+ StringUtil.trans_date(res.getString("hagaki_mei")));
				System.out.println("hagaki_id  = === >"
						+ StringUtil.trans_date(res.getString("hagaki_id")));
				haga
						.setHagaki_id(Integer.parseInt(StringUtil
								.trans_date(Integer.toString(res
										.getInt("hagaki_id")))));
				list.add(haga);
			}
			System.out.println("222");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return list;
	}
	/**
	 * ?????????獲得Hagakicd表的數據List?????
	 * @return List
	 * @author 楊麗娟 2006-04-05
	 */
	public static List getHagakicd(){
		String SQLstr = "SELECT * FROM HAGAKICD ORDER BY HAGAKI_ID ASC";
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(SQLstr);
		List HagakicdList = new ArrayList();
		try {
			/*
			 * 以下代碼用于封裝List
			 */
			while(rs.next()){
				int id = Integer.parseInt(rs.getString("HAGAKI_ID"));
				String name = StringUtil.trans_date(rs.getString("HAGAKI_MEI"));
				Hagakicd hagakicd = new Hagakicd();
				hagakicd.setHagaki_id(id);
				hagakicd.setHagaki_mei(name);
				HagakicdList.add(hagakicd);
			}
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return HagakicdList;
	}
	
	/**
	 * ?????????通過葉書區分查詢葉書名稱????????????
	 * @param id
	 * @return String
	 * @author ?楊麗娟 2006-04-10
	 */
	public static String selectHagaki_mei(int id){
		String mei = null;
		String Sqlstr = "SELECT HAGAKI_MEI FROM HAGAKICD "
						+ "WHERE HAGAKI_ID = " + id;
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(Sqlstr);
		try {
			if(rs.next()){
				mei = StringUtil.trans_date(rs.getString("HAGAKI_MEI"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		con.close();
		return mei;
	}

}