2021能看的网站免费的知乎,黄冈网站建设有哪些,网站应具有的功能模块,美食网站建设方案一、源码特点 jsp 学生学籍管理系统是一套完善的java web信息管理系统#xff0c;对理解JSP java编程开发语言有帮助#xff0c;系统具有完整的源代码和数据库#xff0c;系统主要采用B/S模式开发。开发环境为TOMCAT7.0,Myeclipse8.5开发#xff0c;数据库为sqlserver2…一、源码特点 jsp 学生学籍管理系统是一套完善的java web信息管理系统对理解JSP java编程开发语言有帮助系统具有完整的源代码和数据库系统主要采用B/S模式开发。开发环境为TOMCAT7.0,Myeclipse8.5开发数据库为sqlserver2008使用java语言开发。 java Web学生学籍管理系统 二、功能介绍 主要功能包括 (1)用户管理对用户信息进行添加、删除、修改和查看 (2)班级管理对班级信息进行添加、删除、修改和查看 (3)学年管理对学年信息进行添加、删除、修改和查看 (4)学生管理对学生信息进行添加、删除、修改和查看 (5)转班管理对转班信息进行添加、删除、修改和查看 (6)转校管理对转校信息进行添加、删除、修改和查看 (7)休学管理对休学信息进行添加、删除、修改和查看 (8)复学管理对复学信息进行添加、删除、修改和查看 (9)退学管理对退学信息进行添加、删除、修改和查看 10个人信息修改
数据库设计
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[lxdh] [VARCHAR](40),
[lxdz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNyhm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN密码 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNmm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN姓名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNxm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系电话 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNlxdh
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN联系地址 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNyonghu, level2typeNCOLUMN, level2nameNlxdz
BEGIN
CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
[bj] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN班级 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNbanji, level2typeNCOLUMN, level2nameNbj
BEGIN
CREATE TABLE [dbo].[xuenian]([xnid] [int] IDENTITY(1,1) NOT NULL,
[xn] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学年 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuenian, level2typeNCOLUMN, level2nameNxn
BEGIN
CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[nl] [VARCHAR](40),
[bj] [VARCHAR](40),
[xn] [VARCHAR](40),
[zt] [VARCHAR](40),
[xb] [VARCHAR](40),
[csrq] [VARCHAR](40),
[yx] [VARCHAR](40),
[xx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN用户名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNyhm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN密码 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNmm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN姓名 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNxm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN年龄 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNnl
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN班级 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNbj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学年 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNxn
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN状态 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNzt
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN性别 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNxb
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN出生日期 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNcsrq
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN院系 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNyx
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学校 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxuesheng, level2typeNCOLUMN, level2nameNxx
BEGIN
CREATE TABLE [dbo].[zhuanban]([zbid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[xbj] [VARCHAR](40),
[zrsj] [VARCHAR](40),
[zrsm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学生 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanban, level2typeNCOLUMN, level2nameNxs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN新班级 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanban, level2typeNCOLUMN, level2nameNxbj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN转入时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanban, level2typeNCOLUMN, level2nameNzrsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN转入说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanban, level2typeNCOLUMN, level2nameNzrsm
BEGIN
CREATE TABLE [dbo].[zhuanxiao]([zxid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[xxxmc] [VARCHAR](40),
[zcsj] [VARCHAR](40),
[zcyy] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学生 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanxiao, level2typeNCOLUMN, level2nameNxs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN新学校名称 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanxiao, level2typeNCOLUMN, level2nameNxxxmc
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN转出时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanxiao, level2typeNCOLUMN, level2nameNzcsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN转出原因 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNzhuanxiao, level2typeNCOLUMN, level2nameNzcyy
BEGIN
CREATE TABLE [dbo].[xiuxue]([xxid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[xxyy] [VARCHAR](40),
[xxsj] [VARCHAR](40),
[bzsm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学生 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxiuxue, level2typeNCOLUMN, level2nameNxs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN休学原因 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxiuxue, level2typeNCOLUMN, level2nameNxxyy
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN休学时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxiuxue, level2typeNCOLUMN, level2nameNxxsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN备注说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNxiuxue, level2typeNCOLUMN, level2nameNbzsm
BEGIN
CREATE TABLE [dbo].[fuxue]([fxid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[fxsj] [VARCHAR](40),
[fxsm] [VARCHAR](40),
[bzsm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学生 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNfuxue, level2typeNCOLUMN, level2nameNxs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN复学时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNfuxue, level2typeNCOLUMN, level2nameNfxsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN复学说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNfuxue, level2typeNCOLUMN, level2nameNfxsm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN备注说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNfuxue, level2typeNCOLUMN, level2nameNbzsm
BEGIN
CREATE TABLE [dbo].[tuixue]([txid] [int] IDENTITY(1,1) NOT NULL,
[xs] [VARCHAR](40),
[txsj] [VARCHAR](40),
[txsm] [VARCHAR](40),
[bzsm] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN学生 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNtuixue, level2typeNCOLUMN, level2nameNxs
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN退学时间 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNtuixue, level2typeNCOLUMN, level2nameNtxsj
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN退学说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNtuixue, level2typeNCOLUMN, level2nameNtxsm
GO
EXEC sys.sp_addextendedproperty nameNMS_Description, valueN备注说明 ,level0typeNSCHEMA, level0nameNdbo, level1typeNTABLE, level1nameNtuixue, level2typeNCOLUMN, level2nameNbzsm
代码设计 String keyid (String)request.getParameter(keyid);
String xs(String)request.getParameter(xs);//变量:学生
String fxsj(String)request.getParameter(fxsj);//变量:复学时间
String fxsm(String)request.getParameter(fxsm);//变量:复学说明
String bzsm(String)request.getParameter(bzsm);//变量:备注说明String sql;//声明sqlint row1;///定义执行结果try{sqlupdate xuesheng set zt正常 where yhmxs;
db.update(sql);sqlinsert into fuxue(xs,fxsj,fxsm,bzsm) values(xs,fxsj,fxsm,bzsm);
;//复学SQL 语句//int row 0;rowdb.update(sql);
}catch(Exception e){
System.out.println(e.toString());}
if(row1){
out.println(script);
out.println(alert(操作成功););
out.println(window.locationfuxueadd.jsp); 三、注意事项 1、管理员账号admin密码admin 数据库配置文件DBO.java 2、开发环境为TOMCAT7.0,Myeclipse8.5开发数据库为sqlserver2008使用java语言开发。 3、数据库文件名是jspxsxj.sql 系统名称xsxj 4、系统首页地址http://127.0.0.1:8080/xsxj
四 系统实现 下载地址
https://download.csdn.net/download/qq_41221322/89187508
需要源码 其他的定制服务 下方联系卡片↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓↓
