jdbc

package cn.itcast.utils;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ResourceBundle;


public class JDBCUtils {
private static  String driverClass;
private static  String url;
private static  String username;
private static  String password;

static{
//Property 
driverClass = ResourceBundle.getBundle("db").getString("driverClass");
url = ResourceBundle.getBundle("db").getString("url");
username = ResourceBundle.getBundle("db").getString("username");
password = ResourceBundle.getBundle("db").getString("password");
}

//获得连接
public static Connection getConnection() throws SQLException{
//加载驱动
loadDirver();
return DriverManager.getConnection(url, username,password);
}


private static void loadDirver() {
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}

//释放资源.
public static void release(Statement stmt,Connection conn){
// 释放资源
if (stmt != null) {
try {
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
stmt = null;
}


if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
conn = null;
}
}

public static void release(ResultSet rs ,Statement stmt,Connection conn){
// 释放资源
if(rs != null){
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
rs = null;
}
release(stmt, conn);
}
}