文章插图

Mybatis动态SQLMybatis ， 在带注解的映射器接口类中使用动态SQL ， 可使用script元素 ， 即：<script></script> 。
案例代码Model
package com.what21.mybatis.model;import lombok.Data;@Datapublic class Employee {// IDprivate Integer id;// 名称private String name;// 邮箱private String email;// 性别private String gender;// 年龄private Integer age;}Mapper<映射器接口>
package com.what21.mybatis.demo03.mapper;import com.what21.mybatis.model.Employee;import org.apache.ibatis.annotations.*;import java.util.List;public interface EmployeeMapper {@Select(value = "https://www.520longzhigu.com/shenghuo/select * from `employee` where id = #{id}")@ResultType(Employee.class)public Employee findEmployeeById(Integer id);@Update(value = "https://www.520longzhigu.com/shenghuo/