连接数据库的基础类BaseDao.java

来源：互联网发布：免费一元云购程序源码编辑：程序博客网时间：2024/06/07 13:28
package cn.adcc.Dao;/** * Created by Administrator on 2017/10/31. */import util.ConfigManager;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;/*数据库操作基类*/public class BaseDao {    Connection connection = null;    PreparedStatement pstmt = null;    ResultSet rs = null;    //获取数据库连接    public boolean getConnection() {        try {//       加载不同数据库厂商提供的驱动            Class.forName(ConfigManager.getInstance().getString("jdbc.driver"));//       （1）铺路（获取连接Connection）            String url = ConfigManager.getInstance().getString("jdbc.connection.url");            String username = ConfigManager.getInstance().getString("jdbc.connection.username");            String password = ConfigManager.getInstance().getString("jdbc.connection.password");            connection = DriverManager.getConnection(url, username, password);        } catch (ClassNotFoundException e) {            e.printStackTrace();            return false;        } catch (SQLException e) {            e.printStackTrace();            return false;        }        return true;    }    // 增删改    public int executeUpdate(String sql,Object[] params){        int updateRows = 0;        if(this.getConnection()){            try {                pstmt = connection.prepareStatement(sql);                //填充占位符                for(int i= 0;i<params.length;i++){                    pstmt.setObject(i+1, params[i]);                }                updateRows = pstmt.executeUpdate();            } catch (SQLException e) {                e.printStackTrace();            }        }        return updateRows;    }    //查    public ResultSet executeSQL(String sql,Object[] params){        if(this.getConnection()){            try {                pstmt = connection.prepareStatement(sql);                //填充占位符                for(int i= 0;i<params.length;i++){                    pstmt.setObject(i+1, params[i]);                }                rs = pstmt.executeQuery();            } catch (SQLException e) {                e.printStackTrace();            }        }        return rs;    }    // 释放资源(注意释放资源的顺序)    public boolean closeResource(){        if(rs!=null){            try {                rs.close();            } catch (SQLException e) {                e.printStackTrace();                return false;            }        }        if(pstmt!=null){            try {                pstmt.close();            } catch (SQLException e) {                e.printStackTrace();                return false;            }        }        if(connection!=null){            try {                connection.close();            } catch (SQLException e) {                e.printStackTrace();                return false;            }        }        return true;    }}
阅读全文
0 0