[[toc]]
简介用 Groovy 脚本写 Sql。
英文说明 README.
设计 安装 Spring boot- Maven
Java Appio.github.taylorxian mybatis-groovy-boot-starter 1.0-RC
- Maven
使用说明 Groovy 方法io.github.taylorxian mybatis-groovy 1.0-RC
- Mapper 类: UserMapper.java
@Mapper
public interface UserMapper {
@Select("UserMapperSql#selectByCondition")
@Lang(GroovyLangDriver.class)
List selectByCondition(UserVO userVO);
}
- 脚本: UserMapperSql.groovy
def selectByCondition(Object parameter) {
'''
SELECT id, name, age, addr
FROM `user`
''' + where { c ->
if (parameter?.id) c += 'id = #{id} '
if (parameter?.name) c += ' AND name = #{name} '
c
}
}
Groovy script
- Mapper 类: UserMapper.java
@Mapper
public interface UserMapper {
@Select("UserMapperSelectByName")
@Lang(GroovyLangDriver.class)
UserVO selectByName(String name);
}
- 脚本: UserMapperSelectByName.groovy
'''select * from user where name = #{name}'''
贡献
GitHub地址
