dbmain.java

来自「java Java书籍里面有很多初学java的资料」· Java 代码 · 共 46 行

package DBacc;
import java.sql.*;
import java.net.URL.*;
public class DbMain {
  public static void main(String[] args) {
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      String url="jdbc:odbc:Driver={MicroSoft access Driver (*.mdb)};DBQ=test.mdb";
      Connection conn = DriverManager.getConnection(url,"","");
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from admin");
      dispResultSet(rs);
    }
    catch (Exception ex) {
      System.out.print(ex.toString());
    }
  }
  private static void dispResultSet (ResultSet rs) throws SQLException
{
      int i;
       // 取得结果集的元数据
      ResultSetMetaData rsmd = rs.getMetaData ();
       // 获得结果集的列数
      int numCols = rsmd.getColumnCount ();
       // 显示列的标题
       for (i=1; i<=numCols; i++) {
               if (i > 1) System.out.print("，     ");
               System.out.print(rsmd.getColumnLabel(i));
       }
       System.out.println("");
       System.out.println("");
       // 显示结果集中所有数据
       boolean more = rs.next ();
       while (more) {
               // 循环显示结果集中的所有数据
               for (i=1; i<=numCols; i++) {
                       if (i > 1) System.out.print("，  ");
                       System.out.print(rs.getString(i));
               }
               System.out.println("");
               // 获得下一行数据
               more = rs.next ();
               }
}

}