package com.itsv.gankao.database;import java.sql.*;import java.util.*;import com.itsv.gankao.common.*;public class PerioDicalQuery extends Query {  public PerioDicalQuery() {  }  public void searchByGuideLineId(Connection conn, String guidLindId)              throws SQLException{      String sql = PerioDicalTable.sSQL + " WHERE "                   + PerioDicalTable.FULL_COL_GUIDELINE_ID                   + " =?";      PreparedStatement statement = conn.prepareStatement(sql);      statement.setString(1, guidLindId);      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);  }}