empldir_mysql.sql

《jsp网络编程技术与实例》

-- EmplDir_MySQL.sql

drop table if exists deps;
drop table if exists emps;

create table deps
(
  dep_id integer auto_increment primary key,
  name varchar(50)
);

insert into deps (name) values ('Software');
insert into deps (name) values ('Administration');
insert into deps (name) values ('Support');
insert into deps (name) values ('Marketing');
insert into deps (name) values ('Finance');

create table emps
(
  emp_id integer auto_increment primary key,
  dep_id integer,
  name varchar(100),
  title varchar(50),
  work_phone varchar(50),
  home_phone varchar(50),
  cell_phone varchar(50),
  address varchar(100),
  email varchar(50),
  picture varchar(50),
  emp_login varchar(20) not null,
  emp_password varchar(20) not null,
  emp_level integer default 0,
  manmonth integer
);

insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('John Smith', 'Director', '[e-mail]', '[phone]', '[phone]', '[phone]', '', 2, 'johns.jpg', 'johns', '', 0, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Li Jang', 'Developer', '[e-mail]', '[phone]', '[phone]', '[phone]', '', 1, 'lij.jpg', 'lij', '', 0, 1);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Rob McDonald', 'Manager', '[e-mail]', '[phone]', '[phone]', '[phone]', '', 5, 'robd.jpg', 'robd', '', 0, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('David Snyder', 'Developer', '[e-mail]', '[phone]', '[phone]', '', '', 1, 'davids.jpg', 'davids', '', 0, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Pablo Sanchez', 'Developer', '[e-mail]', '[phone]', '[phone]', '', '', 1, 'pablos.jpg', 'pablos', '', 0, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Stefan Fey', 'Support', '[e-mail]', '[phone]', '[phone]', '', '', 3, 'stefanf.jpg', 'stefanf', '', 0, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Bob Kuch', 'Developer', '[e-mail]', '[phone]', '[phone]', '', '', 1, 'bobk.jpg', 'bobk', 'bobk', 3, 0);
insert into emps (name, title, email, work_phone, home_phone, cell_phone, address, dep_id, picture, emp_login, emp_password, emp_level, manmonth)
	values('Tim Leist', 'Developer', '[e-mail]', '[phone]', '[phone]', '', '', 1, 'timl.jpg', 'timl', '', 0, 0);