A framework for JdbcTemplate mapping xml sqls.

依赖 atomikos datasource 基于spring JdbcTemplate进行封装，实现 JdbcTemplate所需的sql语句分离。

Feat:

执行 sql 日志输出，耗时等;
自动获取 ApplicationContext 中的 DataSource bean, 注册到本框架数据源工厂中；
自动加载 xml 文件中的 sql；
支持@Transactional多数据源事务(搭配jta atomikos)；
支持程序关闭数据源自动销毁。

dependency

    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-jta-atomikos</artifactId>
    </dependency>

1. clone repo

git clone https://github.com/987856377/mjt-spring-boot-starter.git

mvn clean install

2. add dependency

<dependency>
    <groupId>com.springboot</groupId>
    <artifactId>mjt-spring-boot-starter</artifactId>
    <version>0.0.1-SNAPSHOT</version>
</dependency>

3. use @EnableMappingJdbcTemplate

default scan xml package: {"classpath*:/mapper/**/*.xml", "classpath*:/xml/**/*.xml", "classpath*:/mjt/**/*.xml"}

example: @EnableMappingJdbcTemplate(baseLocations = "classpath:/xml/*.xml")

4. xml file

<?xml version="1.0" encoding="UTF-8" ?>
<namespace xmlns="http://localhost/schema/framework"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://localhost/schema/framework http://localhost/schema/framework/framework.xsd"
       mapper="com.springboot.provider.mjt.constants.Mapper">

    <sql id="selectById">
        select * from role where id = ? and title = ?
    </sql>

    <sql id="selectByUsername">
        select * from user where username = ?
    </sql>

</namespace>

5. class file or @MjtMapperScan("com.springboot.provider.mjt.mapper") full package name !!!

@MjtMapper
public class Mapper {

    public static String selectById;

}

6. usage

JdbcOperations jdbcTemplate = com.springboot.mjt.proxy.JdbcOperationsProxy.getProxyInstance(${dsName});

RowMapper<Role> rowMapper = new BeanPropertyRowMapper<>(Role.class);

List<Role> roles = jdbcTemplate.query(Mapper.selectById, rowMapper, 1, "超级管理员");