JavaEE/Oracle课设-人力资源管理系统

create table deps( dep_id number(4) primary key, dep_name varchar2(30) not null, manager_id number(8) ); create table jobs( job_id number(4) primary key, job_name varchar2(30) not null, salary number(8,2) ); create table emps( emp_id number(8) primary key, emp_name varchar2(30) not null, phone varchar2(20) not null, email varchar2(30), job_id number(4) references jobs(job_id), hire_date date, manager_id number(8), dep_id number(4) references deps(dep_id), bonus number(8,2), img blob ); create table usrs( user_id number(4) primary key, user_name varchar2(20), password varchar2(20) not null ); insert into usrs values(1,'admin','123'); commit;