Java测试Mysql数据库的最大连接数

Java测试Mysql数据库的最大连接数类：

 

import java.sql.Connection; 
import java.sql.DriverManager; 
import java.sql.Statement; 
import java.sql.ResultSet; 
import java.sql.SQLException; 
import java.io.IOException; 

class  testMaxConn{ 
public   static   void  main(String args[]){ 
int  count = 0 ; 
Connection []conn = new  Connection[ 1000 ]; 
Statement []stmt  = new  Statement[ 1000 ]; 
ResultSet []rs  = new  ResultSet[ 1000 ]; 
try { 
Class.forName( " com.mysql.jdbc.Driver " ).newInstance(); 
for (count = 0 ;count < 300 ;count ++ ){ 
conn[count]  =  DriverManager.getConnection( " jdbc:mysql://localhost:3306/mysql " ,  " root " ,  " hicc " ); 
stmt[count] = conn[count].createStatement(); 
rs[count] = stmt[count].executeQuery( " SELECT * FROM user " ); 
while  (rs[count].next()){ 
// System.out.println(rs.getString(1)+"t "+rs.getString(2)); 
} 
System. out .print(count + " t " ); 
} 

} catch (SQLException ex1){ 
System. out .println( " n " + ex1.toString()); 
} catch (InstantiationException ex2){ 
System. out .println( " n " + ex2.toString()); 
} catch (ClassNotFoundException ex3){ 
System. out .println( " n " + ex3.toString()); 
} catch (IllegalAccessException ex4){ 
System. out .println( " n " + ex4.toString()); 
} finally { 
try { 
System. out .println( " nSystem has opened  " + count --+ "  Mysql connections.nPress Enter key to close the connections " ); 
System. in .read(); 
System. out .println( " nClose the Connections: " ); 
for (;count >= 0 ;count -- ){ 
rs[count].close(); 
stmt[count].close(); 
conn[count].close(); 
System. out .print(count + " t " ); 
} 
} catch (SQLException ex){ 
System. out .println( " n Close connection exception: " + ex.toString()); 
} catch (IOException io_ex){} 
} // end the first "try" 
} 
}

 

DOS下运行结果：

 

 

 

很爽吧