testjdbc.java

来看一个RMI的示例。原理一定要搞清楚．

package dfbz.jdbc;

import java.rmi.RemoteException;
import java.sql.DriverManager;

import javax.naming.InitialContext;

public class TestJDBC {
	public static void main(String[] args) throws Exception{
		long l = System.currentTimeMillis();
		test2();
		System.out.println(System.currentTimeMillis() - l );
	}
	
	
	public static void test1() throws Exception{
		InitialContext ictx = new InitialContext();
		javax.sql.DataSource ds = (javax.sql.DataSource)ictx.lookup("jdbc/mysql");
		for(int i=0;i<1000;i++){
			java.sql.Connection con = ds.getConnection();
			con.close();
		}
		
	}
	
	public static void test2() throws Exception{
		String driver = "com.mysql.jdbc.Driver";
		String url = "jdbc:mysql://localhost:3306/test";
		Class.forName(driver);
		for(int i=0;i<1000;i++){
			java.sql.Connection con = DriverManager.getConnection(url,"root","root");
			con.close();
			
		}
	}
	
	
	
}