springboot+beetlsql+mysql整合

一、工程目录结构

 

二、pom.xml文件配置

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <scope>runtime</scope>
</dependency>

      <!--beetlsql-->
      <dependency>
          <groupId>com.ibeetl</groupId>
          <artifactId>beetl-framework-starter</artifactId>
          <version>1.1.35.RELEASE</version>
      </dependency>
      <dependency>
          <groupId>com.ibeetl</groupId>
          <artifactId>beetlsql</artifactId>
          <version>2.10.10</version>
      </dependency>

三、beetlsqlConfig文件

@Configuration
public class BeetlSqlConfig {
　　//=============以下是beetl配置=========================
    @BeaninitMethod = "init", name = "beetlConfig")
    public BeetlGroupUtilConfiguration getBeetlGroupUtilConfiguration) {
        BeetlGroupUtilConfiguration beetlGroupUtilConfiguration = new BeetlGroupUtilConfiguration);
        ResourcePatternResolver patternResolver = ResourcePatternUtils.getResourcePatternResolvernew DefaultResourceLoader));
        // WebAppResourceLoader 配置root路径是关键
        //WebAppResourceLoader webAppResourceLoader = new WebAppResourceLoaderpatternResolver.getResource"classpath:/sql").getFile).getPath));
        WebAppResourceLoader webAppResourceLoader = new WebAppResourceLoader);
        beetlGroupUtilConfiguration.setResourceLoaderwebAppResourceLoader);

        //读取配置文件信息
        return beetlGroupUtilConfiguration;
    }

    @Beanname = "beetlViewResolver")
    public BeetlSpringViewResolver getBeetlSpringViewResolver@Qualifier"beetlConfig") BeetlGroupUtilConfiguration beetlGroupUtilConfiguration) {
        BeetlSpringViewResolver beetlSpringViewResolver = new BeetlSpringViewResolver);
        beetlSpringViewResolver.setContentType"text/html;charset=UTF-8");
        beetlSpringViewResolver.setOrder0);
        beetlSpringViewResolver.setConfigbeetlGroupUtilConfiguration);
        return beetlSpringViewResolver;
    }

//=============================以下是beetsql配置=============
    //配置包扫描
    @Beanname = "beetlSqlScannerConfigurer")
    public BeetlSqlScannerConfigurer getBeetlSqlScannerConfigurer) {
        BeetlSqlScannerConfigurer conf = new BeetlSqlScannerConfigurer);
        conf.setBasePackage" com.example.demo.dao");
        conf.setDaoSuffix"Dao");
        conf.setSqlManagerFactoryBeanName"sqlManagerFactoryBean");
        return conf;
    }

    @Beanname = "sqlManagerFactoryBean")
    @Primary
    public SqlManagerFactoryBean getSqlManagerFactoryBean@Qualifier"datasource") DataSource datasource) {
        SqlManagerFactoryBean factory = new SqlManagerFactoryBean);
        BeetlSqlDataSource source = new BeetlSqlDataSource);
        source.setMasterSourcedatasource);
        factory.setCssource);
        factory.setDbStylenew MySqlStyle));
        factory.setInterceptorsnew Interceptor[]{new DebugInterceptor)});
        factory.setNcnew DefaultNameConversion));
        factory.setSqlLoadernew ClasspathLoader"/sql"));
        //sql文件路径
        return factory;
    }

    //配置数据库
    @Beanname = "datasource")
    public DataSource getDataSourceEnvironment env) {
        String url = env.getProperty"spring.datasource.mysql.url");
        String userName = env.getProperty"spring.datasource.mysql.username");
        String password = env.getProperty"spring.datasource.mysql.password");
        return DataSourceBuilder.create).urlurl).usernameuserName).passwordpassword).build);
    }

    //开启事务
    @Beanname = "transactionManager")
    public DataSourceTransactionManager getDataSourceTransactionManager@Qualifier"datasource") DataSource datasource) {
        DataSourceTransactionManager dsm = new DataSourceTransactionManager);
        dsm.setDataSourcedatasource);
        return dsm;
    }
}

四、dao层，继承一个BaseMapper

五、service层