万能Map
# 万能Map🌊
💛(万能方法)工作必备野路子方法,也可以使用到查询,修改,删除等等中💛
假设我们的实体类中,或者数据库的表中,字段或者参数很多,我们应当考虑使用Map
插入
【示例:UserMapper.java
】
public interface UserMapper {
boolean addUser2(Map<String,Object> map);
}
1
2
3
4
2
3
4
【示例:UserMapper.xml
】
<?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.singerw.mapper.UserMapper">
<!--增加用户-->
<insert id="addUser2" parameterType="map">
insert into g_users (userid, username, userphone, userpassword, jurisdiction, createtime, logintime, userstatus)
values (null,#{username},#{userphone},#{userpassword},#{jurisdiction},now(),now(),#{userstatus});
</insert>
</mapper>
1
2
3
4
5
6
7
8
9
10
11
12
13
2
3
4
5
6
7
8
9
10
11
12
13
【示例:UserMapperTest.java
】
public class UserMapperTest {
private SqlSession sqlSession = MyBatisUtils.getSqlSession();
private UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
@Test
public void addUser() {
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
HashMap hashMap = new HashMap<String,Object>();
hashMap.put("username","singerw");
hashMap.put("userphone","18888888888");
hashMap.put("userpassword","123456");
hashMap.put("jurisdiction",1);
hashMap.put("userstatus",1);
mapper.addUser2(hashMap);
}
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
编辑 (opens new window)