package com.itsv.gankao.database;import java.sql.*;import java.util.*;import com.itsv.gankao.common.*;public class ScoreTotleQuery extends Query {  public ScoreTotleQuery() {  }  public void searchByPersonId(Connection conn, String periodId, String personId)              throws SQLException{  String sql = ScoreTotleTable.sSQL               + " WHERE " + ScoreTotleTable.FULL_COL_PERIOD_ID               + " =? "               + " AND " + ScoreTotleTable.FULL_COL_PERSON_ID               + "=" + "'" + personId + "'";  PreparedStatement statement = conn.prepareStatement(sql);  statement.setString(1, periodId);//  statement.setString(2, personId);  statement_ = statement;  result_ = statement.executeQuery();}public String getScore() throws SQLException{   return new Double(result_.getDouble(ScoreTotleTable.COL_SCORE)).toString();}public String getTName() throws SQLException{  return result_.getString(ScoreTotleTable.COL_TNAME);}}