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

Example 1 with User

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

the class TestUserService method saveBatch.

/**
 * 单条SQL批量保存
 *
 * 遇到相同ID抛出异常
 */
@Test
void saveBatch() {
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    List<User> userList = new ArrayList<>();
    userList.add(new User().setUsername("max").setAge(12));
    userList.add(new User().setUsername("Tom").setAge(13));
    userList.add(new User().setId(3L).setUsername("张三").setAge(13));
    boolean b = userService.saveBatch(userList);
    System.out.println(b);
}

Example 2 with User

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

the class TestUserService method saveBatchAndSetBatchSize.

/**
 * 单条SQL批量保存
 *
 * 并限制每次最大数量
 */
@Test
void saveBatchAndSetBatchSize() {
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    List<User> userList = new ArrayList<>();
    userList.add(new User().setUsername("max").setAge(12));
    userList.add(new User().setUsername("Tom").setAge(13));
    userList.add(new User().setId(4L).setUsername("张三").setAge(13));
    // 批量插入时，限制单次最大数量
    boolean b = userService.saveBatch(userList, 1);
    System.out.println(b);
}

Example 3 with User

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

the class TestUserService method saveOrUpdateBatchAndSetBatchSize.

/**
 * 同上，且限制数量
 */
@Test
void saveOrUpdateBatchAndSetBatchSize() {
    List<User> userList = new ArrayList<>();
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    userList.add(new User().setUsername("max").setAge(12));
    userList.add(new User().setUsername("Vicky").setAge(10));
    // SELECT id,username,age,email FROM smp_user WHERE id=?
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    userList.add(new User().setId(5L).setUsername("Tom").setAge(13));
    // SELECT id,username,age,email FROM smp_user WHERE id=?
    // UPDATE smp_user SET username=?, age=? WHERE id=?
    userList.add(new User().setId(5L).setUsername("Jerry").setAge(16));
    // INSERT INTO smp_user ( id, username, age ) VALUES ( ?, ?, ? )
    userList.add(new User().setUsername("张三").setAge(16));
    // 批量插入时，限制单次最大数量
    userService.saveOrUpdateBatch(userList, 3);
}

Example 4 with User

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

the class TestUserService method updateById.

/**
 * 根据ID更新
 */
@Test
void updateById() {
    // UPDATE smp_user SET username=? WHERE id=?
    boolean b = userService.updateById(new User().setId(8L).setUsername("123"));
    System.out.println(b);
}

Example 5 with User

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

the class TestUserMapper method update.

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