java数据库原理,java的DataSource种连接数据库原理

java的DataSource类连接数据库原理

需要jar包：

commons-validator.jar

commons-dbcp-1.3.jar

commons-beanutils.jar

commons-pool-1.5.2.jar

commons-logging.jar

ojdbc14.jar

package org.liujian.test.db;

import org.apache.commons.dbcp.BasicDataSource;

/**

* File Desc: dataSource类

* Product Name: SIRM

* Module Name: BaseDase

* Author:      刘建

* History:     11-12-10 created by 刘建

*/

public class DataSource {

private BasicDataSource dataSource;

public static BasicDataSource getDataSource() {

BasicDataSource basicDataSource = new BasicDataSource();

basicDataSource.setDefaultAutoCommit(true);

basicDataSource.setDriverClassName("oracle.jdbc.driver.OracleDriver");

basicDataSource.setUrl("jdbc:oracle:thin:@192.168.20.160:1521:orcl");

basicDataSource.setUsername("sirmetltest");

basicDataSource.setPassword("sirmetltest");

return basicDataSource;

}

}

package org.liujian.test.db;

import java.sql.*;

/**

* File Desc:

* Product Name: SIRM

* Module Name: BaseDase

* Author:      刘建

* History:     11-12-10 created by 刘建

*/

public class DataSourceFactory {

public static void main(String[] args) {

try {

// Class.forName("oracle.jdbc.driver.OracleDriver");

// Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@192.168.20.160:1521:orcl", "sirmetltest", "sirmetltest");

Connection ct = DataSource.getDataSource().getConnection();

Statement statement = ct.createStatement();

ResultSet rs = statement.executeQuery("select * from r_database");

while (rs.next()) {

System.out.println(rs.getString("name"));

}

rs.close();

statement.close();

ct.close();

} catch (Exception ex) {

ex.printStackTrace();

}

}

}