Examples with User com.maxqiu.demo.entity.User used on opensource projects

Example 31 with User

use of com.maxqiu.demo.entity.User in project demo-SpringBoot by Max-Qiu.

the class TestPage method testMyPage.

/**
 * 自定义 page 对象
 */
@Test
void testMyPage() {
    // SELECT COUNT(*) FROM smp_user WHERE (age = ? AND username = ?) OR (age = ? AND username = ?)
    // select * from smp_user where (age = ? and username = ?) or (age = ? and username = ?) LIMIT ?
    MyPage<User> myPage = new MyPage<>(1, 5);
    myPage.setSelectInt(20);
    myPage.setSelectStr("Jack");
    ParamSome paramSome = new ParamSome(20, "Jack");
    MyPage<User> userMyPage = userMapper.mySelectPage(myPage, paramSome);
    System.out.println(userMyPage.getTotal());
}

Example 32 with User

use of com.maxqiu.demo.entity.User in project demo-SpringBoot by Max-Qiu.

the class UserMapper1Test method addUser.

@Test
void addUser() {
    for (int i = 0; i < 10; i++) {
        User user = new User();
        user.setUsername("TOM" + i);
        user.setEmail(i + "xxx@xxx.com");
        userMapper.insert(user);
    }
}

Example 33 with User

use of com.maxqiu.demo.entity.User in project demo-SpringBoot by Max-Qiu.

the class UserMapper1Test method getUser.

@Test
void getUser() {
    User user = userMapper.selectById(1522866999970672643L);
    System.out.println(user);
}

Example 34 with User

use of com.maxqiu.demo.entity.User in project demo-SpringBoot by Max-Qiu.

the class UserMapper2Test method getUser2.

@Test
void getUser2() {
    LambdaQueryWrapper<User> wrapper = Wrappers.lambdaQuery();
    wrapper.eq(User::getId, 1522869889913196547L);
    // 设置组之后，会在指定库中查找
    wrapper.eq(User::getGroupId, 1);
    User user1 = userMapper.selectOne(wrapper);
    System.out.println(user1);
}

Example 35 with User

use of com.maxqiu.demo.entity.User in project demo-SpringBoot by Max-Qiu.

the class UserMapper2Test method getUser1.

@Test
void getUser1() {
    // 直接根据id查找，会在所有库中执行查找，直至找到
    User user = userMapper.selectById(1522869889913196547L);
    System.out.println(user);
}