jdbc连接oracle
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class test {
private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";
private static final String URL = "jdbc:oracle:thin:@127.0.0.1:1521:xe";
private static final String UNAME = "oracle";
private static final String UPWD = "123456";
static {
try {
Class.forName(DRIVER);
System.out.println("连接成功");
} catch (ClassNotFoundException e) {
e.printStackTrace();
System.out.println("连接失败");
}
}
private Connection conn = null;
private PreparedStatement pstmt = null;
protected ResultSet res = null;
public void getConn() {
try {
conn = DriverManager.getConnection(URL, UNAME, UPWD);
} catch (SQLException e) {
e.printStackTrace();
}
}
protected void colseAll() {
if (null != res) {
try {
res.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (null != pstmt) {
try {
pstmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (null != conn) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
protected ResultSet excuteSelect(String sql, Object[] params) {
this.getConn();
try {
pstmt = conn.prepareStatement(sql);
if (null != params) {
for (int i = 0; i < params.length; i++) {
pstmt.setObject(i+1, params[i]);
}
}
res = pstmt.executeQuery();
} catch (SQLException e) {
e.printStackTrace();
}
return res;
}
protected int excuteEdit(String sql,Object[] params){
int count = 0;
this.getConn();
try {
pstmt = conn.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
pstmt.setObject(i+1, params[i]);
}
count = pstmt.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}finally {
this.colseAll();
}
return count;
}
}