一,在接口中声明方法并且把参数设为Map集合
package com.dao;
import com.pojo.User;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;
public interface UserMapper {
int addUser11(Map<String,Object> map);
}
二,在实现类中给Map赋值
package com.dao;
import com.pojo.User;
import com.uitl.BaseDaoUtil;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
public class UserMapperTest {
@Test
public void addUser11(){
SqlSession sqlSession = BaseDaoUtil.openSqlSession();
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
Map<String,Object> map = new HashMap<>();
map.put("id",9);
map.put("userName","阿峰");
map.put("pwd","1231321");
int i = mapper.addUser11(map);
if (i ==0 ){
System.out.println("失败");
}else {
System.out.println("添加成功");
}
sqlSession.close();
}
}
三,在映射的SQL语句文件中编写相应的SQL语句
<?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.dao.UserMapper">
<insert id="addUser11" parameterType="map">
insert into user (id,userName,pad ) values (#{id},#{userName},#{pwd});
</insert>
</mapper>
其中parameterType应为map因为是mybatis自动生成好的别名
xml中parameterType=“map”的map点变的是传入的整个map,只要SQL语句中取出的
key在传入的map中有就可以用