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.*;
import java.io.IOException;
import java.io.BufferedReader;
import java.io.FileReader;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Hashtable;


public class FileReaderTest {
  public static void main(String[] args) throws Exception {

    int aa;    ////////////////////
    int i;   ///////////////////

   FileReaderTest test=new FileReaderTest();
try
{
    test.readLineFile("d:\\","Winpy1.txt");
}
catch (IOException e)
{
    // TODO Auto-generated catch block
    e.printStackTrace();
}




  }


  public void readLineFile(String filePath, String fileName)
          throws IOException
      , SQLException {
    Connection con;
    Statement stat=null;
    ResultSet rs;
    //Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    try {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      con = DriverManager.getConnection("jdbc:odbc:sjy", "", "");
      stat = con.createStatement();
    }
    catch (ClassNotFoundException e) {}
    // Connetion con=DriverManager.getConnection("jdbc:odbc:sjy","","");









      FileReader fr = new FileReader(filePath + fileName);
      BufferedReader br = new BufferedReader(fr);
      String line = br.readLine();
      while (line != null)
          {

               System.out.println(line);
   line = br.readLine();
   if(line!=null)
   {
       String hanzi=line.substring(0,1);
      // String pinyin=line.substring(1,line.length());

    //  String hanzi=line.substring(0,1);
             int i=1;
             for(;i<line.length();i++)
             {
               char c=line.charAt(i);
              if(c!='a' && c!='b' && c!= 'c'  && c!='d' && c!='e' && c!='f' && c!='g' && c!='h' && c!='i' && c!='j' && c!='k' && c!='l' && c!='m'
                  && c!='n' && c!='o' && c!='p' && c!='q' && c!='r' && c!='s' && c!='t' && c!='u' && c!='v' && c!='w' && c!='x' && c!='y' && c!='z')
               {
                  break;
               }
             }

             String pinyin=line.substring(1,i);
             String bihua=line.substring(i,line.length() );


    //////////

      String insertstr="insert into pinyin (hanzi,pinyin,bihua) values ('"+hanzi+"','"+pinyin+"','"+bihua+"')";
            try
           {
            stat.execute(insertstr);
            }
            catch (SQLException e3)
           {
                // TODO Auto-generated catch block
                e3.printStackTrace();
           }

            }
          }

  }


}