重新整理Mybatis-05

写在前面：受限于自身编程语言水平，文中可能存在错误之处，博客本意只为自查，不建议作为学习之用

<!-- 解决数据库表字段名和实体类属性名不相同问题 -->
	
	<!--1、在sql语句中使用别名 -->
	<select id="selectOrder" parameterType="int" resultType="_Order">
		select order_id orderId,order_name orderName,order_price orderPrice from orders where order_id=#{id}
	</select>
	<!-- 2、使用resultMap -->
	<resultMap id="Order" type="_Order" >
		<id property="orderId" column="order_id"/>
		<result property="orderName" column="order_name"/>
		<result property="orderPrice" column="order_price"/>
	</resultMap>
	
	<select id="selectOrder2" parameterType="int" resultMap="Order">
		select * from orders where order_id=#{id}
	</select>
	

	
	<!-- 实现模糊查询的两种方式 -->
	
	<!-- 1、将用到的%当做参数传入-->
	<select id="selectOrderByName" parameterType="String" resultMap="Order">
		select * from orders where order_name like #{name}
	</select>
	<!-- 2、将%放在双引号中-->
	<select id="selectOrderByName2" parameterType="String" resultMap="Order">
		select * from orders where order_name like "%"#{name}"%"
	</select>