Êþº¾ 4 Ä
|
0 a / b
|
c d e f g h i j i k l m n o n p
|
q
|
/ r f s t f u v w v x
|
y z f { | } | ~
| k f i } |
|
( a
|
(
|
(
|
(
|
hibernateSessionFactory .Lcom/yeshi/buwan/util/HibernateSessionFactory; RuntimeVisibleAnnotations Ljavax/annotation/Resource; <init> ()V Code LineNumberTable LocalVariableTable this $Lcom/yeshi/buwan/util/JuheVideoUtil; clearDeadData vi "Lcom/yeshi/buwan/domain/VideoInfo; list Ljava/util/List; e Ljava/lang/Exception; session Lorg/hibernate/Session; LocalVariableTypeTable 4Ljava/util/List<Lcom/yeshi/buwan/domain/VideoInfo;>; StackMapTable t clearData ,(Lorg/hibernate/Session;Ljava/lang/String;)V scr >Lcom/yeshi/buwan/domain/recommend/SuperCategoryRecommendVideo; vid Ljava/lang/String; scrList PLjava/util/List<Lcom/yeshi/buwan/domain/recommend/SuperCategoryRecommendVideo;>; isNeedDelete 7(Lcom/yeshi/buwan/domain/VideoInfo;Ljava/lang/String;)Z detailSystem isNeedAdd ,(Lorg/hibernate/Session;Ljava/lang/String;)Z name obj Ljava/lang/Object;
|
SourceFile JuheVideoUtil.java 5 6 1 2 ¸SELECT v.* FROM wk_video_video v LEFT JOIN wk_video_iqiyi q ON q.`videoid`=v.`id` LEFT JOIN wk_video_sohu sh ON sh.`videoid`=v.`id` WHERE (q.`videoid` IS NULL AND sh.`videoid` IS NULL) com/yeshi/buwan/domain/VideoInfo ¡ ? ¢ £ ¤ ¥ ¦ § ¨ © ª N O « ¬ java/lang/Exception ® ¯ ° ¦ ± 6 ² 6 1delete from CategoryVideo cv where cv.video.id=? ³ ´ µ ¶ · ¸ ¹ 1delete from ResourceVideo cv where cv.video.id=? .delete from VideoIqiyi cv where cv.video.id=? -delete from VideoSoHu cv where cv.video.id=? .delete from VideoYouKu cv where cv.video.id=? -delete from VideoPPTV cv where cv.video.id=? 'delete from VideoInfo cv where cv.id=? Sfrom SuperCategoryRecommendVideo cv where cv.categoryRecommendVideo.videoInfo.id=? <com/yeshi/buwan/domain/recommend/SuperCategoryRecommendVideo º » Cdelete from CategoryRecommendCacheVideo cv where cv.videoInfo.id=? >delete from CategoryRecommendVideo cv where cv.videoInfo.id=? 1delete from Attention cv where cv.videoInfo.id=? >SELECT count(*) FROM wk_juhe_filter_key WHERE LOCATE( `key`,?) ¼ ¨ java/lang/StringBuilder ½ ¾ ½ ¿ À ª Á Â Ã "com/yeshi/buwan/util/JuheVideoUtil java/lang/Object org/hibernate/Session java/util/List java/util/Iterator java/lang/Throwable ,com/yeshi/buwan/util/HibernateSessionFactory
|
getSession ()Lorg/hibernate/Session; createSQLQuery ,(Ljava/lang/String;)Lorg/hibernate/SQLQuery; org/hibernate/SQLQuery addEntity +(Ljava/lang/Class;)Lorg/hibernate/SQLQuery; ()Ljava/util/List; iterator ()Ljava/util/Iterator; hasNext ()Z next ()Ljava/lang/Object; getId ()Ljava/lang/String; close ()Ljava/sql/Connection; getTransaction ()Lorg/hibernate/Transaction; org/hibernate/Transaction isActive rollback printStackTrace createQuery )(Ljava/lang/String;)Lorg/hibernate/Query; org/hibernate/Query setParameter *(ILjava/lang/Object;)Lorg/hibernate/Query; executeUpdate ()I delete (Ljava/lang/Object;)V uniqueResult append -(Ljava/lang/Object;)Ljava/lang/StringBuilder; -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString java/lang/Integer parseInt (Ljava/lang/String;)I ! / 0 1 2 3 4 5 6 7 / *· ± 8 9 : ; < 6 7 ~ *´ W¸ L+¹ ¹ ¹ M,¹ N-¹
|
-¹ À :+¶ ¸ §ÿã+¹ W§ 7M+¹ ¹ +¹ ¹ ,¶ +¹ W§ :+¹ W¿± E O E w O m w w y w 8 J 9 B E 2 L 3 O - P . ^ / i 0 m 2 t 3 w 2 3 5 9 4 9 = > ' ? @ P A B : ; { C D E ' ? F G , þ % H I Jù I Kü Kÿ L H M N O 7 À *¹ +¹ ¹ W*¹ +¹ ¹ W*¹ +¹ ¹ W*¹ +¹ ¹ W*¹ +¹ ¹ W* ¹ +¹ ¹ W* ¹ +¹ ¹ W* ¹ +¹ ¹ M,¹ N-¹
|
-¹ À :*¹ ! §ÿä*"¹ +¹ ¹ W*#¹ +¹ ¹ W*$¹ +¹ ¹ W± 8 J : < * > ? @ T B i D ~ F H I J ¨ K à L Î N Ý O ã Q ò R ø T U 9 * à P Q C D R S ¨ f T @ E ¨ f T U G ý ¯ I Jú V W 7 6 ¬ 8 \ 9 = > X S Y Z 7 2*%¹ +¹ & ¹ ' M» (Y· ),¶ *+¶ ,¶ -¸ . ¬¬ 8 ` a b c . d 0 f 9 2 C D 2 [ S \ ] G ü 0 ^ _ `
|
