在com.sqlpool包中新建两个文件，一个是DataSourceFactory.java,另一个是databaseresource.properties配置文件
然后是导包：commons-dbcp-1.2.1.jar，commons-pool-1.3.jar，msbase.jar，mssqlserver.jar，msutil.jar，这5个jar包（ 已上传到个人资源文件）
下载地址：http://download.csdn.net/download/qq_39045774/9958805
DataSourceFactory.java：
package com.sqlpool; import org.apache.commons.dbcp.*; import java.sql.*; import java.util.*; public class DataSourceFactory { private static String PROPERTIES_FILE = "/com.sqlpool/databaseresource.properties"; private static DataSourceFactory instance = null; private BasicDataSource ds1; private DataSourceFactory() { Properties prop = new Properties(); try { prop.load(this.getClass().getResourceAsStream(PROPERTIES_FILE)); ds1 = (BasicDataSource)BasicDataSourceFactory.createDataSource(prop); } catch (Exception e) { e.printStackTrace(); } } public static DataSourceFactory getInstance() { if(instance == null) { instance = new DataSourceFactory(); } return instance; } public Connection getConnection() { Connection conn = null; try { conn = ds1.getConnection(); } catch (Exception e) { e.printStackTrace(); return null; } return conn; } }databaseresource.properties
driverClassName=com.microsoft.jdbc.sqlserver.SQLServerDriver url=jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=DataSpaceBi_db //friend为数据库名 username=sa //数据库连接用户名 password=###### //数据库连接密码 defaultAutoCommit=true //是否自动提交事务 maxActive=10 //连接池最大连接数
弄好后在程序中用 Connection conn = DataSourceFactory.getInstance().getConnection(); 就可以得到数据库连接了
