datasource 类

package org.leno.javabean;



import java.sql.SQLException;

import org.apache.commons.dbcp.BasicDataSource;



public class DataSourceFactory {



/**

* @param args

*/

private static BasicDataSource ds;



public static BasicDataSource getDataSource() {

if (ds == null) {

ds = new BasicDataSource();

ds.setDriverClassName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

ds.setUrl("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=java28");

ds.setUsername("sa");

ds.setPassword("123");

ds.setMaxActive(5);

}

return ds;



}



public static void main(String[] args) {

// TODO Auto-generated method stub

try {

System.out.println(DataSourceFactory.getDataSource()

.getConnection());

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}



}



}