mybatis-day02

resultMap

使用resultType要求列名和属性名一致，不过不一致就无法创建映射，我们可以使用resultMap来解决这种问题

<resultMap type="User" id="userResultMap">
	<id column="id_" property="id"/>
	<result column="username_" property="username"/>
	<result column="birthday_" property="birthday"/>
</resultMap>
<select id="findAllUser" resultMap="userResultMap">
	select id id_,username username_,birthday birthday_ from user 
</select>

List<User> list = mapper.findAllUser();

一对一

方式一：新建类A 继承已有的类B，再把C的属性放到A中

Orders>User 一对一

public class OrdersCustom extends Orders {

	private int uid;
	private String username;
	private Date birthday;
	private String sex;
	private String address;
}

<select id="findAllOrders" resultType="com.cqc.mybatis01.vo.OrdersCustom">
	select orders.*,user.id uid,user.username,user.birthday,user.sex,user.address
	from orders,user 
	where orders.user_id=user.id
</select>

SqlSession session = factory.openSession();
UserMapper mapper = session.getMapper(UserMapper.class);

List<OrdersCustom> list = mapper.findAllOrders();

方式二：在类A中加入属性类B

public class Orders {
    private Integer id;

    private Integer userId;

    private String number;

    private Date createtime;

    private String note;
    
    private User user;
}

<resultMap type="com.cqc.mybatis01.pojo.Orders" id="ordersAndUserMap" >
	<id column="id" property="id"/>
	<result column="user_id" property="userId"/>
	<result column="number" property="number"/>
	<result column="createtime" property="createtime"/>
	<result column="note" property="note"/>
	
	<association property="user" javaType="com.cqc.mybatis01.pojo.User">
		<id property="id" column="uid"/>
		<result property="username" column="username"/>
		<result property="birthday" column="birthday"/>
		<result property="username" column="username"/>
		<result property="sex" column="sex"/>
		<result property="address" column="address"/>
	</association>
</resultMap>
<select id="findAllOrders2" resultMap="ordersAndUserMap">
	select orders.*,user.id uid,user.username,user.birthday,user.sex,user.address
	from orders,user 
	where orders.user_id=user.id
</select>

SqlSession session = factory.openSession();
UserMapper mapper = session.getMapper(UserMapper.class);

List<Orders> list = mapper.findAllOrders2();

一对多

在一方加入属性多

public class User {
	private int id;
	private String username;
	private Date birthday;
	private String sex;
	private String address;
	
	private List<Orders> ordersList;
}

SQL

<resultMap type="User" id="userMap">
	<id property="id" column="id"/>
	<result property="username" column="username"/>
	<result property="birthday" column="birthday"/>
	<result property="username" column="username"/>
	<result property="sex" column="sex"/>
	<result property="address" column="address"/>
	
	<collection property="ordersList" ofType="Orders">
		<id column="oid" property="id"/>
		<result column="user_id" property="userId"/>
		<result column="number" property="number"/>
		<result column="createtime" property="createtime"/>
		<result column="note" property="note"/>
	</collection>
</resultMap>
<select id="findAllUsers" resultMap="userMap">
	select user.*,b.id oid ,user_id, number, createtime 
	 from user,orders b where user.id=b.user_id
</select>

java

SqlSession session = factory.openSession();
UserMapper mapper = session.getMapper(UserMapper.class);

List<User> list = mapper.findAllUsers();

#与$的区别？#

mybatis和hibernate的区别

源码

https://gitee.com/ssmcqc/cuimybatis01