新增数据

新增单条数据

java

User user = User.builder()
    .age(18)
    .userName("张三")
    .birthday(new Date())
    .build();

Db.table(User.class)
    .saver()
    .add(user)
    .execute();

批量新增数据

java

User user1 = User.builder()
    .age(18)
    .userName("张三")
    .birthday(new Date())
    .build();

User user2 = User.builder()
    .age(18)
    .userName("李四")
    .birthday(new Date())
    .build();

Db.table(User.class)
    .saver()
    .add(user1, user2)
    .execute();

自定义新增数据

java

Db.table(User.class)
    .saver()
    .set(sys_user.user_name, "张三")
    // 插入 NULL 值
    .set(sys_user.age, SqlValue.ofNull())
    // 插入原生片段
    .set(sys_user.birthday, SqlValue.ofRaw("NOW()"))
    .execute();

sql

INSERT INTO tb_user(user_name, age, birthday) VALUES ("张三", NULL, NOW());