dbsqlserver.java

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

import java.sql.*;
import java.net.URL.*;
public class DBSqlserver {
  public static void main(String[] args) {
    try {
     Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
     Connection conn = DriverManager.getConnection
         ("jdbc:microsoft:sqlserver://219.229.183.114:1433;DatabaseName=northwind","sa","fox/hunter");

      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from region");
      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 ();
               }
}

}