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
_Initializer.class
initial commit
ClementColmerauer
commited
446efab
at 2024-10-20 08:22:05
_Initializer.class
Blame
History
Raw
��� 7 � ) > ? @ A ; B C D E F G H I J K L M N O P C Q R C S C T U V W C X Y Z [ \ ] ^ _ ` a b c d " e f % > % g h i <init> ()V Code LineNumberTable LocalVariableTable this Lcom/uca/dao/_Initializer; Init statement Ljava/sql/PreparedStatement; e Ljava/lang/Exception; connection Ljava/sql/Connection; schedul Lcom/uca/util/Scheduler; StackMapTable j SourceFile _Initializer.java * + k l m �CREATE TABLE IF NOT EXISTS users (login int primary key auto_increment, pseudo varchar(100), email varchar(100), salt varchar(50), hashpswd varchar(100), avatarURL varchar(100), last_date_co date, lvlup int); n o p q r8CREATE TABLE IF NOT EXISTS OWN (ID INT PRIMARY KEY AUTO_INCREMENT, IDOWNER INT, IDPKM INT, GENDER VARCHAR(20), SHINY Boolean, LVL INT, BASEOWNER INT, GETTING_DATE DATE, CONSTRAINT FK_IDOWNER FOREIGN KEY (IDOWNER) REFERENCES USERS(LOGIN), CONSTRAINT FK_BASEOWNER FOREIGN KEY (BASEOWNER) REFERENCES USERS(LOGIN)); �CREATE TABLE IF NOT EXISTS exchange (ID INT PRIMARY KEY AUTO_INCREMENT, IDPKM1 INT, IDPKM2 INT, IDDATA_PKM2 INT, SHINY Boolean, LVL INT, iduser1 int, iduser2 int,CONSTRAINT FK_USER1 FOREIGN KEY (iduser1) REFERENCES users(login)); foo pswd1 foomail s t u toto totomail titi titimail jINSERT INTO own(idowner, idpkm, gender, shiny, lvl, baseowner, getting_date) VALUES(?, ? , ?, ?, ?, ?, ?); v w female x y z { 2022-11-11 | } ~ � male 2022-11-10 genderless 2022-09-08 2023-01-01 3INSERT INTO exchange(idpkm1, iduser1) VALUES(?, ?); PINSERT INTO exchange(idpkm1, iduser1, IDDATA_PKM2, iduser2) VALUES(?, ?, ? , ?); <INSERT INTO exchange(idpkm1, iduser1, shiny) VALUES(?, ?,?); java/lang/Exception � + java/lang/RuntimeException could not create database ! * � com/uca/util/Scheduler � + com/uca/dao/_Initializer java/lang/Object java/sql/Connection com/uca/dao/_Connector getInstance ()Ljava/sql/Connection; prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; java/sql/PreparedStatement executeUpdate ()I com/uca/core/UserCore createUser S(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Lcom/uca/entity/UserEntity; setInt (II)V setString (ILjava/lang/String;)V setBoolean (IZ)V java/sql/Date valueOf #(Ljava/lang/String;)Ljava/sql/Date; setDate (ILjava/sql/Date;)V printStackTrace (Ljava/lang/String;)V start ! ( ) * + , / *� � - . / 0 1 + , � Ѹ K*� L+� W*� L+� W*� L+� W � W � W � W*� L+� +�� +� +� +� +� +� � +� W*� L+� +� +� +� + � +� +� � +� W*� L+� +Ϲ +� +� + � +� +� � +� W*� L+� +� +� +� + � +� +� � +� W*� L+� +� +� +� +U� +� +� � +� W*� L+� +� +� +� + � +� + � � +� W* � L+� +� +� W* � L+� +� +� +� +� W* � L+� +� +� +� W� L+� !� "Y#� $�� %Y� &L+� '� �� - Z V $ - 4 > H R [ c ! m " v # ~ $ � % � & � ' � ) � * � + � , � - � . � / � 0 � 1 � 3 � 4 5 6 7! 8* 93 :@ ;G =P >X ?b @k As B| C� D� E� G� H� I� J� K� L� M� N� O� Q� R� S T U V W& X3 Y: [C \K ]S ^Z `c ak bs c{ d� e� g� h� i� j� k� p� m� n� o� s� t� u . * � 2 3 � 4 5 � 6 7 � 8 9 : �� ; < =
