Êþº¾ 4 )com/fgkj/dao/impl/BattMap_informationImpl java/lang/Object com/fgkj/dao/BaseDAO com/fgkj/dao/CallBack <init> ()V Code
|
|
LineNumberTable LocalVariableTable this +Lcom/fgkj/dao/impl/BattMap_informationImpl;
|
getResults &(Ljava/sql/ResultSet;)Ljava/util/List; java/util/ArrayList
|
com/fgkj/dto/BattMap_information
|
num java/sql/ResultSet ! getInt (Ljava/lang/String;)I
|
# % $ java/lang/Integer & ' valueOf (I)Ljava/lang/Integer;
|
) * + setNum (Ljava/lang/Integer;)V - stationId / 0 1 getString &(Ljava/lang/String;)Ljava/lang/String;
|
3 4 5 setStationId (Ljava/lang/String;)V 7 stationName
|
9 : 5 setStationName < address
|
> ? 5
|
setAddress A longitude C D E getDouble (Ljava/lang/String;)D
|
G I H java/lang/Double & J (D)Ljava/lang/Double;
|
L M N setLongitude (Ljava/lang/Double;)V P latitude
|
R S N setLatitude U information
|
W X 5 setInformation Z \ [ java/util/List ] ^ add (Ljava/lang/Object;)Z ` a b next ()Z
|
d f e java/sql/SQLException g
|
printStackTrace rs Ljava/sql/ResultSet; list Ljava/util/List; binformation "Lcom/fgkj/dto/BattMap_information; e Ljava/sql/SQLException; StackMapTable r oinsert into web_site.tb_battmap_information(StationId,StationName,address,longitude,latitude) values(?,?,?,?,?)
|
t v u com/fgkj/db/DBUtil w x getConn ()Ljava/sql/Connection;
|
z { | getStationId ()Ljava/lang/String;
|
~ | getStationName
|
|
|
getAddress
|
getLongitude ()Ljava/lang/Double;
|
getLatitude
|
com/fgkj/dao/DAOHelper executeUpdate =(Ljava/sql/Connection;Ljava/lang/String;[Ljava/lang/Object;)Z
|
java/lang/Boolean & (Z)Ljava/lang/Boolean;
|
b booleanValue obj Ljava/lang/Object; sql Ljava/lang/String; bl Ljava/lang/Boolean; replace preplace into web_site.tb_battmap_information(StationId,StationName,address,longitude,latitude) values(?,?,?,?,?) update £ update web_site.tb_battmap_information set StationId=?,StationName=?,address=?,longitude=?,latitude=?,information=? where num=?
|
¥ ¦ | getInformation
|
¨ © ª getNum ()Ljava/lang/Integer; del 7delete from web_site.tb_battmap_information where num=? searchAll ()Ljava/util/List; ± mselect num,StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information
|
|
´ µ ¶ executeQuery c(Ljava/lang/String;Ljava/sql/Connection;[Ljava/lang/Object;Lcom/fgkj/dao/CallBack;)Ljava/util/List; serchNotInBattMap ¹ Ðselect distinct tb_battinf.stationid,tb_battinf.stationname from db_battinf.tb_battinf where tb_battinf.stationid not in(select web_site.tb_battmap_information.stationid from web_site.tb_battmap_information ) » +com/fgkj/dao/impl/BattMap_informationImpl$1
|
º ½ ¾ .(Lcom/fgkj/dao/impl/BattMap_informationImpl;)V serchNotInBattMapByUid $(Ljava/lang/Object;)Ljava/util/List; Â com/fgkj/dto/User_inf Äéselect distinct db_battinf.tb_battinf.stationname,db_battinf.tb_battinf.stationid,db_battinf.tb_battinf.fBSDeviceId from db_battinf.tb_battinf left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid where db_user.tb_user_inf.uid=? and db_battinf.tb_battinf.stationid not in(select web_site.tb_battmap_information.stationid from web_site.tb_battmap_information )
|
Á Æ Ç ª getUId É +com/fgkj/dao/impl/BattMap_informationImpl$2
|
È ½ uinf Lcom/fgkj/dto/User_inf; serchInBattMapByUid Ï·select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.monvolstd from web_site.tb_battmap_information,db_battinf.tb_battinf where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId and tb_battmap_information.StationId in ( select distinct db_battinf.tb_battinf.stationid from db_battinf.tb_battinf left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid where db_user.tb_user_inf.uid=? ) Ñ +com/fgkj/dao/impl/BattMap_informationImpl$3
|
Ð ½ serchInBattMapByUid2 Õ com/fgkj/dto/Page
|
Ô × Ø ª
|
getPageAll
|
# Ú Û Ü intValue ()I Þ SELECT FOUND_ROWS() number àNselect SQL_CALC_FOUND_ROWS distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,db_battinf.tb_battinf.station_install,db_battinf.tb_battinf.monvolstd from web_site.tb_battmap_information,db_battinf.tb_battinf where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId and tb_battmap_information.StationId in ( select distinct db_battinf.tb_battinf.stationid from db_battinf.tb_battinf left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid where db_user.tb_user_inf.uid=? and tb_battinf.station_install=true) order by tb_battmap_information.StationId limit ?,?
|
Ô â ã ª getPageCurr
|
Ô å æ ª getPageSize è +com/fgkj/dao/impl/BattMap_informationImpl$4
|
ç ½
|
ë ì ¶ executeQueryLimit
|
î ð ï com/fgkj/dao/LimitNumberFactory ñ ò GetLimtitNumber *(Ljava/sql/Connection;Ljava/lang/String;)I Z ô õ Ü size Z ÷ ø ù get (I)Ljava/lang/Object;
|
û ü ý getPage ()Lcom/fgkj/dto/Page;
|
Ô ÿ +
|
setPageAll page Lcom/fgkj/dto/Page; uid I conn Ljava/sql/Connection; numberSql number LocalVariableTypeTable 4Ljava/util/List<Lcom/fgkj/dto/BattMap_information;>; java/sql/Connection java/lang/String serchInBattMapByUid3 select distinct tb_battmap_information.num,tb_battmap_information.StationId,tb_battmap_information.StationName,address,longitude,latitude,information,db_battinf.tb_battinf.FBSDeviceId,tb_battinf.stationName1,tb_battinf.stationName2,tb_battinf.stationName3,tb_battinf.stationName5 from web_site.tb_battmap_information,db_battinf.tb_battinf where tb_battmap_information.StationId=db_battinf.tb_battinf.StationId and tb_battmap_information.StationId in ( select distinct db_battinf.tb_battinf.stationid from db_battinf.tb_battinf left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid where db_user.tb_user_inf.uid=? ) and tb_battmap_information.StationId=? +com/fgkj/dao/impl/BattMap_informationImpl$5
|
½ binfor serchStationName1 SELECT DISTINCT substring_index(substring_index(address,'-',2),'-',1) as stationname1 FROM web_site.tb_BattMap_information +com/fgkj/dao/impl/BattMap_informationImpl$6
|
½ serchStationName2 SELECT DISTINCT substring_index(substring_index(address,'-',2),'-',-1) as stationname2 FROM web_site.tb_BattMap_information where address like ? java/lang/StringBuilder" %
|
$ 5
|
& '( append -(Ljava/lang/String;)Ljava/lang/StringBuilder;
|
* + | toString- +com/fgkj/dao/impl/BattMap_informationImpl$7
|
, ½ serchStationName1 o SELECT DISTINCT StationName,longitude,latitude FROM web_site.tb_BattMap_information WHERE address like ? 3 +com/fgkj/dao/impl/BattMap_informationImpl$8
|
2 ½ serchByInfo7 select num, StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information where StationId=? serchTudeByStationName: select num, StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information where StationName like ? main ([Ljava/lang/String;)V> com/fgkj/dto/Batt_Maint_Dealarm
|
= A com/fgkj/dto/Battalarm_data
|
@
|
@D E + setAlm_cleared_type
|
@G H + setAlm_idJ com/fgkj/dto/BattDischarge_plan
|
I
|
IM N + setDischarge_reason
|
=P QR setAdata (Lcom/fgkj/dto/Battalarm_data;)V
|
=T UV setBinformation %(Lcom/fgkj/dto/BattMap_information;)V
|
=X YZ setBplan $(Lcom/fgkj/dto/BattDischarge_plan;)V
|
\ ] À serchByCondition Z_ `a iterator ()Ljava/util/Iterator; ced java/util/Iterator af ()Ljava/lang/Object; hji java/lang/System kl out Ljava/io/PrintStream;
|
npo java/io/PrintStream qr println (Ljava/lang/Object;)V ct u b hasNext
|
nw qx (I)V args [Ljava/lang/String; bimpl bmd !Lcom/fgkj/dto/Batt_Maint_Dealarm; adata Lcom/fgkj/dto/Battalarm_data; bplan !Lcom/fgkj/dto/BattDischarge_plan; b 3Ljava/util/List<Lcom/fgkj/dto/Batt_Maint_Dealarm;>;z select num,StationId,StationName,address,longitude,latitude,information from web_site.tb_battmap_information where address like ?
|
SourceFile BattMap_informationImpl.java InnerClasses !
|
/ *· ± 3 » Y· M§ p» Y· N-+¹ ¸ "¶ (-+,¹ . ¶ 2-+6¹ . ¶ 8-+;¹ . ¶ =-+@¹ B ¸ F¶ K-+O¹ B ¸ F¶ Q-+T¹ . ¶ V,-¹ Y W+¹ _ ÿ§ N-¶ c,° d > " . ! : " F # U $ d % p & x (
* , 4 h i j k e l m
n o p ü Zû lK d ] ^ § A+À MqN¸ s-½ Y,¶ ySY,¶ }SY,¶ SY,¶ SY,¶ S¸ ¸ :¶ ¬ 0 1 2 3 3 2 ; 4 4 A A < l m 9 ; ^ § A+À MN¸ s-½ Y,¶ ySY,¶ }SY,¶ SY,¶ SY,¶ S¸ ¸ :¶ ¬ 8 9 : ; 3 : ; < 4 A A < l m 9 ; ¡ ^ · Q+À M¢N¸ s-½ Y,¶ ySY,¶ }SY,¶ SY,¶ SY,¶ SY,¶ ¤SY,¶ §S¸ ¸ :¶ ¬ ? @ A ! B C A K C 4 Q Q L l m I K « ^ %+À M¬N¸ s-½ Y,¶ §S¸ ¸ :¶ ¬ G I J K 4 % % l m ® ¯ [ °L+¸ s» Y· ²¸ ³M,° P Q R j k · ¯ \ ¸L+¸ s» ºY*· ¼¸ ³M,° W Y k j k ¿ À
'+À ÁMÃN-¸ s½ Y,¶ ÅS» ÈY*· ʸ ³:° o p w $ 4 ' ' " Ë Ì $ j k Í À
'+À ÁMÎN-¸ s½ Y,¶ ÅS» ÐY*· Ò¸ ³:° $ ² 4 ' ' " Ë Ì $ j k Ó À c +À ÔM,¶ Ö¶ Ù>¸ s:Ý:ß:½ Y ¸ "SY,¶ ᶠÙd,¶ ä¶ Ùh¸ "SY,¶ äS» çY*· é¸ ê:¸ í6Æ +¹ ó !¹ ó d¹ ö À ¶ ú¸ "¶ þ° *
|
¶ · ¸ ¹ º Æ T ã ] å l æ è \ { w s T 9 j k ] 0 T 9 j
|
p ÿ Ô Z À /+À MN-¸ s½ Y,¶ §SY,¶ yS»Y*·¸ ³:° ì í ø , 4 / / * m & , j k ¯ ] L+¸ s»Y*·¸ ³M,° * j k À >+À M N-¸ s½ Y» Y!·#,¶ ¶%!¶%¶)S»,Y*·.¸ ³:° . / 2 ;B 4 > > 9 l m 5 ; j k / À >+À M0N-¸ s½ Y» Y!·#,¶ ¶%!¶%¶)S»2Y*·4¸ ³:° G H K ;^ 4 > > 9 l m 5 ; j k 5 À
'+À M6N-¸ s½ Y,¶ yS» Y· ²¸ ³:° b c e $f 4 ' ' " l m $ j k 8 À
'+À M9N-¸ s½ Y,¶ }S» Y· ²¸ ³:° j k m $n 4 ' ' " l m $ j k ;< ~ » Y· ²L»=Y·?M»@Y·BN-¸ "¶C-¸ "¶F» Y· :»IY·K:¸ "¶L,-¶O,¶S,¶W+,¶[:¹^ :§ ¹b À=:²g¶m¹s ÿå²g¹ ó ¶v± F q r s t u (v 1w :x Cy Hz N{ T} [~ s {~
R yz { |} {~ 1 b l m : Y [ 8 j k s } [ 8 j p # ÿ g =@ I Z c ] À =+À M
N-¸ s½ Y» Y!·#,¶ ¶%!¶%¶)S» Y· ²¸ ³:°
: 4 = = 8 l m 4 : j k B º È Ð ç , 2
|
