scoreitemsrec.java

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

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

public class ScoreItemsRec {
  public ScoreItemsRec() {
  }

  private String name_;
  private String tvalue_;

  public static ScoreItemsRec[] loadByPersonId (Connection conn, String periodId, String personId)
       throws SQLException{

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

       try{
           query.searchByPersonId(conn, periodId, personId);

           while (query.next()) {
                  ScoreItemsRec rec = new ScoreItemsRec();
                  rec.setName(query.getName());
                  rec.setTvalue(query.getTvalue());
                  vec.add(rec);
           }

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

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

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

   public void setTvalue(String tvalue){
       tvalue_ = tvalue;
   }

   public String getName() {
       return name_;
   }

   public String getTvalue() {
       return tvalue_;
   }

}