jsp学生管理系统源程序
1.创建数据库：CREATE DATABASE db_swms CHARSET gbk;
2.运行com.swms.util.CreateTable自动建表。
3.直接右键运行。
4.如果新建数据库/表，为了保证本文源自优文论文网能登陆，向数据库插入一条记录。
INSERT INTO db_swms.tb_admin (a_username, a_password, a_status) VALUES('admin', 'admin', '0');
*.备用数据SQL，演示时可向表中插入数据。
CREATE DATABASE /*!32312 IF NOT EXISTS*/`db_swms` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `db_swms`;
/*Data for the table `tb_admin` */
insert into `tb_admin`(a_id,a_username,a_password,a_status) values (1,'admin','admin','0');
/*Data for the table `tb_classes` */
insert into `tb_classes`(cl_id,cl_NO,cl_name,cl_count,cl_adviser,cl_gradeId,cl_specialityId) values (1,'2006080013','计科0603班',49,'刘德华',1,1),(2,'2006080014','计科0604班',51,'张学友',1,1);
/*Data for the table `tb_course` */
insert into `tb_course`(c_id,c_NO,c_name,c_credit) values (1,'1564156','C语言',2.5),(2,'2534564','C++',3),(3,'256465','高等数学',3);
/*Data for the table `tb_enterprise` */
insert into `tb_enterprise`(e_id,e_name,e_tel,e_address,e_intro) values (1,'华为','02085411655','广州','软件'),(2,'思科','075502341654','深圳','网络'),(3,'百度','010213484512','北京','搜索引擎');
/*Data for the table `tb_evaluation` */
insert into `tb_evaluation`(el_id,el_morals,el_intellect,el_sport,el_ability,el_avgPoint,el_totalPoint,el_rank,el_level,el_termId,el_studentId) values (1,23,54.5,9.2,12.5,84,86.7,'3','优',1,1),(2,15,15,15,15,15,15,'15','良',2,2);
/*Data for the table `tb_faculty` */
insert into `tb_faculty`(f_id,f_NO,f_name) values (1,'08','计算机与通信工程系'),(2,'01','中国语言文学系');
/*Data for the table `tb_grade` */
insert into `tb_grade`(g_id,g_NO,g_name) values (1,'2006','06级'),(2,'2007','07级'),(3,'2008','08级'),(4,'2009','09级');
/*Data for the table `tb_practice` */
insert into `tb_practice`(p_id,p_NO,p_type,p_content,p_mark,p_remarks,p_enterpriseId) values (1,'05418516','工作','软件工程师','80','不错',1),(2,'26549265','工作','网络工程师','95','很好',1);毕业论文http://www.Lwfree.cn/ 论文网http://www.Lwfree.com/
/*Data for the table `tb_record` */
insert into `tb_record`(r_id,r_exam,r_makeup,r_rebuild,r_studentId,r_courseId) values (1,80,0,0,1,1),(2,95,0,0,2,2);
/*Data for the table `tb_speciality` */
insert into `tb_speciality`(sp_id,sp_NO,sp_name,sp_facultyId) values (1,'001','计算机科学与技术',1),(2,'002','通信工程',1),(3,'001','汉语言文学',2);
/*Data for the table `tb_student` */
insert into `tb_student`(s_id,s_NO,s_password,s_name,s_gender,s_birthday,s_nation,s_politicalStatus,s_origin,s_IDcardNO,s_tel,
s_email,s_mark,s_duty,s_status,s_classesId) values (1,'200608001325','132456','李小龙','男','1987-06-15','汉','党员','广东','410324548540323515','135485481325','bruce_lee@hotmail.com',46,'班长','2',1),(2,'200608001306','132456','黄晓明','男','1988-06-23','汉','团员','上海','451321548623536165','18941548484','xiaoming@163.com',45,'团支书','2',1),(3,'200708001210','123465','吴小莉','女','1987-06-11','汉','团员','江西','41202135461615663','12335415454','xiaoli@yahoo.cn',34,'无','2',1);
/*Data for the table `tb_syllabus` */
insert into `tb_syllabus`(sy_id,sy_name,sy_termId,sy_classesId,sy_courseId) values (1,'06-07上期计科0603C',1,1,1),(2,'06-07上期计科0604G',1,2,3),(3,'06-07上期计科0604C',1,2,2);
/*Data for the table `tb_teacher` */
/*Data for the table `tb_term` */
insert into `tb_term`(te_id,te_name) values (1,'2006-2007上期'),(2,'2007-2008上期'),(3,'2009-2010下期');
/*Data for the table `tb_work` */
insert into `tb_work`(w_id,w_NO,w_place,w_trade,w_job,w_salary,w_enterpriseId) values (1,'2654621','北京','软件','软件工程师',3500,3),(2,'2654684','深圳','IT','网络工程师',2500,2);1323