连接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 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.poracle账号repareStatement(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();} } }