栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

(java)使用Mybatis-Plus中执行sql的一些常用语句

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

(java)使用Mybatis-Plus中执行sql的一些常用语句

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class TestSpringMP {
    @Autowired
    private UserMapper userMapper;


    
    @Test
    public void testSelectList() {
        List users = this.userMapper.selectList(null);
           for (User user : users)
            System.out.println(user);
    }

    
    @Test
    public void testSelectById() {
        User user = userMapper.selectById(7L);
        System.out.println(user);
    }
    
    @Test
    public void testSelectByIds() {
        List users = userMapper.selectBatchIds(Arrays.asList(1L, 2L));
        for (User user : users) {
            System.out.println(user);
        }

    }
    
    @Test
    public void testSelectByConditions() {
        User user = new User();
        user.setAge(20);
        QueryWrapper wrapper = new QueryWrapper<>(user);
        User user1 = userMapper.selectOne(wrapper);
        System.out.println(user1);
    }

    
    @Test
    public void testSelectCount() {
//        QueryWrapper wrapper = new QueryWrapper<>();
        Integer count = userMapper.selectCount(null);
        System.out.println(count);
    }

    
    @Test
    public void testSelectLists() {
        QueryWrapper wrapper = new QueryWrapper<>();
          wrapper.like("email","cn");
        List users = userMapper.selectList(wrapper);
        for (User user : users) {
            System.out.println(user);
        }
    }

    
    @Test
    public void testSelectPages() {
      
        Page page = new Page<>(1,3);
        IPage iPage = userMapper.selectPage(page, null);
        System.out.println("总记录数:"+iPage.getTotal());
        System.out.println("总页数:"+iPage.getPages());
        List users = iPage.getRecords();
        for (User user : users) {
            System.out.println(user);
        }

    }
 
    
    @Test
    public void testInsert() {
        User user = new User();
        user.setAge(20);
        user.setMail("test@itcast.cn");
        user.setName("曹操");
        user.setUserName("caocao");
        user.setPassword("123456");
        int result = userMapper.insert(user);
        System.out.println("数据库受影响的行数:"+result);//数据库受影响的行数
        System.out.println("id:"+user.getId());

    }

    
    @Test
    public void testUpdate() {
        User user = new User();
        user.setAge(18);
        user.setMail("test@itcast.cn");
        user.setName("小牛");
        user.setUserName("xiaoniu");
        user.setPassword("123456");
        user.setId(7L);
         userMapper.updateById(user);


    }
    
    @Test
    public void testUpdateByConditions() {
        User user = new User();
        user.setAge(20);
        user.setName("小牛1");
        user.setUserName("xiaoniu667");
        QueryWrapper wrapper = new QueryWrapper<>();
        wrapper.eq("name","小牛"); //字段的名字
        userMapper.update(user,wrapper);


    }

    
    @Test
    public void testUpdateByConditions1() {
        UpdateWrapper wrapper = new UpdateWrapper<>();
        wrapper.eq("name", "小牛1").set("age", 21);
        userMapper.update(null, wrapper);

    }

    
    @Test
    public void testDelete() {
       this.userMapper.deleteById(6L);
    }

    
    @Test
    public void testDeleteByConditions() {
        HashMap map = new HashMap<>();
         map.put("name","小牛1");
        this.userMapper.deleteByMap(map);

    }

    
    @Test
    public void testDeleteByConditions1() {
        QueryWrapper wrapper = new QueryWrapper<>();
        wrapper.eq("name","张三");
        userMapper.delete(wrapper);

    }
    
    @Test
    public void testDeleteByConditions2() {
        User user = new User();
        user.setAge(20);
        user.setName("李四");
        QueryWrapper wrapper = new QueryWrapper<>(user);
        userMapper.delete(wrapper);

    }
    
    @Test
    public void testDeleteByIds() {
      userMapper.deleteBatchIds(Arrays.asList(3L,4L));
    }




} 

转载请注明:文章转载自 www.mshxw.com
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号