iBATISを使ったO/RマッピングによるDBアクセスの実例 3

CREATE TABLE DEPT (
    DEPTNO     NUMERIC(2) NOT NULL,
    DNAME      VARCHAR(14),
    LOC        VARCHAR(13),
    CONSTRAINT PK_DEPT PRIMARY KEY (DEPTNO)
);
CREATE TABLE EMP (
    EMPNO      NUMERIC(4) NOT NULL,
    ENAME      VARCHAR(10),
    JOB        VARCHAR(9),
    MGR        NUMERIC(4),
    HIREDATE   DATE,
    SAL        NUMERIC(7,2),
    COMM       NUMERIC(7,2),
    DEPTNO     NUMERIC(2) NOT NULL,
    CONSTRAINT PK_EMP PRIMARY KEY (EMPNO)
);
CREATE TABLE EMPIMAGE(
    EMPNO      NUMERIC(4) NOT NULL,
    IMG        LONGVARBINARY,
    CONSTRAINT PK_EMPIMAGE PRIMARY KEY(EMPNO)
);