Updates and Deletes

Update Data

Database Update

String newName = "biezhi_" + System.currentTimeMillis();
int result = update().from(User.class).set("user_name", newName).execute();
// UPDATE users SET user_name = ?

result = update().from(User.class).set("user_name", newName).where("id", 1).execute();
// UPDATE users SET user_name = ? WHERE id = ?

Instance Update

User user = new User();
user.setId(1);
user.setAge(22);
user.setUserName("jack");
user.update();
// UPDATE users SET age = ?, user_name = ? WHERE id = ?

Update by primary key

new User().set("user_name", "jack").updateById(3);
// UPDATE users SET user_name = ? WHERE id = ?

Update by lambda

update().from(User.class).set(User::getUserName, "base64").updateById(3);
update().from(User.class).set(User::getUserName, "base64").where(User::getId).eq(2).execute();

Delete Data

int result = delete().from(User.class).where("id", 1).execute();
// DELETE FROM users WHERE id = ?

Instance Delete

User user = new User();
user.setAge(15);
user.setUserName("jack");
user.delete();
// DELETE FROM users WHERE age = ? AND user_name = ?

Delete By Primary Key

Anima.deleteById(User.class, 5);
// DELETE FROM users WHERE id = ?

Batch Delete

Anima.deleteBatch(User.class, 1, 2, 3);

Anima.deleteBatch(User.class, List<Integer>);

// DELETE FROM users WHERE id in (?, ?, ?)

Delete by lambda

delete().from(User.class).where(User::getId).eq(1).execute();
delete().from(User.class).where(User::getAge).lte(20).execute();