ssm实现增删改查（包含oracle数据库）

-------------------------创建数据库 --创建用户（以管理员身份登录数据库,创建新用户） create user handson identified by 274039; --为用户分配权限 grant create session,resource,dba to handson; --创建表空间 create tablespace handson_data datafile 'D:\oracleWorkSpace\handson_data.dbf' size 10m autoextend on next 1m maxsize 50m extent management local; --给用户指定表空间 alter user handson default tablespace handson_data; --用新创建的用户登陆数据库（conn handson/274039） ------------------------创建表EMPLOYEE create table EMPLOYEE( EMP_ID number(4) primary key, EMP_NAME varchar2(100) not null, EMP_SEX number(4) not null, EMP_AGE number(4) not null, EMP_DEPART varchar(50) not null ) --添加自增 create sequence seq_EMPLOYEE start with 1 increment by 1; --创建触发器 create or replace trigger tr_EMPLOYEE before insert on EMPLOYEE for each row begin select seq_EMPLOYEE.nextval into :new.EMP_ID from dual; end; --插入数据 insert into EMPLOYEE values(1,'李晓明',1,25,'行政部'); insert into EMPLOYEE values(1,'杨伟林',1,29,'行政部'); insert into EMPLOYEE(EMP_NAME,EMP_SEX,EMP_AGE,EMP_DEPART) values('1',1,29,'行政部'); update EMPLOYEE set EMP_NAME=#{name},EMP_SEX=#{pwd},EMP_AGE=#{name},EMP_DEPART=#{pwd} where EMP_ID = #{id} --查询 select * from EMPLOYEE --drop drop table EMPLOYEE drop sequence seq_EMPLOYEE