Drug administration system/src/com/hqyj/dao/Stockdrug.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

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

<?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.StockdrugDao">
<!-- namespace必须与对应接口全类名一致 ；id必须与对应接口的某个方法名一致-->
	
	
	<select id="querystockdrugAll" resultType="com.hqyj.bean.Stockdrug">
		select * from stockdrug
	</select>
	
	<select id="queryStockdrugBydrug_id" resultType="com.hqyj.bean.Stockdrug">
		select * from stockdrug where drug_id=#{drug_id}
	</select>
	
	<select id="updateStockdrugBydrug_id" resultType="com.hqyj.bean.Stockdrug">
		update stockdrug set buy_num=#{buy_num} where drug_id=#{drug_id}
	</select>
	
	<select id="addStockdrugBydrug_id" resultType="com.hqyj.bean.Stockdrug">
		 insert into stockdrug(bill_id,drug_id,price,buy_num,date,supplier) values(#{bill_id},#{drug_id},#{price},#{buy_num},#{date},#{supplier})
	</select>
	
	
	<delete id="stockdrugdelete" parameterType="int">
		delete from stockdrug where id=#{id}
	</delete>
	
	<select id="stockdrugQueryById" resultType="com.hqyj.bean.Stockdrug">
		select * from stockdrug where id=#{id}
	</select>
	<select id="stockdrugupdate" resultType="com.hqyj.bean.Stockdrug">
		update stockdrug set bill_id=#{bill_id},drug_id=#{drug_id},price=#{price},buy_num=#{buy_num},date=#{date},supplier=#{supplier}  where id=#{id}
	</select>
	
	<sql id="stockdrug_where">
        <!-- where标签的作用：会自动向sql语句中添加where关键字; 会去掉第一个条件的and关键字-->
        <where>
            <if test="bill_id!=null and bill_id!=''">
                and bill_id=#{bill_id}
            </if>
             <if test="drug_id!=null and drug_id!=''">
                and drug_id=#{drug_id}
            </if>
             <if test="price!=null and price!=''">
                and price=#{price}
            </if>
             <if test="buy_num!=null and buy_num!=''">
                and buy_num=#{buy_num}
            </if>
            
             <if test="date!=null and date!=''">
                and date=#{date}
            </if>
             
             <if test="supplier!=null and supplier!=''">
                and supplier=#{supplier}
            </if>
        </where>
     </sql>