连接oracle，附通用增删改查方法

package cn.jbit.pet.dao;
import java.sql.*;
public class BaseDao {

protected Connection conn=null;
protected PreparedStatement pstmt=null;
protected ResultSet rs=null;

public void getConnection() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
        try {
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","ok");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

public void closeAll() {

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

e.printStackTrace();
}
}
    
    public int executeUpdateSQL(String sql,Object []param){
     int num=0;
     try {
     getConnection();
pstmt=conn.prepareStatement(sql);
if(param!=null){
for (int i = 0; i < param.length; i++) {
pstmt.setObject(i+1, param[i]);
}
}
num=pstmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
closeAll();
}
return num;
    }
    public void executeQuerySQL(String sql,Object []param){
     try {
     getConnection();
pstmt=conn.prepareStatement(sql);
if(param!=null){
for (int i = 0; i < param.length; i++) {
pstmt.setObject(i+1, param[i]);
}
}
rs=pstmt.executeQuery();
} catch (SQLException e) {

e.printStackTrace();
}
    } 
}