@Mapper

public interface GoodsDao {
	/**
	 * 基于商品id刪除商品
	 * @param id 商品id
	 * @return 刪除行數(shù)
	 * 數(shù)據(jù)層方法對象的sql映射
	 */

     @Delete("delete from tb_goods where id=#{id}")
      //當(dāng)傳入的參數(shù)只有一個且不是數(shù)組時
      //#{id}這個地方的變量可以不是傳入的參數(shù)名（自己隨意）
     int deleteById(Integer id);

}

@SpringBootTest
public class TestGoods {

	@Autowired
	private GoodsDao gd;
	@Test
	void TestGoods() {
		int i =gd.deleteById(10);
		System.out.println(i);
	}
}

@Mapper

public interface GoodsDao {
	/**
	 * 基于商品id刪除商品
	 * @param id 商品id
	 * @return 刪除行數(shù)
	 * 數(shù)據(jù)層方法對象的sql映射
	 */

     @Delete("delete from tb_goods where id=#{id}")

     int deleteById(Integer id);

}

@Component
public class GoodsDaoImpl {

	@Autowired
	private SqlSession sqlSession;
	 
	public int deleteById(Integer id) {
		return sqlSession.delete("com.cy.demo.goods.dao.GoodsDao.deleteById", id);
		//sqlSession.delete("com.cy.demo.goods.dao.deleteById"，id)
	}
}

@SpringBootTest
public class GoodsDaoImpTest {

	@Autowired
	private GoodsDaoImpl gdi;
	@Test
	void testdelete() {
		int i = gdi.deleteById(9);
		
		System.out.println(i);
	}	
}

 /**
      *GoodsDao.java
     * ids可以接受多個參數(shù)
      * 在mapper文件中直接使用array來接受，
     * @param ids
     * @return
     */
     int deleteObject(/*@Param("ids")*/Integer...ids);
      //當(dāng)mybatis過低時需要加上@Param("ids")才能識別

<?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.cy.demo.goods.dao.GoodsDao">
	<delete id="deleteObject">
		delete from tb_goods
		<where>
			
			<if test="ids!=null and ids.length>0">
			id in
				<foreach collection="ids" open="(" close=")" separator=","
					item="i">
					#{i}
				</foreach>
			</if>
			or 1=2
		</where>

	</delete>
</mapper>

	@Autowired
	private GoodsDao gd;
	
	@Test
	void deleteObject() {
		int rows=gd.deleteObject(1,2,3);
		System.out.println(row);
	}