Projet 1 - Dans les préférences eclipse -> instaled JRE : ajouter la JDK et la choisir par défaut. 2 - Faire un maven install
Bdd 1 - ouvrir hsql.jar, créer une base de donnée :
http://rpouiller.developpez.com/tutoriels/spring/application-web-spring-hibernate/images/III_A_2.png
CREATE TABLE USERT ( USERID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY, NAME VARCHAR(50) NOT NULL, SURNAME VARCHAR(50) NOT NULL, AGE INTEGER NOT NULL ); INSERT INTO USERT("NAME","SURNAME","AGE") VALUES('Richard','Darbois',59);
CREATE TABLE MOBILE ( USERID INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1) PRIMARY KEY, BRAND VARCHAR(50) NOT NULL, YEAR INTEGER NOT NULL, DESCRIPTION VARCHAR(100) NOT NULL, PRICE FLOAT NOT NULL, MODEL VARCHAR(50) NOT NULL, );
INSERT INTO MOBILE("BRAND","YEAR","DESCRIPTION","PRICE","MODEL") VALUES('Nokia',1994,'lol',10.4,'3310');