departmentrec.java

来自「java网站源代码,有数据库的操作代码,业务逻辑代码等内容」· Java 代码 · 共 55 行

package com.itsv.gankao.database;
import java.sql.*;
import java.util.*;

public class DepartmentRec {
  public DepartmentRec() {
  }

  private String id_;
  private String name_;

  public static DepartmentRec[] loadByPeriodId
                              (Connection conn, String periodId) throws SQLException{

      DepartmentQuery query = new DepartmentQuery();
      Vector vec = new Vector();

      try{
          query.searchByPeriodId(conn, periodId);

          while (query.next()) {
                 DepartmentRec rec = new DepartmentRec();
                 rec.setID(query.getID());
                 rec.setName(query.getName());
                 vec.add(rec);
          }

      } catch (SQLException e){
          e.printStackTrace();
          throw e;
      }finally{
          query.close();
      }

      return (DepartmentRec[])vec.toArray(new DepartmentRec[vec.size()]);
  }

  public void setID(String id){
      id_=id;
  }

  public void setName(String name){
      name_ = name;
  }

  public String getID() {
      return id_;
  }

  public String getName() {
      return name_;
  }


}