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 {

  public static void main(String[] args) throws Exception {
    String hanzi, pinyin;
    Connection con;
    Statement stat;
    ResultSet rs;
    //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    }
    catch (ClassNotFoundException e) {}
    // Connetion con=DriverManager.getConnection("jdbc:odbc:sjy","","");
    try {
      con = DriverManager.getConnection("jdbc:odbc:sjy", "", "");
      stat = con.createStatement();
     rs = stat.executeQuery("SELECT * from pinyin ");
      while(rs.next())
      {
          System.out.println(rs.getString("hanzi") );
       }


     con.close();
    }
    catch (SQLException e) {}

  }


}