123,123

您當(dāng)前所在位置：首頁(yè) → 數(shù)據(jù)庫(kù) → MYSQL → Mysql的最大連接數(shù)怎樣用java程序測(cè)試

Mysql的最大連接數(shù)怎樣用java程序測(cè)試 時(shí)間：2015-06-28 00:00:00 來(lái)源：IT貓撲網(wǎng) 作者：網(wǎng)管聯(lián)盟 我要評(píng)論(0)

以前工作的時(shí)候由于Oracle8i數(shù)據(jù)庫(kù)經(jīng)常出現(xiàn)用戶過(guò)多的錯(cuò)誤,由于數(shù)據(jù)量大,經(jīng)常出現(xiàn)ORA:12500錯(cuò)誤,但主要原因是訪問(wèn)過(guò)多而引起的,后來(lái)就用Java寫(xiě)了個(gè)簡(jiǎn)單的用JDBC連接來(lái)測(cè)試Oracle最大連接數(shù)的程序.現(xiàn)在常用MySQL,所以又寫(xiě)了一個(gè)簡(jiǎn)單的測(cè)試其最大連接數(shù)的程序，在此介紹給大家：

以下為引用的內(nèi)容：

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/MySQL", "root", "");
????? 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"
?? }
?}

關(guān)鍵詞標(biāo)簽：Mysql,java程序測(cè)試

相關(guān)閱讀

文章評(píng)論

查看所有0條評(píng)論>>