jdbcBaseDao封装模板

package easybuyDao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class jdbcbaseDao {
     private final String url="jdbc:oracle:thin:localhost:1521:orcl";
     private final String user="scott";
     private final String upwd="123456";
    /**
     * 数据库连接
     * @return
     */
    public Connection getConnection(){
        Connection conn=null;
        try {
          Class.forName("oracle.jdbc.driver.OracleDriver");
          conn=DriverManager.getConnection(url,user,upwd);
        } catch (Exception e) {
            System.out.println("数据库连接失败；");
        }
        return conn;
    }
    /**
     * 数据库关闭
     * @param conn
     * @param ps
     * @param r
     */
    public void closeRescources(Connection conn,PreparedStatement ps,ResultSet r){
        try {
            if(conn!=null)
                conn.close();
            if(ps!=null)
                ps.close();
            if(r!=null)
                r.close();
        } catch (Exception e) {
            System.out.println("资源关闭失败");
        }
    }

    /**
     * 数据库的增、删、改
     * @param sql
     * @param param
     * @return
     * @throws Exception
     */
    public int executeUpdate(String sql,Object[] param) throws Exception{
        Connection conn=getConnection();
        PreparedStatement ps=null;
        int i=0;
        try {
            ps=conn.prepareStatement(sql);
            for (int j = 0; j < param.length; j++) {
                ps.setObject(j+1,param[j]);
            }
            i=ps.executeUpdate();
        } catch (Exception e) {
            e.printStackTrace();
        }
        closeRescources(conn, ps, null);
        return i;
    }
    /**
     * 数据库的查询
     * @param sql
     * @param param
     * @return
     * @throws Exception
     */
    public ResultSet executeQuery(String sql,Object[] param) throws Exception {
        Connection conn=getConnection();
        PreparedStatement ps=null;
        ResultSet r=null;
        ps=conn.prepareStatement(sql);
        try{
        if(param!=null){
            for(int i=0;i<param.length;i++){
                ps.setObject(i+1, param[i]);
            }
        }
        r=ps.executeQuery();
        }catch(Exception e){
            e.printStackTrace();
        }
        closeRescources(conn, ps, r);   
        return r;
    }

}