Connect to oracle, with general addition, deletion, modification, and query methods

Connect to oracle, with general addition, deletion, modification, and query methods

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 blocke.printStackTrace();}        try {conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","system","ok");} catch (SQLException e) {// TODO Auto-generated catch blocke.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 blocke.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();}    } }