?? commdao.java
字號:
package com.tingsun.oa.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
public class CommDAO {
public Connection getConn(){
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn =DriverManager.getConnection(//創建數據連接
"jdbc:oracle:thin:@127.0.0.1:1521:gdb", "med", "med");
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//oracle 裝載驅動,加入java 對象
return conn;
}
public void closeConn(Connection conn){
try {
conn.close();
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
}
public void closeConn(Connection conn,Statement stmt,ResultSet rs){
try {
if(rs!=null){
rs.close();
}
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
}
public void closeConn(Connection conn,PreparedStatement pst){
try {
if(pst!=null){
pst.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
}
public void closeConn(Connection conn,PreparedStatement pst,ResultSet rs){
try {
if(rs!=null){
rs.close();
}
if(pst!=null){
pst.close();
}
if(conn!=null){
conn.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -