Drug administration system/WebRoot/WEB-INF/classes/com/hqyj/dao/Warehouse.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.hqyj.dao.WarehouseDao">
<!-- namespace必须与对应接口全类名一致 ；id必须与对应接口的某个方法名一致-->
	<select id="queryWarehouseBydrug_id" resultType="com.hqyj.bean.Warehouse">
		select * from warehouse where drug_id=#{drug_id}
	</select>
	
	<select id="updateWarehouseBydrug_id" resultType="com.hqyj.bean.Warehouse">
		update warehouse set stock_number=#{stock_number} where drug_id=#{drug_id}
	</select>
	<select id="addWarehouseBydrug_id" resultType="com.hqyj.bean.Warehouse">
		 insert into warehouse(drug_id,stock_number) values(#{drug_id},#{stock_number})
	</select>
	
	<sql id="warehouse_where">
        <!-- where标签的作用：会自动向sql语句中添加where关键字; 会去掉第一个条件的and关键字-->
        <where>
             <if test="drug_id!=null and drug_id!=''">
                and drug_id=#{drug_id}
            </if>
             <if test="stock_number!=null and stock_number!=''">
                and stock_number=#{stock_number}
            </if>
             <if test="manufacturer!=null and manufacturer!=''">
                and manufacturer=#{manufacturer}
            </if>
            
             <if test="standard!=null and standard!=''">
                and standard=#{standard}
            </if>
             
             <if test="sale_price!=null and sale_price!=''">
                and sale_price=#{sale_price}
            </if>
        </where>
     </sql>
	<select id="querywarehouse" resultType="com.hqyj.bean.Warehouse">
		select * from warehouse 
		<include refid="warehouse_where"></include>
	</select>
	
	<select id="querywarehouseAll" resultType="com.hqyj.bean.Warehouse">
		select * from warehouse 
	</select>
	
	<select id="queryWarehouseById" resultType="com.hqyj.bean.Warehouse">
		select * from warehouse where id=#{id}
	</select>
	
	
	<select id="updateWarehouseById" resultType="com.hqyj.bean.Warehouse">
		update warehouse set manufacturer=#{manufacturer},standard=#{standard},sale_price=#{sale_price} where id=#{id}
	</select>
	
</mapper>