• JSP奖学金管理系统myeclipse开发sqlserver数据库bs框架java编程jdbc详细设计

    一、源码特点
         JSP 奖学金管理系统是一套完善的web设计系统，对理解JSP java编程开发语言有帮助，系统具有完整的源代码和数据库，开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为
    SQLSERVER2008，使用java语言开发，系统主要采用B/S模式开发。

    JSP奖学金管理系统myeclipse开发sqlserver数据库bs框架java编程jdbc-管理软件文档类资源-CSDN下载一、源码特点JSP奖学金管理系统是一套完善的web设计系统，对理解JSPjava编程开发语更多下载资源、学习资料请访问CSDN下载频道.https://download.csdn.net/download/qq_41221322/85807590

    JSP奖学金管理系统myeclipse开发sqlserver


    二、功能介绍
    (1)用户管理：对用户信息进行添加、删除、修改和查看
    (2)班级管理：对班级信息进行添加、删除、修改和查看
    (3)学生管理：对学生信息进行添加、删除、修改和查看
    (4)思想道德管理：对思想道德信息进行添加、删除、修改和查看
    (5)科目管理：对科目信息进行添加、删除、修改和查看
    (6)学生成绩管理：对学生成绩信息进行添加、删除、修改和查看
    (7)体育成绩管理：对体育成绩信息进行添加、删除、修改和查看
    (8)公寓卫生管理：对公寓卫生信息进行添加、删除、修改和查看
    (9)评定表管理：对评定表信息进行添加、删除、修改和查看
    (10)判定系数管理：对判定系数信息进行添加、删除、修改和查看
    (11)用户登录、退出，查看综合评定表
    系统具有三个角色 用户，学生，管理员，不同的角色，具有不同的操作权限

    数据库设计

    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. [qx] [VARCHAR](40),
    7. ) ON [PRIMARY]
    8. END
    9. GO
    10. 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'
    11. GO
    12. 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'
    13. GO
    14. 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'
    15. GO
    16. 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'qx'
    17. BEGIN
    18. CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
    19. [bj] [VARCHAR](40),
    20. [zy] [VARCHAR](40),
    21. ) ON [PRIMARY]
    22. END
    23. GO
    24. 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'
    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'zy'
    27. BEGIN
    28. CREATE TABLE [dbo].[xuesheng]([xsid] [int] IDENTITY(1,1) NOT NULL,
    29. [yhm] [VARCHAR](40),
    30. [mm] [VARCHAR](40),
    31. [xm] [VARCHAR](40),
    32. [bj] [VARCHAR](40),
    33. [xb] [VARCHAR](40),
    34. [rxnf] [VARCHAR](40),
    35. ) ON [PRIMARY]
    36. END
    37. GO
    38. 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'
    39. GO
    40. 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'
    41. GO
    42. 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'
    43. GO
    44. 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'
    45. GO
    46. 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'
    47. GO
    48. 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'rxnf'
    49. BEGIN
    50. CREATE TABLE [dbo].[sxdd]([sxddid] [int] IDENTITY(1,1) NOT NULL,
    51. [xs] [VARCHAR](40),
    52. [cj] [VARCHAR](40),
    53. [jcf] [VARCHAR](40),
    54. [jf] [VARCHAR](40),
    55. [jianfen] [VARCHAR](40),
    56. ) ON [PRIMARY]
    57. END
    58. GO
    59. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sxdd', @level2type=N'COLUMN', @level2name=N'xs'
    60. GO
    61. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sxdd', @level2type=N'COLUMN', @level2name=N'cj'
    62. GO
    63. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'基础分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sxdd', @level2type=N'COLUMN', @level2name=N'jcf'
    64. GO
    65. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sxdd', @level2type=N'COLUMN', @level2name=N'jf'
    66. GO
    67. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'减分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sxdd', @level2type=N'COLUMN', @level2name=N'jianfen'
    68. BEGIN
    69. CREATE TABLE [dbo].[kemu]([kmid] [int] IDENTITY(1,1) NOT NULL,
    70. [km] [VARCHAR](40),
    71. ) ON [PRIMARY]
    72. END
    73. GO
    74. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kemu', @level2type=N'COLUMN', @level2name=N'km'
    75. BEGIN
    76. CREATE TABLE [dbo].[xscj]([xscjid] [int] IDENTITY(1,1) NOT NULL,
    77. [xs] [VARCHAR](40),
    78. [km] [VARCHAR](40),
    79. [cj] [VARCHAR](40),
    80. ) ON [PRIMARY]
    81. END
    82. GO
    83. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xscj', @level2type=N'COLUMN', @level2name=N'xs'
    84. GO
    85. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xscj', @level2type=N'COLUMN', @level2name=N'km'
    86. GO
    87. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'xscj', @level2type=N'COLUMN', @level2name=N'cj'
    88. BEGIN
    89. CREATE TABLE [dbo].[tycj]([tycjid] [int] IDENTITY(1,1) NOT NULL,
    90. [xs] [VARCHAR](40),
    91. [cj] [VARCHAR](40),
    92. ) ON [PRIMARY]
    93. END
    94. GO
    95. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tycj', @level2type=N'COLUMN', @level2name=N'xs'
    96. GO
    97. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'tycj', @level2type=N'COLUMN', @level2name=N'cj'
    98. BEGIN
    99. CREATE TABLE [dbo].[gyws]([gywsid] [int] IDENTITY(1,1) NOT NULL,
    100. [jcf] [VARCHAR](40),
    101. [jf] [VARCHAR](40),
    102. [jianfen] [VARCHAR](40),
    103. ) ON [PRIMARY]
    104. END
    105. GO
    106. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'基础分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gyws', @level2type=N'COLUMN', @level2name=N'jcf'
    107. GO
    108. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gyws', @level2type=N'COLUMN', @level2name=N'jf'
    109. GO
    110. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'减分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'gyws', @level2type=N'COLUMN', @level2name=N'jianfen'
    111. BEGIN
    112. CREATE TABLE [dbo].[pdb]([pdbid] [int] IDENTITY(1,1) NOT NULL,
    113. [xh] [VARCHAR](40),
    114. [xm] [VARCHAR](40),
    115. [sxdd] [VARCHAR](40),
    116. [sxddjc] [VARCHAR](40),
    117. [sxddjf] [VARCHAR](40),
    118. [sxddjianf] [VARCHAR](40),
    119. [sxddjif] [VARCHAR](40),
    120. [xscjzf] [VARCHAR](40),
    121. [xscjks] [VARCHAR](40),
    122. [xscjpjf] [VARCHAR](40),
    123. [xscjjf] [VARCHAR](40),
    124. [tycj] [VARCHAR](40),
    125. [tyjf] [VARCHAR](40),
    126. [wsjcf] [VARCHAR](40),
    127. [wsjf] [VARCHAR](40),
    128. [wsjianf] [VARCHAR](40),
    129. [wsjif] [VARCHAR](40),
    130. [fjcj] [VARCHAR](40),
    131. [zcj] [VARCHAR](40),
    132. [bz] [VARCHAR](40),
    133. ) ON [PRIMARY]
    134. END
    135. GO
    136. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xh'
    137. GO
    138. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xm'
    139. GO
    140. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'sxdd'
    141. GO
    142. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德基础' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'sxddjc'
    143. GO
    144. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德加分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'sxddjf'
    145. GO
    146. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德减分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'sxddjianf'
    147. GO
    148. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'sxddjif'
    149. GO
    150. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生成绩总分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xscjzf'
    151. GO
    152. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生成绩科数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xscjks'
    153. GO
    154. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生成绩平均分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xscjpjf'
    155. GO
    156. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生成绩积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'xscjjf'
    157. GO
    158. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'体育成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'tycj'
    159. GO
    160. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'体育积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'tyjf'
    161. GO
    162. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卫生基础分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'wsjcf'
    163. GO
    164. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卫生加分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'wsjf'
    165. GO
    166. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卫生减分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'wsjianf'
    167. GO
    168. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'卫生积分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'wsjif'
    169. GO
    170. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'附加成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'fjcj'
    171. GO
    172. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'总成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'zcj'
    173. GO
    174. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdb', @level2type=N'COLUMN', @level2name=N'bz'
    175. BEGIN
    176. CREATE TABLE [dbo].[pdxs]([pdxsid] [int] IDENTITY(1,1) NOT NULL,
    177. [sxdd] [VARCHAR](40),
    178. [xscj] [VARCHAR](40),
    179. [ty] [VARCHAR](40),
    180. [gyws] [VARCHAR](40),
    181. ) ON [PRIMARY]
    182. END
    183. GO
    184. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'思想道德' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdxs', @level2type=N'COLUMN', @level2name=N'sxdd'
    185. GO
    186. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生成绩' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdxs', @level2type=N'COLUMN', @level2name=N'xscj'
    187. GO
    188. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'体育' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdxs', @level2type=N'COLUMN', @level2name=N'ty'
    189. GO
    190. EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'公寓卫生' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'pdxs', @level2type=N'COLUMN', @level2name=N'gyws'
    191.  
    192.

    三、注意事项
        1、管理员账号：admin密码：admin 数据库配置文件DBO.java
         2、开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为SQLSERVER2008，使用java语言开发。
        3、数据库文件名是jspsjxjgl.mdf，系统名称jxjgl
        4、系统首页地址：http://127.0.0.1:8080/jxjgl/login.jsp

     

     

     

     

     

     

     

     

     

  • 相关阅读:
    VoLTE端到端业务详解 | 用户标识类
    SOCKS5代理与网络安全：如何安全地进行爬虫操作
    【Java基础知识 46】GET和POST的区别，java模拟postman发post请求
    【毕业设计】基于stm32的车牌识别系统 - 物联网 单片机
    ngrok内网穿透
    OptiMode应用矢量有限元法模拟表面等离子体激元
    java计算机毕业设计vue校园菜鸟驿站管理系统MyBatis+系统+LW文档+源码+调试部署
    IO学习系列之使用read和write复制文件内容
    安全标准汇总
    11.10~11.15置信区间，均值、方差假设检验，正态,t,卡方，F分布，第一第二类错误
  • 原文地址：https://blog.csdn.net/qq_41221322/article/details/125495838