Spring Mybatis CRUD example

SampleCRUD-1.0.0-BUILD-SNAPSHOT.war

환경 : Oracle 12c

1. Create User and role

[oracle@ORCL1 opc]$ sqlplus sys/Welcome1#@pdb1 as sysdba

-- USER SQL

CREATE USER "DAVID" IDENTIFIED BY "Welcome1@" 

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES

-- SYSTEM PRIVILEGES

GRANT CREATE SESSION TO DAVID;         

GRANT CREATE DATABASE LINK TO DAVID;

GRANT CREATE MATERIALIZED VIEW TO DAVID;

GRANT CREATE PROCEDURE TO DAVID;

GRANT CREATE PUBLIC SYNONYM TO DAVID;

GRANT CREATE ROLE TO DAVID;

GRANT CREATE SEQUENCE TO DAVID;

GRANT CREATE SYNONYM TO DAVID;

GRANT CREATE TABLE TO DAVID;             

GRANT DROP ANY TABLE TO DAVID;        

GRANT CREATE TRIGGER TO DAVID;

GRANT CREATE TYPE TO DAVID;

GRANT CREATE VIEW TO DAVID;

alter user "DAVID" quota unlimited on USERS;

2. Create Table

CREATE TABLE DAVID.CUSTOMER

(

  CUSTOMER_ID VARCHAR2(50) NOT NULL 

, NAME VARCHAR2(50) 

, STANDARD VARCHAR2(20) 

, AGE NUMBER 

, SEX VARCHAR2(20) 

,  CONSTRAINT USER_PK PRIMARY KEY (CUSTOMER_ID)

);

3. Deploy to weblogic

Reference site :  http://www.raistudies.com/spring/spring-mvc/spring-mvc-3-crud-example-with-mybatis-3/