departmentquery.java

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

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

import com.itsv.gankao.common.*;


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

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

      String sql = "SELECT " + DepartmentTable.wholeSql
                   + " FROM " + PerioDicalTable.TABLE_NAME
                   + "," + ScoreTable.TABLE_NAME
                   + "," + PersonTable.TABLE_NAME
                   + "," + DepartmentTable.TABLE_NAME
                   + " WHERE " + PerioDicalTable.FULL_COL_ID
                   + "=" + ScoreTable.FULL_COL_PERIOD_ID
                   + " AND " + ScoreTable.FULL_COL_PERSON_ID
                   + "=" + PersonTable.FULL_COL_ID
                   + " AND " + PersonTable.FULL_COL_DEP_ID
                   + "=" + DepartmentTable.FULL_COL_ID
                   + " AND " + PerioDicalTable.FULL_COL_ID
                   + "=?";

      PreparedStatement statement = conn.prepareStatement(sql);
      statement.setString(1, periodId);
      statement_ = statement;
      result_ = statement.executeQuery();
  }

  public String getID() throws SQLException{
      return result_.getString(PerioDicalTable.COL_ID);
  }

  public String getName() throws SQLException{
      return result_.getString(PerioDicalTable.COL_NAME);
  }

}