韩顺平PHP雇员系统的代码

管理员： create table admin( id int primary key, name varchar(32) not null, password varchar(128) not null); 雇员： create table emp( id int primary key auto_increment, name varchar(64) not null, grade tinyint, email varchar(64) not null, salary float); insert into emp (name,grade,email,salary) values('shunping',1,'shunping@sohu.com',200); insert into admin values(100,'admin',md5('admin')); create database empmanage; insert into emp (name,grade,email,salary) values('shunping1',2,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping2',3,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping3',4,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping4',5,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping5',6,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping6',7,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping7',8,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping8',9,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping9',10,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) values('shunping10',11,'shunping@sohu.com',200); insert into emp (name,grade,email,salary) select name,grade,email,salary from emp;