filereader.java~18~

完成一级汉字和二级汉字的按拼音排序和按笔画排序功能

package net.bishe.file;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */
import java.sql.*;                  // JDBC package
import com.microsoft.jdbc.sqlserver.*;

public class FileReader {
  private java.sql.Connection  con = null;
  private final String url = "jdbc:microsoft:sqlserver://";
  private final String serverName= "localhost";
  private final String portNumber = "1433";
  private final String databaseName= "pubs";
  private final String userName = "sa";
      private final String password = "";
      // Informs the driver to use server a side-cursor,
  // which permits more than one active statement
  // on a connection.
  private final String selectMethod = "cursor";


  private String getConnectionUrl(){
       return url+serverName+":"+portNumber+";databaseName="+databaseName+";selectMethod="+selectMethod+";";
  }

  private java.sql.Connection getConnection(){
       try{
            Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
            System.out.println(getConnectionUrl());
            con = java.sql.DriverManager.getConnection(getConnectionUrl(),userName,password);
            if(con!=null) System.out.println("Connection Successful!");
       }catch(Exception e){
            e.printStackTrace();
            System.out.println("Error Trace in getConnection() : " + e.getMessage());
      }
       return con;
   }

  /*
       Display the driver properties, database details
  */

  public void displayDbProperties(){
       java.sql.DatabaseMetaData dm = null;
       java.sql.ResultSet rs = null;
       try{
            con= this.getConnection();
            if(con!=null){
                 dm = con.getMetaData();
                 System.out.println("Driver Information");
                 System.out.println("\tDriver Name: "+ dm.getDriverName());
                 System.out.println("\tDriver Version: "+ dm.getDriverVersion ());
                 System.out.println("\nDatabase Information ");
                 System.out.println("\tDatabase Name: "+ dm.getDatabaseProductName());
                 System.out.println("\tDatabase Version: "+ dm.getDatabaseProductVersion());
                 System.out.println("Avalilable Catalogs ");
                 rs = dm.getCatalogs();
                 while(rs.next()){
                      System.out.println("\tcatalog: "+ rs.getString(1));
                 }
                 rs.close();
                 rs = null;
                 closeConnection();
            }else System.out.println("Error: No active Connection");
       }catch(Exception e){
            e.printStackTrace();
       }
       dm=null;
  }

  private void closeConnection(){
       try{
            if(con!=null)
                 con.close();
            con=null;
       }catch(Exception e){
            e.printStackTrace();
       }
  }
  public static void main(String[] args) throws Exception
    {
    //   FileReader myDbTest = new FileReader();
      // myDbTest.displayDbProperties();
      try{
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;User=sa;Password=;DatabaseName=hxy");
      Statement stmt=conn.createStatement();
      String sql="select * from pinyin";
      ResultSet rs = stmt.executeQuery(sql);
      while(rs.next())
      {
        System.out.println(rs.getString("hanzi"));

      }

     }
    catch(Exception ex)
    {
      System.err.println(ex.getMessage());
    }





    }



}