mybatis听课笔记（根据多个条件查询）

 

list不常用，用的最多的是map实例化对象。

 

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bjsxt.mapper.FlowerMapper">
<!--查询  -->
	<!-- 查询所有的花卉信息 -->
	<select id="selF" resultType="flower">
		select * from flower
	</select>
	<!--根据ID查询花卉信息  -->
	<select id="selFById" parameterType="int" resultType="flower">
		select * from flower where id=#{0}
	</select>
	<!--根据价格和产地查询  -->
	<select id="selFByP" parameterType="flower" resultType="flower">
		select * from flower where price>#{price}  and production=#{production}
	</select>
	<!--根据价格和产地查询  -->
	<select id="selFByP2" parameterType="map" resultType="flower">
		select * from flower where price>${price1}  and production=${production1}
	</select>
<!-- 增加 -->	
	<!-- 增加花卉信息 -->
	<insert id="insF" parameterType="flower">
		insert into flower values(default,#{name},#{price},#{production})
	</insert>
<!--修改  -->
	<!-- 修改花卉信息 -->
	<update id="upF" parameterType="flower">
		update flower set name=#{name} where id=#{id}
	</update>
<!--删除一条花卉信息 -->
	<delete id="delF" parameterType="int">
		delete from flower where id=#{0}
	</delete>
</mapper>