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

数据库的基础类BaseDao.java连接教程。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