• JSP基于Javaweb学籍管理系

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    本项目为后台管理系统；
    管理员角色包含以下功能：

    登录、专业管理、班级管理、课程管理、学生学籍管理、学生成绩管理等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 
    5.数据库：MySql 5.7版本；

    6.是否Maven项目: 否；

    技术栈

    1. 后端：servlet

    2. 前端：JSP+css+javascript

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中com/dao/DB.java配置文件中的数据库配置改为自己的配置;

    4. 运行项目，输入http://localhost:8080/ 登录

    运行截图

     

     

     

     

     

    相关代码

    管理端控制器

    1. public class admin_servlet extends HttpServlet
    2. {
    3. 	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    4. 	{
    5.         String type=req.getParameter("type");
    6. 		
    7. 		if(type.endsWith("adminMana"))
    8. 		{
    9. 			adminMana(req, res);
    10. 		}
    11. 		if(type.endsWith("adminAdd"))
    12. 		{
    13. 			adminAdd(req, res);
    14. 		}
    15. 		if(type.endsWith("adminDel"))
    16. 		{
    17. 			adminDel(req, res);
    18. 		}
    19. 	}
    20. 	
    21. 	public void adminMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    22. 	{
    23. 		List adminList=new ArrayList();
    24. 		String sql="select * from t_admin";
    25. 		Object[] params={};
    26. 		DB mydb=new DB();
    27. 		try
    28. 		{
    29. 			mydb.doPstm(sql, params);
    30. 			ResultSet rs=mydb.getRs();
    31. 			while(rs.next())
    32. 			{
    33. 				TAdmin admin=new TAdmin();
    34. 				admin.setUserId(rs.getInt("userId"));
    35. 				admin.setUserName(rs.getString("userName"));
    36. 				admin.setUserPw(rs.getString("userPw"));
    37. 				adminList.add(admin);
    38. 		    }
    39. 			rs.close();
    40. 		}
    41. 		catch(Exception e)
    42. 		{
    43. 			e.printStackTrace();
    44. 		}
    45. 		mydb.closed();
    46. 		
    47. 		req.setAttribute("adminList", adminList);
    48. 		req.getRequestDispatcher("admin/admin/adminMana.jsp").forward(req, res);
    49. 	}
    50. 	public void adminAdd(HttpServletRequest req,HttpServletResponse res)
    51. 	{
    52. 		String userName=req.getParameter("userName");
    53. 		String userPw=req.getParameter("userPw");
    54. 		String sql="insert into t_admin values(?,?)";
    55. 		Object[] params={userName,userPw};
    56. 		DB mydb=new DB();
    57. 		mydb.doPstm(sql, params);
    58. 		mydb.closed();
    59. 		
    60. 		req.setAttribute("message", "操作成功");
    61. 		req.setAttribute("path", "admin?type=adminMana");
    62. 		
    63.         String targetURL = "/common/success.jsp";
    64. 		dispatch(targetURL, req, res);
    65. 	}
    66. 	
    67. 	public void adminDel(HttpServletRequest req,HttpServletResponse res)
    68. 	{
    69. 		System.out.println(req.getParameter("userId")+"**");
    70. 		String sql="delete from t_admin where userId="+Integer.parseInt(req.getParameter("userId"));
    71. 		Object[] params={};
    72. 		DB mydb=new DB();
    73. 		mydb.doPstm(sql, params);
    74. 		mydb.closed();
    75. 		
    76. 		req.setAttribute("message", "操作成功");
    77. 		req.setAttribute("path", "admin?type=adminMana");
    78. 		
    79.         String targetURL = "/common/success.jsp";
    80. 		dispatch(targetURL, req, res);
    81. 	}
    82.  
    83. 	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    84. 	{
    85. 		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
    86. 		try 
    87. 		{
    88. 		    dispatch.forward(request, response);
    89. 		    return;
    90. 		} 
    91. 		catch (ServletException e) 
    92. 		{
    93.                     e.printStackTrace();
    94. 		} 
    95. 		catch (IOException e) 
    96. 		{
    97. 			
    98. 		    e.printStackTrace();
    99. 		}
    100. 	}
    101. 	public void init(ServletConfig config) throws ServletException 
    102. 	{
    103. 		super.init(config);
    104. 	}
    105. 	
    106. 	public void destroy() 
    107. 	{
    108. 		
    109. 	}
    110. }

     学生管理控制器

    1. public class stu_servlet extends HttpServlet
    2. {
    3. 	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
    4. 	{
    5.         String type=req.getParameter("type");
    6. 		
    7. 		if(type.endsWith("stuAdd"))
    8. 		{
    9. 			stuAdd(req, res);
    10. 		}
    11. 		if(type.endsWith("stuDel"))
    12. 		{
    13. 			stuDel(req, res);
    14. 		}
    15. 		if(type.endsWith("stuMana"))
    16. 		{
    17. 			stuMana(req, res);
    18. 		}
    19. 		if(type.endsWith("stuEdit"))
    20. 		{
    21. 			stuEdit(req, res);
    22. 		}
    23. 		if(type.endsWith("stuDetail"))
    24. 		{
    25. 			stuDetail(req, res);
    26. 		}
    27. 		if(type.endsWith("stuAll"))
    28. 		{
    29. 			stuAll(req, res);
    30. 		}
    31. 		if(type.endsWith("stuSearchByXuehao"))
    32. 		{
    33. 			stuSearchByXuehao(req, res);
    34. 		}
    35. 		if(type.endsWith("stuTongji"))
    36. 		{
    37. 			stuTongji(req, res);
    38. 		}
    39. 	}
    40. 	
    41. 	
    42. 	public void stuAdd(HttpServletRequest req,HttpServletResponse res)
    43. 	{
    44. 		String xuehao=req.getParameter("xuehao");
    45. 		String name1=req.getParameter("name1");
    46. 		String sex=req.getParameter("sex");
    47. 		int age=Integer.parseInt(req.getParameter("age"));
    48. 		
    49. 		int banji_id=Integer.parseInt(req.getParameter("banji_id"));
    50. 		String ruxueshijian=req.getParameter("ruxueshijian");
    51. 		String biyeshijian=req.getParameter("biyeshijian");
    52. 		String xuezhi=req.getParameter("xuezhi");
    53. 		
    54. 		String xuexiao=req.getParameter("xuexiao");
    55. 		String del="no";
    56. 		if(liuService.jianchaxuhao(xuehao.trim())==true)
    57. 		{
    58. 			req.setAttribute("message", "学号重复。请重新输入");
    59. 			req.setAttribute("path", "admin/stu/stuAdd.jsp");
    60. 			String targetURL = "/common/success.jsp";
    61. 			dispatch(targetURL, req, res);
    62. 		}
    63. 		else
    64. 		{
    65. 			String sql="insert into t_stu values(?,?,?,?,?,?,?,?,?,?)";
    66. 			Object[] params={xuehao,name1,sex,age,banji_id,ruxueshijian,biyeshijian,xuezhi,xuexiao,del};
    67. 			DB mydb=new DB();
    68. 			mydb.doPstm(sql, params);
    69. 			mydb.closed();
    70. 			
    71. 			req.setAttribute("message", "操作成功");
    72. 			req.setAttribute("path", "stu?type=stuMana");
    73. 			
    74. 	        String targetURL = "/common/success.jsp";
    75. 			dispatch(targetURL, req, res);
    76. 		}
    77. 	}
    78. 	
    79. 	public void stuDel(HttpServletRequest req,HttpServletResponse res)
    80. 	{
    81. 		String sql="update t_stu set del='yes' where id="+Integer.parseInt(req.getParameter("id"));
    82. 		Object[] params={};
    83. 		DB mydb=new DB();
    84. 		mydb.doPstm(sql, params);
    85. 		mydb.closed();
    86. 		
    87. 		req.setAttribute("message", "操作成功");
    88. 		req.setAttribute("path", "stu?type=stuMana");
    89. 		
    90.         String targetURL = "/common/success.jsp";
    91. 		dispatch(targetURL, req, res);
    92. 	}
    93.  
    94. 	public void stuMana(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    95. 	{
    96. 		List stuList=new ArrayList();
    97. 		String sql="select * from t_stu where del='no'";
    98. 		Object[] params={};
    99. 		DB mydb=new DB();
    100. 		try
    101. 		{
    102. 			mydb.doPstm(sql, params);
    103. 			ResultSet rs=mydb.getRs();
    104. 			while(rs.next())
    105. 			{
    106. 				Tstu stu=new Tstu();
    107. 				stu.setId(rs.getInt("id"));
    108. 				stu.setXuehao(rs.getString("xuehao"));
    109. 				stu.setName1(rs.getString("name1"));
    110. 				stu.setSex(rs.getString("sex"));
    111. 				stu.setAge(rs.getInt("age"));
    112. 				stu.setBanji_id(rs.getInt("banji_id"));
    113. 				stu.setRuxueshijian(rs.getString("ruxueshijian"));
    114. 				stu.setBiyeshijian(rs.getString("biyeshijian"));
    115. 				stu.setXuezhi(rs.getString("xuezhi"));
    116. 				stu.setXuexiao(rs.getString("xuexiao"));
    117. 				stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
    118. 				stuList.add(stu);
    119. 		    }
    120. 			rs.close();
    121. 		}
    122. 		catch(Exception e)
    123. 		{
    124. 			e.printStackTrace();
    125. 		}
    126. 		mydb.closed();
    127. 		if(stuList.size()==0)
    128. 		{
    129. 			req.setAttribute("msg", 0);
    130. 		}
    131. 		else
    132. 		{
    133. 			req.setAttribute("msg", 1);
    134. 		}
    135. 		req.setAttribute("stuList", stuList);
    136. 		req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
    137. 	}
    138. 	
    139. 	
    140. 	public void stuSearchByXuehao(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    141. 	{
    142. 		List stuList=new ArrayList();
    143. 		String sql="select * from t_stu where del='no' and xuehao like '%"+req.getParameter("xuehao").trim()+"%'";
    144. 		Object[] params={};
    145. 		DB mydb=new DB();
    146. 		try
    147. 		{
    148. 			mydb.doPstm(sql, params);
    149. 			ResultSet rs=mydb.getRs();
    150. 			while(rs.next())
    151. 			{
    152. 				Tstu stu=new Tstu();
    153. 				stu.setId(rs.getInt("id"));
    154. 				stu.setXuehao(rs.getString("xuehao"));
    155. 				stu.setName1(rs.getString("name1"));
    156. 				stu.setSex(rs.getString("sex"));
    157. 				stu.setAge(rs.getInt("age"));
    158. 				stu.setBanji_id(rs.getInt("banji_id"));
    159. 				stu.setRuxueshijian(rs.getString("ruxueshijian"));
    160. 				stu.setBiyeshijian(rs.getString("biyeshijian"));
    161. 				stu.setXuezhi(rs.getString("xuezhi"));
    162. 				stu.setXuexiao(rs.getString("xuexiao"));
    163. 				stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
    164. 				stuList.add(stu);
    165. 		    }
    166. 			rs.close();
    167. 		}
    168. 		catch(Exception e)
    169. 		{
    170. 			e.printStackTrace();
    171. 		}
    172. 		mydb.closed();
    173. 		if(stuList.size()==0)
    174. 		{
    175. 			req.setAttribute("msg", 0);
    176. 		}
    177. 		else
    178. 		{
    179. 			req.setAttribute("msg", 1);
    180. 		}
    181. 		req.setAttribute("stuList", stuList);
    182. 		req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
    183. 	}
    184. 	
    185. 	
    186. 	public void stuEdit(HttpServletRequest req,HttpServletResponse res)
    187. 	{
    188. 		String xuehao=req.getParameter("xuehao");
    189. 		String name1=req.getParameter("name1");
    190. 		String sex=req.getParameter("sex");
    191. 		int age=Integer.parseInt(req.getParameter("age"));
    192. 		int banji_id=Integer.parseInt(req.getParameter("banji_id"));
    193. 		String ruxueshijian=req.getParameter("ruxueshijian");
    194. 		String biyeshijian=req.getParameter("biyeshijian");
    195. 		String xuezhi=req.getParameter("xuezhi");
    196. 		String xuexiao=req.getParameter("xuexiao");
    197. 		
    198. 		String sql="update t_stu set xuehao=?,name1=?,sex=?,age=?,banji_id=?,ruxueshijian=?,biyeshijian=?,xuezhi=?,xuexiao=? where id="+Integer.parseInt(req.getParameter("id"));
    199. 		Object[] params={xuehao,name1,sex,age,banji_id,ruxueshijian,biyeshijian,xuezhi,xuexiao};
    200. 		DB mydb=new DB();
    201. 		mydb.doPstm(sql, params);
    202. 		mydb.closed();
    203. 		
    204. 		req.setAttribute("message", "操作成功");
    205. 		req.setAttribute("path", "stu?type=stuMana");
    206. 		
    207.         String targetURL = "/common/success.jsp";
    208. 		dispatch(targetURL, req, res);
    209. 	}
    210. 	
    211. 	
    212. 	public void stuDetail(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    213. 	{
    214. 		Tstu stu=new Tstu();
    215. 		String sql="select * from t_stu where del='no' and id ="+req.getParameter("id").trim();
    216. 		Object[] params={};
    217. 		DB mydb=new DB();
    218. 		try
    219. 		{
    220. 			mydb.doPstm(sql, params);
    221. 			ResultSet rs=mydb.getRs();
    222. 			while(rs.next())
    223. 			{
    224. 				stu=new Tstu();
    225. 				stu.setId(rs.getInt("id"));
    226. 				stu.setXuehao(rs.getString("xuehao"));
    227. 				stu.setName1(rs.getString("name1"));
    228. 				stu.setSex(rs.getString("sex"));
    229. 				stu.setAge(rs.getInt("age"));
    230. 				stu.setBanji_id(rs.getInt("banji_id"));
    231. 				stu.setRuxueshijian(rs.getString("ruxueshijian"));
    232. 				stu.setBiyeshijian(rs.getString("biyeshijian"));
    233. 				stu.setXuezhi(rs.getString("xuezhi"));
    234. 				stu.setXuexiao(rs.getString("xuexiao"));
    235. 				stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
    236. 		    }
    237. 			rs.close();
    238. 		}
    239. 		catch(Exception e)
    240. 		{
    241. 			e.printStackTrace();
    242. 		}
    243. 		mydb.closed();
    244. 		
    245. 		req.setAttribute("stu", stu);
    246. 		req.getRequestDispatcher("admin/stu/stuDetail.jsp").forward(req, res);
    247. 	}
    248. 	
    249. 	
    250. 	public void stuAll(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    251. 	{
    252. 		List stuList=new ArrayList();
    253. 		String sql="select * from t_stu where del='no'";
    254. 		Object[] params={};
    255. 		DB mydb=new DB();
    256. 		try
    257. 		{
    258. 			mydb.doPstm(sql, params);
    259. 			ResultSet rs=mydb.getRs();
    260. 			while(rs.next())
    261. 			{
    262. 				Tstu stu=new Tstu();
    263. 				stu.setId(rs.getInt("id"));
    264. 				stu.setXuehao(rs.getString("xuehao"));
    265. 				stu.setName1(rs.getString("name1"));
    266. 				stu.setSex(rs.getString("sex"));
    267. 				stu.setAge(rs.getInt("age"));
    268. 				stu.setBanji_id(rs.getInt("banji_id"));
    269. 				stu.setRuxueshijian(rs.getString("ruxueshijian"));
    270. 				stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
    271. 				stuList.add(stu);
    272. 		    }
    273. 			rs.close();
    274. 		}
    275. 		catch(Exception e)
    276. 		{
    277. 			e.printStackTrace();
    278. 		}
    279. 		mydb.closed();
    280. 		
    281. 		req.setAttribute("stuList", stuList);
    282. 		req.getRequestDispatcher("admin/stu_xuanke/stuAll.jsp").forward(req, res);
    283. 	}
    284. 	
    285. 	
    286. 	public void stuTongji(HttpServletRequest req,HttpServletResponse res) throws ServletException, IOException
    287. 	{
    288. 		
    289. 		
    290. 		List stuList=new ArrayList();
    291. 		String sql="select * from t_stu where del='no' and banji_id=?";
    292. 		Object[] params={req.getParameter("banji_id")};
    293. 		DB mydb=new DB();
    294. 		try
    295. 		{
    296. 			mydb.doPstm(sql, params);
    297. 			ResultSet rs=mydb.getRs();
    298. 			while(rs.next())
    299. 			{
    300. 				Tstu stu=new Tstu();
    301. 				stu.setId(rs.getInt("id"));
    302. 				stu.setXuehao(rs.getString("xuehao"));
    303. 				stu.setName1(rs.getString("name1"));
    304. 				stu.setSex(rs.getString("sex"));
    305. 				stu.setAge(rs.getInt("age"));
    306. 				stu.setBanji_id(rs.getInt("banji_id"));
    307. 				stu.setRuxueshijian(rs.getString("ruxueshijian"));
    308. 				stu.setBiyeshijian(rs.getString("biyeshijian"));
    309. 				stu.setXuezhi(rs.getString("xuezhi"));
    310. 				stu.setXuexiao(rs.getString("xuexiao"));
    311. 				stu.setBanji_name(liuService.getBanjiName(rs.getInt("banji_id")));
    312. 				stuList.add(stu);
    313. 		    }
    314. 			rs.close();
    315. 		}
    316. 		catch(Exception e)
    317. 		{
    318. 			e.printStackTrace();
    319. 		}
    320. 		mydb.closed();
    321. 		
    322. 		req.setAttribute("stuList", stuList);
    323. 		req.getRequestDispatcher("admin/stu/stuMana.jsp").forward(req, res);
    324. 	}
    325. 	
    326. 	public void dispatch(String targetURI,HttpServletRequest request,HttpServletResponse response) 
    327. 	{
    328. 		RequestDispatcher dispatch = getServletContext().getRequestDispatcher(targetURI);
    329. 		try 
    330. 		{
    331. 		    dispatch.forward(request, response);
    332. 		    return;
    333. 		} 
    334. 		catch (ServletException e) 
    335. 		{
    336.                     e.printStackTrace();
    337. 		} 
    338. 		catch (IOException e) 
    339. 		{
    340. 			
    341. 		    e.printStackTrace();
    342. 		}
    343. 	}
    344. 	public void init(ServletConfig config) throws ServletException 
    345. 	{
    346. 		super.init(config);
    347. 	}
    348. 	
    349. 	public void destroy() 
    350. 	{
    351. 		
    352. 	}
    353. }

    如果也想学习本系统，下面领取。回复：116JSP    

  • 相关阅读:
    【编程语言】Python平台化为何比Java差？
    数据结构与算法之LeetCode-1413. 逐步求和得到正数的最小值（贪心与排序）
    什么是RabbitMQ，RabbitMQ基本概念，RabbitMQ的使用场景
    【算法训练-二分查找 三】【特殊二分】寻找峰值
    Pycharm加载项目时异常，看不到自己的项目文件
    关于解决前后端分离开发——跨域问题
    【Bug处理】E0265 函数 “SizeClass::RoundUp“ (已声明 所在行数:62）不可访问
    本周大新闻｜7-11便利店测试AR远程购物，PICO商店支持退款
    saas化调研
    Visual Studio Community快速入门
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/125566492