printresultset.java

来自「java数据库编程源码」· Java 代码 · 共 33 行

package JavaDatabaseBible.part2;

import java.io.*;
import java.sql.*; 

public class printResultSet{
  public static void main(String[] args){
    String url = args[0];
    String query = args[1];
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection con = DriverManager.getConnection (url);
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery(query);
      ResultSetMetaData md = rs.getMetaData();
	    PrintStream	out	= new PrintStream (new FileOutputStream("rs.txt"));
      
      int nColumns = md.getColumnCount();
      for(int i=1;i<=nColumns;i++){
        out.print(md.getColumnLabel(i)+((i==nColumns)?"\n":"\t"));
      }
      while (rs.next()) {
        for(int i=1;i<=nColumns;i++){
          out.print(rs.getString(i)+((i==nColumns)?"\n":"\t"));
        }
      }
    }
    catch(Exception e){
      e.printStackTrace();
    }
  }
}