JDBC配置文件db.properties(Mysql) 及dbutils的编写

package util;import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;import org.apache.commons.dbcp.BasicDataSource;public class DBUtils { private static BasicDataSource dataSource; static {
//读取属性配置文件
Properties prop = new Properties();
//得到文件输入流
InputStream ips = DBUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
//把文件流加载到prop对象中
try {
prop.load(ips);
String driver = prop.getProperty("driver");
String url = prop.getProperty("url");
String username = prop.getProperty("username");
String password = prop.getProperty("password");
String initSize = prop.getProperty("initialSize");
String maxSize = prop.getProperty("maxActive"); //创建连接池数据源对象
dataSource = new BasicDataSource();
dataSource.setDriverClassName(driver);
dataSource.setUrl(url);
dataSource.setUsername(username);
dataSource.setPassword(password);
//设置连接池策略信息
dataSource.setInitialSize(Integer.parseInt(initSize));
dataSource.setMaxActive(Integer.parseInt(maxSize)); } catch (IOException e) {
e.printStackTrace();
}
} public static Connection getConn() throws SQLException{
return dataSource.getConnection();
} public static void close(Connection conn,Statement stat,ResultSet rs) throws SQLException {
if(rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
throw e;
}
} if(stat != null) {
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
throw e;
}
} if(conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
throw e;
}
}
}}