datasourcepooltest.java

此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作

package pooling;

import java.sql.*;
import profiler.Profiler;

public class DataSourcePoolTest {

  private static DataSourceConnectionPool pool;
  private static String url = "jdbc:cloudscape:c:/wrox/database/Wrox4370.db";

  public static void main(String args[]) {

    // Create an instance of our profile
    Profiler p = new Profiler();

    try {

      // Establish our Connection
      System.out.println("Establish a connection [" + url + "]");
      p.Start("creating a pool of 10 connections");
      pool = new DataSourceConnectionPool();

      // Lets Get 10 Connections
      Connection c[] = new Connection[10];
      p.Stop();

      // Obtain 10 connections and profile this section of code
      // .. START
      p.Start("main() in PoolTest");
      for (int i = 0; i < 10; i++) {
        c[i] = pool.getConnection();
      } 
      p.Stop();

      // .. END

    } catch (Exception e) {
      e.printStackTrace();
    } 
  } 
}