scoretotlerec.java

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

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

public class ScoreTotleRec {

  public ScoreTotleRec() {
  }

  private String score_;
  private String tname_;

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

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

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

           while (query.next()) {
                  ScoreTotleRec rec = new ScoreTotleRec();
                  rec.setScore(query.getScore());
                  rec.setTName(query.getTName());
                  vec.add(rec);
           }

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

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

   public void setScore(String sScore){
       score_=sScore;
   }

   public void setTName(String sTname){
       tname_ = sTname;
   }

   public String getScore() {
       return score_;
   }

   public String getTName() {
       return tname_;
   }


}