81,122
社区成员




如果用DBCP
InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("java:xxxxx");
Connection conn = ds.getConnection();
package util;
import org.apache.commons.dbcp.*;
import java.sql.*;
import java.util.*;
public class DataSourceFactory {
private static String PROPERTIES_FILE = "/util/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;
}
}