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);  }}