1.
微信截图_20230505092557.png
2.写json 脚本
{
"job": {
"setting": {
"speed": {
"channel": 3
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "123456",
"column": [
"ID",
"AJBH",
"XCKYBH",
"JJBH",
"AJMC",
"AJXZ",
"AJXZMC",
"AJLB",
"AJLBMC",
"DXZPAJLB",
"DXZPAJLBMC",
"AJFAB",
"AJFABMC",
"AY",
"AYMC",
"FAY",
"FAYMC",
"AJZTDM",
"AJZTMC",
"FASJ",
"FADZ",
"FADZXZQH",
"FADZXZQHMC",
"AJFSKSSJ",
"AJFSJSSJ",
"JYAQ",
"DBJB",
"DBJBMC",
"SAJZ",
"SLSJ",
"SLDWDM",
"SLDWMC",
"LARQ",
"LADWDM",
"LADWMC",
"BADWDM",
"BADWMC",
"ZBRXM",
"ZBRLXDH",
"PAFS",
"PAFSMC",
"PASJ",
"PADWDM",
"PADWMC",
"XKDWDM",
"XKDWMC",
"KYRXM",
"XKDD",
"CRIME_TIME_BEGIN",
"CRIME_TIME_END",
"SHRZJLXBM",
"SHRZJLXMC",
"SHRLX",
"SHRLXMC",
"SHRXM",
"SHRZJHM",
"SHRLXFS",
"SHRZHLX",
"SHRZHLXMC",
"SHR_ACCOUNT_ID",
"SHR_ACCOUNT",
"SHRBZ",
"HJDZ_DZBM",
"HJDZ_DZMC",
"SJZZ",
"XKJYAQ",
"SJLY",
"XTLY",
"DWBM",
"DWMC",
"CREATE_XM",
"CREATE_ID",
"CREATE_TIME",
"UPDATE_TIME",
"SFSC",
"REPLICA_STATE",
"SUBJECT_ID",
"ZCZT",
"WJMC",
"CLZT",
"BDMB_ZTK"
],
"connection": [
{
"table": [
"swk_case"
],
"jdbcUrl":
"jdbc:mysql://127.0.0.1:3306/test?
characterEncoding=utf8&useSSL=false&allowMultiQueries=true&serverTimezone=Asia/S
hanghai&zeroDateTimeBehavior=CONVERT_TO_NULL"
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "123456",
"column": [
"ID",
"AJBH",
"XCKYBH",
"JJBH",
"AJMC",
"AJXZ",
"AJXZMC",
"AJLB",
"AJLBMC",
"DXZPAJLB",
"DXZPAJLBMC",
"AJFAB",
"AJFABMC",
"AY",
"AYMC",
"FAY",
"FAYMC",
"AJZTDM",
"AJZTMC",
"FASJ",
"FADZ",
"FADZXZQH",
"FADZXZQHMC",
"AJFSKSSJ",
"AJFSJSSJ",
"JYAQ",
"DBJB",
"DBJBMC",
"SAJZ",
"SLSJ",
"SLDWDM",
"SLDWMC",
"LARQ",
"LADWDM",
"LADWMC",
"BADWDM",
"BADWMC",
"ZBRXM",
"ZBRLXDH",
"PAFS",
"PAFSMC",
"PASJ",
"PADWDM",
"PADWMC",
"XKDWDM",
"XKDWMC",
"KYRXM",
"XKDD",
"CRIME_TIME_BEGIN",
"CRIME_TIME_END",
"SHRZJLXBM",
"SHRZJLXMC",
"SHRLX",
"SHRLXMC",
"SHRXM",
"SHRZJHM",
"SHRLXFS",
"SHRZHLX",
上传脚本到 bin目录下
"SHRZHLXMC",
"SHR_ACCOUNT_ID",
"SHR_ACCOUNT",
"SHRBZ",
"HJDZ_DZBM",
"HJDZ_DZMC",
"SJZZ",
"XKJYAQ",
"SJLY",
"XTLY",
"DWBM",
"DWMC",
"CREATE_XM",
"CREATE_ID",
"CREATE_TIME",
"UPDATE_TIME",
"SFSC",
"REPLICA_STATE",
"SUBJECT_ID",
"ZCZT",
"WJMC",
"CLZT",
"BDMB_ZTK"
],
"preSql": [],
"postSql": [],
"connection": [
{
"jdbcUrl":
"jdbc:mysql://127.0.0.1:3306/test?
characterEncoding=utf8&useSSL=false&allowMultiQueries=true&serverTimezone=Asia/S
hanghai&zeroDateTimeBehavior=CONVERT_TO_NULL",
"table": [
"swk_case_test"
]
}
],
"loadProps": {}
}
}
}
]
}
}
image.png
4.
image.png
网友评论