package mysqlconnnumber;
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:3308/mysql", "root", "root");//修改了端口为3308,默认是3306
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.println(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.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"
}
}