public class DBHelper {
private static String driver = "com.mysql.jdbc.Driver";//MySQL 驅動
private static String url = "jdbc:mysql://IP:3306/數據庫";//MYSQL數據庫連接Url
private static String user = "root";//用戶名
private static String password = "root";//密碼
/**
* 連接數據庫
* */
public static Connection getConn(){
Connection conn = null;
try {
Class.forName(driver);//獲取MYSQL驅動
conn = (Connection) DriverManager.getConnection(url, user, password);//獲取連接
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
/**
* 關閉數據庫
* */
public static void closeAll(Connection conn, PreparedStatement ps){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
/**
* 關閉數據庫
* */
public static void closeAll(Connection conn, PreparedStatement ps, ResultSet rs){
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (ps != null) {
try {
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (rs != null) {
try {
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
