基于javaweb+mysql的jsp+servlet学生信息管理系统(jsp+jdbc+mysql+tomcat+servlet)

最新推荐文章于 2024-10-09 11:40:15 发布

Java源码jdk

最新推荐文章于 2024-10-09 11:40:15 发布

阅读量369

点赞数 6

文章标签： java mysql servlet

本文链接：https://blog.csdn.net/2301_81060432/article/details/134701527

版权

基于javaweb+mysql的jsp+servlet学生信息管理系统(jsp+jdbc+mysql+tomcat+servlet)

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb+mysql的JSP+Servlet学生信息管理系统(jsp+jdbc+mysql+tomcat+servlet)


登录：

admin    123456

				request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
			}else {
				request.setAttribute("error3", "nodeleteError");
				request.getRequestDispatcher("login.jsp").forward(request, response);
		}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class QueryStudentByPageServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public QueryStudentByPageServlet() {
        super();
    }
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		IStudentService studentService = new StudentServiceImpl();
		int count = studentService.getTotalCount();
		
		Page page = new Page();
		
		
		String cPage = request.getParameter("currentPage");

/**
 * Servlet implementation class DeleteLoginIDServlet
 */
public class DeleteLoginIDServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		boolean result1 = service.deleteLoginID(ID);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error2", "loginError");
			request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
		}else {
			request.setAttribute("error2", "nologinError");
			if(!result1) {
				request.setAttribute("error3", "deleteError");
				request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
			}else {
				request.setAttribute("error3", "nodeleteError");
				request.getRequestDispatcher("login.jsp").forward(request, response);
		}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}


	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
		int sno = Integer.parseInt(request.getParameter("sno"));
		int age = Integer.parseInt(request.getParameter("age"));
		String dept = request.getParameter("dept");
		Student student = new Student(name, sno, age, dept);
		
		IStudentService studentService = new StudentServiceImpl();
			boolean result = false;
			try {
				result = studentService.addStudent(student);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error", "addError");
		}else {
			request.setAttribute("error", "noaddError");
		}
		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}

public class UpdateStudentServlet extends HttpServlet {

	/**
	 * 
	 */

				request.getRequestDispatcher("login.jsp").forward(request, response);
			}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

/**
 * Servlet implementation class DeleteLoginIDServlet
 */
public class DeleteLoginIDServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		boolean result1 = service.deleteLoginID(ID);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error2", "loginError");
			request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
		}else {
			request.setAttribute("error2", "nologinError");

		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error1", "deleteError");
		}else {
			request.setAttribute("error1", "nodeleteError");
		}
		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class CheckLoginServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error", "loginError");
		}else {
			request.setAttribute("error", "nologinError");
		}
		request.getRequestDispatcher("login.jsp").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

						try {
							item.write(file);
							} catch (Exception e) {
							e.printStackTrace();
							}
			}
		}
		IStudentService studentService = new StudentServiceImpl();
		boolean result = studentService.upLoadWork(sno,name);
		
		System.out.println(name+sno);
		System.out.println(result);
		if(!result) {
			request.setAttribute("error3", "uploadError");
			request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
			
		}else{
			request.setAttribute("error3", "nouploadError");
			request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
			
		}
		}
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

/**
 * Servlet implementation class UpdateLoginPwdServlet
 */

   
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		String pwd1 = request.getParameter("upwd1");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error0", "loginError");
			request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response);
		}else {
			request.setAttribute("error0", "nologinError");
			boolean result1 = service.updateLoginPwd(ID,pwd1);
			if(!result1) {
				request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response);
			}else {
				request.setAttribute("error1", "noupdateError");
				request.getRequestDispatcher("login.jsp").forward(request, response);
			}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

/**

 */
public class DeleteStudentServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		int sno = Integer.parseInt(request.getParameter("sno"));
		IStudentService service = new StudentServiceImpl();
		boolean result = service.deleteStudentBySno(sno);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error1", "deleteError");
		}else {
			request.setAttribute("error1", "nodeleteError");
		}
		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class CheckLoginServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error", "loginError");
		}else {
			request.setAttribute("error", "nologinError");

		String cPage = request.getParameter("currentPage");
		
		if(cPage == null) {
			cPage = "0";
		}
		int currentPage = Integer.parseInt(cPage);
		page.setCurrentPage(currentPage);

		int totalCount = studentService.getTotalCount();
		page.setTotalCount(totalCount);
		int pageSize = 4;
		
		page.setPageSize(pageSize);
		
		List<Student> students = studentService.queryStudentsByPage(currentPage, pageSize);
		
		page.setStudents(students);
		request.setAttribute("page1", page);
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

				request.getRequestDispatcher("UpdateLoginPwd.jsp").forward(request, response);
			}else {
				request.setAttribute("error1", "noupdateError");
				request.getRequestDispatcher("login.jsp").forward(request, response);
			}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

/**
 * Servlet implementation class DeleteLoginIDServlet
 */
public class DeleteLoginIDServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		boolean result1 = service.deleteLoginID(ID);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error2", "loginError");
			request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
		}else {


/**
 * Servlet implementation class DeleteLoginIDServlet
 */
public class DeleteLoginIDServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService service = new StudentServiceImpl();
		boolean result = service.checkLoginID(ID,pwd);
		boolean result1 = service.deleteLoginID(ID);
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error2", "loginError");
			request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
		}else {
			request.setAttribute("error2", "nologinError");
			if(!result1) {
				request.setAttribute("error3", "deleteError");
				request.getRequestDispatcher("DeleteLoginID.jsp").forward(request, response);
			}else {
				request.setAttribute("error3", "nodeleteError");
				request.getRequestDispatcher("login.jsp").forward(request, response);
		}
		}
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}


public class AddStudentServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
		int sno = Integer.parseInt(request.getParameter("sno"));
		int age = Integer.parseInt(request.getParameter("age"));
		String dept = request.getParameter("dept");
		Student student = new Student(name, sno, age, dept);
		
		IStudentService studentService = new StudentServiceImpl();
			boolean result = false;
			try {
				result = studentService.addStudent(student);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error", "addError");
		}else {
			request.setAttribute("error", "noaddError");

		page.setTotalCount(totalCount);
		int pageSize = 4;
		
		page.setPageSize(pageSize);
		
		List<Student> students = studentService.queryStudentsByPage(currentPage, pageSize);
		
		page.setStudents(students);
		request.setAttribute("page1", page);
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class AddStudentServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
		int sno = Integer.parseInt(request.getParameter("sno"));
		int age = Integer.parseInt(request.getParameter("age"));
		String dept = request.getParameter("dept");
		Student student = new Student(name, sno, age, dept);
		
		IStudentService studentService = new StudentServiceImpl();
			boolean result = false;
			try {
				result = studentService.addStudent(student);
			} catch (Exception e) {


	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class QueryStudentByPageServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
    public QueryStudentByPageServlet() {
        super();
    }
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		IStudentService studentService = new StudentServiceImpl();
		int count = studentService.getTotalCount();
		
		Page page = new Page();
		
		
		String cPage = request.getParameter("currentPage");
		
		if(cPage == null) {
			cPage = "0";
		}
		int currentPage = Integer.parseInt(cPage);
		page.setCurrentPage(currentPage);

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String ID = request.getParameter("UID");
		String pwd = request.getParameter("upwd");
		IStudentService studentService = new StudentServiceImpl();
		boolean result = studentService.addLoginID(ID,pwd);
		
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error4", "addError");
			request.getRequestDispatcher("register.jsp").forward(request, response);
		}else {
			request.setAttribute("error4", "noaddError");
			request.getRequestDispatcher("login.jsp").forward(request, response);
		}
		
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

/**
 * Servlet implementation class DeleteStudentServlet
 */
public class DeleteStudentServlet extends HttpServlet {
	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		int sno = Integer.parseInt(request.getParameter("sno"));

	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
		int sno = Integer.parseInt(request.getParameter("sno"));
		int age = Integer.parseInt(request.getParameter("age"));
		String dept = request.getParameter("dept");
		Student student = new Student(name, sno, age, dept);
		
		IStudentService studentService = new StudentServiceImpl();
			boolean result = false;
			try {
				result = studentService.addStudent(student);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		response.setContentType("text/html;charest=UTF-8");
		response.setCharacterEncoding("utf-8");
		if(!result) {
			request.setAttribute("error", "addError");
		}else {
			request.setAttribute("error", "noaddError");
		}
		request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
	}

	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		doGet(request, response);
	}

}

public class UpdateStudentServlet extends HttpServlet {

	/**
	 *

		page.setCurrentPage(currentPage);

		int totalCount = studentService.getTotalCount();
		page.setTotalCount(totalCount);
		int pageSize = 4;
		
		page.setPageSize(pageSize);
		
		List<Student> students = studentService.queryStudentsByPage(currentPage, pageSize);
		
		page.setStudents(students);
		request.setAttribute("page1", page);
		request.getRequestDispatcher("index.jsp").forward(request, response);
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class AddStudentServlet extends HttpServlet {

	/**

	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

public class AddStudentServlet extends HttpServlet {

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;

	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("name");
		int sno = Integer.parseInt(request.getParameter("sno"));
		int age = Integer.parseInt(request.getParameter("age"));
		String dept = request.getParameter("dept");
		Student student = new Student(name, sno, age, dept);
		
		IStudentService studentService = new StudentServiceImpl();
			boolean result = false;
			try {
				result = studentService.addStudent(student);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

请添加图片描述

Java源码jdk

关注

6
点赞
踩
8

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫