mysql 샘플 테이블 + 쿼리 연습 문제

-
http://java-school.net/jdbc/SQL-SELECT-Statement CREATE TABLE DEPT (     DEPTNO DECIMAL ( 2 ),     DNAME VARCHAR ( 14 ),     LOC VARCHAR ( 13 ),     CONSTRAINT PK_DEPT PRIMARY KEY ( DEPTNO ) ); CREATE TABLE EMP (     EMPNO DECIMAL ( 4 ),     ENAME VARCHAR ( 10 ),     JOB VARCHAR ( 9 ),     MGR DECIMAL ( 4 ),     HIREDATE DATE ,     SAL DECIMAL ( 7 , 2 ),     COMM DECIMAL ( 7 , 2 ),     DEPTNO DECIMAL ( 2 ),     CONSTRAINT PK_EMP PRIMARY KEY ( EMPNO ),     CONSTRAINT FK_DEPTNO FOREIGN KEY ( DEPTNO ) REFERENCES DEPT ( DEPTNO ) ); CREATE TABLE SALGRADE (     GRADE TINYINT ,     LOSAL SMALLINT ,     HISAL SMALLINT ); INSE...

Java 정규식 테스트 사이트

-


https://regex-testdrive.com/en/dotest



group()으로 쪼개서 보여주니까 편하니 좋다




// json 에서 리턴코드 0000만 뽑아오기

final String expStr = "(.*)(returnCode|rsltCd)([\\s|\\t]*?[\"][\\s|\\t]*?[:][\\s|\\t]*?[\"][\\s|\\t]*?)([0-9|A-Z|a-z]+)(.*)";
   
    Pattern pattern = Pattern.compile(expStr);
    Matcher matcher = pattern.matcher(jsonStr);
    String returnCodeStr = "";
   
    while(matcher.find()) {
    returnCodeStr = matcher.group(4);
    }