idea spring boot 整合mybatis 和druid

 <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
//spring boot 需要1.5+
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
      <dependency>
            <groupId>org.mybatis.generator</groupId>
            <artifactId>mybatis-generator-core</artifactId>
            <version>1.3.6</version>
        </dependency>
   <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.0</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

以上是基础依赖，其他可自行添加

mapper接口扫描

@SpringBootApplication
@MapperScan("com.example.demo.mapper")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

@Configuration
public class DruidDataSourceConfiguration {
    @Bean
    @ConfigurationProperties(prefix = "spring.datasource")
    public DataSource druidDataSource() {
        DruidDataSource druidDataSource = new DruidDataSource();
        return druidDataSource;
    }
}

spring:
  application:
    name: webDemo

  datasource:
    url: jdbc:mysql://192.168.162.103:3306/user_center
    username: user_center
    password: user_center
    driver-class-name: com.mysql.jdbc.Driver
    # 使用druid数据源
    type: com.alibaba.druid.pool.DruidDataSource
server:
  port: 9001

mybatis:
  mapper-locations: classpath:com/example/demo/entity/*.xml

注意资源的路径需要/

 

调用

@Service
public class DbServie {
    @Autowired
    BaseCompanyUserMapper baseCompanyUserMapper;


    public List<BaseCompanyUser>  queryDbUser(String apiCode){
        BaseCompanyUserExample baseCompanyUserExample = new BaseCompanyUserExample();
        baseCompanyUserExample.createCriteria().andApiCodeEqualTo(apiCode);
        List<BaseCompanyUser> baseCompanyUsers = baseCompanyUserMapper.selectByExample(baseCompanyUserExample);
        return baseCompanyUsers;
    }


    public List<BaseCompanyUser> queryDbUsers(){
        BaseCompanyUserExample baseCompanyUserExample = new BaseCompanyUserExample();
        List<BaseCompanyUser> baseCompanyUsers = baseCompanyUserMapper.selectByExample(baseCompanyUserExample);
        return baseCompanyUsers;
    }
}