Êþº¾ 3 Ç main/MainTable java/lang/Object mpool Lcom/table_sql/MySqlPool; conn Ljava/sql/Connection; <init> ()V Code
|
|
LineNumberTable LocalVariableTable this Lmain/MainTable; createbadbatt (Lcom/table_sql/MySqlPool;)V =CREATE TABLE IF NOT EXISTS web_site.tb_badbatt_mon (`num` int(11) NOT NULL AUTO_INCREMENT,`battgroupid` int NOT NULL DEFAULT '0', `mon_num` int NOT NULL DEFAULT '0',`record_num` int NOT NULL DEFAULT '0',`test_starttime` datetime NOT NULL DEFAULT '1982-01-01 00:00:00',`group_vol` float NOT NULL DEFAULT '0',`test_curr` float NOT NULL DEFAULT '0',`mon_vol` float NOT NULL DEFAULT '0',`real_cap` float NOT NULL DEFAULT '0',`stdcap` float NOT NULL DEFAULT '0',`note` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT ' ',PRIMARY KEY (`num`),KEY `index_num` (`battgroupid`)) java/util/ArrayList
|
|
add (Ljava/lang/Object;)Z
|
com/table_sql/MySqlPool ! " getConn ()Ljava/sql/Connection;
|
$ % & makeManualCommit -(Ljava/sql/Connection;Ljava/util/ArrayList;)Z
|
m_ConnPool createbadbatt_monSql Ljava/lang/String; sql_str Ljava/util/ArrayList; bl Z LocalVariableTypeTable )Ljava/util/ArrayList<Ljava/lang/String;>; deletebadbatt 2 0DELETE FROM web_site.tb_badbatt_mon WHERE num>0 deletebadbatt_monSql updatealarmcap 6 nupdate db_alarm.tb_battalarm_data set alm_cleared_type=1 where alm_id in(119010,119011) and alm_cleared_type=0 updatealarmcapSql serverstartSql P(Ljava/util/Date;Ljava/lang/String;Ljava/lang/String;Lcom/table_sql/MySqlPool;)V ; java/lang/StringBuilder = update
|
: ? @ (Ljava/lang/String;)V B D C $com/mysql_param/Mysql_database_param E ) web_site
|
: G H I append -(Ljava/lang/String;)Ljava/lang/StringBuilder; B K L ) tb_Process_survey N P set Process_starttime=' R T S com/table/badbatt/BadBatt_thread U V sdf Ljava/text/SimpleDateFormat;
|
X Z Y java/text/SimpleDateFormat [ \ format $(Ljava/util/Date;)Ljava/lang/String; ^ ',ProcessVersion=' ` ' where ServerName=' b '
|
: d e f toString ()Ljava/lang/String;
|
h i j sqlMysqlUpdate *(Ljava/sql/Connection;Ljava/lang/String;)Z nowdate Ljava/util/Date;
|
serverName version m_ConnPool_ sql main ([Ljava/lang/String;)V t GMT+8
|
v x w java/util/TimeZone y z getTimeZone ((Ljava/lang/String;)Ljava/util/TimeZone;
|
v | } ~
|
setDefault (Ljava/util/TimeZone;)V
|
u0
|
java/lang/Thread sleep (J)V
|
java/lang/InterruptedException
|
printStackTrace java/lang/System out Ljava/io/PrintStream; tb_badbatt_mon表æ°å»º!
|
java/io/PrintStream @ println
|
'tb_badbatt_mon表éå¯å»é¤å°±æ°æ®!
|
¡ 0 £ Aè½ååä½æå¡å¯å¨,容éåè¦çå®æ¶æ°æ®æ¹ä¸ºåå²!
|
¥ 4 § 1æå¡å¯å¨ï¼è®°å½æå¡å¯å¨çåå§æ¶é´! © java/util/Date
|
¨ B ¬ ) BMS_FBSDEV_BADBATT B ¯ ° ) VERSION
|
² 8 9 ´ com/table/alarm/Alarm_thread
|
³ ¶
|
³ ¸ ¹
|
start
|
R ¶
|
R ¸ args [Ljava/lang/String; e Ljava/lang/InterruptedException; alarm_t Lcom/table/alarm/Alarm_thread; bd_t "Lcom/table/badbatt/BadBatt_thread; StackMapTable
|
SourceFile MainTable.java !
|
|
|
/ *· ±
L» Y· M,+¶ W*¶ ,¸ #>± % & ' ( * ' ( ) * + , - . * /
|
0
1L» Y· M,+¶ W*¶ ,¸ #>± , - . / 0 * ' 3 ) * + , - . * /
|
4
5L» Y· M,+¶ W*¶ ,¸ #>± 3 4 5 6 7 * ' 7 ) * + , - . * / 8 9 Ø V» :Y<· >² A¶ F² J¶ FM¶ FO¶ F² Q*¶ W¶ F]¶ F,¶ F_¶ F+¶ Fa¶ F¶ c:-¶ :-¶ g6± " : ; ) < 2 = @ : E > K @ U A H V k l V m ) V n ) V o E p ) K U , - q r % s¸ u¸ {» Y· ³ ¸ § L+¶ ² ¶ ² ¸ ² ¶ ² ¸ ² ¢¶ ² ¸ ¤² ¦¶ » ¨Y· ª² «² ®² ¸ ±» ³Y² · µL+¶ ·» RY² · ºM,¶ »± J C D F G I L ( M . O 6 P < R D S J U R V e X p Y t [ \ ] * ¼ ½ ¾ ¿ p À Á Â Ã Ä [ Å Æ
|
