[JDBC技术]3.JDBC数据库连接池实例

package jdbc;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Properties;

import org.logicalcobwebs.proxool.*;

import java.sql.DriverManager;

/**

* 通过组件连接Oracle数据库

*/

import org.logicalcobwebs.proxool.ProxoolDriver;

public class JDBCData

{

public static void main(String[] args)

{

// TODO Auto-generated method stub

try

{

//加载启动

Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");

//设置属性，连接数

Properties info = new Properties();

info.setProperty("proxool.maximum-connection-count", "10");

info.setProperty("proxool.house-keeping-test-sql", "select CURRENT_DATA");

//用户名和密码

info.setProperty("user", "SYSTEM");

info.setProperty("password", "password");

String alias = "test";

//加载Oracle的启动和URL

String driverClass = "oracle.jdbc.driver.OracleDriver";

String deiverURL = "jdbc:oracle:thin:@localhost:1521:orcl";

String url = "proxool." + alias + ":" + driverClass + ":" +deiverURL;

//通过组件的方式注册连接

ProxoolFacade.registerConnectionPool(url,info);

Connection con = DriverManager.getConnection(url);

Statement st = con.createStatement();

ResultSet rs = st.executeQuery("select * from student");

while(rs.next())

{

System.out.println(rs.getString(1));

System.out.println(rs.getString(2));

System.out.println(rs.getString(3));

}

}

catch (ClassNotFoundException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

catch (ProxoolException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

catch (SQLException e)

{

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

此连接方式需要以下库文件： <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

如果觉得《[JDBC技术]3.JDBC数据库连接池实例》对你有帮助，请点赞、收藏，并留下你的观点哦！