FluentMybatis实现mybatis动态sql拼装和fluent api语法

< dependencies >

     <!-- 引入fluent-mybatis 运行依赖包, scope为compile -->

     < dependency >

         < groupId >com.github.atool</ groupId >

         < artifactId >fluent-mybatis</ artifactId >

         < version >1.3.1</ version >

     </ dependency >

     <!-- 引入fluent-mybatis-processor, scope设置为provider 编译需要，运行时不需要 -->

     < dependency >

         < groupId >com.github.atool</ groupId >

         < artifactId >fluent-mybatis-processor</ artifactId >

         < version >1.3.1</ version >

     </ dependency >

</ dependencies >

create schema fluent_mybatis_tutorial;

create table hello_world

(

     id           bigint unsigned auto_increment primary key ,

     say_hello    varchar (100) null ,

     your_name    varchar (100) null ,

     gmt_create   datetime   DEFAULT NULL COMMENT '创建时间' ,

     gmt_modified datetime   DEFAULT NULL COMMENT '更新时间' ,

     is_deleted   tinyint(2) DEFAULT 0 COMMENT '是否逻辑删除'

) ENGINE = InnoDB

   CHARACTER SET = utf8 comment '简单演示表' ;

@FluentMybatis

public class HelloWorldEntity implements IEntity {

     private Long id;

     private String sayHello;

     private String yourName;

     private Date gmtCreate;

     private Date gmtModified;

     private Boolean isDeleted;

     // get, set, toString 方法

}

@ComponentScan (basePackages = "cn.org.atool.fluent.mybatis.demo1" )

@MapperScan ( "cn.org.atool.fluent.mybatis.demo1.entity.mapper" )

@Configuration

public class HelloWorldConfig {

     /**

      * 设置dataSource属性

      *

      * @return

      */

     @Bean

     public DataSource dataSource() {

         BasicDataSource dataSource = new BasicDataSource();

         dataSource.setDriverClassName( "com.mysql.jdbc.Driver" );

         dataSource.setUrl( "jdbc:mysql://localhost:3306/fluent_mybatis_tutorial?useUnicode=true&characterEncoding=utf8" );

         dataSource.setUsername( "root" );

         dataSource.setPassword( "password" );

         return dataSource;

     }

     /**

      * 定义mybatis的SqlSessionFactoryBean

      *

      * @param dataSource

      * @return

      */

     @Bean

     public SqlSessionFactoryBean sqlSessionFactoryBean(DataSource dataSource) {

         SqlSessionFactoryBean bean = new SqlSessionFactoryBean();

         bean.setDataSource(dataSource);

         return bean;

     }

}

@RunWith (SpringJUnit4ClassRunner. class )

@ContextConfiguration (classes = HelloWorldConfig. class )

public class HelloWorldTest {

     /**

      * fluent mybatis编译时生成的Mapper类

      */

     @Autowired

     HelloWorldMapper mapper;

     @Test

     public void testHelloWorld() {

         /**

          * 为了演示方便，先删除数据

          */

         mapper.delete(mapper.query()

             .where.id().eq(1L).end());

         /**

          * 插入数据

          */

         HelloWorldEntity entity = new HelloWorldEntity();

         entity.setId(1L);

         entity.setSayHello( "hello world" );

         entity.setYourName( "fluent mybatis" );

         entity.setIsDeleted( false );

         mapper.insert(entity);

         /**

          * 查询 id = 1 的数据

          */

         HelloWorldEntity result1 = mapper.findOne(mapper.query()

             .where.id().eq(1L).end());

         /**

          * 控制台直接打印出查询结果

          */

         System.out.println( "1. HelloWorldEntity:" + result1.toString());

         /**

          * 更新id = 1的记录

          */

         mapper.updateBy(mapper.updater()

             .update.sayHello().is( "say hello, say hello!" )

             .set.yourName().is( "fluent mybatis is powerful!" ).end()

             .where.id().eq(1L).end()

         );

         /**

          * 查询 id = 1 的数据

          */

         HelloWorldEntity result2 = mapper.findOne(mapper.query()

             .where.sayHello().like( "hello" )

             .and.isDeleted().eq( false ).end()

             .limit( 1 )

         );

         /**

          * 控制台直接打印出查询结果

          */

         System.out.println( "2. HelloWorldEntity:" + result2.toString());

     }

}