packagedbtest;importjava.sql.Connection;importjava.sql.DriverManager;importjava.sql.SQLException;publicclassDBconnector{publicstaticConnectiongetMySQLConnection(Stringdri...
package dbtest;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBconnector {
public static Connection getMySQLConnection(String dricerClassName,String serverHost,
String serverPort,String dbName,String userName,String password)throws
ClassNotFoundException,
SQLException{
if(dricerClassName==null){
dricerClassName="com.mysql.jdbc.Driver";
}
if(serverHost==null){serverHost="127.0.0.1";
}
if(serverPort==null){serverPort="3306";
}
String dbURL="jdbc:mysql://"+serverHost+":" +serverPort+"/"+dbName;
Class.forName("com.mysql.jdbc.Driver");
return getConnection(dricerClassName,dbURL,userName,password);
}
public static void main (String[] srgs)throws ClassNotFoundException,
SQLException{
String mySQLDriver="com.mysql.jdbc.Driver";
String dbName="testdb";
String userName="root";
String password="root";
Connection con=DBconnector.getMySQLConnection(mySQLDriver, null, null, dbName,
userName, password);
System.out.println("连接成功");
con.close();
String url="jdbc:mysql://127.0.01.:3306/"+dbName;
con =DBconnector.getConnection(mySQLDriver,url,userName,password);
con.close();
System.out.println("关闭");
}
}
展开