jooq使用代码

1、批量插入

public void saveParamPropValue(List<DbParamPropValue> dbaParamPropValueList) {
        List<InsertValuesStep4<DbParamPropValueRecord, Long, Long, String, String>> inserts = new ArrayList<>();
        dbaParamPropValueList.forEach(item -> {
            InsertValuesStep4<DbParamPropValueRecord, Long, Long, String, String> insert = create.insertInto(
            DB_PARAM_PROP_VALUE,
            DB_PARAM_PROP_VALUE.PARAM_GROUP_ID,
            DB_PARAM_PROP_VALUE.PARAM_ITEM_ID,
            DB_PARAM_PROP_VALUE.ITEM_VALUE,
            DB_PARAM_PROP_VALUE.MYSQL_GROUP_NAME)
            .values(
                item.getParamGroupId(),
                item.getParamItemId(),
                item.getItemValue(),
                item.getMysqlGroupName());
            inserts.add(insert);
        });
        create.batch(inserts).execute();
    }

2、根据参数添加查询条件

public List<DbParamPropValue> queryAll(DbParamPropValue dbParamPropValue) {
        SelectQuery<DbParamPropValueRecord> select = create.selectQuery(DB_PARAM_PROP_VALUE);
        if (StringUtils.isNotBlank(dbParamPropValue.getItemValue())) {
            select.addConditions(DB_PARAM_PROP_VALUE.ITEM_VALUE.eq(dbParamPropValue.getItemValue()));
        }
 }