建立DBUtil类用来读取xml配置内容

package util;


import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;


import org.apache.commons.dbcp.BasicDataSource;

//注意从maven导入相应的依赖的jar包，如ojdbc14:10.2.0.4.0;commons-dbcp1.4;jstl1.2;tomcat自带包
public class DBUtil {
private static BasicDataSource ds;
static{
Properties prop = new Properties();
try {
prop.load(DBUtil.class.getClassLoader().getResourceAsStream("config.properties"));
String className = prop.getProperty("className");
String url = prop.getProperty("url");
String userName = prop.getProperty("userName");
String password = prop.getProperty("password");
int maxActive = Integer.parseInt(prop.getProperty("maxactive"));
int maxWait = Integer.parseInt(prop.getProperty("maxwait"));

ds = new BasicDataSource();
ds.setDriverClassName(className);
ds.setUrl(url);
ds.setUsername(userName);
ds.setPassword(password);
ds.setMaxActive(maxActive);
ds.setMaxWait(maxWait);

} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws Exception{
return ds.getConnection();
}

public static void closeConnection(Connection conn){
if(conn!=null){
try {
conn.setAutoCommit(true);
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

public static void main(String[] args) {
try {
Connection conn = DBUtil.getConnection();

} catch (Exception e) {
e.printStackTrace();
}

}

}