JAVA Maven项目MyBatis+阿里Druid连接池 整合

    
    
      junit
      junit
      4.11
    
      
          org.junit.jupiter
          junit-jupiter
          RELEASE
          compile
      
    
    
    
      org.mybatis
      mybatis
      3.5.2
      compile
    

    
    
      mysql
      mysql-connector-java
      8.0.22
    
    
      
          com.alibaba
          druid
          1.2.8
      
  

public class MybatisUtils {
    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            //定义配置文件路径
            String resource = "mybatis-config.xml";
            //定义好配置文件路径后 使用InputStream 将文件读取进内存
            InputStream inputStream = Resources.getResourceAsStream(resource);
            //将配置文件放入 SqlSession工厂构建器 里面创建一个 sqlSession工厂
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    
    public static SqlSession getSession(){
        //通过 SQLSession工厂获取一个 SQLSession对象
        return sqlSessionFactory.openSession();
    }
}

public class DruidDataSourceFactory extends UnpooledDataSourceFactory {
    public DruidDataSourceFactory (){
        this.dataSource=new DruidDataSource();
    }

    
    @Override
    public DataSource getDataSource() {
        try {
            ((DruidDataSource)this.dataSource).init();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return  this.dataSource;
    }
}

到此关于怎么让MyBatis和Druid整合的教程就结束了 现在我们可以写一个小小的案例看一下结果。

创建一个Mapper

    
        select * from user
    

配置Mapper接口

package com.xiao.dao;

import com.xiao.pojo.User;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;


public interface UserMapper {
    
    List findUserAll();
}

测试代码

public class MyTest {
    @Test
    public static void main(String[] args) {
        //创建一个SqlSession对象
        SqlSession session = MybatisUtils.getSession();

        UserMapper mapper = session.getMapper(UserMapper.class);

        List users = mapper.findUserAll();

        for (User user : users) {
            System.out.println(user.getUsername());
        }

        //SqlSession对象用完即销毁
        session.close();
    }
}

运行结果

新人博主，纯手码，点个赞吧！！！！