foreach 查出BIGTYPE,SMALLTYPE

package com.qfedu.springboot.ssm.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.qfedu.springboot.ssm.entity.Cate;
import com.qfedu.springboot.ssm.entity.User;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import static org.junit.jupiter.api.Assertions.*;

@SpringBootTest
class UserMapperTest {
    @Autowired
    private UserMapper userMapper;

    @Autowired
    private CateMapper cateMapper;

    @Test
    void test1(){
        User user = new User();
//        user.setId(111L);
//        user.setAge(11);
//
//        user.setEmail("qq@qq.com");
//        user.setName("csj");
//        userMapper.insert(user);

        List<User> users = userMapper.selectList(null);
//        List<User> focList = new ArrayList<>();
        ArrayList<String> list=new ArrayList();
        for (User user1 : users) {
//            user1.setBigType(user1.getAge()+1000);
//            String id = "1";
//            String id = user1.getBigType();
//            String id2 = user1.getSmallType();
//            System.out.println(id);
//            System.out.println("================================");
//            System.out.println(user1.getBigType());
//            System.out.println("~~~~~~~~~~~~~~~~~~~~");
//            Cate cate = cateMapper.selectById(user1.getBigType());
//            System.out.println(cate);
//            Cate cate2 = cateMapper.selectById(user1.getSmallType());
//            System.out.println(cate.getName());
            user1.setBigType(cateMapper.selectById(user1.getBigType()).getName());
            user1.setSmallType(cateMapper.selectById(user1.getSmallType()).getName());

        }
        for (User user1 : users) {
            System.out.println(user1);
        }
    }
    @Test
    void test2(){

        QueryWrapper<User> wrapper = new QueryWrapper<>();
        wrapper.eq("name", "csj");
        List<User> users = userMapper.selectList(wrapper);
        System.out.println(users);
    }

}
上一篇:Java8 Collections.sort()及Arrays.sort()中Lambda表达式及增强版Comparator的使用


下一篇:mybatis的缓存