W3C键值对应表

 

键值对应表:

 

keycode 8 = BackSpace

keycode 9 = Tab Tab 

keycode 12 = Clear 

keycode 13 = Enter 

keycode 16 = Shift_L 

keycode 17 = Control_L 

keycode 18 = Alt_L 

keycode 19 = Pause 

keycode 20 = Caps_Lock 

keycode 27 = Escape Escape 

keycode 32 = space space 

keycode 33 = Prior 

keycode 34 = Next 

keycode 35 = End 

keycode 36 = Home 

keycode 37 = Left 

keycode 38 = Up 

keycode 39 = Right 

keycode 40 = Down 

keycode 41 = Select 

keycode 42 = Print 

keycode 43 = Execute 

keycode 45 = Insert 

keycode 46 = Delete 

keycode 47 = Help 

keycode 48 = 0 equal braceright 

keycode 49 = 1 exclam onesuperior 

keycode 50 = 2 quotedbl twosuperior 

keycode 51 = 3 section threesuperior 

keycode 52 = 4 dollar 

keycode 53 = 5 percent 

keycode 54 = 6 ampersand 

keycode 55 = 7 slash braceleft 

keycode 56 = 8 parenleft bracketleft 

keycode 57 = 9 parenright bracketright 

keycode 65 = a A 

keycode 66 = b B 

keycode 67 = c C 

keycode 68 = d D 

keycode 69 = e E EuroSign 

keycode 70 = f F

keycode 71 = g G 

keycode 72 = h H 

keycode 73 = i I 

keycode 74 = j J 

keycode 75 = k K 

keycode 76 = l L 

keycode 77 = m M mu 

keycode 78 = n N 

keycode 79 = o O 

keycode 80 = p P 

keycode 81 = q Q at 

keycode 82 = r R 

keycode 83 = s S 

keycode 84 = t T 

keycode 85 = u U 

keycode 86 = v V 

keycode 87 = w W 

keycode 88 = x X 

keycode 89 = y Y 

keycode 90 = z Z 

keycode 96 = KP_0 KP_0 

keycode 97 = KP_1 KP_1 

keycode 98 = KP_2 KP_2 

keycode 99 = KP_3 KP_3 

keycode 100 = KP_4 KP_4 

keycode 101 = KP_5 KP_5 

keycode 102 = KP_6 KP_6 

keycode 103 = KP_7 KP_7 

keycode 104 = KP_8 KP_8 

keycode 105 = KP_9 KP_9 

keycode 106 = KP_Multiply KP_Multiply 

keycode 107 = KP_Add KP_Add

 

keycode 108 = KP_Separator KP_Separator 

keycode 109 = KP_Subtract KP_Subtract 

keycode 110 = KP_Decimal KP_Decimal 

keycode 111 = KP_Divide KP_Divide 

keycode 112 = F1 

keycode 113 = F2 

keycode 114 = F3 

keycode 115 = F4 

keycode 116 = F5 

keycode 117 = F6 

keycode 118 = F7 

keycode 119 = F8 

keycode 120 = F9 

keycode 121 = F10 

keycode 122 = F11 

keycode 123 = F12 

keycode 124 = F13 

keycode 125 = F14 

keycode 126 = F15 

keycode 127 = F16 

keycode 128 = F17 

keycode 129 = F18 

keycode 130 = F19 

keycode 131 = F20 

keycode 132 = F21 

keycode 133 = F22 

keycode 134 = F23 

keycode 135 = F24 

keycode 136 = Num_Lock 

keycode 137 = Scroll_Lock 

keycode 187 = acute grave 

keycode 188 = comma semicolon 

keycode 189 = minus underscore 

keycode 190 = period colon 

keycode 192 = numbersign apostrophe 

keycode 210 = plusminus hyphen macron 

keycode 211 = 

keycode 212 = copyright registered 

keycode 213 = guillemotleft guillemotright 

keycode 214 = masculine ordfeminine 

keycode 215 = ae AE 

keycode 216 = cent yen 

keycode 217 = questiondown exclamdown 

keycode 218 = onequarter onehalf threequarters 

keycode 220 = less greater bar 

keycode 221 = plus asterisk asciitilde 

keycode 227 = multiply division

 

keycode 228 = acircumflex Acircumflex 

keycode 229 = ecircumflex Ecircumflex 

keycode 230 = icircumflex Icircumflex 

keycode 231 = ocircumflex Ocircumflex 

keycode 232 = ucircumflex Ucircumflex 

keycode 233 = ntilde Ntilde 

keycode 234 = yacute Yacute 

keycode 235 = oslash Ooblique 

keycode 236 = aring Aring 

keycode 237 = ccedilla Ccedilla 

keycode 238 = thorn THORN 

keycode 239 = eth ETH 

keycode 240 = diaeresis cedilla currency 

keycode 241 = agrave Agrave atilde Atilde 

keycode 242 = egrave Egrave 

keycode 243 = igrave Igrave 

keycode 244 = ograve Ograve otilde Otilde 

keycode 245 = ugrave Ugrave 

keycode 246 = adiaeresis Adiaeresis 

keycode 247 = ediaeresis Ediaeresis 

keycode 248 = idiaeresis Idiaeresis 

keycode 249 = odiaeresis Odiaeresis 

keycode 250 = udiaeresis Udiaeresis 

keycode 251 = ssharp question backslash 

keycode 252 = asciicircum degree 

keycode 253 = 3 sterling 

keycode 254 = Mode_switch

 

A  0X65  U   0X85

B  0X66  V   0X86

C  0X67  W   0X87

D  0X68  X   0X88

E  0X69  Y   0X89

F  0X70  Z   0X90

G  0X71  0   0X48

H  0X72  1   0X49

I  0X73  2   0X50

J  0X74  3   0X51

K  0X75  4   0X52

L  0X76  5   0X53

M  0X77  6   0X54

N  0X78  7   0X55

O  0X79  8   0X56

P  0X80  9   0X57

Q  0X81 ESC  0X1B

R  0X82 CTRL  0X11

S  0X83 SHIFT 0X10

T  0X84 ENTER 0XD

 

如果要使用组合键,则可以利用event.ctrlKey,event.shiftKey,event .altKey判断是否按下了ctrl键、shift键以及alt键。

 

这是一组数据,你主要看编码和id的对应关系(A表):17 一次风机A primary_air_fan_A 18 一次风机B primary_air_fan_B 19 主汽轮机 main_steam_turbine 20 凝结水泵A condensate_pump_A 21 凝结水泵B condensate_pump_B 22 引风机A induced_draft_fan_A 23 引风机B induced_draft_fan_B 24 磨煤机A coal_mill_A 25 磨煤机B coal_mill_B 26 磨煤机C coal_mill_C 27 磨煤D coal_mill_D 28 磨煤机E coal_mill_E 29 磨煤机F coal_mill_F 30 给水泵A feed_pump_turbine_A 31 给水泵B feed_pump_turbine_B 32 送风机A forced_draught_blower_A 33 送风机B forced_draught_blower_B下面这个你需要看两个id之间的对应关系(B表,前面一个是新id,后面的是上面的id):148 32 217 18 218 19 219 20 220 21 221 22 222 17 223 23 224 24 225 25 226 26 227 27 228 28 229 29 230 30 231 31 232 33。下面是目标表C的SQL:CREATE TABLE "JNPF_INIT"."BIZ_MEASURE_POINT" ( "ID" BIGINT IDENTITY(21, 1) NOT NULL, "MEASURE_POINT_NAME" VARCHAR(100) NOT NULL, "MEASURE_POINT_KEY" VARCHAR(50) NOT NULL, "SID" BIGINT NOT NULL, "ATTRIBUTE_TYPE_ID" VARCHAR(50), "MEASURE_POINT_TYPE_ID" VARCHAR(50), "UNIT_NAME" VARCHAR(10), "LIMIT_TYPE" INT DEFAULT 0 NOT NULL, "UPPER_LIMIT" REAL, "LOWER_LIMIT" REAL, "FIELD_NAME" VARCHAR(50), "CREATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "UPDATED_AT" TIMESTAMP(0) DEFAULT CURRENT_TIMESTAMP() NOT NULL, "DELETED_AT" TIMESTAMP(0), "F_TENANT_ID" VARCHAR(50) NOT NULL, "F_FLOW_ID" VARCHAR(50), "F_FLOW_TASK_ID" VARCHAR(50), NOT CLUSTER PRIMARY KEY("ID"), CONSTRAINT "MEASURE_POINT_KEY" UNIQUE("MEASURE_POINT_KEY"), CHECK("SID" >= 0)) STORAGE(ON "MAIN", CLUSTERBTR);。最后是要导入的数据:{"primary_air_fan_A": ["w3_unit1_10hlb30cf001", "w3_unit1_10hla30cp001", "w3_unit1_10hlv30m02ai01", "w3_unit1_10hlv30m01ai01", "w3_unit1_10hlb30m01ai01", "w3_unit1_10hlb30cy012", "w3_unit1_10hlb30cy011", "w3_unit1_10hlb30ct066", "w3_unit1_10hlb30ct065", "w3_unit1_10hlb30ct064", "w3_unit1_10hlb30ct063", "w3_unit1_10hlb30ct062", "w3_unit1_10hlb30ct061", "w3_unit1_10hlb30ct052", "w3_unit1_10hlb30ct051", "w3_unit1_10hlb30ct043", "w3_unit1_10hlb30ct042", "w3_unit1_10hlb30ct041", "w3_unit1_10hlb30ct033", "w3_unit1_10hlb30ct032", "w3_unit1_10hlb30ct031", "w3_unit1_10hlb30ct023", "w3_unit1_10hlb30ct022", "w3_unit1_10hlb30ct021", "w3_unit1_10hlb30ct013", "w3_unit1_10hlb30ct012", "w3_unit1_10hlb30ct011", "w3_unit1_10hla30ct003", "w3_unit1_10hla30ct002", "w3_unit1_10hla30ct001"], "primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], "main_steam_turbine": ["w3_unit1_10qjdzj10ct001", "w3_unit1_10qjdzj10cq001", "w3_unit1_10mav74ct032", "w3_unit1_10mav74ct031", "w3_unit1_10max22ct001", "w3_unit1_10max21ct001", "w3_unit1_10max17ct001", "w3_unit1_10mav74ct011", "w3_unit1_10mav74cp038", "w3_unit1_10mav60ct010", "w3_unit1_10mav50ct010", "w3_unit1_10mav40ct010", "w3_unit1_10mav30ct010", "w3_unit1_10mav20ct010", "w3_unit1_10mav10ct010", "w3_unit1_10mav10cp010", "w3_unit1_10mav00ct020", "w3_unit1_10mav00ct010", "w3_unit1_10maa50ct004", "w3_unit1_10maa50ct003", "w3_unit1_10maa50ct002", "w3_unit1_10maa50ct001", "w3_unit1_10cjj31001cra00r", "w3_unit1_10max12m01ai01", "w3_unit1_10mav74m02ai01", "w3_unit1_10mav73m03ai01", "w3_unit1_10xav10m03ai01", "w3_unit1_10xav10m02ai01", "w3_unit1_10max16m02ai01", "w3_unit1_10max16m01ai01", "w3_unit1_10max11m01ai01", "w3_unit1_10mav74m01ai01", "w3_unit1_10mav73m02ai01", "w3_unit1_10mav73m01ai01", "w3_unit1_10mav73ct011", "w3_unit1_10mav73cl001", "w3_unit1_10mav74ct021", "w3_unit1_10mac50ct004", "w3_unit1_10mac50ct003", "w3_unit1_10mac50ct002", "w3_unit1_10mac50ct001"], "condensate_pump_A": ["w3_unit1_10xac20cy042", "w3_unit1_10xac20cy041", "w3_unit1_10lcb11ct014", "w3_unit1_10lcb11ct013", "w3_unit1_10lcb11ct012", "w3_unit1_10lcb11ct011", "w3_unit1_10lcb11ct010", "w3_unit1_10lcp13m01ai01", "w3_unit1_10lcb11m01ai01", "w3_unit1_10lcb11ct009", "w3_unit1_10lcb11ct008", "w3_unit1_10lcb11ct007", "w3_unit1_10lcb11ct006", "w3_unit1_10lcb11ct005", "w3_unit1_10lcb11ct004", "w3_unit1_10lcb11ct003", "w3_unit1_10lcb11ct002", "w3_unit1_10lcb11ct001", "w3_unit1_10lca11cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "condensate_pump_B": ["w3_unit1_10xac20cy052", "w3_unit1_10xac20cy051", "w3_unit1_10lcb12ct014", "w3_unit1_10lcb12ct013", "w3_unit1_10lcb12ct012", "w3_unit1_10lcb12ct011", "w3_unit1_10lcb12ct010", "w3_unit1_10lcp12m01ai01", "w3_unit1_10lcb12m01ai01", "w3_unit1_10lcb12ct009", "w3_unit1_10lcb12ct008", "w3_unit1_10lcb12ct007", "w3_unit1_10lcb12ct006", "w3_unit1_10lcb12ct005", "w3_unit1_10lcb12ct004", "w3_unit1_10lcb12ct003", "w3_unit1_10lcb12ct002", "w3_unit1_10lcb12ct001", "w3_unit1_10lca10cp001", "w3_unit1_10lca20cp001", "w3_unit1_10lca20ct002"], "induced_draft_fan_A": ["w3_unit1_10hnc10ct163", "w3_unit1_10hnc10ct162", "w3_unit1_10hnc10ct161", "w3_unit1_10hnv10cp101", "w3_unit1_10hnc10ct102", "w3_unit1_10hnc10ct101", "w3_unit1_10hnc10ct100", "w3_unit1_10hnc10cf001", "w3_unit1_10hna10ct004", "w3_unit1_10hna10cp003", "w3_unit1_10hna10cp002", "w3_unit1_10hnc10m01ai01", "w3_unit1_10hnc10ct017", "w3_unit1_10hnc10ct016", "w3_unit1_10hnc10ct015", "w3_unit1_10hnc10ct014", "w3_unit1_10hnc10ct013", "w3_unit1_10hnc10ct012", "w3_unit1_10hnc10ct011", "w3_unit1_10hnc10ct010", "w3_unit1_10hnc10ct009", "w3_unit1_10hnc10ct008", "w3_unit1_10hnc10ct007", "w3_unit1_10hnc10ct006", "w3_unit1_10hnc10ct005", "w3_unit1_10hnc10ct004", "w3_unit1_10hnc10ct003", "w3_unit1_10hnc10ct002", "w3_unit1_10hnc10ct001", "w3_unit1_10hnc10cg002", "w3_unit1_10hnc10cg001"], "induced_draft_fan_B": ["w3_unit1_10hnc20ct163", "w3_unit1_10hnc20ct162", "w3_unit1_10hnc20ct161", "w3_unit1_10hnc20cp101", "w3_unit1_10hnc20ct102", "w3_unit1_10hnc20ct101", "w3_unit1_10hnc20ct100", "w3_unit1_10hnc20cf001", "w3_unit1_10hna20ct004", "w3_unit1_10hna20cp003", "w3_unit1_10hna20cp002", "w3_unit1_10hnc20m01ai01", "w3_unit1_10hnc20ct017", "w3_unit1_10hnc20ct016", "w3_unit1_10hnc20ct015", "w3_unit1_10hnc20ct014", "w3_unit1_10hnc20ct013", "w3_unit1_10hnc20ct012", "w3_unit1_10hnc20ct011", "w3_unit1_10hnc20ct010", "w3_unit1_10hnc20ct009", "w3_unit1_10hnc20ct008", "w3_unit1_10hnc20ct007", "w3_unit1_10hnc20ct006", "w3_unit1_10hnc20ct005", "w3_unit1_10hnc20ct004", "w3_unit1_10hnc20ct003", "w3_unit1_10hnc20ct002", "w3_unit1_10hnc20ct001", "w3_unit1_10hnc20cg002", "w3_unit1_10hnc20cg001"], "coal_mill_A": ["w3_unit1_10hfc12ct016", "w3_unit1_10hfc10ct022", "w3_unit1_10hfc10ct021", "w3_unit1_10hfc10cp011", "w3_unit1_10hfc10cp001", "w3_unit1_10hfv12ct011", "w3_unit1_10hfv12cp011", "w3_unit1_10hfv11ct001", "w3_unit1_10hfe10cp002", "w3_unit1_10hfc12ct015", "w3_unit1_10hfc12ct014", "w3_unit1_10hfc12ct013", "w3_unit1_10hfc12ct012", "w3_unit1_10hfc12ct011", "w3_unit1_10hfc10ct036", "w3_unit1_10hfc10ct035", "w3_unit1_10hfc10ct034", "w3_unit1_10hfc10ct033", "w3_unit1_10hfc10ct032", "w3_unit1_10hfc10ct031", "w3_unit1_pri_flow_a", "w3_unit1_10hfe10ct001", "w3_unit1_10hfe10cp001", "w3_unit1_10hfc10ct013", "w3_unit1_10hfc10ct012", "w3_unit1_10hfc10ct011"], "coal_mill_B": ["w3_unit1_10hfc22ct016", "w3_unit1_10hfc20ct022", "w3_unit1_10hfc20ct021", "w3_unit1_10hfc20cp011", "w3_unit1_10hfc20cp001", "w3_unit1_10hfv22ct011", "w3_unit1_10hfv22cp011", "w3_unit1_10hfe20cp002", "w3_unit1_10hfc22ct015", "w3_unit1_10hfc22ct014", "w3_unit1_10hfc22ct013", "w3_unit1_10hfc22ct012", "w3_unit1_10hfc22ct011", "w3_unit1_10hfc20ct036", "w3_unit1_10hfc20ct035", "w3_unit1_10hfc20ct034", "w3_unit1_10hfc20ct033", "w3_unit1_10hfc20ct032", "w3_unit1_10hfc20ct031", "w3_unit1_pri_flow_b", "w3_unit1_10hfe20ct001", "w3_unit1_10hfe20cp001", "w3_unit1_10hfc20ct013", "w3_unit1_10hfc20ct012", "w3_unit1_10hfc20ct011"], "coal_mill_C": ["w3_unit1_10hfc32ct016", "w3_unit1_10hfc30ct022", "w3_unit1_10hfc30ct021", "w3_unit1_10hfc30cp011", "w3_unit1_10hfc30cp001", "w3_unit1_10hfv32ct011", "w3_unit1_10hfv32cp011", "w3_unit1_10hfe30cp002", "w3_unit1_10hfc32ct015", "w3_unit1_10hfc32ct014", "w3_unit1_10hfc32ct013", "w3_unit1_10hfc32ct012", "w3_unit1_10hfc32ct011", "w3_unit1_10hfc30ct036", "w3_unit1_10hfc30ct035", "w3_unit1_10hfc30ct034", "w3_unit1_10hfc30ct033", "w3_unit1_10hfc30ct032", "w3_unit1_10hfc30ct031", "w3_unit1_pri_flow_c", "w3_unit1_10hfe30ct001", "w3_unit1_10hfe30cp001", "w3_unit1_10hfc30ct013", "w3_unit1_10hfc30ct012", "w3_unit1_10hfc30ct011"], "coal_mill_D": ["w3_unit1_10hfc42ct016", "w3_unit1_10hfc40ct022", "w3_unit1_10hfc40ct021", "w3_unit1_10hfc40cp011", "w3_unit1_10hfc40cp001", "w3_unit1_10hfv42ct011", "w3_unit1_10hfv42cp011", "w3_unit1_10hfe40cp002", "w3_unit1_10hfc42ct015", "w3_unit1_10hfc42ct014", "w3_unit1_10hfc42ct013", "w3_unit1_10hfc42ct012", "w3_unit1_10hfc42ct011", "w3_unit1_10hfc40ct036", "w3_unit1_10hfc40ct035", "w3_unit1_10hfc40ct034", "w3_unit1_10hfc40ct033", "w3_unit1_10hfc40ct032", "w3_unit1_10hfc40ct031", "w3_unit1_pri_flow_d", "w3_unit1_10hfe40ct001", "w3_unit1_10hfe40cp001", "w3_unit1_10hfc40ct013", "w3_unit1_10hfc40ct012", "w3_unit1_10hfc40ct011"], "coal_mill_E": ["w3_unit1_10hfc50ct022", "w3_unit1_10hfc50ct021", "w3_unit1_10hfc50cp011", "w3_unit1_10hfc50cp001", "w3_unit1_10hfv52ct011", "w3_unit1_10hfv52cp011", "w3_unit1_10hfe50cp002", "w3_unit1_10hfc52ct015", "w3_unit1_10hfc52ct014", "w3_unit1_10hfc52ct013", "w3_unit1_10hfc52ct012", "w3_unit1_10hfc52ct011", "w3_unit1_10hfc50ct036", "w3_unit1_10hfc50ct035", "w3_unit1_10hfc50ct034", "w3_unit1_10hfc50ct033", "w3_unit1_10hfc50ct032", "w3_unit1_10hfc50ct031", "w3_unit1_pri_flow_e", "w3_unit1_10hfe50ct001", "w3_unit1_10hfe50cp001", "w3_unit1_10hfc50ct013", "w3_unit1_10hfc50ct012", "w3_unit1_10hfc50ct011", "w3_unit1_10hfc40ct011"], "coal_mill_F": ["w3_unit1_10hfc62ct016", "w3_unit1_10hfc60ct022", "w3_unit1_10hfc60ct021", "w3_unit1_10hfc60cp011", "w3_unit1_10hfc60cp001", "w3_unit1_10hfv62ct011", "w3_unit1_10hfv62cp011", "w3_unit1_10hfe60cp002", "w3_unit1_10hfc62ct015", "w3_unit1_10hfc62ct014", "w3_unit1_10hfc62ct013", "w3_unit1_10hfc62ct012", "w3_unit1_10hfc62ct011", "w3_unit1_10hfc60ct036", "w3_unit1_10hfc60ct035", "w3_unit1_10hfc60ct034", "w3_unit1_10hfc60ct033", "w3_unit1_10hfc60ct032", "w3_unit1_10hfc60ct031", "w3_unit1_pri_flow_f", "w3_unit1_10hfe60ct001", "w3_unit1_10hfe60cp001", "w3_unit1_10hfc60ct013", "w3_unit1_10hfc60ct012", "w3_unit1_10hfc60ct011"], "feed_pump_turbine_A": ["w3_unit1_10xac10ct094", "w3_unit1_10xac10ct093", "w3_unit1_10xac10ct092", "w3_unit1_10xac10ct091", "w3_unit1_10xac10cp001", "w3_unit1_10xaa13cp001", "w3_unit1_10xaa12cp011", "w3_unit1_10xaa12cp001", "w3_unit1_10lbr11cp001", "w3_unit1_10xac10ct081", "w3_unit1_10xac10ct008", "w3_unit1_10xac10ct007", "w3_unit1_10xac10ct006", "w3_unit1_10xac10ct005", "w3_unit1_10xac10ct004", "w3_unit1_10xac10ct003", "w3_unit1_10xac10ct002", "w3_unit1_10xac10ct001", "w3_unit1_10xaa11ct201", "w3_unit1_10xaa11cp001", "w3_unit1_10xaa11ct135", "w3_unit1_load"], "feed_pump_turbine_B": ["w3_unit1_10xac20ct094", "w3_unit1_10xac20ct093", "w3_unit1_10xac20ct092", "w3_unit1_10xac20ct091", "w3_unit1_10xac20cp001", "w3_unit1_10xaa23cp001", "w3_unit1_10xaa22cp011", "w3_unit1_10xaa22cp001", "w3_unit1_10lbr12cp001", "w3_unit1_10xac20ct081", "w3_unit1_10xac20ct008", "w3_unit1_10xac20ct007", "w3_unit1_10xac20ct006", "w3_unit1_10xac20ct005", "w3_unit1_10xac20ct004", "w3_unit1_10xac20ct003", "w3_unit1_10xac20ct002", "w3_unit1_10xac20ct001", "w3_unit1_10xaa21ct201", "w3_unit1_10xaa21cp001", "w3_unit1_10xaa21ct135", "w3_unit1_load"], "forced_draught_blower_A": ["w3_unit1_10hla10cp001", "w3_unit1_10hlv10m01ai01", "w3_unit1_10hlb10m01ai01", "w3_unit1_10hlb10cy012", "w3_unit1_10hlb10cy011", "w3_unit1_10hlb10ct066", "w3_unit1_10hlb10ct065", "w3_unit1_10hlb10ct064", "w3_unit1_10hlb10ct063", "w3_unit1_10hlb10ct062", "w3_unit1_10hlb10ct061", "w3_unit1_10hlb10ct042", "w3_unit1_10hlb10ct041", "w3_unit1_10hlb10ct033", "w3_unit1_10hlb10ct032", "w3_unit1_10hlb10ct031", "w3_unit1_10hlb10ct023", "w3_unit1_10hlb10ct022", "w3_unit1_10hlb10ct021", "w3_unit1_10hlb10ct013", "w3_unit1_10hlb10ct012", "w3_unit1_10hlb10ct011", "w3_unit1_10hla10ct003", "w3_unit1_10hla10ct002", "w3_unit1_10hla10ct001", "w3_unit1_10hlb10cf003", "w3_unit1_10hlb10cf002", "w3_unit1_10hlb10cf001"], "forced_draught_blower_B": ["w3_unit1_10hla20cp001", "w3_unit1_10hlv20m02ai01", "w3_unit1_10hlb20m01ai01", "w3_unit1_10hlb20cy012", "w3_unit1_10hlb20cy011", "w3_unit1_10hlb20ct066", "w3_unit1_10hlb20ct065", "w3_unit1_10hlb20ct064", "w3_unit1_10hlb20ct063", "w3_unit1_10hlb20ct062", "w3_unit1_10hlb20ct061", "w3_unit1_10hlb20ct042", "w3_unit1_10hlb20ct041", "w3_unit1_10hlb20ct033", "w3_unit1_10hlb20ct032", "w3_unit1_10hlb20ct031", "w3_unit1_10hlb20ct023", "w3_unit1_10hlb20ct022", "w3_unit1_10hlb20ct021", "w3_unit1_10hlb20ct013", "w3_unit1_10hlb20ct012", "w3_unit1_10hlb20ct011", "w3_unit1_10hla20ct003", "w3_unit1_10hla20ct002", "w3_unit1_10hla20ct001", "w3_unit1_10hlb20cf003", "w3_unit1_10hlb20cf002", "w3_unit1_10hlb20cf001"]}。你需要做的是编写表C的插入SQL。这个插入SQL中MEASURE_POINT_NAME字段采用表A中的中文,但是是加一个序号比如说:一次风机B1、一次风机B2。MEASURE_POINT_KEY字段则是去上面的数据中匹配,这个里面有多少条数据就表示这个要插入多少条:"primary_air_fan_B": ["w3_unit1_10hlb40cf001", "w3_unit1_10hla40ct003", "w3_unit1_10hla40ct002", "w3_unit1_10hla40ct001", "w3_unit1_10hla40cp001", "w3_unit1_10hlv40m02ai01", "w3_unit1_10hlv40m01ai01", "w3_unit1_10hlb40m01ai01", "w3_unit1_10hlb40cy012", "w3_unit1_10hlb40cy011", "w3_unit1_10hlb40ct066", "w3_unit1_10hlb40ct065", "w3_unit1_10hlb40ct064", "w3_unit1_10hlb40ct063", "w3_unit1_10hlb40ct062", "w3_unit1_10hlb40ct061", "w3_unit1_10hlb40ct052", "w3_unit1_10hlb40ct051", "w3_unit1_10hlb40ct043", "w3_unit1_10hlb40ct042", "w3_unit1_10hlb40ct041", "w3_unit1_10hlb40ct033", "w3_unit1_10hlb40ct032", "w3_unit1_10hlb40ct031", "w3_unit1_10hlb40ct023", "w3_unit1_10hlb40ct022", "w3_unit1_10hlb40ct021", "w3_unit1_10hlb40ct013", "w3_unit1_10hlb40ct012", "w3_unit1_10hlb40ct011"], SID字段的匹配方式根据表A和表B的数据来,比如说表A是18 一次风机B primary_air_fan_B,这个数据就对应表B的217 18。那么SID就是18。也就是说所有的primary_air_fan_B的SID都是18。剩下的字段"ATTRIBUTE_TYPE_ID" VARCHAR(50), "MEASURE_POINT_TYPE_ID" VARCHAR(50), "UNIT_NAME" VARCHAR(10), "LIMIT_TYPE" INT DEFAULT 0 NOT NULL, "UPPER_LIMIT" REAL, "LOWER_LIMIT" REAL, 字段全部固定值:714801548705677637 714801636857364805 ℃ 1 100 60。最后说一遍,你需要把我给你的json字符串中的数据变成这个C表的插入SQL。我使用的达梦数据库。请将他们一一匹配好。
最新发布
09-19
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值