mybatis 中0 和 null 关系处理

转自:http://blog.csdn.net/zhangwei408089826/article/details/49924953


最近在项目开发中,mybatis 遇到一个很奇怪的问题,因为想在后台传一个 int 型 0 插入到数据,却被识别成了 null。后面,排除问题时,查到 mybatis 源码对其进增强判断添加 or importRow ==0

<insert id="insertDemo" parameterType="java.util.Map">
INSERT INTO
    TABLE
<trim prefix="(" suffix=")" suffixOverrides=",">
    <if test="importRow != null and importRow != '' or importRow ==0 ">
    IMPORT_ROW,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
    <if test="importRow != null and importRow != '' or importRow ==0 ">
        #{importRow},
    </if>
</trim>
</insert>




  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
Mybatis处理自关联表一对多的方式与处理其他一对多关系的方式类似。假设我们有一个Department表,每个部门可以有多个下属部门,我们可以在Department表增加一个parent_id字段表示上级部门的id,从而实现自关联。接下来,我们可以定义一个DepartmentMapper接口,使用Mybatis的注解或XML方式实现查询自关联表的一对多关系。 XML方式实现: ```xml <!-- 定义查询语句 --> <select id="getSubDepartments" resultType="Department"> select * from department where parent_id = #{parentId} </select> <!-- 定义DepartmentMapper接口 --> public interface DepartmentMapper { List<Department> getSubDepartments(Integer parentId); } ``` 注解方式实现: ```java @Select("select * from department where parent_id = #{parentId}") List<Department> getSubDepartments(Integer parentId); ``` 以上代码实现了查询某个部门的所有下属部门。如果需要查询某个部门的所有子部门,可以使用递归方式查询。例如,我们可以在Department类定义一个children属性表示子部门列表,然后在查询部门时同时查询其所有子部门,并通过递归方式将子部门添加到父部门的children属性。代码如下: ```java public class Department { private Integer id; private String name; private Integer parentId; private List<Department> children; // getter和setter省略 public void addSubDepartment(Department department) { if (children == null) { children = new ArrayList<>(); } children.add(department); } } public interface DepartmentMapper { @Select("select * from department where parent_id = #{parentId}") List<Department> getSubDepartments(Integer parentId); } public class DepartmentService { @Autowired private DepartmentMapper departmentMapper; public Department getDepartmentTree(Integer departmentId) { Department department = departmentMapper.getDepartment(departmentId); List<Department> subDepartments = departmentMapper.getSubDepartments(departmentId); if (subDepartments != null) { for (Department subDepartment : subDepartments) { Department subDepartmentTree = getDepartmentTree(subDepartment.getId()); department.addSubDepartment(subDepartmentTree); } } return department; } } ``` 以上代码实现了查询某个部门的所有子部门,并将其构造成树型结构。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值