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_;  }}