classes/production/sale_invoicing/com/ysm/dao/SupplierDao.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.ysm.dao.SupplierDao">
	<!-- 查询商家信息 -->
	<select id="findSupplier1" resultType="supplier">
		select * from s_supplier
	</select>
	<!-- 查询商家信息 -->
	<select id="findSupplier" resultType="supplier">
		select * from s_supplier
		<!--<if test="start!=null and count!=null">-->
        	<!--limit #{start},#{count}-->
        <!--</if>-->
	</select>
	<select id="total" resultType="int">
		select count(*) from s_supplier
	</select>
	<!-- 条件查询 -->
	<select id="findSupplierByName" resultType="supplier">
		select * from s_supplier where name like '%${name}%' and linkman like '%${linkman}%'
	</select>
	
	<!-- id查询信息 -->
	<select id="findSupplierById" parameterType="Integer" resultType="supplier">
		select * from s_supplier where id = #{id}
	</select>
		
	<!-- 修改商家信息 -->
	<update id="updateSupplier" parameterType="supplier">
		update s_supplier set name=#{name},linkman=#{linkman},phone=#{phone},address=#{address},bankname=#{bankname},carid=#{carid} where id = #{id}
	</update>
	
	<!-- 添加商家信息 -->
	<insert id="addSupplier" parameterType="com.ysm.emtity.Supplier" useGeneratedKeys="true" keyProperty="id">
		insert into s_supplier(name,linkman,phone,address,bankname,carid)
		values (#{name},#{linkman},#{phone},#{address},#{bankname},#{carid})

			<!--<if test="name!=null and name!=''">-->
				<!--#{name},-->
			<!--</if>-->
			<!--<if test="linkman!=null and linkman!=''">-->
				<!--#{linkman},-->
			<!--</if>-->
			<!--<if test="phone!=null and phone!=''">-->
				<!--#{phone},-->
			<!--</if>-->
			<!--<if test="address!=null and address!=''">-->
				<!--#{address},-->
			<!--</if>-->
			<!--<if test="bankname!=null and bankname!=''">-->
				<!--#{bankname},-->
			<!--</if>-->
			<!--<if test="carid!=null and carid!=''">-->
				<!--#{carid},-->
			<!--</if>-->

	</insert>