<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""https://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="org.mybatis.example.BlogMapper"><!--定义添加,id要和dao接口中定义的添加方法名一样--><!--添加--><insertid="add">
insert into foods(foodsName,foodsTypeId) values(#{arg0},#{arg1})
</insert><!--刪除--><deleteid="delete">
delete from foods where foodsId=#{arg0}
</delete><!--修改,parameterType与Dao接口对应方法参数类型对应--><updateid="update"parameterType="com.gxa.pojo.Foods">
update foods set foodsName=#{foodsName} where foodsId=#{foodsId}
</update><!--查詢,resultType与Dao接口对应方法返回值类型对应--><selectid="query"resultType="com.gxa.pojo.Foods">
select * from foods where foodsId=#{arg0}
</select></mapper>