MVC Model1 - Paging

JSP 2016. 10. 12. 22:54
반응형

Paging1.war


1. SQL: 

CREATE TABLE EMPLOYEE (
EMP_ID INT  UNSIGNED AUTO_INCREMENT,
EMP_NAME CHAR(100),
JOB CHAR(100),
CITY CHAR(100),
COUNTRY CHAR(100),
PRIMARY KEY(EMP_ID ) 
)

INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('JOHNNY','GUITAR','SEOUL','KOREA');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('JENNY','BASS','SEOUL','KOREA');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('LUCY','ACOUSTIC','WARSAW','POLAND');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('ULA','UKULELE','WARSAW','POLAND');
INSERT EMPLOYEE (EMP_NAME, JOB, CITY, COUNTRY) VALUES ('ASIA','POWERDRUM','ZAKOPANE','POLAND');

SELECT * FROM EMPLOYEE


2. Files :


반응형
Posted by ThinkPad War
,