package testsql;
import java.io.*;
import java.sql.*;
import java.util.*;
public class txtsql {
  public txtsql() {
  }
  public static void main(String[] args) {
    try{
     BufferedReader br=new BufferedReader(new FileReader(args[0]));
     String[] line=new String[10];
     int i;
     for(i=0;i<=9;i++)
        line[i]=br.readLine() ;//line[0] 是空行.line[1]--line[9]

      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
      Connection conn = DriverManager.getConnection
      ("jdbc:microsoft:sqlserver://JIANGNS1\\\\JNSINSTANCE:1433;User=sa;Password=jns;DatabaseName=jnstest");

      StringBuffer inst;
      Statement st=conn.createStatement()   ;

      StringTokenizer st0=new StringTokenizer(line[1]);st0.nextElement() ;
      StringTokenizer st1=new StringTokenizer(line[2]);st1.nextElement() ;
      StringTokenizer st2=new StringTokenizer(line[3]);st2.nextElement() ;
      StringTokenizer st3=new StringTokenizer(line[4]);st3.nextElement() ;
      StringTokenizer st4=new StringTokenizer(line[5]);st4.nextElement() ;
      StringTokenizer st5=new StringTokenizer(line[6]);st5.nextElement() ;
      StringTokenizer st6=new StringTokenizer(line[7]);st6.nextElement() ;
      StringTokenizer st7=new StringTokenizer(line[8]);st7.nextElement() ;
      StringTokenizer st8=new StringTokenizer(line[9]);st8.nextElement() ;

      while(st0.hasMoreTokens() )
      {
        inst=new StringBuffer("insert into jnstable ( N410,N411,N412,N413,N414,N415,N416,N417,N418)VALUES(");
        inst.append(st0.nextToken()+","+st1.nextToken()+","+st2.nextToken()+","+
                    st3.nextToken()+","+st4.nextToken()+","+st5.nextToken()+","+
                    st6.nextToken()+","+st7.nextToken()+","+st8.nextToken()+")") ;
        System.out .println(inst) ;
        st.executeUpdate(inst.toString() ) ;
      }
    conn.close() ;
    }catch(FileNotFoundException e){ System.out .println(e) ;}
     catch(ClassNotFoundException e){ System.out .println(e) ;}
     catch(java.sql.SQLException  e){ System.out .println(e) ;}
     catch(IOException e){ System.out .println(e) ;}

  }
  }
[/color]