数据库sql-2

CREATE TABLE guyuan(
gid INT PRIMARY KEY auto_increment,
gname VARCHAR(40),
gsex VARCHAR(10),
gtitle VARCHAR(60),
gbirthday date,
bid INT,
CONSTRAINT lklk FOREIGN KEY(bid) REFERENCES bumen(bid)
);
CREATE TABLE bumen(
bid INT PRIMARY KEY,
bname VARCHAR(20),
bumenjianjie VARCHAR(30)
);
CREATE TABLE salary(
gid INT PRIMARY KEY,
basesalary INT,
titlesalary INT,
deduction INT
);
ALTER TABLE guyuan auto_increment=1001;
INSERT INTO guyuan(gname,gsex,gtitle,gbirthday,bid)
VALUES('张三','男','高级程师','1975-1-1',1111),
('李四','女','助工','1985-1-1',1111),
('王五','男','工程师','1978-11-11',2222),
('赵六','男','工程师','1979-1-1',2222);
INSERT INTO bumen(bid,bname,bumenjianjie)
VALUES(1111,'生产部','产品加工'),
(2222,'销售部','销售公司产品'),
(3333,'人事部','人事管理');
insert INTO salary(gid,basesalary,titlesalary,deduction)
VALUES(1001,2200,1100,200),
(1002,1200,200,100),
(1003,1900,700,200),
(1004,1950,700,150);
SELECT * FROM guyuan;
SELECT gid,gname,gtitle,bname FROM guyuan,bumen WHERE guyuan.bid=bumen.bid;
SELECT * FROM guyuan WHERE gname LIKE'李%';
SELECT guyuan.gid,gname,gtitle,basesalary+titlesalary-deduction AS '实发工资' FROM guyuan,salary WHERE guyuan.gid=salary.gid;
select gname,basesalary+titlesalary-deduction as '工资' from guyuan,salary where guyuan.gid=salary.gid and guyuan.gid in(select gid from guyuan where bid in (select bid from bumen where bname='销售部'));
SELECT gtitle,COUNT(*) FROM guyuan GROUP BY gtitle;
SELECT gsex,COUNT(*) FROM guyuan WHERE gsex='男';

CREATE TABLE EMPLOYEE(
uid INT PRIMARY KEY auto_increment,
uname VARCHAR(20) NOT NULL,
hiredate date NOT NULL,
job VARCHAR(10),
salary DOUBLE(8,2) DEFAULT 0,
pct DOUBLE(8,2) DEFAULT 0,
detno INT,
CONSTRAINT lglili FOREIGN KEY (detno) REFERENCES department(deptno)
);
CREATE TABLE department(
deptno INT(11) PRIMARY KEY,
dname VARCHAR(30) NOT NULL,
mgrid INT(11),
lid INT(11)
);
INSERT INTO department(deptno,dname,mgrid,lid)
VALUES(10,'销售部',1006,101),
(20,'研发部',1003,102),
(30,'董事会',1005,101),
(40,'人事部',NULL,102);
ALTER TABLE employee auto_increment=1001;
INSERT INTO employee(uname,hiredate,job,salary,pct,detno)
VALUES('刘亦菲','2018-09-12','科员',10200,0.20,10),
('张学友','2017-04-23','科员',15000,0.00,20),
('王斐','2011-08-24','经理',18000,0.10,20),
('刘能','2014-03-18','科长',15000,0.15,10),
('黛玉','2016-09-29','总经理',22800,0.20,30),
('刘德华','2016-09-12','经理',21000,0.10,10),
('赵本山','2018-12-30','科长',17500,0.00,20),
('王宝强','2018-08-22','科员',8000,0.20,10);
SELECT uid,job,salary FROM employee;
SELECT uid,uname,job,salary+pct AS '实际月薪' FROM employee;
SELECT * FROM employee WHERE detno=10;
SELECT * FROM employee WHERE uname LIKE'%菲';
SELECT * FROM employee WHERE job='科长' AND salary>17000;
SELECT uid,uname,dname FROM employee,department WHERE employee.detno=department.deptno;

CREATE TABLE EMPLOYEE(
uid INT PRIMARY KEY auto_increment,
uname VARCHAR(20) NOT NULL,
hiredate date NOT NULL,
job VARCHAR(10),
salary DOUBLE(8,2) DEFAULT 0,
pct DOUBLE(8,2) DEFAULT 0,
detno INT,
CONSTRAINT lglili FOREIGN KEY (detno) REFERENCES department(deptno)
);
CREATE TABLE department(
deptno INT(11) PRIMARY KEY,
dname VARCHAR(30) NOT NULL,
mgrid INT(11),
lid INT(11)
);
INSERT INTO department(deptno,dname,mgrid,lid)
VALUES(10,'销售部',1006,101),
(20,'研发部',1003,102),
(30,'董事会',1005,101),
(40,'人事部',NULL,102);
ALTER TABLE employee auto_increment=1001;
INSERT INTO employee(uname,hiredate,job,salary,pct,detno)
VALUES('刘亦菲','2018-09-12','科员',10200,0.20,10),
('张学友','2017-04-23','科员',15000,0.00,20),
('王斐','2011-08-24','经理',18000,0.10,20),
('刘能','2014-03-18','科长',15000,0.15,10),
('黛玉','2016-09-29','总经理',22800,0.20,30),
('刘德华','2016-09-12','经理',21000,0.10,10),
('赵本山','2018-12-30','科长',17500,0.00,20),
('王宝强','2018-08-22','科员',8000,0.20,10);
SELECT * FROM employee WHERE job='总经理';
SELECT * FROM employee WHERE salary>16000;
SELECT * FROM employee WHERE salary BETWEEN 15000 AND 20000;
SELECT * FROM employee WHERE detno in (10,20);
SELECT * FROM employee WHERE job in ('总经理','经理');
SELECT * FROM employee WHERE uname LIKE'%王%';
SELECT uid,uname,dname FROM employee,department WHERE employee.detno=department.deptno;

CREATE DATABASE db1;
USE db1;
CREATE TABLE tb_class(
cid INT PRIMARY KEY,
cname VARCHAR(50) NOT NULL
);
CREATE TABLE tb_stu(
id INT PRIMARY KEY auto_increment,
name VARCHAR(20),
age INT,
sex VARCHAR(10),
scid INT,
CONSTRAINT lhlhl FOREIGN KEY (scid) REFERENCES tb_class(cid)
);
INSERT INTO tb_class(cid,cname)
VALUES(101,'3A班'),
(102,'7C班'),
(103,'未知');
INSERT INTO tb_stu(name,age,sex,scid)
VALUES('付林泽',18,'男',101),
('田世旋',18,'男',101),
('刘佳美',17,'女',101),
('朱旭东',19,'男',102),
('孙晓虎',20,'男',102),
('狄超',16,'男',102);
SELECT * FROM tb_stu;
SELECT id,name,age FROM tb_stu;
SELECT * FROM tb_stu WHERE age=18 AND id=1;
SELECT * FROM tb_stu WHERE id in(1,3,4);
SELECT * FROM tb_stu WHERE name='朱旭东' OR age=18;
SELECT COUNT(*) FROM tb_stu;
SELECT MAX(age),cid,MAX(age) FROM tb_class,tb_stu WHERE tb_class.cid=tb_stu.scid GROUP BY cid;
SELECT sex,COUNT(*) FROM tb_stu GROUP BY sex;
SELECT name,age,scid FROM tb_stu WHERE age<(SELECT avg(age) FROM tb_stu);
SELECT id,name,sex,cname FROM tb_stu LEFT JOIN tb_class ON tb_stu.scid=tb_class.cid;

CREATE DATABASE db1;
USE db1;
CREATE TABLE tb_class(
cid INT PRIMARY KEY,
cname VARCHAR(50) NOT NULL
);
CREATE TABLE tb_stu(
id INT PRIMARY KEY auto_increment,
name VARCHAR(20),
age INT,
sex VARCHAR(10),
scid INT,
CONSTRAINT lhlhl FOREIGN KEY (scid) REFERENCES tb_class(cid)
);
INSERT INTO tb_class(cid,cname)
VALUES(10,'A班'),
(20,'B班'),
(30,'C班');
INSERT INTO tb_stu(name,age,sex,scid)
VALUES('张三',18,'男',10),
('张哈哈',18,'男',10),
('刘佳美',17,'女',10),
('王五',19,'男',20),
('赵六子',20,'女',10),
('狄超',16,'男',30);
SELECT * FROM tb_stu;
SELECT name,age FROM tb_stu;
SELECT * FROM tb_stu WHERE age=18 AND sex='男';
SELECT * FROM tb_stu WHERE id in(2,3,4);
SELECT * FROM tb_stu WHERE name LIKE'张%';
SELECT COUNT(*) FROM tb_stu;
SELECT MAX(age),cid,MAX(age) FROM tb_class,tb_stu WHERE tb_class.cid=tb_stu.scid GROUP BY cid;
SELECT sex,COUNT(*) FROM tb_stu GROUP BY sex;
SELECT name,age,scid FROM tb_stu WHERE age<(SELECT avg(age) FROM tb_stu);
SELECT id,name,sex,cname FROM tb_stu LEFT JOIN tb_class ON tb_stu.scid=tb_class.cid;

CREATE DATABASE db1;
USE db1;
CREATE TABLE tb_scores(
id INT PRIMARY KEY auto_increment,
score FLOAT(7,2),
grade VARCHAR(30)
);
CREATE TABLE tb_student(
id INT PRIMARY KEY auto_increment,
name VARCHAR(20) NOT NULL,
sid INT,
CONSTRAINT lglgl FOREIGN KEY (sid) REFERENCES tb_scores(id)
);
INSERT INTO tb_scores(score,grade)
VALUES(89.00,'良好'),
(100.00,'优秀'),
(77.00,'良好'),
(69.00,'良好'),
(59.00,'不及格'),
(30.00,'不及格');
INSERT INTO tb_student(name,sid)
VALUES('张三',1),
('李四',2),
('王五',4),
('赵六',6),
('张泽鹏',5),
('申振锋',4),
('刘雨',3),
('吴浪',3),
('吴凯',1),
('魏强',2);
SELECT * FROM tb_student;
SELECT id,name FROM tb_student LIMIT 2,6;
SELECT * FROM tb_student WHERE name LIKE'张%';
SELECT tb_student.id,name,score FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid ORDER BY score;
SELECT score,COUNT(*) FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid GROUP BY tb_scores.id;
SELECT tb_scores.id,score,grade FROM tb_scores WHERE score  BETWEEN 70 AND 90;
SELECT grade,MIN(score) FROM tb_scores GROUP BY grade;
SELECT tb_student.id,name,score,grade FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid WHERE score BETWEEN 70 AND 90;
SELECT tb_student.id,name,score FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid ORDER BY score ASC LIMIT 1;
SELECT grade,COUNT(*) FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid WHERE tb_scores.id=2;

CREATE DATABASE db1;
USE db1;
CREATE TABLE tb_scores(
id INT PRIMARY KEY auto_increment,
score FLOAT(7,2),
grade VARCHAR(30)
);
CREATE TABLE tb_student(
id INT PRIMARY KEY auto_increment,
name VARCHAR(20) NOT NULL,
sid INT,
CONSTRAINT lglgl FOREIGN KEY (sid) REFERENCES tb_scores(id)
);
INSERT INTO tb_scores(score,grade)
VALUES(89.00,'良好'),
(100.00,'优秀'),
(77.00,'良好'),
(69.00,'良好'),
(59.00,'不及格'),
(30.00,'不及格');
INSERT INTO tb_student(name,sid)
VALUES('张三',1),
('李四',2),
('王五',4),
('赵六',6),
('张泽鹏',5),
('申振锋',4),
('刘雨',3),
('吴浪',3),
('吴凯',1),
('魏强',2);
SELECT * FROM tb_student;
SELECT * FROM tb_student WHERE name LIKE'张%';
SELECT sid,name FROM tb_student ;
SELECT id,name,sid FROM tb_student ORDER BY sid asc;
SELECT COUNT(*) FROM tb_student;
SELECT tb_scores.id,score,grade FROM tb_scores WHERE score  BETWEEN 80 AND 100;
SELECT grade,SUM(score),avg(score),MAX(score),MIN(score) FROM tb_scores GROUP BY grade;
SELECT tb_student.id,name,score,grade FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid;
SELECT tb_student.id,name,score FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid WHERE score=(SELECT MAX(score) FROM tb_scores);
SELECT tb_student.id,name,score,grade FROM tb_scores INNER JOIN tb_student ON tb_scores.id=tb_student.sid WHERE grade in('优秀','良好');

CREATE DATABASE db1;
USE db1;
CREATE TABLE tb_dept(
deptno INT PRIMARY KEY ,
dname VARCHAR(30),
loc VARCHAR(40)
);
CREATE TABLE tb_emp(
empno INT,
ename VARCHAR(30),
job VARCHAR(20),
mgr INT,
hiredate date,
sal INT,
comm INT,
deptno INT,
CONSTRAINT lflf FOREIGN KEY (deptno) REFERENCES tb_dept(deptno)
);
INSERT INTO tb_dept(deptno,dname,loc)
VALUES(10,'ACCOUNTING','NEW YORK'),
(20,'RESEARCH','DALLAS'),
(30,'SALES','CHICAGO'),
(40,'OPERATIONS','BOSTON');
INSERT INTO tb_emp(empno,ename,job,mgr,hiredate,sal,comm,deptno)
VALUES(7369,'SSMITH','CLERK',7902,'1980-12-17',880,NULL,20),
(7499,'ALLEN','SALESMAN',7698,'1981-02-20',1760,300,30),
(7521,'WARD','SALESMAN',7698,'1981-02-22',1375,500,30),
(7566,'JONES','MANAGER',7839,'1981-04-02',3273,NULL,20),
(7654,'MARTIN','SALESMAN',7698,'1981-09-28',1375,1400,30);
SELECT * FROM tb_emp;
SELECT empno,ename,deptno FROM tb_emp;
SELECT ename,sal+500 FROM tb_emp;
SELECT ename,sal FROM tb_emp WHERE sal<1000 OR sal>3000;
SELECT ename,sal FROM tb_emp WHERE job='SALESMAN';
SELECT ename FROM tb_emp WHERE sal>1500;
SELECT * FROM tb_emp WHERE hiredate LIKE'1981%';
SELECT * FROM tb_emp WHERE sal=(SELECT MAX(sal) FROM tb_emp);
SELECT * FROM tb_emp WHERE sal<(SELECT avg(sal) FROM tb_emp);
SELECT empno,ename,job,dname FROM  tb_emp LEFT JOIN tb_dept ON tb_emp.deptno=tb_dept.deptno;

CREATE DATABASE css;
USE css;
CREATE TABLE grade(
xingming VARCHAR(20),
yingyu INT,
shuxue INT,
yuwen INT
);
CREATE TABLE stuinfo(
zhaunye VARCHAR(20),
banji  VARCHAR(20),
xingming  VARCHAR(30),
xingbie  VARCHAR(20),
zuowei  INT
);
CREATE TABLE jilu(
xingming1 VARCHAR(20),
jilu1 VARCHAR(30)
);
INSERT INTO grade(xingming,yingyu,shuxue,yuwen)
VALUES('侯玉婷',64,85,45),
('里克特',62,40,16),
('王舍城',35,9,27),
('MARY',50,71,2),
('普利策',85,60,58),
('COCO',66,87,70);
INSERT INTO stuinfo(zhaunye,banji,xingming,xingbie,zuowei)
VALUES('相声','1班','侯玉婷','男',8),
('软件工程','2班','里克特','男',12),
('小品','1班','王舍城','男',9),
('相声','2班','MARY','女',15),
('软件工程','1班','普利策','男',20),
('小品','1班','COCO','女',18);
INSERT INTO jilu(xingming1,jilu1)
VALUES('里克特','迟到'),
('里克特','事假'),
('王舍城','旷课'),
('王舍城','旷课'),
('王舍城','迟到'),
('COCO','病假'),
('普利策','事假');
UPDATE grade SET yuwen=20 WHERE xingming='里克特';
SELECT avg(yingyu),avg(shuxue),avg(yuwen) FROM grade,stuinfo WHERE grade.xingming=stuinfo.xingming AND banji='1班';
SELECT * FROM grade WHERE yingyu<60 AND shuxue<60 and yuwen<60;
select (yingyu+shuxue+yuwen)/3,xingming from grade where xingming in  (select xingming1 from jilu group by xingming1 having count(*) >=2);
SELECT xingming,yuwen+yingyu+shuxue AS '总分' ,(yingyu+shuxue+yuwen)/3 AS '平均分' FROM grade WHERE (yingyu+shuxue+yuwen)/3>60;
SELECT avg(yingyu),avg(shuxue),avg(yuwen) FROM grade;
SELECT xingming,yingyu,shuxue,yuwen FROM grade INNER JOIN jilu ON grade.xingming=jilu.xingming1 WHERE xingming in(SELECT xingming1 FROM jilu WHERE jilu1='旷课') GROUP BY xingming;

CREATE DATABASE TDB;
USE TDB;
CREATE TABLE TS(
number INT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
sex VARCHAR(4),
depno INT,
salary FLOAT,
address VARCHAR(100)
);
CREATE TABLE part(
depno INT(10) PRIMARY KEY,
depname VARCHAR(20) NOT NULL,
depnote VARCHAR(50)
);
INSERT INTO ts(number,name,sex,depno,salary,address)
VALUES(201,'Tom','女',602,4500,'河北省石家庄'),
(202,'Lucy','男',601,2500,'日照市东港区'),
(203,'Mike','男',604,1500,'山西运城'),
(204,'James','女',602,3500,'内蒙古包头'),
(205,'Jack','男',605,1200,'台湾台北');
INSERT INTO part(depno,depname,depnote)
VALUES(601,'软件技术系','软件技术等专业'),
(602,'网络技术系','多媒体技术等专业'),
(605,'艺术设计系','广告艺术设计等专业'),
(604,'管理工程系','连锁经营管理等专业');
UPDATE ts SET salary=salary+400 WHERE depno=605;
SELECT number AS '教工号',depno AS '部门号' FROM ts WHERE address LIKE'%包头%';
SELECT MIN(number),name FROM ts;
SELECT sex,avg(salary) FROM ts GROUP BY sex;
SELECT name,depname FROM ts,part WHERE ts.depno=PART.depno AND sex='男';

CREATE DATABASE stu_course;
USE stu_course;
CREATE TABLE student(
id INT PRIMARY KEY auto_increment,
name VARCHAR(40),
sex VARCHAR(10),
age INT,
dept VARCHAR(20)
);
CREATE TABLE course(
id INT PRIMARY KEY auto_increment,
name VARCHAR(40),
credit INT
);
CREATE TABLE score(
sid INT,
cid INT,
grade INT,
CONSTRAINT lolol FOREIGN KEY(cid) REFERENCES course(id),
CONSTRAINT lplp FOREIGN KEY (sid) REFERENCES student(id)
);
ALTER TABLE student auto_increment=1001;
INSERT INTO student(name,sex,age,dept)
VALUES('张三','男',18,'精英班'),
('李四','男',19,'物联网'),
('王五','女',20,'大数据'),
('赵六','男',17,'精英班'),
('李红','女',18,'全栈');
INSERT INTO course(name,credit)
VALUES('C语言',10),
('数据库',9),
('java',7),
('网页设计',7),
('计算机基础',5);
INSERT INTO score(sid,cid,grade)
VALUES(1001,1,90),
(1001,2,85),
(1002,2,60),
(1003,3,45),
(1004,3,55),
(1005,1,80);
ALTER TABLE student ADD come date;
SELECT sid,grade FROM score WHERE cid=3 ORDER BY grade DESC;
SELECT MAX(grade),avg(grade) FROM score WHERE cid=1;
SELECT name FROM student WHERE dept in(SELECT dept FROM student WHERE name='张三') AND name!='张三';
SELECT avg(grade) FROM course,score WHERE course.id=score.cid AND name='C语言';
SELECT name FROM course,score WHERE course.id=score.cid AND id in (SELECT cid FROM score GROUP BY cid HAVING avg(grade)>60) GROUP BY name;
SELECT name,MAX(grade),MIN(grade) FROM course,score WHERE course.id=score.cid  GROUP BY name;
SELECT avg(grade) FROM student,score WHERE student.id=score.sid AND sid in(SELECT id FROM student WHERE name LIKE'李%');

CREATE TABLE guyuan(
gid INT PRIMARY KEY auto_increment,
gname VARCHAR(40),
gsex VARCHAR(10),
gtitle VARCHAR(60),
gbirthday date,
bid INT,
CONSTRAINT lklk FOREIGN KEY(bid) REFERENCES bumen(bid)
);
CREATE TABLE bumen(
bid INT PRIMARY KEY,
bname VARCHAR(20),
bumenjianjie VARCHAR(30)
);
CREATE TABLE salary(
gid INT PRIMARY KEY,
basesalary INT,
titlesalary INT,
deduction INT
);
ALTER TABLE guyuan auto_increment=1001;
INSERT INTO guyuan(gname,gsex,gtitle,gbirthday,bid)
VALUES('张三','男','高级程师','1975-1-1',1111),
('李四','女','助工','1985-1-1',1111),
('王五','男','工程师','1978-11-11',2222),
('赵六','男','工程师','1979-1-1',2222);
INSERT INTO bumen(bid,bname)
VALUES(1111,'生产部'),
(2222,'销售部'),
(3333,'人事部');
insert INTO salary(gid,basesalary,titlesalary,deduction)
VALUES(1001,2200,1100,200),
(1002,1200,200,100),
(1003,1900,700,200),
(1004,1950,700,150);
UPDATE guyuan,salary,bumen WHERE guyuan.gid=salary.gid AND guyuan.bid=bumen.bid SET gtitle='高级工程师'，basesalary=2700,titlesalary=800  WHERE gname='李四';
DELETE FROM bumen WHERE bname='人事部';
SELECT gid,basesalary+titlesalary-deduction AS '实发工资',basesalary+titlesalary AS '应发工资' FROM salary;
SELECT * FROM guyuan WHERE gname LIKE'李%' AND gbirthday>1979;
SELECT salary.gid,gname,gtitle,bname,basesalary+titlesalary-deduction AS '实发工资' FROM guyuan,salary,bumen WHERE guyuan.gid=salary.gid AND guyuan.bid=bumen.bid;
SELECT gname,basesalary+titlesalary-deduction AS '工资' FROM guyuan,salary WHERE guyuan.gid=salary.gid;
SELECT gtitle,COUNT(*) FROM guyuan GROUP BY gtitle;

create DATABASE XSGL;
USE XSGL;
CREATE TABLE student(
sno INT PRIMARY KEY auto_increment,
sname VARCHAR(40),
ssex VARCHAR(10),
sage INT,
sdept VARCHAR(20)
);
CREATE TABLE course(
cno INT PRIMARY KEY auto_increment,
cname VARCHAR(40),
ccredit INT
);
CREATE TABLE score(
sno INT,
cno INT,
grade INT,
CONSTRAINT lolol FOREIGN KEY(cno) REFERENCES course(cno),
CONSTRAINT lplp FOREIGN KEY (sno) REFERENCES student(sno)
);
ALTER TABLE student auto_increment=1001;
INSERT INTO student(sname,ssex,sage,sdept)
VALUES('张三','男',22,'软件工程'),
('李四','男',19,'物联网'),
('王五','女',20,'软件工程'),
('赵六','男',23,'精英班'),
('李红','女',18,'全栈');
INSERT INTO course(cname,ccredit)
VALUES('C语言',10),
('数据库',9),
('java',7),
('网页设计',7),
('计算机基础',5);
INSERT INTO score(sno,cno,grade)
VALUES(1001,1,90),
(1001,2,85),
(1002,2,60),
(1003,3,45),
(1004,3,55),
(1005,1,80);
SELECT sno,sname FROM student;
SELECT sname,sno,sdept FROM student;
SELECT * FROM student,course,score WHERE student.sno=score.sno AND score.cno=course.cno;
SELECT sname,sage FROM student;
SELECT * FROM student WHERE sdept='软件工程';
SELECT sname,sage FROM student WHERE sage<20;
SELECT sno,cno FROM score WHERE grade<60;
SELECT sname,sdept,sage FROM student WHERE sage BETWEEN 20 AND 23;
SELECT sname,ssex FROM student WHERE sdept not in ('物联网','全栈','软件工程');