ResourceUtil 封装了对资源文件的操作,可在博客内找到封装的代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
/**
* DBUtil 负责数据库的连接和关闭工具类.
*
*/
public final class DBUtil {
/** 数据库驱动 */
private static final String MMS_DB_DRIVER = ResourceUtil.getDBDriver();
/** 数据库URL */
private static final String MMS_DB_URL = ResourceUtil.getUrl();
/** 数据库用户名 */
private static final String MMS_DB_USER_NAME = ResourceUtil.getDBUserName();
/** 数据库用户密码 */
private static final String MMS_DB_USER_PWD = ResourceUtil.getDBPassword();
/**
* 获得数据库连接
*
* @return 数据库连接
* @throws MMSException
* 发生异常,则抛出MMSException
*/
public static Connection getConnection() throws MMSException {
Connection conn = null;
try {
Class.forName(MMS_DB_DRIVER);
conn = DriverManager.getConnection(MMS_DB_URL, MMS_DB_USER_NAME,
MMS_DB_USER_PWD);
} catch (Exception e) {
throw new MMSException("Get the connection exception: " + e);
}
return conn;
}
/**
* 关闭资源
*
* @param rs
* 结果集
* @param stmt
* 状态集
* @param conn
* 连接
*/
public static void close(ResultSet rs, Statement stmt, Connection conn) {
try {
if (rs != null)
rs.close();
if (stmt != null)
stmt.close();
if (conn != null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
转载于:https://blog.51cto.com/7160225/1196284