后端

mysql

#
创建账号 liuwy   密码 1250405120@l
CREATE
USER 'liuwy'@'%' IDENTIFIED BY '1250405120@l';

#
所有数据库权限
GRANT
SELECT
ON *.* TO 'liuwy'@'%';

FLUSH
PRIVILEGES;

#
删除用户
DROP
USER 'liuwy'@'%';

#
查看用户
SELECT User, Host, authentication_string, plugin
FROM mysql.user;

java8

stream流操作

1.多字段排序

• 先按照年份排序、再按照类型排序

• 先按照png jpg jpeg bmp排序靠后、然后按照id从大到小排序

2.LinkedHasMap映射为JSONObject

Map<String, BigDecimal> lastProjectName2InterestSum=lastDataSetData.getDataSets().stream()
        .map(JSON::toJSONString)
        .map(JSONObject::parseObject)
        .collect(Collectors.groupingBy(x->x.getString("project_name"),Collectors.reducing(BigDecimal.ZERO,obj->obj.getBigDecimal("interest_sum"),BigDecimal::add)));

spring

前言-配置源加载顺序

配置源的加载顺序与优先级 https://blog.csdn.net/zizhuangzhuang/article/details/121213857

springcloud config配置读取优先级 https://www.cnblogs.com/question-sky/p/11580365.html

---

配置加载（注意是仅仅是加载，并非生效）顺序，先加载先被覆盖，所以数字大的最终生效！

1. bootstrap.yaml
2. application.yaml
3. application.properties
4. systemEnvironment System.getEnv() 环境属性，例如JAVA_HOME/M2_HOME
5. systemProperties System.getProperties() Java系统属性、-D开头的VM属性
6. commandLineArgs Program arguments 传入main函数的参数列表
7. 远程读取的配置文件 如spring cloud config

yml添加配置

bootstrap.yml

fill:
  bdxy:
    tenantIds: ${FILL_BDXY_TENANTIDS:123,456}
    templateCodes: ${FILL_BDXY_TEMPLATECODES:JYJC}

使用

@Value("#{'${fill.bdxy.tenantIds:}'.split(',')}")
protected List<String> tenantIds;

@Value("#{'${fill.bdxy.templateCodes:}'.split(',')}")
protected List<String> templateCodes;

字典

1.插入字典定义的sql

• 修改name， 别名

INSERT INTO entity_def
(id, tenant_id, name, tree, alias, config, schema_def, visible, enable_ext_data, version, dict_develop_type, product_code,
 project_tag)
VALUES (xx, 0, 'xxxxTypeDict', 0, '成本合同采购方式字典', '{"enableInherited":true}',
        '{"entityConstraints":[{"name":"xxxxTypeDictCodeUK","uniqueFieldsConstraint":{"fields":"code"}},{"name":"xxxxTypeDictNameUK","uniqueFieldsConstraint":{"fields":"name"}}],"entityPropDefs":[{"name":"code","alias":"编码","required":true,"minLength":0,"maxLength":50,"visible":true,"config":{},"dataKind":{"type":"string"}},{"name":"name","alias":"名称","required":true,"minLength":0,"maxLength":100,"visible":true,"config":{},"dataKind":{"type":"string"}},{"name":"description","alias":"说明","required":false,"minLength":0,"maxLength":255,"visible":true,"config":{},"dataKind":{"type":"string"}}]}',
        1, 1, 0, NULL, NULL, NULL);

INSERT INTO entity_def_tag_rel (id, def_id, tag_id)
VALUES (xx, xx, 1);

2.读取entity的规则

当entity_def表中enableInherited为true，说明读取的字典项来源要判断entity_inherit表有无tenant_id、entity_type对应的数据行

• 如果有，则entity项取entity表中tenant_id，entity_type的数据
• 如果没有，则entity项取entity表中tenant_id为0，entity_type的数据

dolphinscheduler

修改ds账号密码

在对应的dolphinscheduler库下

UPDATE t_ds_user
SET user_password = MD5('xxxxx')
WHERE user_name = 'xxxx'