如何用jdbc函数返回select查询到的整个表

Question

import java.sql.*;
public class Lookup {
  public static void main(String[] args) {
    try {
      Class.forName(
        "sun.jdbc.odbc.JdbcOdbcDriver");
      Connection c = DriverManager.getConnection(
        "jdbc:odbc:MyDataTest","sa","");
      Statement s = c.createStatement();
      ResultSet r = 
        s.executeQuery("sp_helpdb");
      while(r.next()) {
        System.out.println(
          r.getString("name") + ", " 
          + r.getString("db_size")
          + ": " + r.getString("owner")
          + ": " + r.getString("dbid")
          + ": " + r.getString("created")
          + ": " + r.getString("status")
          + ": " + r.getString("compatibility_level"));
      }
      s.close();
    } catch(Exception e) {
      e.printStackTrace();
    }
  }
}

Answer 1

ResultSet 的实例 调用 next方法

Answer 2

ResultSet qtr=statement.executequery(sql);
while (qtr.next())
{
out.println(qtr.getString(1));
......
}