kensyou.java

来自「用strutshibernate做的项目」· Java 代码 · 共 170 行

package com.dut.logic.db;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
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 Kensyou {

	private int nen; // samllint

	private int hagaki_id; // samllint

	private String hagaki_mei;

	private int toukyu_id; // samllint

	private String toukyu_mei;

	private int sketa; // samllint

	private Date uketuke_s_date;

	private Date uketuke_e_date;

	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 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 getSketa() {
		return sketa;
	}

	public void setSketa(int sketa) {
		this.sketa = sketa;
	}

	public int getToukyu_id() {
		return toukyu_id;
	}

	public void setToukyu_id(int toukyu_id) {
		this.toukyu_id = toukyu_id;
	}

	public Date getUketuke_e_date() {
		return uketuke_e_date;
	}

	public void setUketuke_e_date(Date uketuke_e_date) {
		this.uketuke_e_date = uketuke_e_date;
	}

	public Date getUketuke_s_date() {
		return uketuke_s_date;
	}

	public void setUketuke_s_date(Date uketuke_s_date) {
		this.uketuke_s_date = uketuke_s_date;
	}

	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;
	}
	
	/**
	 * 获得Kensyou表的List
	 * @param sqlstr
	 * @return
	 * @author �杨丽娟 2006-04-14
	 */
	public static List getKensyouData(String sqlstr){
		List KensyouList = new ArrayList();
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(sqlstr);
		try {
			/*
			 * 以下代码用于封装List
			 */
			while(rs.next()){
				Kensyou KSY = new Kensyou();
				
				int nen = Integer.parseInt(rs.getString("NEN"));
				KSY.setNen(nen);
				
				int hagaki_id = Integer.parseInt(rs.getString("HAGAKI_ID"));
				KSY.setHagaki_id(hagaki_id);
				
				int toukyu_id = Integer.parseInt(rs.getString("TOUKYU_ID"));
				KSY.setToukyu_id(toukyu_id);
				
				int sketa = Integer.parseInt(rs.getString("SKETA"));
				KSY.setSketa(sketa);
				
				Date uketuke_s_date = DataTypeCheck.StringtoDate(rs.getString("UKETUKE_S_DATE"));
				KSY.setUketuke_s_date(uketuke_s_date);
				
				Date uketuke_e_date = DataTypeCheck.StringtoDate(rs.getString("UKETUKE_E_DATE"));
				KSY.setUketuke_e_date(uketuke_e_date);
				
				Date insert_date = DataTypeCheck.StringtoDate(rs.getString("INSERT_DATE"));
				KSY.setInsert_date(insert_date);
				
				Date update_date = DataTypeCheck.StringtoDate(rs.getString("UPDATE_DATE"));
				KSY.setUpdate_date(update_date);
				
				KensyouList.add(KSY);
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		con.close();
		return KensyouList;
	}


}