?? databasebean.java
字號:
package hbu.david.cmc.dao;
import java.sql.*;
public class DatabaseBean {
private static String driverName = "com.mysql.jdbc.Driver";
private static String username = "root";
private static String password = "851120";
private static String databaseURL = "jdbc:mysql://localhost:3306/openajaxalbum?useUnicode=true&characterEncoding=UTF-8";
/**
* 獲取數據庫連接Connection對象
* 無法獲取則返回null
* @return
*/
public static Connection getConnection() {
Connection conn = null;
try {
// 加載驅動程序
Class.forName(driverName);
// 獲取數據庫連接
conn = DriverManager.getConnection(databaseURL, username, password);
} catch (ClassNotFoundException cnfe) {
// 無法找到驅動程序
cnfe.printStackTrace();
conn = null;
} catch (SQLException sqle) {
// 數據庫發生異常
sqle.printStackTrace();
conn = null;
}
return conn;
}
/**
* 關閉連接
* 按次序釋放資源
* @param conn
* @param stmt
* @param rs
*/
public static void close(Connection conn, PreparedStatement prepstmt, ResultSet rs) {
try {
if (rs != null)
rs.close();
} catch (Exception rse) {
rse.printStackTrace();
}
try {
if (prepstmt != null)
prepstmt.close();
} catch (Exception stmte) {
stmte.printStackTrace();
}
try {
if (conn != null)
conn.close();
} catch (Exception conne) {
conne.printStackTrace();
}
}
public static void main(String[] args){
Connection conn=DatabaseBean.getConnection();
System.out.print(conn);
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -