fuzhucheng / studentmanagement Goto Github PK

//学生表
CREATE TABLE student(
STID INT AUTO_INCREMENT PRIMARY KEY,
STNAME VARCHAR(20),
STSEX VARCHAR(10),
STAGE VARCHAR(10),
STPHONE VARCHAR(20)
);
//管理员表，起这个名我们要注意到，我们在工厂的bean类名为：UserStudent。这两者是必须对应的。
CREATE TABLE userstudent(
userid VARCHAR(30) PRIMARY KEY,
name VARCHAR(30),
password VARCHAR(32)
);
//测试数据
INSERT INTO userstudent(userid,name,password) VALUES ('fuzhu','fuzhu','751197996');
INSERT INTO student(STID,STNAME,STSEX,STAGE,STPHONE) VALUES (123,'fuzhufuzhu',boy','20','13531477062');

Contributors

Stargazers

Forkers

zongpang zxw854953678 diablohl xuzhemin926 donggrui wuziri lzj249200 creepww gangyf awan1314 lijinghao1997 liuguanghua11 morrischeng z5x54 qg-fly loustrong wangdande sjl421 sqmd rmice qq172837 yeyudie zhangylz lty1994 shirleywan ybgitcom xiehouqing 2804422821 leihao666 yclipd dy1213 yeprobot ritabai yfan97 linluzhang liuyueit arrayway soyeonqwq maplestorykidd ritazz liuminghu bugess whb20162195 mysteriouselement zhwniceshoot jiexiliu linyup zengjxrsingstar quqqyh wangnextdoor777 ylslash coder-andy96 lifazhan123 hys4248 yrhero 1814371623 kevinjames12 never9079 dudiaoyunhai still-rise thunder-lei-merit yasiruofficial hr82521 gdx555 onedang afterglow-g saki0504 huangyiyu zxknpu jiuyuan9 devsoftbank lk46 zore2infinity lwwwc xht1118 hlnzgsm apokerman dragonuzi hahagioi998 2yyl mamata2507 xudongnini hiteshbedre supershans zhonghfei greg11a dear-zz 66rlyy dhkjyz leinata-ya lebniz666 vdsmitnov52