• 【1569】jsp学生学籍管理系统Myeclipse开发sqlserver数据库web结构jsp编程计算机网页项目

    一、源码特点
        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）个人信息修改

    数据库设计

    1. BEGIN
    2. CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
    3. [yhm] [VARCHAR](40),
    4. [mm] [VARCHAR](40),
    5. [xm] [VARCHAR](40),
    6. [lxdh] [VARCHAR](40),
    7. [lxdz] [VARCHAR](40),
    8. ) ON [PRIMARY]
    9. END
    10. GO
    11. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'yhm'
    12. GO
    13. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'mm'
    14. GO
    15. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'xm'
    16. GO
    17. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'lxdh'
    18. GO
    19. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'联系地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'lxdz'
    20. BEGIN
    21. CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
    22. [bj] [VARCHAR](40),
    23. ) ON [PRIMARY]
    24. END
    25. GO
    26. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'bj'
    27. BEGIN
    28. CREATE TABLE [dbo].[xuenian]([xnid] [int] IDENTITY(1,1) NOT NULL,
    29. [xn] [VARCHAR](40),
    30. ) ON [PRIMARY]
    31. END
    32. GO
    33. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学年' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuenian', @level2type=N'COLUMN', @level2name=N'xn'
    34. BEGIN
    35. CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
    36. [yhm] [VARCHAR](40),
    37. [mm] [VARCHAR](40),
    38. [xm] [VARCHAR](40),
    39. [nl] [VARCHAR](40),
    40. [bj] [VARCHAR](40),
    41. [xn] [VARCHAR](40),
    42. [zt] [VARCHAR](40),
    43. [xb] [VARCHAR](40),
    44. [csrq] [VARCHAR](40),
    45. [yx] [VARCHAR](40),
    46. [xx] [VARCHAR](40),
    47. ) ON [PRIMARY]
    48. END
    49. GO
    50. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'yhm'
    51. GO
    52. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'mm'
    53. GO
    54. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xm'
    55. GO
    56. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'年龄' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'nl'
    57. GO
    58. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'bj'
    59. GO
    60. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学年' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xn'
    61. GO
    62. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'zt'
    63. GO
    64. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xb'
    65. GO
    66. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出生日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'csrq'
    67. GO
    68. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'院系' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'yx'
    69. GO
    70. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学校' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xuesheng', @level2type=N'COLUMN', @level2name=N'xx'
    71. BEGIN
    72. CREATE TABLE [dbo].[zhuanban]([zbid] [int] IDENTITY(1,1) NOT NULL,
    73. [xs] [VARCHAR](40),
    74. [xbj] [VARCHAR](40),
    75. [zrsj] [VARCHAR](40),
    76. [zrsm] [VARCHAR](40),
    77. ) ON [PRIMARY]
    78. END
    79. GO
    80. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanban', @level2type=N'COLUMN', @level2name=N'xs'
    81. GO
    82. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanban', @level2type=N'COLUMN', @level2name=N'xbj'
    83. GO
    84. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'转入时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanban', @level2type=N'COLUMN', @level2name=N'zrsj'
    85. GO
    86. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'转入说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanban', @level2type=N'COLUMN', @level2name=N'zrsm'
    87. BEGIN
    88. CREATE TABLE [dbo].[zhuanxiao]([zxid] [int] IDENTITY(1,1) NOT NULL,
    89. [xs] [VARCHAR](40),
    90. [xxxmc] [VARCHAR](40),
    91. [zcsj] [VARCHAR](40),
    92. [zcyy] [VARCHAR](40),
    93. ) ON [PRIMARY]
    94. END
    95. GO
    96. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanxiao', @level2type=N'COLUMN', @level2name=N'xs'
    97. GO
    98. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'新学校名称' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanxiao', @level2type=N'COLUMN', @level2name=N'xxxmc'
    99. GO
    100. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'转出时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanxiao', @level2type=N'COLUMN', @level2name=N'zcsj'
    101. GO
    102. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'转出原因' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'zhuanxiao', @level2type=N'COLUMN', @level2name=N'zcyy'
    103. BEGIN
    104. CREATE TABLE [dbo].[xiuxue]([xxid] [int] IDENTITY(1,1) NOT NULL,
    105. [xs] [VARCHAR](40),
    106. [xxyy] [VARCHAR](40),
    107. [xxsj] [VARCHAR](40),
    108. [bzsm] [VARCHAR](40),
    109. ) ON [PRIMARY]
    110. END
    111. GO
    112. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xiuxue', @level2type=N'COLUMN', @level2name=N'xs'
    113. GO
    114. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'休学原因' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xiuxue', @level2type=N'COLUMN', @level2name=N'xxyy'
    115. GO
    116. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'休学时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xiuxue', @level2type=N'COLUMN', @level2name=N'xxsj'
    117. GO
    118. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xiuxue', @level2type=N'COLUMN', @level2name=N'bzsm'
    119. BEGIN
    120. CREATE TABLE [dbo].[fuxue]([fxid] [int] IDENTITY(1,1) NOT NULL,
    121. [xs] [VARCHAR](40),
    122. [fxsj] [VARCHAR](40),
    123. [fxsm] [VARCHAR](40),
    124. [bzsm] [VARCHAR](40),
    125. ) ON [PRIMARY]
    126. END
    127. GO
    128. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'fuxue', @level2type=N'COLUMN', @level2name=N'xs'
    129. GO
    130. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复学时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'fuxue', @level2type=N'COLUMN', @level2name=N'fxsj'
    131. GO
    132. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'复学说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'fuxue', @level2type=N'COLUMN', @level2name=N'fxsm'
    133. GO
    134. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'fuxue', @level2type=N'COLUMN', @level2name=N'bzsm'
    135. BEGIN
    136. CREATE TABLE [dbo].[tuixue]([txid] [int] IDENTITY(1,1) NOT NULL,
    137. [xs] [VARCHAR](40),
    138. [txsj] [VARCHAR](40),
    139. [txsm] [VARCHAR](40),
    140. [bzsm] [VARCHAR](40),
    141. ) ON [PRIMARY]
    142. END
    143. GO
    144. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tuixue', @level2type=N'COLUMN', @level2name=N'xs'
    145. GO
    146. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退学时间' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tuixue', @level2type=N'COLUMN', @level2name=N'txsj'
    147. GO
    148. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'退学说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tuixue', @level2type=N'COLUMN', @level2name=N'txsm'
    149. GO
    150. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注说明' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tuixue', @level2type=N'COLUMN', @level2name=N'bzsm'
    151.  
    152.

    代码设计

    1. 	String keyid =(String)request.getParameter("keyid");
    2. String xs=(String)request.getParameter("xs");//变量:学生
    3. String fxsj=(String)request.getParameter("fxsj");//变量:复学时间
    4. String fxsm=(String)request.getParameter("fxsm");//变量:复学说明
    5. String bzsm=(String)request.getParameter("bzsm");//变量:备注说明
    6.  
    7. String sql="";//声明sql
    8.  
    9. int row=1;///定义执行结果
    10. 		
    11. try{
    12.  
    13. 		sql="update xuesheng set zt='正常' where yhm='"+xs+"'";
    14. db.update(sql);
    15. 	
    16. 	 sql="insert into fuxue(xs,fxsj,fxsm,bzsm) values('"+xs+"','"+fxsj+"','"+fxsm+"','"+bzsm+"')";
    17. ;//复学SQL 语句
    18. 		//int row =0;
    19. 		row=db.update(sql);
    20. }catch(Exception e){
    21. System.out.println(e.toString());}
    22. if(row==1){
    23. out.println("