scorewholequery.java

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

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

import com.itsv.gankao.common.*;

public class ScoreWholeQuery extends Query {
  public ScoreWholeQuery() {
  }

  public void searchByPersonId(Connection conn, String periodId, String personId)
              throws SQLException{

//  String sql = "SELECT * FROM " + ScoreWholeTable.TABLE_NAME
  String sql = "SELECT TCOUNT, WHOLE_SCORE, TNAME FROM " + ScoreWholeTable.TABLE_NAME
               + " WHERE " + ScoreWholeTable.FULL_COL_PERIOD_ID
               + " =? "
               + " AND " + ScoreWholeTable.FULL_COL_PERSON_ID
               + "=" + "'" + personId + "'";

  PreparedStatement statement = conn.prepareStatement(sql);
  long lPeriodId = new Long(periodId).longValue();
  long lPersonId = new Long(personId).longValue();

  statement.setLong(1, lPeriodId);
//  statement.setLong(2, lPersonId);
  statement_ = statement;
  result_ = statement.executeQuery();
}

public String getTcount() throws SQLException{
  return new Double(result_.getDouble(ScoreWholeTable.COL_TCOUNT)).toString();
}

public String getTName() throws SQLException{
  return result_.getString(ScoreWholeTable.COL_TNAME);
}

}