개발자용(본인) 테스트 db 만들어야함(중요)

테스트 코드 실행전

users 테이블의 모든 데이터를 삭제

users 테이블의 원본데이터(17건) 를 입력하는 insert 쿼리를 실행

commit ;

system 계정 에서 작업하기

• -table space 생성 SELECT * FROM DBA_DATA_FILES;

CREATE TABLESPACE TS_DBSQL_DEV DATAFILE 'D:\B_UTIL\4.ORACLE\APP\ORACLE\ORADATA\XE\TS_DBSQL_DEV.DBF' SIZE 100M AUTOEXTEND ON;

• -사용자 추가 create user coral0209_dev identified by java default tablespace TS_DBSQL_DEV temporary tablespace temp quota unlimited on TS_DBSQL_DEV quota 0m on system;
• -접속, 생성권한 GRANT CONNECT, RESOURCE TO coral0209_dev;

Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('finally2','212','11',null,'1212sd',null,'1212',null,'ryan.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\ryan.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ddit','sdsdd','dd',null,'ddd',null,'dd',null,'cony.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\cony.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ss','ssssffff','ssssssff',null,'ssssssfff',null,'ss',null,null,null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('sallyddd','sdsd','sssss',null,'sdsds',null,'sdsdsd',null,'cony.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\cony.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('sds','sds','ddsddd',null,'sds',null,'sd',null,'moon.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\moon.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('sally','ss','pass',null,'ssally','주소1','주소2','집코드',null,null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('testest','테스트','0000',to_date('2021.02.04.00.00.00','YYYY.MM.DD.HH24.MI.SS'),'테스트별명','서울 강남구 압구정로 102','형제조','06027','moon.png','d:\upload\e5c365ae-6f6c-41a6-83c2-26789d50cabf.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('brown','dd','dd',to_date('2021.02.04.00.00.00','YYYY.MM.DD.HH24.MI.SS'),null,'서울 강남구 양재대로 333','dd','06313','sally.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\sally.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('brown111','dd','aa',null,'sdsd','서울 강남구 강남대로 708','sdsd','06000','ryan.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\ryan.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ㅇㄴㄴㅇ','sdds','sddssdds',null,'sdsd',null,null,null,null,null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('jazz2','재즈','0000',to_date('2021.02.04.00.00.00','YYYY.MM.DD.HH24.MI.SS'),'오리온재즈','서울 강서구 강서로 251','s','07639','moon.png','d:\upload\5cc0db65-85a0-4de1-a60a-b294483ae3e6.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('testphoto','이수정','pass',null,'ㄴㅇ','서울 강남구 압구정로 102','ㅇ','06027','cony.png',null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('testtest','테스트22','1111',to_date('2021.02.04.00.00.00','YYYY.MM.DD.HH24.MI.SS'),'22','서울 강남구 강남대로 708','dd','06000',null,null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ddddd','ddddd','sdsd',null,'ㄷㄷㄷㅇㅇ','서울 강남구 강남대로 708','dd','06000','cony.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\cony.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('testphoto2','dsds','sd',null,'dsds',null,null,null,'james.png',null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('testing','dd','dd',null,'dd',null,null,null,'james.png','D:\upload\james.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ddd','ddd','dddd',null,'ddd',null,'ddd',null,'cony.png',null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('ㅇㅇㅇㅇ','ff','ff',null,'ff',null,'ff',null,'cony.png',null); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('dd','sdsddxxx','ddddddx',null,'sdsxxx',null,'sdsddd',null,'moon.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\moon.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('krkr','dfs','1212',null,'sdfsdf',null,'sdfsdf',null,'moon.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\moon.png'); Insert into USERS (USERID,USERNM,PASS,REG_DT,ALIAS,ADDR1,ADDR2,ZIPCODE,FILENAME,REALFILENAME) values ('wow','sd','dddd',null,'sd',null,'sd',null,'sally.png','D:\A_TeachingMaterial\6.JspSpring\workspace\29memberSpring\src\main\webapp\images\sally.png');