jdbcBaseDao封装模板

来源：互联网发布：大数据概念股一览编辑：程序博客网时间：2024/05/22 17:00
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;    }}
阅读全文
0 0