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

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

412323052507

422323052507

432323052507

442323052507

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

1
2
3
4
登录:

admin 123456

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39





public class UploadServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
response.setContentType("text/html; charset=UTF-8");
String name = null;
int sno = -1;

boolean isMutipart = ServletFileUpload.isMultipartContent(request);
if(isMutipart) {
DiskFileItemFactory factory = new DiskFileItemFactory();
ServletFileUpload upload = new ServletFileUpload(factory);
factory.setRepository(new File("D:\\uploadtemp"));
List<FileItem> items = null;
try {
items = upload.parseRequest(request);
} catch (FileUploadException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Iterator<FileItem> iter = items.iterator();
while(iter.hasNext()) {
FileItem item= iter.next();
String fileName = item.getName();
String itemName = item.getFieldName();
if(item.isFormField()) {
if(itemName.equals("name")){
name = item.getString("utf-8");
}else if(itemName.equals("sno")) {
sno =Integer.parseInt(item.getString("utf-8"));
}else {

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

}
package student.servlet;



public class UpdateStudentServlet 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, age, dept);

System.out.println(sno);

IStudentService service = new StudentServiceImpl();
boolean result = service.updateStudentBySno(sno, student);

response.setContentType("text/html;charest=UTF-8");
response.setCharacterEncoding("utf-8");
if(!result) {
request.setAttribute("error2", "updateError");
}else {
request.setAttribute("error2", "noupdateError");
}

request.getRequestDispatcher("QueryStudentByPageServlet").forward(request, response);
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42

}
package student.servlet;



/**
* Servlet implementation class AddLoginIDServlet
*/
public class AddLoginIDServlet 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 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);
}

}
package student.servlet;

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
package student.servlet;



/**
* 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 {
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
package student.servlet;




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);

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);


项目链接:
https://javayms.github.io?id=402323052507201bs
https://javayms.pages.dev?id=402323052507201bs