菜鸡学mybatis的随缘笔记

最新推荐文章于 2024-08-21 23:39:15 发布

eeet9

最新推荐文章于 2024-08-21 23:39:15 发布

阅读量102

点赞数

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/eeet9/article/details/106985999

版权

mybatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

万能Map

假设，我们的实体类，或者数据库的表，字段或者参数过多，我们应该考虑使用MAP!
Usermapper.java

int addUser2(Map<String, Object> map);

UserMapper.xml

<insert id="addUser2" parameterType="map">
        insert  into  zzz.management(sname, snumber, scourse, fen) values (#{userid},#{usernumber},#{userscourse},#{userfen})
    </insert>

UserDaoTest.java

@Test
    public void addUser2(){
        SqlSession sqlSession = MybatisUtils.getSeqlSession();
        Usermapper usermapper = sqlSession.getMapper(Usermapper.class);
        HashMap<String,Object>map=new HashMap<String, Object>();
        map.put("userid",5);
        map.put("usernumber",5);
        map.put("userscourse",5);
        map.put("userfen",5);
        usermapper.addUser2(map);
        sqlSession.commit();
    }

UserMapper.java

int addUser2(Map<String, Object> map);

UserMapper.xml

 <select id="getUserId2" parameterType="map" resultType="com.upc.pojo.User">
        select *from zzz.management where snumber=#{id} and sname =#{name}
    </select>

UserDaoTest.java

 public void getUserID2(){
        SqlSession sqlSession = MybatisUtils.getSeqlSession();
        Usermapper usermapper = sqlSession.getMapper(Usermapper.class);
        Map<String,Object> map = new HashMap<String, Object>();
        map.put("id","34");
        map.put("name","1231");
        usermapper.getUserId2(map);

        sqlSession.commit();

    }