Portfolio Code | Clement Colmerauer
Repositories
Site
Web server Pokemon
Code
Commits
Branches
Tags
Search
Tree:
446efab
Branches
Tags
master
Web server Pokemon
build
classes
java
main
com
uca
dao
UserDAO.class
initial commit
ClementColmerauer
commited
446efab
at 2024-10-20 08:22:05
UserDAO.class
Blame
History
Raw
��� 76 S � � � R � � � � n � o � � � � o � � � o � � � � � � � o � � 3 � � � � � � � � � n � R � � � � � � R � � � � n � � � � � � � � / � / � � / � � � � � 3 � n � n � � � 9 � � � 9 � � 9 � � 9 � R � R � � � � � � � � � � � � � � � R � R � � � <init> ()V Code LineNumberTable LocalVariableTable this Lcom/uca/dao/UserDAO; getAllUsers ()Ljava/util/ArrayList; utilDate Ljava/util/Date; entity Lcom/uca/entity/UserEntity; sqlDate Ljava/sql/Date; preparedStatement Ljava/sql/PreparedStatement; resultSet Ljava/sql/ResultSet; e Ljava/sql/SQLException; entities Ljava/util/ArrayList; LocalVariableTypeTable 2Ljava/util/ArrayList<Lcom/uca/entity/UserEntity;>; StackMapTable � � Signature 4()Ljava/util/ArrayList<Lcom/uca/entity/UserEntity;>; getUserById (I)Lcom/uca/entity/UserEntity; id I getUserIdByMail '(Ljava/lang/String;)Ljava/lang/Integer; mail Ljava/lang/String; pswdCheck 9(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Boolean; hashedPassword pswd exist Ljava/lang/Boolean; � firstCo (I)Ljava/lang/Boolean; lastCoDate lastCoCal Ljava/util/Calendar; actualDateCal date result userEmailExist '(Ljava/lang/String;)Ljava/lang/Boolean; � getUserInfo #(I)Lcom/uca/entity/UserInfosEntity; userInfo Lcom/uca/entity/UserInfosEntity; login '(Ljava/lang/String;Ljava/lang/String;)I email bool lvlup possible userSearch )(Ljava/lang/String;)Ljava/util/ArrayList; search F(Ljava/lang/String;)Ljava/util/ArrayList<Lcom/uca/entity/UserEntity;>; userExist updateLvlUp create 8(Lcom/uca/entity/UserEntity;)Lcom/uca/entity/UserEntity; salt user delete (Lcom/uca/entity/UserEntity;)V obj (Ljava/lang/Object;)V &(Ljava/lang/Object;)Ljava/lang/Object; 3Lcom/uca/dao/_Generic<Lcom/uca/entity/UserEntity;>; SourceFile UserDAO.java T U java/util/ArrayList � � 'SELECT * FROM users ORDER BY login ASC; � � � � � � com/uca/entity/UserEntity pseudo hashpswd last_date_co java/util/Date T java/sql/SQLException U &SELECT * FROM users WHERE login = (?); � � *SELECT login FROM users WHERE email = (?); v w 3SELECT salt,hashpswd FROM users WHERE login = (?) ; !" # $ %& ' java/util/Calendar () 6UPDATE USERS SET LAST_DATE_CO = (?) WHERE LOGIN = (?); java/sql/Date *+ , %SELECT * FROM users WHERE email = ? ; com/uca/entity/UserInfosEntity 5SELECT count(*) as count FROM own WHERE idowner = ? ; count - BSELECT count(distinct idpkm) as count FROM own WHERE idowner = ? ; . ESELECT count(*) as count FROM own WHERE idowner = ? AND shiny = true; / z { � � +SELECT lvlup FROM users WHERE login = (?) ; /UPDATE USERS SET lvlup = (?) WHERE LOGIN = (?); ISELECT * FROM users WHERE pseudo = (?) OR login = (?) ORDER BY login ASC; 0 %SELECT * FROM users WHERE login = ? ; UPDATE USERS SET lvlup = 5; ZINSERT INTO users(pseudo, email, salt, hashpswd, last_date_co, lvlup) VALUES(?,?,?,?,?,?); 12 32 42 52 � � � � com/uca/dao/UserDAO com/uca/dao/_Generic java/sql/PreparedStatement java/sql/ResultSet java/lang/Boolean java/lang/String connect Ljava/sql/Connection; java/sql/Connection prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; executeQuery ()Ljava/sql/ResultSet; next ()Z getInt (Ljava/lang/String;)I setLogin (I)V getString &(Ljava/lang/String;)Ljava/lang/String; setPseudo (Ljava/lang/String;)V setEmail setHashpswd getDate #(Ljava/lang/String;)Ljava/sql/Date; getTime ()J (J)V setLastCoDate (Ljava/util/Date;)V add (Ljava/lang/Object;)Z printStackTrace valueOf (I)Ljava/lang/String; setString (ILjava/lang/String;)V booleanValue java/lang/Integer (I)Ljava/lang/Integer; intValue ()I setInt (II)V org/mindrot/jbcrypt/BCrypt hashpw 8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; equals (Z)Ljava/lang/Boolean; getInstance ()Ljava/util/Calendar; setTime get (I)I setDate (ILjava/sql/Date;)V executeUpdate setPkm setDistinctPkm setShiny parseInt getPseudo ()Ljava/lang/String; getEmail gensalt getHashpswd ! R S T U V / *� � W X Y Z [ \ V � �� Y� L*� � M,� N-� � n� Y� :- � � -� � -� � -� � -� :� � Y� � :� +� W���� M,� +� � � W N $ - : G T a k p ~ � " � # � & � $ � % � ( X R ~ ] ^ - _ _ ` k ! a b { c d t e f � g h � Y Z � i j k � i l m ) � n o� i 3� R B p q r s V q �� Y� M*� � N-� � -� :� � ^, � � ,� � ,� � ,� � � :� � Y� � :,� ���� N-� ,� � � W J . 0 1 2 ' 3 1 4 > 5 K 6 X 7 e 8 p 9 u ; � < � ? � B � @ � A � C X R � ] ^ p a b x c d ' e e f � g h � Y Z � t u � _ ` m � ' n o� a� B v w V � G*+� !� "� �*� #� M,+� ,� N-� � - � � $�� M,� � < @ W . I K N O ! P ( Q 1 S = W @ U A V E X X 4 $ c d ( e f A g h G Y Z G x y m /B z { V & d*,� %� &>:*� '� : � ( � :� � %+)� � *:� � +� ,:� :� � W Z W 2 ^ _ b c " d + e 5 h D i W m Z k \ l a n X \ D | y > c d + , e f \ g h d Y Z d } y d x y [ t u X ~ m � W �B � � V � �M*� � N-� � -� :� � �� :� � Y � � � Y� � :� -:� .� -:� 0� 0� � ,M� � ,M*� 1� N� Y� 2: -� 3Y � 4� 5� 6 -� ( -� 7 W� N-� ,� � � W Z t v w x ! y + { 6 | T ~ Y ` � e � v � ~ � � � � � � � � � � � � � � � � � � � X p 6 � a b T f � ^ Y a � � e U � � � " � ^ � c d ! � e f � g h � Y Z � t u � � m = � F R � n o 3 K � + / /� 6 R � B � � V � 3M*� 8� N-+� -� :� � ,M� N-� ,� ) , W & � � � � � ) � , � - � 1 � X > c d e f - g h 3 Y Z 3 x y 1 ~ m � , R � � � � V x �� 9Y� :M*� ;� N-� ( -� :� � ,<� � =*� >� N-� ( -� :� � ,<� � ?*� @� N-� ( -� :� � ,<� � A� N-� ,� � � W R � � � � $ � . � ; � G � O � W � a � n � z � � � � � � � � � � � � � � � X > � c d $ } e f � g h � Y Z � t u � � � m � ; 9 n o2� 2B � � V � P*,� !� "� �>*+,� B:� "� >� � "� >� > � **,� %� &� C� "� �� � W : � � � � � � $ � , � 1 � 3 � 8 � J � L � N � X 4 P Y Z P } y P � y A � u 9 � m � � � � V 5 {M*� D� N-� ( -� :� � LE� � � � ,M,� "� 0*� F� N-E� d� ( -� ( -� 7 W� N-� ,� q t W > � � � � � ( � = � D � P � b � j � q � t � u � y � X > c c d S e f u g h { Y Z { t u y � m � 8 � n o@� 7B � � V � �� Y� M*� G� N-+� -+� H� ( -� :� � s� Y� : � � � � � � � � � :� � Y� � :� ,� W���� N-� ,� � � W V � � � � ' / 9 B P ^ l z � � � � � � � � � X \ � ] ^ B d _ ` � ! a b � c d / z e f � g h � Y Z � � y � i j k � i l m , � / n o� o 3� R � B p � � � V � 3M*� I� N-� ( -� :� � ,M� N-� ,� ) , W & )# ,! -" 1$ X > c d e f - g h 3 Y Z 3 t u 1 ~ m � , R � � U V � *� J� L+� 7 W� L+� � W + , 0 . / 1 X c d g h Y Z m V � � V h*� K� M,+� L� ,+� M� � NN,-� +� O-� *:+� ,� ,� 6 ,� ( ,� 7 W+�M,� � ` a W > 7 8 9 ": &; .< 8= >> G? O@ XA _B aC bD fF X > U c d & ; � y 8 ) | y b g h h Y Z h � ` m � a � � V 5 � W M X Y Z � ` A � � V 3 *+� � P� W X Y Z A � � V 3 *+� � Q� W X Y Z p � � �
