test.java

这是我上次报java培训时

package jinLing.pub;

import java.util.*;

public class Test {
  PubDb pubDb = new PubDb();
  public Test() {
  }

  public Collection get_info(Hashtable list) {
    Collection col = null;
    String sql = "select * from tf_info where INFO_ID=" + list.get("INFO_ID").toString();
    System.out.print("==============at test:" + sql);
    col = pubDb.execSel(sql);
    return col;
  }

  public Collection get_info(Hashtable list, String pageno, String count) {
    Collection col = null;
    String sql = "select * from tf_info where INFO_ID=" + list.get("INFO_ID").toString();
    System.out.print("==============at test:" + sql);
    col = pubDb.execSel(sql, pageno, count);
    return col;
  }

  public int getCount() {
    int count = -1;
    try {
      count = pubDb.getRecordcount();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
    return count;
  }
}