Friday, December 29, 2017

SPRING BOOT - a run-through explaination

Based off of lynda tutorials:
create a project with all selection: jpa, web, thymeleaf, actuator.. and export the created project into eclipse. Now look into pom.xml to see all the dependencies added based on selected during project selection.

The only class created in the src>>main package, called as ??Application, is the heart of the application:

@SpringBootApplication : This annotation on the class definition of the ????Application class. It does all of our autoconfiguration and all of the Component Scanning, It also sets up things for rapid development.

Since, we have chosen 'maven' project at project creation using Spring Initializr(start.spring.io), the libraries required are all taken care off. Hence the project is now ready to run.

>>rt click on the ???Application java file and run as 'Spring Boot Application'(This feature is available as a result of installing ' Spring IDE Core' plugin in eclipse).

To check if the application has run fine.. look for the console on eclipse, (last second line as seen below),
  [2m: [0;39m Tomcat started on port(s): 8080 (http)

that mentions that tomcat has started successfully. To test this, open, localhost:8080(as mentioned in console) in a browser. A page with, "Whitelabel Error Page" pops up. This is since we do not have any webpages configured on server start. Hence, we need to create one, in the location, src>>main>>resources>>static>>index.html.
Now restart server,
and access, http://localhost:8080 again, This will bring up the new index.html page that you just created.

application.properties(src>>main>>resources>>static) : This file can be used to alter any server details, such as changing the port from 8080 to 8000.

We could type in ,
server.port=8000,and restart the server... and now we will see that the server is running in port 8000 overriding the default, which was 8080. hence, we can now access the webpage using "localhost:8000"

Furthermore, notice the mappings defined for various URLs in the console after the server starts(refer screenshot of mappings,from console, below),



These mappings are generated and configured by the actuator plugin. Hence, we had no configurations that needed to be done to access the index.html file on server start-up.


Embedded Databases and configuration:We need to create few files to configure database to the project,

1)DDL(data definition language). create a DDL file named , schema.sql in the static folder, which holds the tables creation queries as in example  below:

 CREATE TABLE ROOM(
  ROOM_ID BIGINT AUTO_INCREMENT PRIMARY KEY,
  NAME VARCHAR(16) NOT NULL,
  ROOM_NUMBER CHAR(2) NOT NULL UNIQUE,
  BED_INFO CHAR(2) NOT NULL
);

 CREATE TABLE GUEST(
  GUEST_ID BIGINT AUTO_INCREMENT PRIMARY KEY,
  FIRST_NAME VARCHAR(64),
  LAST_NAME VARCHAR(64),
  EMAIL_ADDRESS VARCHAR(64),
  ADDRESS VARCHAR(64),
  COUNTRY VARCHAR(32),
  STATE VARCHAR(12),
  PHONE_NUMBER VARCHAR(24)
);

 CREATE TABLE RESERVATION(
  RESERVATION_ID BIGINT AUTO_INCREMENT PRIMARY KEY,
  ROOM_ID BIGINT NOT NULL,
  GUEST_ID BIGINT NOT NULL,
  RES_DATE DATE
);

 ALTER TABLE RESERVATION ADD FOREIGN KEY (ROOM_ID) REFERENCES ROOM(ROOM_ID);
ALTER TABLE RESERVATION ADD FOREIGN KEY (GUEST_ID) REFERENCES GUEST(GUEST_ID);
CREATE INDEX IDX_RES_DATE_ ON RESERVATION(RES_DATE);


2)DML(Data Manipulation Language): create a DMLfile named , data.sql in the static folder, which holds the data manipulation queries such as insert/delet, etc, as in example  below:


 INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P1', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P2', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P3', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P4', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P5', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Piccadilly', 'P6', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Cambridge', 'C1', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Cambridge', 'C2', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Cambridge', 'C3', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W1', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W2', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W3', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W4', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W5', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W6', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Westminster', 'W7', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Oxford', 'O1', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Oxford', 'O2', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Oxford', 'O3', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Oxford', 'O4', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Oxford', 'O5', '1Q');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Victoria', 'V1', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Victoria', 'V2', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Victoria', 'V3', '2D');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Manchester', 'M1', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Manchester', 'M2', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Manchester', 'M3', '1K');
INSERT INTO ROOM (NAME, ROOM_NUMBER, BED_INFO) VALUES ('Manchester', 'M4', '1K');

 INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Adams', 'Roy', 'radams1v@xinhuanet.com', 'United States', '2872 Marquette Street', 'NY', '1-(235)314-9823');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Adams', 'Martin', 'madams2b@msu.edu', 'China', '4 Mandrake Plaza', '', '9-(401)660-9813');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Alvarez', 'Roger', 'ralvarezk@blogs.com', 'United States', '3 Green Plaza', 'FL', '6-(980)036-6105');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Alvarez', 'Anne', 'aalvarez1y@mlb.com', 'United States', '6 Glendale Parkway', 'FL', '7-(967)349-7237');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Alvarez', 'Ann', 'aalvarez20@jalbum.net', 'Afghanistan', '851 Nelson Circle', '', '7-(418)731-2327');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Anderson', 'Betty', 'banderson14@digg.com', 'United States', '3538 Scofield Drive', 'TX', '1-(291)830-0405');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Anderson', 'Laura', 'landerson24@icio.us', 'United States', '805 Paget Court', 'NY', '3-(587)240-6409');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Armstrong', 'Christopher', 'carmstrong2p@cyberchimps.com', 'United States', '4514 Independence Point', 'TX', '3-(411)160-3757');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bell', 'David', 'dbell2l@wp.com', 'United States', '5205 Vera Junction', 'CA', '8-(035)412-4547');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Berry', 'Paula', 'pberry1z@admin.ch', 'China', '5095 International Drive', '', '6-(195)796-7745');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bishop', 'Dennis', 'dbishopo@xinhuanet.com', 'Armenia', '11442 East Circle', '', '4-(871)489-3543');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bishop', 'Carolyn', 'cbishopw@1688.com', 'Ukraine', '23273 Emmet Road', '', '5-(795)729-5690');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Black', 'Harold', 'hblack2p@clickbank.net', 'Indonesia', '7715 Havey Center', '', '0-(378)142-3343');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bowman', 'Jerry', 'jbowman1j@fotki.com', 'Indonesia', '49381 Northridge Point', '', '9-(389)678-8585');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bradley', 'Keith', 'kbradley1c@techcrunch.com', 'United States', '21 Sauthoff Point', 'OH', '5-(780)609-5353');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Brooks', 'Samuel', 'sbrooks4@google.co.uk', 'United States', '9857 Hollow Ridge Park', 'PA', '5-(517)250-0437');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Bryant', 'Donald', 'dbryant1@cdbaby.com', 'South Korea', '8 Crescent Oaks Circle', '', '5-(629)251-0019');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Burke', 'Tammy', 'tburke2a@theglobeandmail.com', 'Russia', '7298 Bluejay Road', '', '8-(710)063-1619');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Burns', 'Joe', 'jburns18@mail.ru', 'Russia', '2795 Lighthouse Bay Place', '', '3-(465)132-7455');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Campbell', 'Jessica', 'jcampbell2i@cpanel.net', 'United States', '7963 Ohio Alley', 'OR', '0-(150)386-2177');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Campbell', 'Christopher', 'ccampbell2i@amazon.de', 'Russia', '6 Walton Court', '', '5-(275)117-4811');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Carpenter', 'Pamela', 'pcarpenterj@china.com.cn', 'United States', '661 Karstens Road', 'HI', '6-(268)816-2465');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Carpenter', 'Paul', 'pcarpenter28@dropbox.com', 'Philippines', '33614 Cambridge Road', '', '3-(561)990-7094');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Carter', 'Tammy', 'tcarter1j@washington.edu', 'United States', '3 Leroy Crossing', 'TN', '7-(489)865-7002');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Carter', 'Paul', 'pcarter1z@cnet.com', 'United States', '3 Green Plaza', 'CA', '3-(854)158-1783');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Chapman', 'Justin', 'jchapmans@aol.com', 'United States', '2127 David Lane', 'WV', '1-(910)152-0295');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Chapman', 'Margaret', 'mchapmanb@hud.gov', 'Canada', '953 Reindahl Parkway', '', '1-(010)495-9996');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Clark', 'Bonnie', 'bclark6@bing.com', 'United States', '4 Porter Avenue', 'CO', '9-(524)812-6248');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Clark', 'Andrea', 'aclark2j@sphinn.com', 'United States', '02 Haas Park', 'MI', '1-(123)323-9494');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Coleman', 'Shirley', 'scoleman26@bizjournals.com', 'United States', '4903 Commercial Drive', 'AL', '7-(798)598-1459');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Coleman', 'Angela', 'acoleman6@gmpg.org', 'Russia', '1208 Menomonie Terrace', '', '9-(959)063-5551');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Cox', 'Harold', 'hcox23@dyndns.org', 'France', '08 Butterfield Place', 'B5', '6-(983)957-3202');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Cruz', 'Alan', 'acruzj@marketwatch.com', 'China', '023 Laurel Terrace', '', '1-(003)990-0308');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Cunningham', 'Anna', 'acunningham2@yale.edu', 'China', '1 Steensland Lane', '', '7-(769)474-5961');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Daniels', 'Robin', 'rdaniels2d@weebly.com', 'United States', '9728 Paget Court', 'AR', '7-(116)447-5902');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Daniels', 'Phillip', 'pdaniels1y@hexun.com', 'Kazakhstan', '5 Blue Bill Park Trail', '', '4-(029)713-9304');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Davis', 'Thomas', 'tdavis1h@globo.com', 'United States', '6332 Fuller Pass', 'TX', '5-(778)054-9695');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Dean', 'Joe', 'jdeanp@vinaora.com', 'United States', '8 Darwin Crossing', 'AZ', '9-(625)975-9705');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Dean', 'Sara', 'sdean1t@unc.edu', 'Mexico', '9 South Crossing', 'GUA', '7-(206)725-7117');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Dixon', 'Patricia', 'pdixon2m@biglobe.ne.jp', 'United States', '49 Moose Way', 'DC', '1-(159)384-4102');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Dixon', 'Cynthia', 'cdixon1e@vimeo.com', 'China', '52645 Dorton Pass', '', '6-(422)372-7084');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Dixon', 'Todd', 'tdixon2o@ed.gov', 'China', '82172 Lukken Alley', '', '0-(290)722-9657');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Elliott', 'David', 'delliottn@wsj.com', 'Russia', '6478 Doe Crossing Court', '', '4-(687)980-5138');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Elliott', 'Gregory', 'gelliott2f@exblog.jp', 'Indonesia', '01298 Raven Alley', '', '2-(826)961-5278');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ellis', 'James', 'jellisa@wordpress.com', 'United States', '8108 Upham Avenue', 'CA', '9-(104)768-0365');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ferguson', 'Russell', 'rferguson1b@uol.com.br', 'United States', '9143 Hudson Terrace', 'OH', '7-(498)208-8970');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ferguson', 'Mark', 'mferguson2m@columbia.edu', 'Poland', '6 Fisk Drive', '', '7-(920)445-0162');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Fields', 'Lori', 'lfieldsq@smh.com.au', 'United States', '76485 Roth Alley', 'WA', '2-(229)182-4243');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Fisher', 'Thomas', 'tfisher26@sina.com.cn', 'Uzbekistan', '8 Haas Avenue', '', '1-(842)637-0935');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ford', 'Matthew', 'mfordi@ucoz.com', 'Syria', '63 East Place', '', '5-(508)161-9676');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Fowler', 'Clarence', 'cfowler1t@unicef.org', 'United States', '890 Nevada Road', 'CT', '5-(922)750-2234');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Fowler', 'Steve', 'sfowler2f@ed.gov', 'United States', '243 Ohio Plaza', 'AL', '8-(435)340-9290');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Fox', 'Craig', 'cfox1v@sakura.ne.jp', 'Philippines', '576 Novick Alley', '', '3-(453)987-1524');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Freeman', 'Kimberly', 'kfreemank@cmu.edu', 'Australia', '46613 Buena Vista Pass', 'NSW', '0-(289)984-9766');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Freeman', 'Johnny', 'jfreeman1g@aboutads.info', 'China', '719 Trailsway Street', '', '6-(658)139-7764');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Garza', 'Carl', 'cgarzal@friendfeed.com', 'United States', '92 Scott Court', 'DC', '2-(818)774-1651');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Garza', 'Martha', 'mgarza29@fastcompany.com', 'Philippines', '64 Farwell Circle', '', '9-(455)359-2298');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('George', 'Angela', 'ageorgew@slashdot.org', 'United States', '1 Corben Street', 'MD', '5-(864)699-8310');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('George', 'Linda', 'lgeorge27@mtv.com', 'United States', '5793 Northport Center', 'MI', '7-(899)692-4554');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Gilbert', 'Rose', 'rgilbert1c@java.com', 'Indonesia', '32441 Oriole Junction', '', '9-(771)659-3359');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Gomez', 'Jacqueline', 'jgomeze@miitbeian.gov.cn', 'France', '794 Armistice Crossing', 'A7', '9-(345)143-4371');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Gordon', 'Antonio', 'agordon28@weather.com', 'United States', '8 Maywood Parkway', 'CA', '5-(724)135-8826');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Grant', 'Raymond', 'rgrant11@amazonaws.com', 'China', '248 Scott Trail', '', '0-(001)715-0415');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Grant', 'Janet', 'jgrant2c@nbcnews.com', 'Philippines', '07 Schurz Circle', '', '3-(757)166-1573');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Gray', 'Steven', 'sgray17@over-blog.com', 'Sweden', '4 5th Street', 'AB', '8-(004)861-6730');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hamilton', 'William', 'whamilton2a@biglobe.ne.jp', 'United States', '23 Ronald Regan Drive', 'MO', '7-(178)515-6650');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hamilton', 'Ernest', 'ehamilton0@51.la', 'Poland', '3 Bay Park', '', '1-(402)667-5979');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hansen', 'Jane', 'jhansen0@xrea.com', 'United States', '8 Beilfuss Place', 'SC', '8-(468)743-8087');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hansen', 'Annie', 'ahansen7@furl.net', 'United States', '728 Fisk Plaza', 'MD', '3-(527)508-7158');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hanson', 'Carolyn', 'chanson1r@netlog.com', 'United States', '5066 Dottie Junction', 'NY', '8-(597)931-5162');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hanson', 'Christopher', 'chansonp@ftc.gov', 'Indonesia', '50 Claremont Crossing', '', '5-(759)595-6039');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Harris', 'Michael', 'mharris2g@printfriendly.com', 'United States', '43 Veith Parkway', 'CT', '2-(345)753-2214');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Harrison', 'Stephanie', 'sharrison21@devhub.com', 'Poland', '709 Pepper Wood Avenue', '', '1-(280)302-4944');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Harvey', 'Anne', 'aharvey2g@sfgate.com', 'China', '4 American Place', '', '9-(535)847-7555');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hayes', 'Barbara', 'bhayes2q@jiathis.com', 'United States', '6 Scofield Circle', 'TX', '0-(173)195-7190');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hayes', 'Nicole', 'nhayes10@qq.com', 'China', '98830 Schlimgen Park', '', '7-(755)477-0983');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hayes', 'Emily', 'ehayes1h@ox.ac.uk', 'Indonesia', '784 Susan Street', '', '8-(944)943-0482');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Henderson', 'Martin', 'mhenderson16@wsj.com', 'United States', '7306 Buhler Plaza', 'TX', '6-(058)886-9240');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hernandez', 'Billy', 'bhernandezx@sphinn.com', 'United States', '994 Kennedy Street', 'PA', '2-(728)757-6883');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hernandez', 'Heather', 'hhernandezr@hostgator.com', 'Indonesia', '74 Clove Drive', '', '5-(593)151-3362');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hicks', 'Sharon', 'shicks3@wsj.com', 'Indonesia', '0974 Calypso Junction', '', '3-(868)311-6209');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hicks', 'Lori', 'lhicks9@wordpress.org', 'China', '854 Lakewood Gardens Court', '', '9-(849)992-9828');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Howard', 'Richard', 'rhoward1i@theatlantic.com', 'United States', '6 Welch Pass', 'CA', '5-(673)015-8549');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Howell', 'Ronald', 'rhowell13@soup.io', 'Japan', '75904 Hoffman Way', '', '3-(124)276-4530');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hughes', 'Judy', 'jhughes25@4shared.com', 'United States', '03 Sullivan Circle', 'DE', '4-(702)002-3923');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Hunter', 'Amy', 'ahuntere@intel.com', 'United States', '9781 Kennedy Avenue', 'WV', '0-(992)102-4834');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Jackson', 'Kathryn', 'kjackson3@wikia.com', 'United States', '43603 Northwestern Plaza', 'MS', '9-(266)577-1031');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Jenkins', 'Steven', 'sjenkins1e@a8.net', 'United States', '7396 Canary Center', 'CA', '3-(613)563-6513');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Johnson', 'Kevin', 'kjohnson2h@unesco.org', 'Poland', '5 Haas Circle', '', '8-(553)359-6387');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Johnston', 'Christina', 'cjohnston1m@nationalgeographic.com', 'Gabon', '05059 Fordem Lane', '', '7-(543)809-5071');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Johnston', 'Ryan', 'rjohnston1s@ucla.edu', 'Russia', '4 Sunfield Avenue', '', '3-(807)624-4323');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Jordan', 'Marie', 'mjordan1n@weather.com', 'United States', '5 Moulton Avenue', 'GA', '9-(380)848-6527');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Kelley', 'Pamela', 'pkelley2c@hibu.com', 'United States', '97636 5th Pass', 'KS', '0-(546)670-0937');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Kelly', 'Evelyn', 'ekelly2h@facebook.com', 'United States', '82091 Leroy Center', 'KY', '5-(319)309-1959');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Kennedy', 'Dorothy', 'dkennedy23@unblog.fr', 'United States', '01 Park Meadow Place', 'TX', '0-(605)308-6131');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('King', 'Sean', 'skingl@geocities.jp', 'Indonesia', '6611 Spaight Street', '', '5-(463)415-7449');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('King', 'Kimberly', 'kking1r@naver.com', 'Nigeria', '7 Northfield Avenue', '', '4-(192)264-2329');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('King', 'Nicholas', 'nking2r@businessweek.com', 'Philippines', '3 Gulseth Drive', '', '4-(647)544-4105');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Knight', 'Katherine', 'kknight1p@walmart.com', 'United States', '3 Surrey Circle', 'LA', '6-(906)910-4569');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Larson', 'Martin', 'mlarson24@tripadvisor.com', 'United States', '32 Surrey Road', 'NC', '8-(568)965-0021');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Lee', 'Louis', 'lleeh@yellowbook.com', 'United States', '80 Boyd Court', 'NJ', '3-(100)131-3147');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Lewis', 'Ruby', 'rlewisv@answers.com', 'United States', '37 Saint Paul Place', 'IA', '1-(585)331-1972');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Lewis', 'Jonathan', 'jlewis4@tuttocitta.it', 'Mauritania', '1771 Cascade Place', '', '2-(107)787-5478');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Little', 'Eric', 'elittle18@cdc.gov', 'United States', '1008 6th Street', 'FL', '9-(855)524-1969');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Little', 'Kathy', 'klittlec@slideshare.net', 'China', '033 Victoria Circle', '', '9-(104)402-8499');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Martin', 'Frank', 'fmartin1a@ed.gov', 'United States', '21822 Talisman Drive', 'TX', '1-(296)887-1815');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Martin', 'Roy', 'rmarting@delicious.com', 'Bolivia', '789 Scoville Plaza', '', '8-(330)043-5619');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Martinez', 'Randy', 'rmartinez1q@adobe.com', 'United States', '9031 Clove Court', 'KS', '6-(835)245-0202');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Mason', 'Janet', 'jmason1m@pbs.org', 'United States', '48485 Springs Lane', 'WA', '0-(404)244-1973');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Mcdonald', 'Ann', 'amcdonaldu@drupal.org', 'United States', '94 Columbus Crossing', 'IN', '2-(019)467-7792');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Mcdonald', 'Kathryn', 'kmcdonald5@mit.edu', 'Indonesia', '3486 Vidon Street', '', '3-(381)326-4723');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Meyer', 'Lisa', 'lmeyer2k@ycombinator.com', 'Tuvalu', '6 Mallory Circle', '', '6-(321)779-8895');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Miller', 'Pamela', 'pmiller2b@t-online.de', 'United States', '951 High Crossing Alley', 'TX', '1-(377)914-2151');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Miller', 'Brandon', 'bmiller1u@prweb.com', 'Indonesia', '3992 Sugar Circle', '', '6-(106)294-1370');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Miller', 'Julia', 'jmiller2d@zdnet.com', 'Argentina', '551 Bartelt Crossing', '', '0-(666)185-0852');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Montgomery', 'Lois', 'lmontgomeryf@nba.com', 'United States', '8 Farwell Center', 'NC', '8-(375)554-1933');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morales', 'Jonathan', 'jmorales19@ed.gov', 'United States', '715 Muir Pass', 'TX', '7-(721)881-1745');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Moreno', 'Ronald', 'rmorenoa@wp.com', 'Indonesia', '6832 Dakota Drive', '', '1-(452)732-4207');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Moreno', 'Anne', 'amorenox@imgur.com', 'China', '72 Autumn Leaf Drive', '', '7-(297)043-6194');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Moreno', 'Martha', 'mmoreno1a@skyrock.com', 'China', '41 Ridgeview Pass', '', '8-(179)386-6387');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Moreno', 'Linda', 'lmoreno22@odnoklassniki.ru', 'Indonesia', '09 Mesta Street', '', '6-(716)643-5063');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morgan', 'Shawn', 'smorgany@a8.net', 'United States', '5351 Blaine Street', 'UT', '9-(614)327-3110');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morgan', 'Ruby', 'rmorgan1n@narod.ru', 'France', '13 Arapahoe Drive', 'B2', '4-(056)808-7190');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morris', 'Russell', 'rmorrist@yahoo.com', 'United States', '2 Dryden Street', 'CA', '8-(312)542-5335');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morris', 'Ernest', 'emorris17@linkedin.com', 'United States', '538 Lawn Hill', 'NY', '0-(722)159-2263');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Morris', 'Frank', 'fmorris15@goo.ne.jp', 'Greece', '073 Moland Avenue', '', '3-(574)360-9298');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Murphy', 'Sharon', 'smurphy1x@exblog.jp', 'United States', '030 Tomscot Trail', 'NC', '3-(392)774-3776');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Murray', 'Angela', 'amurray1f@elegantthemes.com', 'United States', '11496 Bobwhite Junction', 'VA', '7-(311)742-6306');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Murray', 'Tina', 'tmurray8@admin.ch', 'Brazil', '63 Arapahoe Avenue', '', '7-(922)695-1373');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Murray', 'Judith', 'jmurray12@weather.com', 'China', '772 Eagle Crest Court', '', '5-(447)261-8375');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Nguyen', 'Michelle', 'mnguyen9@home.pl', 'United States', '76 Vidon Crossing', 'LA', '3-(168)110-6625');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Nichols', 'Sean', 'snichols1d@alexa.com', 'Indonesia', '48 Garrison Court', '', '9-(909)775-6033');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Owens', 'Joyce', 'jowens1o@icq.com', 'United States', '0017 Fordem Hill', 'CA', '6-(213)022-2309');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Owens', 'Alan', 'aowens16@domainmarket.com', 'Zimbabwe', '9 Tomscot Place', '', '3-(534)603-4932');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Perez', 'Rebecca', 'rperezo@sbwire.com', 'United States', '67390 Manitowish Pass', 'TX', '7-(406)875-9890');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Perez', 'Marilyn', 'mperez1g@epa.gov', 'United States', '191 East Lane', 'TN', '2-(678)829-2820');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Perry', 'John', 'jperry1d@xinhuanet.com', 'United States', '02184 2nd Way', 'MD', '3-(362)867-6688');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Perry', 'Sharon', 'sperryd@barnesandnoble.com', 'China', '9202 Clemons Avenue', '', '3-(895)126-1278');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Pierce', 'Alice', 'apierce2r@umich.edu', 'United States', '6 Corben Trail', 'MI', '0-(467)177-3734');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Pierce', 'Ernest', 'epierce1w@flavors.me', 'France', '99 Warner Drive', 'B2', '7-(918)938-0007');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Pierce', 'Lois', 'lpierce2n@spotify.com', 'Argentina', '819 Holy Cross Drive', '', '4-(370)593-0211');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Porter', 'Debra', 'dporter1x@sakura.ne.jp', 'Indonesia', '1 Haas Street', '', '8-(747)340-6398');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ramirez', 'Frank', 'framirez2k@goodreads.com', 'United States', '3 Rowland Parkway', 'NC', '0-(669)037-4790');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ray', 'Norma', 'nray1l@columbia.edu', 'United States', '8 Crescent Oaks Terrace', 'CA', '3-(007)729-3299');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Reid', 'Katherine', 'kreid2@reverbnation.com', 'United States', '51 Stang Crossing', 'CA', '1-(816)180-4329');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Reid', 'Phyllis', 'preids@amazon.co.uk', 'Peru', '46 Rusk Parkway', '', '8-(695)108-5308');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Reid', 'Ashley', 'areid1p@taobao.com', 'United States', '88 Village Green Center', 'OH', '0-(960)491-5644');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Reyes', 'Nicole', 'nreyes5@exblog.jp', 'United States', '67524 Nobel Way', 'AZ', '7-(420)898-9688');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Reynolds', 'Gary', 'greynoldsz@state.gov', 'United States', '1 Prairieview Center', 'WA', '5-(337)284-9527');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Richards', 'Jessica', 'jrichards21@issuu.com', 'United States', '924 John Wall Trail', 'ME', '8-(061)711-6311');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Riley', 'Patricia', 'prileyd@topsy.com', 'United States', '459 3rd Avenue', 'GA', '8-(662)260-9720');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rivera', 'Cynthia', 'crivera1i@dagondesign.com', 'Central African Republic', '257 Raven Street', '', '2-(285)744-2177');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rodriguez', 'Christine', 'crodriguez1l@amazonaws.com', 'Mauritius', '78026 Everett Center', '', '8-(868)081-1984');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rodriguez', 'Kelly', 'krodriguez25@china.com.cn', 'Dominican Republic', '9 Beilfuss Plaza', '', '7-(441)055-8273');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rogers', 'Frank', 'frogers1w@statcounter.com', 'United States', '37717 Rutledge Park', 'PA', '8-(685)173-5668');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rogers', 'Janet', 'jrogers1o@ft.com', 'Argentina', '5 Muir Terrace', '', '5-(740)110-8659');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rose', 'Sarah', 'srose1@japanpost.jp', 'United States', '3147 3rd Place', 'CA', '9-(625)374-4080');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Rose', 'Scott', 'srose2o@chron.com', 'United States', '7741 Dennis Crossing', 'IA', '2-(957)474-8286');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ruiz', 'Paula', 'pruiz10@de.vu', 'United States', '0 Stone Corner Drive', 'CA', '5-(733)929-8978');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Russell', 'Jerry', 'jrussellh@mtv.com', 'Indonesia', '18 Redwing Center', '', '7-(835)874-3804');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ryan', 'Patrick', 'pryanq@bing.com', 'Portugal', '2456 Randy Junction', '13', '7-(908)548-4462');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Sanchez', 'Shawn', 'ssanchezy@utexas.edu', 'Colombia', '3 Butternut Point', '', '6-(314)041-2239');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Sanders', 'Patricia', 'psandersb@squarespace.com', 'United States', '9349 Morning Center', 'MO', '1-(201)273-2884');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Sanders', 'Marie', 'msandersz@jiathis.com', 'Indonesia', '956 Texas Terrace', '', '6-(897)485-7971');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Sanders', 'Frances', 'fsanders2j@ow.ly', 'China', '048 Mifflin Plaza', '', '5-(360)904-8808');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Shaw', 'Carol', 'cshaw2e@marriott.com', 'United States', '650 Grover Alley', 'GA', '6-(867)939-2196');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Simmons', 'James', 'jsimmons22@mysql.com', 'United States', '79 Hansons Circle', 'VA', '4-(084)741-2810');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Snyder', 'Fred', 'fsnyder2n@samsung.com', 'United States', '5 8th Drive', 'CA', '4-(204)127-6115');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Snyder', 'Benjamin', 'bsnyderv@cafepress.com', 'Poland', '8 Steensland Point', '', '3-(961)447-1196');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Stephens', 'Joyce', 'jstephens20@zimbio.com', 'United States', '5 Toban Drive', 'MO', '9-(961)593-9442');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Stephens', 'Barbara', 'bstephens1f@yellowbook.com', 'Cuba', '27 Fulton Plaza', '', '5-(765)751-8667');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Stone', 'Kelly', 'kstonei@cdc.gov', 'United States', '26 Kropf Way', 'NY', '8-(139)634-6415');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Torres', 'Angela', 'atorres8@uol.com.br', 'United States', '63232 Columbus Place', 'MA', '1-(439)654-3373');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Tucker', 'Roy', 'rtuckerg@example.com', 'United States', '6707 Maple Parkway', 'OH', '3-(093)128-8690');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Tucker', 'Joseph', 'jtucker15@disqus.com', 'United States', '17922 Quincy Pass', 'CA', '0-(990)513-0451');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Tucker', 'Dorothy', 'dtucker14@ehow.com', 'France', '3593 Atwood Circle', 'B5', '9-(243)144-3879');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Turner', 'Rebecca', 'rturner27@google.co.uk', 'China', '89156 Atwood Junction', '', '4-(853)728-1963');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wagner', 'Brian', 'bwagner13@quantcast.com', 'United States', '3833 Pierstorff Point', 'MD', '5-(595)231-2208');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Walker', 'Kenneth', 'kwalker29@aboutads.info', 'United States', '9 Superior Crossing', 'WA', '0-(953)489-2738');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wallace', 'Debra', 'dwallacer@nps.gov', 'United States', '23 Ohio Terrace', 'CT', '0-(483)351-8933');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Ward', 'Raymond', 'rwardm@nationalgeographic.com', 'United States', '47656 Old Shore Street', 'NC', '3-(715)261-7860');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Warren', 'Henry', 'hwarren19@apache.org', 'Philippines', '12 Kennedy Plaza', '', '4-(180)111-6593');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Washington', 'Henry', 'hwashington2q@mail.ru', 'Indonesia', '80 Autumn Leaf Street', '', '6-(962)303-1876');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Watkins', 'Adam', 'awatkinst@timesonline.co.uk', 'Egypt', '4 Susan Street', '', '7-(977)440-3683');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Watkins', 'Nicholas', 'nwatkins1b@va.gov', 'China', '74962 Steensland Avenue', '', '1-(946)323-6647');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Watson', 'Timothy', 'twatson1k@shinystat.com', 'United States', '184 Lukken Hill', 'NE', '1-(046)935-7571');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Webb', 'Louis', 'lwebb2e@blogspot.com', 'Indonesia', '1958 Granby Avenue', '', '0-(713)613-4968');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Webb', 'Charles', 'cwebb2l@twitter.com', 'Latvia', '5012 Eggendart Pass', '', '2-(444)641-6850');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Welch', 'Tina', 'twelch1u@yahoo.co.jp', 'United States', '4 Bashford Terrace', 'MN', '1-(518)288-4237');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Welch', 'Rose', 'rwelchu@gnu.org', 'Serbia', '56176 Burning Wood Lane', '', '9-(271)628-1625');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wheeler', 'Paula', 'pwheeler1s@mac.com', 'United States', '39639 Leroy Avenue', 'OH', '4-(874)769-0414');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Williams', 'Shawn', 'swilliamsc@joomla.org', 'United States', '60 Sugar Plaza', 'MI', '4-(867)695-7864');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Williams', 'Harold', 'hwilliamsm@dion.ne.jp', 'Russia', '6728 Colorado Street', '', '5-(250)547-3562');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Willis', 'Paul', 'pwillis12@e-recht24.de', 'United States', '0177 Everett Junction', 'DC', '7-(560)524-0255');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wood', 'Jose', 'jwoodn@mtv.com', 'United States', '59447 Ludington Parkway', 'NY', '3-(322)044-6672');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wood', 'Janet', 'jwood1k@goodreads.com', 'Ireland', '445 Harper Parkway', '', '0-(943)656-4847');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wright', 'Victor', 'vwright7@baidu.com', 'Ukraine', '542 Mandrake Center', '', '0-(279)357-3386');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wright', 'Kimberly', 'kwrightf@tinyurl.com', 'Brazil', '9893 Summit Plaza', '', '3-(288)433-6668');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Wright', 'Joan', 'jwright1q@phoca.cz', 'Moldova', '55 Dawn Parkway', '', '7-(830)749-3794');
INSERT INTO GUEST (LAST_NAME, FIRST_NAME, EMAIL_ADDRESS, COUNTRY, ADDRESS, STATE, PHONE_NUMBER) VALUES('Young', 'Judith', 'jyoung11@goodreads.com', 'United States', '2 Sachtjen Parkway', 'WV', '9-(659)879-6466');

 INSERT INTO RESERVATION (ROOM_ID, GUEST_ID, RES_DATE) VALUES ((SELECT ROOM_ID FROM ROOM WHERE ROOM_NUMBER = 'C2'), (SELECT GUEST_ID FROM GUEST WHERE LAST_NAME = 'Young'), '2017-01-01');


3) set the auto schema creation, which is a feature of hibernate to null, by setting the below string in the application.properties file. By doing so, we can avoid Hibernate from overwriting or autowriting/updating the existing schema to the defaults.

spring.jpa.hibernate.ddl-auto=none

4)After the above 3 steps,  if we restart the server, we will also see few lines in the console, that indicated the loading and executing of the DDL and DML files to load the tables into memory. Since loading is done into the memory, we do not need to have any database set up for this project.








Spring Data JPA
Spring Data is a sub framework that comes with Spring that helps in reducing a huge number of lines of code to a single line...

consider a method that get's DB connection, executes the statement and retrieves resultset and iterates over it, etc. All of this is replaced with a single line f code, when using Spring Data.

By demonstration:

1. Lets start with creating Entity POJOs as related to teh schema defined in DDL file.



  • Annotating each variable as we are internally using Hibernate for mapping the variables to the tables.
  • Generate getters and setter for all the variables. Hence our Entity is ready.
  • Make sure that the hibernate.ddl==auto is correctly set in application.properties file to avoid an overrwrite.
2. Now, create a Repository Interface for the Entity you created in the previous step. This class is going to help us retrieve the Entity objects created in previous steps. By Repository, we intend to extend this class to 1 of the 2 common data operations API provided by spring jpa.
    • CrudRepository (provides operations such as, save, findone, findall., delete, deleteAll, etc)
    • PagingAndSortingRepository(provides operations findAll(Sort sort) and findAll(Pageable pageable);
  • We are in our case using CrudRepository. Its usage is as shown below. The "findByNumber" is a query method obtained by extending this interface.This is the power of Spring Data JPA, which generates the select query at the backend to retrieve the room record based on the number(id) passed; in just a single line of code.

package com.reservations.repository;

import org.springframework.data.repository.CrudRepository;
import org.springframework.stereotype.Repository;

import com.reservations.Entities.Room;

@Repository
public interface RoomRepository extends CrudRepository<Room, Long>{ 
//long is the datatype for the ID variable in Room emtity
Room findByNumber(String number);
}


Similarly, there are many query methods that does various data operations based on the interface extended. To know more, read this article (https://docs.spring.io/spring-data/jpa/docs/current/reference/html/ )
dkfhjgvjhk


3. Similarly now, create Entity and Repository classes for the remaining 2 Tables in the DDL file(Guest and Reservation)

Service and Controller Classes:


  • We now create a Service class, with @service annotation, and write methods that return all the reservations given a date. 


package com.reservations.service;

 import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

 import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

 import com.reservations.Entities.Guest;
import com.reservations.Entities.Reservation;
import com.reservations.Entities.Room;
import com.reservations.domain.RoomReservation;
import com.reservations.repository.GuestRepository;
import com.reservations.repository.ReservationRepository;
import com.reservations.repository.RoomRepository;

 @Service
public class ReservationService {
    private RoomRepository roomRepository;
    private GuestRepository guestRepository;
    private ReservationRepository reservationRepository;

     @Autowired
    public ReservationService(RoomRepository roomRepository, GuestRepository guestRepository, ReservationRepository reservationRepository) {
        this.roomRepository = roomRepository;
        this.guestRepository = guestRepository;
        this.reservationRepository = reservationRepository;
    }

     public List<RoomReservation> getRoomReservationsForDate(Date date){
        Iterable<Room> rooms = this.roomRepository.findAll();
        Map<Long, RoomReservation> roomReservationMap = new HashMap<>();
        rooms.forEach(room->{
            RoomReservation roomReservation = new RoomReservation();
            roomReservation.setRoomId(room.getId());
            roomReservation.setRoomName(room.getName());
            roomReservation.setRoomNumber(room.getNumber());
            roomReservationMap.put(room.getId(), roomReservation);
        });
        Iterable<Reservation> reservations = this.reservationRepository.findByDate(new java.sql.Date(date.getTime()));
        if(null!=reservations){
            reservations.forEach(reservation -> {
                Guest guest = this.guestRepository.findOne(reservation.getGuestId());
                if(null!=guest){
                    RoomReservation roomReservation = roomReservationMap.get(reservation.getId());
                    roomReservation.setDate(date);
                    roomReservation.setFirstName(guest.getFirstName());
                    roomReservation.setLastName(guest.getLastName());
                    roomReservation.setGuestId(guest.getId());
                }
            });
        }
        List<RoomReservation> roomReservations = new ArrayList<>();
        for(Long roomId:roomReservationMap.keySet()){
            roomReservations.add(roomReservationMap.get(roomId));
        }
        return roomReservations;
    }
}

Note: Using   @Autowired. indicates to Spring to have them constructed before being injected into the constructor of the service class.


  • Once we have the service class done, we could use the same class as the service API, however, to be more clear on MVC pattern, let's write another class, with @controller annotated, which will serve as a url for returning all reservations, retrieved via our service class implemented above.


package com.reservations.controller;

 import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

 @Controller
@RequestMapping(value="/reservations")
public class ReservationController {

@RequestMapping(method=RequestMethod.GET)
public String getReservations(){
return "reservations";
}

 }

Note: @RequestMapping,indicates to Spring, that this would be the method returned for url=reservations for GET request.


Templates: 
We now need to create a template(html file) which is retrieved with name based on the strings returned in the @RequestMapping method.


Note: If you notice the reservations string that is returned on requesting the /reservations sub url, it return a template(html page), which matches the string that is returned; as in the screenshot above. Now if we restart the application/server, access the url as, localhost:8080/reservations, it will retrieve this html template.


Thymeleaf:

Thymeleaf is a rendering engine for templates, a library that will be used in this project to implement rendering of objects in the html pages. The html pages will have tags with 'th' to use this library. This library can be configured to your html code by including the line below:

<html lang="en" xmlns:th="http://www.thymeleaf.org">

The new html code would have "th" implementation included:

<tr th:each="roomReservation: ${roomReservations}">
        <td th:text="${roomReservation.roomName}">Room Name</td>
        <td th:text="${roomReservation.roomNumber}">Room Number</td>
        <td th:text="${roomReservation.lastName} + ', ' + ${roomReservation.firstName}">Full Name</td>
    </tr>

We could further improvise the html code using the bootstrap library APIs, done by including this library in code as :
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>

And now the final template code would be:

<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="utf-8"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge"/>
    <meta name="viewport" content="width=device-width, initial-scale=1"/>

    <title>Diana's Reservations</title>

    <link rel="stylesheet" href="https://code.jquery.com/ui/1.12.1/themes/ui-darkness/jquery-ui.css"/>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css"/>
    <link rel="stylesheet" href="../static/css/site.css"/>

    <!--[if lt IE 9]>
    <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
    <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
    <![endif]-->
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top">
    <div class="container">
        <div class="navbar-header">
            <a class="navbar-brand" href="reservations">Diana's Hotels - Reservations</a>
        </div>
    </div>
</nav>
<div class="container">
    <div class="page-header">
        <h1>Welcome to the Reservations Page</h1>
    </div>
    <div class="input-group">
        <span class="input-group-addon" id="basic-addon1"><span class="glyphicon glyphicon-calendar" aria-hidden="true"></span></span>
        <input type="text" class="form-control" id="datepicker" aria-describedby="basic-addon1"/>
    </div>

    <table class="table table-striped table-bordered">
        <tr>
            <td>Room</td>
            <td>Room Number</td>
            <td>Guest</td>
        </tr>
        <tr th:each="roomReservation: ${roomReservations}">
            <td th:text="${roomReservation.roomName}">Room Name</td>
            <td th:text="${roomReservation.roomNumber}">Room Number</td>
            <td th:text="${roomReservation.lastName}!=null? ${roomReservation.lastName} + ', ' + ${roomReservation.firstName} : 'VACANT'">Full Name</td>
        </tr>
    </table>
</div>
<footer class="footer navbar-inverse navbar-fixed-bottom">
    <div class="container">
        <div class="row">
            <div class="col-md-4"></div>
            <div class="col-md-4"><p class="text-muted">@Copyright 2017 Diana</p></div>
        </div>
    </div>
</footer>

<script src="http://code.jquery.com/jquery-1.12.4.min.js"></script>
<script src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<script src="../static/js/site.js"></script>
</body>
</html>

Now, what is roomReservations in the template code above?
It is the model(org.springframework.ui.Model) that is passed from the calling class; In our case, it is the GET method form the Controller class which returns the "reservations" string. We now need to populate and set the model attribute, so that it reflects in the template when it loads.

Hence, our Controller code changes to below, in order to pass or set the Model attribute to the template.
Notes: Please make sure that the strings match(model names)

The logic in displaying the reservations is based on the date selected. The html displays all the reservations for the date passed, However, if the date is wrongly formatted or is not passed, then the date is defaulted to the current date.

package com.reservations.controller;

import java.text.DateFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;

import com.reservations.domain.RoomReservation;
import com.reservations.service.ReservationService;

@Controller
@RequestMapping(value="/reservations")
public class ReservationController {
    private static final DateFormat DATE_FORMAT = new SimpleDateFormat("yyyy-MM-dd");

    @Autowired
    private ReservationService reservationService;

    @RequestMapping(method= RequestMethod.GET)
    public String getReservations(@RequestParam(value="date", required=false)String dateString, Model model){
        Date date = null;
        if(null!=dateString) {
            try {
                date = DATE_FORMAT.parse(dateString);
            } catch (ParseException pe) {
                date = new Date();
            }
        }else{
            date = new Date();
        }
        List<RoomReservation> roomReservationList = this.reservationService.getRoomReservationsForDate(date);
        model.addAttribute("roomReservations", roomReservationList);
        return "reservations";
    }
}


TESTING what we created using SPRING framework itself:

If we look into the pom.xml for the below lines of code; is the package that enables easy testing, via the Spring framework

<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
<!-- This plugin consists of lot of Spring's Test framework, 
Junit type frameworks,Mockito for mocking elements 
All of this comes in for free as part of creating the project via the Spring Initializr-->
</dependency>


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)