1.使用#{arg}接受
mapper接口
public interface FoodMapper {
public int add(String foodName,Integer foodTypeId);
}
mapper.xml实现
<insert id="add">
insert into foods(foodsName,foodsTypeId) values(#{arg0},#{arg1})
</insert>
2.使用#{param}接受
mapper接口
public interface FoodMapper {
public int add(String foodName,Integer foodTypeId);
}
mapper.xml实现
<insert id="add">
insert into foods(foodsName,foodsTypeId) values(#{param1},#{param2})
</insert>
3.使用@Param注解
mapper接口
public interface FoodMapper {
public int add(@Param(foodName)String foodName,@Param(foodTypeId)Integer foodTypeId);
}
mapper.xml实现
<insert id="add">
insert into foods(foodsName,foodsTypeId) values(#{foodName},#{foodTypeId})
</insert>
4.使用Map
mapper接口
public interface FoodMapper {
public int add(Map m);
}
public void test(){
Map m = new HashMap<>();
m.put("key1",foodName);
m.put("key2",foodTypeId);
FoodMapper mapper = new FoodMapper();
mapper.add(m);
}
mapper.xml实现
<insert id="add" parameterType="java.util.Map">
insert into foods(foodsName,foodsTypeId) values(#{key1},#{key2})
</insert>
5.使用实体类对象
public interface FoodMapper {
public int add(Food food);
}
mapper.xml实现
<insert id="add" parameterType="com.bean.Food">
<!--其中#{}中要与实体类的相应属性相同-->
insert into foods(foodsName,foodsTypeId) values(#{foodName},#{foodTypeId})
</insert>