基于Java的软件学院本科生信息管理系统设计源码

CREATE TABLE XJCARD( Sno VARCHAR(10) NOT NULL PRIMARY KEY, Cno VARCHAR(10), Mname VARCHAR(20), name VARCHAR(20), sex VARCHAR(10), Ename VARCHAR(20), birth DATE, marry bit, tel VARCHAR(20), political VARCHAR(20), jiguan VARCHAR(100), rudangDate DATE, mingzu VARCHAR(20), xingshi VARCHAR(20), cengci VARCHAR(20), waiyu VARCHAR(20), address VARCHAR(100), huoche VARCHAR(50), youzheng VARCHAR(20), hometel VARCHAR(20), lianxiren VARCHAR(20), ruxuedate DATE, ruxuekaohao VARCHAR(20), shenfenzheng VARCHAR(20), biyedate DATE, biyezhengshu VARCHAR(20), xueshizheng VARCHAR(20), ); CREATE TABLE XJCARDmember( Sno VARCHAR(10) not NULL, membername VARCHAR(20), memberrela VARCHAR(20), memberdanwei VARCHAR(100), memberzhiwu VARCHAR(20), Smno VARCHAR(10) NOT NULL PRIMARY KEY, ); CREATE TABLE STUDYEXP( Sno VARCHAR(10) NOT NULL PRIMARY KEY, xuexiqz DATE, xuexidanwei VARCHAR(100), xuexizhiwu VARCHAR(20), xuejileibie VARCHAR(20), xuejiyuanyin VARCHAR(50), xuejidate DATE, xuejiyuanxi VARCHAR(50), xuejizhuanye VARCHAR(50), xuejinianji VARCHAR(10), jiangliniandu VARCHAR(30), jianglimingchen VARCHAR(50), jianglidanwei VARCHAR(50), jianglidengji VARCHAR(20), chufenriqi DATE, chufenmingchen VARCHAR(50), chufendanwei VARCHAR(50), chufenyuanyin VARCHAR(50), ); INSERT INTO XJCARD(Sno,Cno,Mname,name,sex,Ename,birth,marry,tel,political,jiguan,mingzu,xingshi,cengci,address,huoche,youzheng,hometel,lianxiren,ruxuedate,ruxuekaohao,shenfenzheng) values('21201334', '212013', '软件工程', '朱晓栋', '女', 'Zhu', '2002-10-21', '0', '19179149875', '共青团员', '江西省上饶市', '汉族', '全日制', '高中', '江西省九江市', '江西省九江市', '333222', '19191919191', '陈志朋', '2021-09-09', '1122334455', '363636363636363636'); INSERT INTO XJCARDmember(sno,membername,memberrela,memberdanwei,memberzhiwu) values('21201334', '陈志朋', '母女', '江西省九江市', '织物'); CREATE TABLE ZZY( Sno VARCHAR(10) NOT NULL PRIMARY KEY, Cno VARCHAR(10), Mname VARCHAR(20), name VARCHAR(20), sex VARCHAR(10), tel VARCHAR(20), ZRZY VARCHAR(20), ZRXY VARCHAR(20), ZZYreason VARCHAR(400), SQdate DATE, XFJ VARCHAR(10), ZYPM VARCHAR(10), ZYRS VARCHAR(5), ZYPML VARCHAR(10), ZCJWYYJ VARCHAR(200), ZCJWY VARCHAR(20), ZCJWYdate DATE, ZCXYYJ VARCHAR(200), ZCFGJXLS VARCHAR(20), ZCFGJXLSdate DATE, BRclass VARCHAR(20), BRFX VARCHAR(20), ZRJWY VARCHAR(20), ZRJWYdate DATE, ZRFGJXLSYJ VARCHAR(200), ZRFGJXLS VARCHAR(20), ZRFGJXdate DATE, JWCYJ VARCHAR(200), JWCLS VARCHAR(20), JWCdate DATE, ); 判断的话 从用户ID存过来，显示界面就在这开始 通过判断 老师有没有签字 有没有日期 来判断是不是完成了