• jsp公务员考试系统myeclipse开发Mysql数据库web结构java编程计算机网页项目

    一、源码特点
      JSP 公务员考试系统 是一套完善的web设计系统，对理解JSP java编程开发语言有帮助，系统采用serlvet+dao+bean 模式开发，系统具有完整的源代码和数据库，系统主要采用B/S模式开
    发。开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为Mysql，使用java语言开发

    jsp公务员考试系统myeclipse开发Mysql数据库w

    二、功能介绍
    系统主要的角色 包括 用户和管理员
    后台主要功能：
    (1)用户管理：对用户信息进行添加、删除、修改和查看
    (2)章节管理：对章节信息进行添加、删除、修改和查看
    (3)试题管理：对试题信息进行添加、删除、修改和查看、导入
    (4)试卷管理：对试卷信息进行添加、删除、修改和查看
    (5)组卷管理：对组卷信息进行添加、删除、修改和查看
    (6)成绩管理：对成绩信息进行查看
    (7)留言管理：对出库信息进行添加、删除、修改和查看
    (8）用户登录、个人信息修改
    前台主要功能：
    （1）系统首页查看未过期的试卷
    (2)用户注册、登录
    (3)试卷学习，练习，随机练习
    (4)留言
    (5)我的成绩
    (6)章节练习情况
    (7)错题库
    (8)错题练习
    (9)错题练习情况
    (10)个人信息

    成绩处理方法类

    1. package com.servlet;
    2.  
    3. import java.io.IOException;
    4. import java.io.PrintWriter;
    5. import javax.servlet.ServletException;
    6. import javax.servlet.http.HttpServlet;
    7. import javax.servlet.http.HttpServletRequest;
    8. import javax.servlet.http.HttpServletResponse;
    9. import javax.servlet.http.HttpSession;
    10.  
    11. import com.bean.chengji;
    12. import com.dao.chengjiDao;
    13.  
    14.  
    15. import java.util.List;
    16. import java.sql.ResultSet;
    17.  
    18. public class chengjiServlet extends HttpServlet  {
    19. 	public void service(HttpServletRequest request, HttpServletResponse response)
    20. 	throws ServletException, IOException {
    21. 		request.setCharacterEncoding("gb2312");
    22. 		System.out.println("method"+request.getParameter("method"));
    23. 		String method=(String)request.getParameter("method");
    24. 		if(method.equals("insert")){//成绩添加
    25. 			insertM(request, response);
    26. 		}else if(method.equals("list")){//成绩列表
    27. 			ListM(request, response);
    28. 		}else if(method.equals("delete")){//成绩删除
    29. 			deleteM(request, response);
    30. 		}else if(method.equals("modifyindex")){//成绩修改页面
    31. 			modifyIndex(request, response);
    32. 		}
    33. 		else if(method.equals("modify")){//成绩修改
    34. 			modifyM(request, response);
    35. 		}else if(method.equals("detail")){//成绩详细信息
    36. 			detailM(request, response);
    37. 		}else if(method.equals("Plist")){//成绩列表信息
    38. 			PListM(request, response);
    39. 		}
    40. 	}
    41. 	private void insertM(HttpServletRequest request, HttpServletResponse response){//成绩添加
    42. 		chengjiDao dao=new chengjiDao();
    43. 		chengji chengji=new chengji();
    44. 		chengji.setCjid((String)request.getParameter("keyid"));
    45. chengji.setSj((String)request.getParameter("sj"));
    46. chengji.setKssj((String)request.getParameter("kssj"));
    47. chengji.setCj((String)request.getParameter("cj"));
    48. chengji.setYh((String)request.getParameter("yh"));
    49.  
    50. 	response.setCharacterEncoding("gb2312");
    51. 		try {
    52. 			dao.insert(chengji);
    53. 			request.setAttribute("flag", "操作成功"); 
    54. 			
    55. 			
    56. 			
    57. 			request.getRequestDispatcher("chengji/chengjiadd.jsp").forward(request, response);
    58. 		} catch (Exception e) {
    59. 			e.printStackTrace();
    60. 		}
    61. 				
    62. 	}
    63. 	private void ListM(HttpServletRequest request, HttpServletResponse response){//成绩信息列表
    64. 		ResultSet rs=null;
    65. 		chengjiDao dao = new chengjiDao();
    66. 	    System.out.println("alist");
    67.  
    68. 		String sql="";
    69. 		response.setCharacterEncoding("gb2312");
    70. 		try{
    71. 			rs=dao.qlist(sql);
    72.  
    73. 			PrintWriter out = response.getWriter();
    74. 			request.setAttribute("rs", rs); 
    75. 		
    76.  
    77. 			request.getRequestDispatcher("chengji/chengjilist.jsp").forward(request, response);
    78. 		}catch(Exception e){
    79. 			e.toString();
    80. 			e.printStackTrace();
    81. 		}
    82. 		
    83. 	}
    84. 	private void PListM(HttpServletRequest request, HttpServletResponse response){//测试信息列表
    85. 		ResultSet rs=null;
    86. 		chengjiDao dao = new chengjiDao();
    87. 	   
    88. 	    String str=(String)request.getParameter("Page");
    89. 		String sql="";
    90. 		response.setCharacterEncoding("gb2312");
    91. 		try{
    92. 			
    93. if(str==null){
    94. 				str="0";
    95. 				}
    96. rs=dao.qlist(sql);
    97.  
    98. 			PrintWriter out = response.getWriter();
    99. 			request.setAttribute("rs", rs); 
    100. 		
    101.  
    102. 		request.getRequestDispatcher("chengji/chengjiPlist.jsp?Page=1").forward(request, response);
    103. 		}catch(Exception e){
    104. 			e.toString();
    105. 			e.printStackTrace();
    106. 		}
    107. 		
    108. 	}
    109. 	private void modifyIndex(HttpServletRequest request, HttpServletResponse response){//成绩修改首页
    110. 			ResultSet rs=null;
    111. 	response.setCharacterEncoding("gb2312");
    112. 		chengjiDao dao = new chengjiDao();
    113. 		
    114. 	
    115. 		String keyid=(String)request.getParameter("keyid");
    116. 		String sql="";
    117. 	
    118. 		
    119. 		if(keyid!=null&&!keyid.equals("")){
    120. 			
    121. 			sql+=" and cjid='"+keyid+"'";
    122. 			
    123. 		}
    124. 		try{
    125. 			rs=dao.qlist(sql);
    126. 			PrintWriter out = response.getWriter();
    127. 			request.setAttribute("rs", rs); 
    128. 			
    129. 			request.getRequestDispatcher("chengji/chengjimodify.jsp").forward(request, response);
    130. 			//response.sendRedirect("chengji/chengjimodify.jsp");
    131. 		}catch(Exception e){
    132. 			e.toString();
    133. 			e.printStackTrace();
    134. 		}
    135. 		
    136. 	}
    137. 	private void detailM(HttpServletRequest request, HttpServletResponse response){//成绩详细信息页面
    138. 		
    139. 		ResultSet rs=null;
    140. 	response.setCharacterEncoding("gb2312");
    141. 		chengjiDao dao = new chengjiDao();
    142. 		
    143. 	
    144. 		String keyid=(String)request.getParameter("keyid");
    145. 		String sql="";
    146. 	
    147. 		
    148. 		if(keyid!=null&&!keyid.equals("")){
    149. 			
    150. 			sql+=" and cjid='"+keyid+"'";
    151. 			
    152. 		}
    153. 		try{
    154. 			rs=dao.qlist(sql);
    155. 			
    156. 			request.setAttribute("rs", rs); 
    157. 		request.getRequestDispatcher("chengji/chengjidetail.jsp").forward(request, response);
    158. 		}catch(Exception e){
    159. 			e.toString();
    160. 			e.printStackTrace();
    161. 		}
    162. 		
    163. 	}
    164. 	private void deleteM(HttpServletRequest request, HttpServletResponse response){//成绩删除
    165. 		ResultSet lst=null;
    166. 		chengjiDao dao = new chengjiDao();
    167. 	  response.setCharacterEncoding("gb2312");
    168. 		String keyid=(String)request.getParameter("keyid"); 
    169. 	
    170. 		try{
    171. 			dao.delete(keyid);
    172. 				request.setAttribute("flag", "删除成功"); 
    173. 		request.getRequestDispatcher("chengjiServlet?method=list").forward(request, response);
    174. 		
    175. 			//response.sendRedirect("chengjiServlet?method=list");
    176. 		}catch(Exception e){
    177. 			e.toString();
    178. 			e.printStackTrace();
    179. 		}
    180. 		
    181. 	}
    182.  
    183. 	private void modifyM(HttpServletRequest request, HttpServletResponse response){//成绩修改功能
    184. 		chengjiDao dao=new chengjiDao();
    185. 		chengji chengji=new chengji();
    186. 		chengji.setCjid((String)request.getParameter("keyid"));
    187. chengji.setSj((String)request.getParameter("sj"));
    188. chengji.setKssj((String)request.getParameter("kssj"));
    189. chengji.setCj((String)request.getParameter("cj"));
    190. chengji.setYh((String)request.getParameter("yh"));
    191.  
    192. 	response.setCharacterEncoding("gb2312");
    193. 		try {
    194. 			dao.modify(chengji);
    195. 			PrintWriter out = response.getWriter();
    196. 			
    197. 			request.setAttribute("flag", "操作成功"); 
    198. 			request.getRequestDispatcher("chengjiServlet?method=list").forward(request, response);
    199. 			
    200. 			//response.sendRedirect("chengjiServlet?method=list");
    201. 		} catch (Exception e) {
    202. 			e.printStackTrace();
    203. 		}
    204. 				
    205. 	}
    206. }


    三、注意事项
    1、管理员账号：admin 密码：admin 数据库配置文件DBO.java ，权限包括管理员 和用户
    2、开发环境为TOMCAT7.0,Myeclipse8.5开发，数据库为Mysql，使用java语言开发。
    3、数据库文件名是jspgwyzxks 系统名称gwyzxks
    4、地址：http://127.0.0.1:8080/gwyzxks/shouye.jsp

    系统实现

     

     

     

     

     

     

     

  • 相关阅读:
    计算机网络第4章-网络层（1）
    这或许是全网最全时间序列特征工程构造的文章了
    Java项目:物资发放管理系统(java+Springboot+HTML+layui+Mysql)
    C++设计模式之Strategy策略模式
    SQL语句中 LEFT JOIN 后 ON 和 WHERE 的区别
    Fast Unsupervised Projection for Large-Scale Data
    【Matlab代码】基于遗传算法和蚂蚁优化算法的路径优化问题
    解决vue ui无法远程访问的问题
    技术债务（Technical Debt）
    品牌线上打假，应防微杜渐
  • 原文地址：https://blog.csdn.net/qq_41221322/article/details/127644888