Mybatis输入输出映射

1.parameterType输入映射

1.1 简单类型映射

<delete id="removeUser" parameterType="int">
 delete from user where id = #{id}
</delete>

1.2 对象类型映射

<update id="updateUser"
parameterType="com.itheima.mybatis.day02.crud.model.User">
 update user
 set username=#{username}, birthday=#{birthday}, sex=#{sex}, address=#
{address}
 where id = #{id}
</update>

2.resultType输出映射

2.1 简单类型映射

示例：

/**
* 统计数量
* @param
*/
Integer count();

<select id="count" resultType="int">
 select count(*) from user
</select>

2.2 对象类型映射

<select id="findById" parameterType="int"
resultType="com.itheima.mybatis.day02.crud.model.User">
 select * from user where id = #{id}
</select>

3.resultMap输出映射

需求：
查询所有订单

3.1 创建订单数据模型

@Data
public class Order {
  private Integer id;
  private Integer userId;
  private String number;
  private Date createTime;
  private String note;
}

3.2 声明操纵映射

public interface OrderMapper {
  /**
  * 查询所有订单.
  *
  * @return 查询结果
  */
  List<Order> findAll();
}

3.3 配置操作映射

<select id="findAll" parameterType="map"
resultType="com.itheima.mybatis.day02.crud.model.Order">
 select * from orders
</select>

3.4 加载订单映射配置

<mappers>
  <mapper resource="mapper/userMapper.xml" />
  <mapper resource="mapper/orderMapper.xml" />
</mappers>