编程和数据库基础

CREATE TABLE userInfo(

id int unsigned not null auto_increment PRIMARY KEY,
username VARCHAR(50) NOT NULL ,
password VARCHAR(50) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into userInfo values(1,'hfut1','000000');




CREATE TABLE weXinInfo(
id int unsigned not null auto_increment PRIMARY KEY,
fromUserName VARCHAR(100) NOT NULL UNIQUE KEY,
isLogin VARCHAR(20) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
insert into weXinInfo values(1,'hfut1','000000');



CREATE TABLE basicInformation(
id int unsigned not null auto_increment PRIMARY KEY,
contractNo VARCHAR(50) NOT NULL UNIQUE KEY,
idNumber VARCHAR(50) NOT NULL,
name VARCHAR(20) NOT NULL,
productName VARCHAR(50) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into basicInformation values(1,'hfut00001','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(2,'hfut00002','340123199505064567','陈家航','美的集团');
insert into basicInformation values(3,'hfut00003','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(4,'hfut00004','340123199505064567','陈家航','美的集团');
insert into basicInformation values(5,'hfut00005','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(6,'hfut00006','340123199505064567','陈家航','美的集团');
insert into basicInformation values(7,'hfut00007','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(8,'hfut00008','340123199505064567','陈家航','美的集团');
insert into basicInformation values(9,'hfut00009','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(10,'hfut00010','340123199505064567','陈家航','美的集团');
insert into basicInformation values(11,'hfut00011','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(12,'hfut00012','340123199505064567','陈家航','美的集团');
insert into basicInformation values(13,'hfut00013','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(14,'hfut00014','340123199505064567','陈家航','美的集团');
insert into basicInformation values(15,'hfut00015','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(16,'hfut00016','340123199505064567','陈家航','美的集团');
insert into basicInformation values(17,'hfut00017','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(18,'hfut00018','340123199505064567','陈家航','美的集团');
insert into basicInformation values(19,'hfut00019','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(20,'hfut00020','340123199505064567','陈家航','美的集团');
insert into basicInformation values(21,'hfut00021','340123199505064567','陈辉龙','万达信息股份有限公司');
insert into basicInformation values(22,'hfut00022','340123199505064567','陈家航','美的集团');






CREATE TABLE userInfo(
id int unsigned not null auto_increment PRIMARY KEY,
jobNumber VARCHAR(50) NOT NULL UNIQUE KEY,
password VARCHAR(50) NOT NULL,
employeeName VARCHAR(50) NOT NULL,
employeeNickname VARCHAR(20) NOT NULL,
employeeNameLastname VARCHAR(20) NOT NULL,
male VARCHAR(20) NOT NULL,
departmentName varchar(100) NOT NULL,
position varchar(100) NOT NULL,
phone VARCHAR(50) NOT NULL
)ENGINE=InnoDB DEFAULT CHARSET=utf8;




insert into userInfo values(1,'hfut1','000000','陈辉龙','辉龙','陈','M','移动开发部','iOS开发','15212789350');
insert into userInfo values(2,'hfut2','000000','陈家航','家航','陈','M','移动开发部','java后台','15256019326');
insert into userInfo values(3,'hfut3','000000','胡新星','新星','胡','M','移动开发部','java后台','18326631523');
insert into userInfo values(4,'hfut4','000000','丁文强','文强','丁','M','移动开发部','项目经理','13917654720');
insert into userInfo values(5,'hfut5','000000','李悦','李悦','李','F','移动开发部','Android开发','13349114455');
insert into userInfo values(6,'hfut6','000000','刘艳','刘艳','刘','F','移动开发部','产品经理','13816246242');
insert into userInfo values(7,'hfut7','000000','谢华','谢华','谢','F','移动开发部','iOS开发','18101697700');
insert into userInfo values(8,'hfut8','000000','周晶晶','晶晶','周','F','移动开发部','web前端','18326106202');
insert into userInfo values(9,'hfut9','000000','卓显桂','显桂','桌','M','移动开发部','Android开发','18964525948');
insert into userInfo values(10,'hfut10','000000','杨扬','杨扬','杨','M','移动开发部','Android开发','15026932206');
insert into userInfo values(11,'hfut11','000000','王双','王双','王','F','移动开发部','测试工程师','15856985266');