personrec.java

java网站源代码,有数据库的操作代码,业务逻辑代码等内容

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

public class PersonRec {
  public PersonRec() {
  }

  private String id_;
   private String name_;

   public static PersonRec[] loadByDepartId (Connection conn, String periodId, String departId)
       throws SQLException{

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

       try{
           query.searchByDepartId(conn, periodId, departId);

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

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

       return (PersonRec[])vec.toArray(new PersonRec[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_;
   }


}