scorewholerec.java

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

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

public class ScoreWholeRec {
  public ScoreWholeRec() {
  }

  private String tcount_;
  private String tname_;

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

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

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

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

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

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

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

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

   public String getScore() {
       return tcount_;
   }

   public String getTName() {
       return tname_;
   }


}