Mybatis Plus使用xml编写动态sql简易搭建方法
在Resources
文件夹下创建一个Mapper
文件夹
比如我们需要在User表中使用增删改查,创建UserMapper.xml
,对应MybatisPlus中的UserMapper
接口
之后我们在application.yml
中配置mapper文件夹的路径
mybatis-plus:
mapper-locations: classpath:mapper/*.xml
之后在UserMapper中创建函数
@Repository
public interface UserMapper extends BaseMapper<User> {
// 使函数参数对应xml中的参数wxNickName
List<User> selectByName(@Param("wxNickName") String name);
}
就可以在UserMapper.xml
中写sql语句了
写法和Mybatis一样滴
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "<http://mybatis.org/dtd/mybatis-3-mapper.dtd>">
<mapper namespace="com.zhou.usercenter.dao.user.UserMapper">
<select id="selectByName" resultType="com.zhou.usercenter.domain.entity.user.User">
select * from user
<where>
<if test="wxNickName != null and wxNickName != ''">
wx_nickname like CONCAT('%',#{wxNickName},'%');
</if>
</where>
</select>
</mapper>
之后调用即可
@SpringBootTest
class UserCenterApplicationTests {
@Autowired
UserMapper userMapper;
@Test
void contextLoads() {
List<User> users = userMapper.selectByName("杰伦");
System.out.println(users);
}
}
即可看到正确的输出结果