java多线程

import java.sql.Connection;  
import java.sql.ResultSet;  
import java.sql.SQLException;  
 
public class Test1 extends Thread{  
 
    private String sql;  
    private String poolname;  
    private Connection c;  
    public Test1(String poolname,Connection c,String sql){  
        this.poolname=poolname;  
        this.c=c;  
        this.sql=sql;  
    }  
    public static void main(String[] args) {  
          
        for(int i=0;i<100;i++){  
            String sql="select * from table1 limit "+i+",1";  
 
            new Test1("datamininfo",MyDbPool.getDbConnection("datamininfo"),sql).start();  
              
            sql="select * from table2 limit "+i+",1";  
            new Test1("uic",MyDbPool.getDbConnection("uic"),sql).start();  
        }  
 
    }  
      
    public void run(){  
        try {  
            ResultSet rs=c.createStatement().executeQuery(sql);  
            while(rs.next()){  
                System.out.println(rs.getString(1));  
            }  
            if(poolname.equals("datamininfo"))  
            System.out.println("DataMinInfo:n"+MyDbPool.GetPoolStats("name1"));  
            else 
            System.out.println("UIC:n"+MyDbPool.GetPoolStats("name2"));  
        } catch (SQLException e) {  
            e.printStackTrace();  
        }finally{  
            MyDbPool.close(c);  
        }  
    }  
 
}