Êþº¾ 4 ý com/sql/Sql_Sybase java/lang/Object SQL_TYPE_SYBASE_DEMO I ConstantValue SQL_TYPE_SYBASE SQL_TYPE_MSSQLSERVER
|
m_SQL_TYPE mSQLServerIp Ljava/lang/String; mSQLServerUsrName mSQLServerPWD mSQLServerPort sql_res Ljava/sql/ResultSet; sql_conn Ljava/sql/Connection; <init> (Lcom/config/AppConfig;)V Code
|
()V 127.0.0.1 " $ sxfg001 & ( * , .
|
0 2 1 com/config/AppConfig 3 4 getSourceSQLServerType ()I
|
0 6 7 8 getSourceSQLServerIp ()Ljava/lang/String;
|
0 : ; 8 getSourceSQLServerUsrName
|
0 = > 8 getSourceSQLServerPWD
|
0 @ A 4 getSourceSQLServerPort
|
C D E getConnection ()Ljava/sql/Connection; LineNumberTable LocalVariableTable this Lcom/sql/Sql_Sybase; cfg Lcom/config/AppConfig; get_SQL_TYPE getQueryVolString r(Ljava/lang/String;Ljava/util/GregorianCalendar;Ljava/util/GregorianCalendar;Ljava/lang/String;)Ljava/lang/String; P R java/lang/StringBuilder T ESELECT StationId,EquipmentId,SignalId,FloatValue FROM HistoryBattery
|
Q V W (Ljava/lang/String;)V
|
Y [ Z java/util/GregorianCalendar \ ] get (I)I
|
Q _ ` a append (I)Ljava/lang/StringBuilder; c WHERE
|
Q e ` f -(Ljava/lang/String;)Ljava/lang/StringBuilder; h StationId= j AND RecordTime>'
|
Y l m n getTime ()Ljava/util/Date; p yyyy-MM-dd HH:mm:ss
|
r t s com/base/Com u v getDateTimeFormat 6(Ljava/util/Date;Ljava/lang/String;)Ljava/lang/String; x ' z AND RecordTime<=' | ORDER BY RecordTime
|
Q ~ 8 toString StationId=' HSELECT StationId,EquipmentId,SignalId,FloatValue FROM TBL_HistorySignal
AND SampleTime>' AND SampleTime<=' ORDER BY SampleTime st_id gc_start Ljava/util/GregorianCalendar; gc_end
|
time_order str StackMapTable java/lang/String getQueryCurrentString DSELECT StationId,EquipmentId,SignalId,FloatValue FROM HistorySignal AND RecordTime >' AND RecordTime <=' com.sybase.jdbc3.jdbc.SybDriver
|
java/lang/Class ¡ forName %(Ljava/lang/String;)Ljava/lang/Class;
|
£ ¤ ¥ newInstance ()Ljava/lang/Object; § jdbc:sybase:Tds: © : « /SiteWeb
|
¯ ® java/lang/System ° ± getProperties ()Ljava/util/Properties; ³ user
|
µ · ¶ java/util/Properties ¸ ¹ put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; » password
|
½ ¿ ¾ java/sql/DriverManager D À ?(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection; Â ,com.microsoft.sqlserver.jdbc.SQLServerDriver Ä jdbc:sqlserver:// Æ ;DatabaseName=SiteWeb
|
½ È D É M(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection; Ë java/lang/InstantiationException Í java/lang/IllegalAccessException Ï java/lang/ClassNotFoundException Ñ java/sql/SQLException con url sysProps Ljava/util/Properties; × java/sql/Connection Ù java/lang/Exception getSqlres ()Ljava/sql/ResultSet;
|
close_conn
|
Exceptions Ö ß à close get_conn_state ()Z sqlSybaseQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; Ö æ ç è createStatement ()Ljava/sql/Statement; ê ì ë java/sql/Statement í î setQueryTimeout (I)V ê ð ñ ä executeQuery sql_str sql Ljava/sql/Statement; rs sqlSybaseExecute ê ø ù ú execute (Ljava/lang/String;)Z
|
SourceFile Sql_Sybase.java !
|
|
|
É ]*· *µ * µ !*#µ %*#µ '*µ )*µ +*µ -*+¶ /µ *+¶ 5µ !*+¶ 9µ %*+¶ <µ '*+¶ ?µ )**¶ Bµ -± F > " ' , 4 ! < " D # L $ T & \ ' G ] H I ] J K L 4 / *´ ¬ F + G H I M N % =O:*´ b» QYS· U,¶ X`¶ ^b¶ dg¶ d+¶ di¶ d,¶ ko¸ q¶ dw¶ dy¶ d-¶ ko¸ q¶ dw¶ d{¶ d¶ d¶ }:§ Ò*´ g» QYS· U,¶ X`¶ ^b¶ d¶ d+¶ dw¶ di¶ d,¶ ko¸ q¶ dw¶ dy¶ d-¶ ko¸ q¶ dw¶ d{¶ d¶ d¶ }:§ g*´ _» QY· U,¶ X`¶ ^b¶ dg¶ d+¶ d¶ d,¶ ko¸ q¶ dw¶ d¶ d-¶ ko¸ q¶ dw¶ d¶ d¶ d¶ }:° F ~ 1 2 4 5 6 $ 7 - 8 C 9 Y : c 4 h ; k < r > { ?
@ A B ® C Ä D Î > Ó E Ö F Þ H ç I ñ J ö K ÿ L M+ N5 H: P G > = H I = = = = 9 ü k û jû c N ý kO:*´ _» QY· U,¶ X`¶ ^b¶ dg¶ d+¶ d¶ d,¶ ko¸ q¶ dw¶ d¶ d-¶ ko¸ q¶ dw¶ d{¶ d¶ d¶ }:° F . _ ` b c d $ e - f C g Y h c b h k G > k H I k k k k g ü h D E | L*´ *´ X¸ ¶ ¢W» QY¦· U*´ !¶ d¨¶ d*´ )¶ ^ª¶ d¶ }M¸ ¬N-²*´ %¶ ´W-º*´ '¶ ´W,-¸ ¼L§ ?M§ ;*´ 3Á¸ W» QY÷ U*´ !¶ dŶ d¶ }M,*´ %*´ '¸ ÇL§ M+° _ b Ê _ b Ì _ b Î _ b Ð n Î n Ð F F o p s t ? u C v N w Y y _ z b { c f n t G 4 H I Ò ? Ó C Ô Õ Ó ü Ö÷ P Øv Ø Ú Û / *´ +° F Æ G H I Ü Ý Ð U *´ -Æ *´ -¹ Þ *µ -± F Ê Ì Í Ï G H I á â F *´ -Ç ¬¬ F Ò Ó Ô G H I ã ä Ý Ð p *´ -¹ å M, ¹ é ,+¹ ï N-° F ß
|
à á â G * H I ò
|
ó ô õ ö W Ý Ð e *´ -¹ å M, ¹ é ,+¹ ÷ W± F ç
|
è é ê G H I
|
ó ô û ü
|
