periodicalquery.java

java网站源代码,有数据库的操作代码,业务逻辑代码等内容

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


}