toukyucd.java

用strutshibernate做的项目

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 Toukyucd {
	static StringUtil U2 = new StringUtil();// Date Turn Method

	static BatchDBConnectionUtil BU1 = new BatchDBConnectionUtil();// Date
																	// Lianjie

	private int toukyu_id;// smallint

	private String toukyu_mei;

	private Date insert_date;

	private Date update_date;// Datetime

	public Date getInsert_date() {
		return insert_date;
	}

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

	public int getToukyu_id() {
		return toukyu_id;
	}

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

	public String getToukyu_mei() {
		return toukyu_mei;
	}

	public void setToukyu_mei(String toukyu_mei) {
		this.toukyu_mei = toukyu_mei;
	}

	public Date getUpdate_date() {
		return update_date;
	}

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

	
	/**
	 * 该函数用于获得Toukyucd表的结果集List���܂�
	 * @return List
	 * @author �杨丽娟 2006-04-05
	 */
	public static List getToukyucd(){
		String SQLstr = "SELECT * FROM TOUKYUCD ORDER BY TOUKYU_ID ASC";
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(SQLstr);
		List ToukyucdList = new ArrayList();
		try {
			/*
			 * 以下代码用于封装List
			 */
			while(rs.next()){
				Toukyucd toukyucd = new Toukyucd();
				int id = Integer.parseInt(rs.getString("TOUKYU_ID"));
				String name = StringUtil.trans_date(rs.getString("TOUKYU_MEI"));
				toukyucd.setToukyu_id(id);
				toukyucd.setToukyu_mei(name);
				ToukyucdList.add(toukyucd);
			}
			con.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ToukyucdList;
	}
	
	/**
	 * 该函数用于查询等级名称��������
	 * ���将等级名称返回�������̕ԉ�
	 * @param id
	 * @return String
	 * @author �杨丽娟 2006-04-10
	 */
	public static String selectToukyu_mei(int id){
		String mei = null;
		String Sqlstr = "SELECT TOUKYU_MEI FROM TOUKYUCD "
						+ "WHERE TOUKYU_ID = " + id;
		BatchDBConnectionUtil con = new BatchDBConnectionUtil();
		ResultSet rs = con.executeQuery(Sqlstr);
		try {
			if(rs.next()){
				mei = StringUtil.trans_date(rs.getString("TOUKYU_MEI"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		con.close();
		return mei;
	}

}