我的数据库录入程序是从一个文件逐行读入字符,然后插入数据库里,使用一个文件或几个文件测试时是正常的,但是如果文件过多就会报错,希望给予指点,我把程序代码和报错信息放在这里
s1=br.readLine();
     int rowCnt=0;//用于时间的计数器
     String preDate="";
     while((s1=br.readLine())!=null)
     {
     i=0;
     StringTokenizer word=new StringTokenizer(s1);
     while(word.hasMoreTokens())
     {
     i++;
     x[i]=word.nextToken();
     }
     if(!preDate.equals(x[1])){rowCnt=0;preDate=x[1];}
     date=x[1]+" "+time[rowCnt++];
     sql.execSQLCommand("use hs300;insert into hs300 values('"+date+"','"+txtName+"','"+x[2]+"','"+x[3]+"','"+x[4]+"','"+x[5]+"','"+x[6]+"','"+x[7]+"');");
    
     }
     br.close();
     reader.close();
     sql.closeConnection();错误信息:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Address alread
y in use: connect
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establis
hing socket.
        at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source
)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
        at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)        at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Sou
rce)
        at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown S
ource)
        at com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Sour
ce)
        at com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Sou
rce)
        at com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
        at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source
)
        at com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source
)
        at SQL.execSQLCommand(SQL.java:45)
        at InsertSQL.insert2DB(InsertSQL.java:47)
        at InsertSQL.insert2DB(InsertSQL.java:62)
        at InsertSQL.main(InsertSQL.java:66)java.lang.NullPointerException
        at SQL.execSQLCommand(SQL.java:46)
        at InsertSQL2.insert2DB(InsertSQL2.java:109)
        at InsertSQL2.insert2DB(InsertSQL2.java:148)
        at InsertSQL2.main(InsertSQL2.java:152)
java.lang.NullPointerException
        at SQL.execSQLCommand(SQL.java:46)
        at InsertSQL2.insert2DB(InsertSQL2.java:109)
        at InsertSQL2.insert2DB(InsertSQL2.java:148)
        at InsertSQL2.main(InsertSQL2.java:152)
java.lang.NullPointerException
        at SQL.execSQLCommand(SQL.java:46)
        at InsertSQL2.insert2DB(InsertSQL2.java:109)
        at InsertSQL2.insert2DB(InsertSQL2.java:148)
        at InsertSQL2.main(InsertSQL2.java:152)