<resultMap id="dictMap" type="com.zsh.demo.entity.SysDict"> <id column="id" property="id"></id> <result column="name" property="name"></result> <result column="code" property="code"></result> <result column="memo" property="memo"></result> <association property="sysDictType" javaType="com.zsh.demo.entity.SysDictType"> <id property="typeId" column="type_Ids"></id> <result column="names" property="name"></result> <result column="codes" property="code"></result> </association> </resultMap> <select id="getDictItem" resultMap="dictMap"> select i.*,t.name as names from sys_dict_item i join sys_dict_type t on i.type_id=t.type_id </select>
Mybatis一对一查询与起别名
最新推荐文章于 2024-03-14 21:07:09 发布