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

Example 11 with User

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

the class TestLambdaUpdateWrapper method testSetSetSql.

/**
 * LambdaUpdateWrapper 仅多出 set 和 setSql 方法
 */
@Test
void testSetSetSql() {
    // UPDATE smp_user SET email=?, age=?,username = 'max' WHERE (id = ?)
    LambdaUpdateWrapper<User> updateWrapper = Wrappers.lambdaUpdate();
    // .set 方式
    updateWrapper.set(User::getAge, 18);
    // .setSql 方式
    updateWrapper.setSql("username = 'max'");
    // 设置 where条件
    updateWrapper.eq(User::getId, 1);
    // 实体对象内的属性也会被作为 set 条件
    User user = new User().setEmail("123@123.com");
    // 当 updateWrapper 有 set 时，也可以 userMapper.update(null,updateWrapper) 即生成的SQL中必须有 SET
    int update = userMapper.update(user, updateWrapper);
    System.out.println(update);
}

Example 12 with User

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

the class TestUser method insertOrUpdate.

@Test
void insertOrUpdate() {
    // 先查询有没有，没有则插入
    // SELECT id,username,age,email FROM smp_user WHERE id=?
    // INSERT INTO smp_user ( id, username ) VALUES ( ?, ? )
    // 先查询有没有，有则更新
    // SELECT id,username,age,email FROM smp_user WHERE id=?
    // UPDATE smp_user SET username=? WHERE id=?
    User user = new User();
    user.setId(1113L);
    user.setUsername("你好啊");
    boolean b = user.insertOrUpdate();
    System.out.println(b);
}

Example 13 with User

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

the class TestUser method selectById1.

@Test
void selectById1() {
    // SELECT id,username,age,email FROM smp_user WHERE id=?
    User user = new User();
    user.setId(123L);
    User newUser = user.selectById();
    System.out.println(newUser);
    System.out.println(user.equals(newUser));
}

Example 14 with User

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

the class TestUser method selectAll.

@Test
void selectAll() {
    // SELECT id,username,age,email FROM smp_user
    List<User> users = new User().selectAll();
    users.forEach(System.out::println);
}

Example 15 with User

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

the class TestUser method update1.

@Test
void update1() {
    // UPDATE smp_user SET email=? WHERE (username = ?)
    // 构造WHERE条件
    LambdaUpdateWrapper<User> wrapper = new LambdaUpdateWrapper<>();
    wrapper.eq(User::getUsername, "xxxxxx");
    // 构造 SET 值
    User user = new User();
    user.setEmail("123@126.com");
    boolean i = user.update(wrapper);
    System.out.println("更新结果：" + i);
}