时隔多月,我终于想起了这个内容没有更新完成。
接着上次的内容,管理员有自己的登录页面,
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>管理员登录页面</title>
<style>
.fn{
height:25px;
}
</style>
</head>
<body>
<form action="/Student_grade/admin/admin_loginservlet" method="post">
<img src="/Student_grade/imge/yun.jpg" alt="yun" width="100%";height="100%" >
<div style="font-family:verdana;padding:10px;border-radius:10px;width:330px;border:5px solid #4169E1;position:absolute;top:30%;left:40%;background-color:rgb(255,255,255,0.3)">
<h1 align="center"style="font-size:40px;">管理员登录端口</h1>
<b style="font-size:25px;">账号:</b><input type="text" value="admin" name="userid" placeholder="请输入账号" size="25" class="fn"/><br><br>
<b style="font-size:25px;">密码:</b><input type="password" name="password" placeholder="请输入密码" size="25" class="fn"/><br><br>
<input type="submit" value="登录" style="font-size:18px;"/>
<input type="reset" value="重置" style="font-size:18px;"/>
<br>
<a href="/Student_grade/loginchoose.jsp">返回登录首页</a><br>
</div>
</form>
</body>
</html>
相对应的servlet
package com.Student.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
* Servlet implementation class Admin_loginservlet
*/
@WebServlet("/admin/admin_loginservlet")
public class Admin_loginservlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException,IOException{
response.setContentType("text/html;charset=UTF-8");
PrintWriter out =response.getWriter();
request.setCharacterEncoding("UTF-8");
String name=request.getParameter("userid");
String password=request.getParameter("password");
out.println("<html><body>");
if(name== null||name.length()==0)
{
out.print("<script language='javascript'>alert('用户名为空,请重新输入');window.location.href='admin_login.jsp';</script>");
}
else if(password== null||password.length()==0)
{
out.print("<script language='javascript'>alert('密码为空,请重新输入');window.location.href='admin_login.jsp';</script>");
}
else if(password.length()>0||password.length()>0)
{
if(name.equals("admin")&&password.equals("123456")) {
out.print("<script language='javascript'>alert('登录成功');window.location.href='admin_page.jsp';</script>");
}
else {
out.print("<script language='javascript'>alert('信息错误!');window.location.href='admin_login.jsp';</script>");
}
}
out.println("<html><body>");
}
}
登录后,
左边有相应的操作区,右边是显示区
主页面代码:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>后台管理页面</title>
</head>
<body>
<table width=100% border="0">
<tr>
<td colspan="2" style=" background-image: linear-gradient(to right,lightyellow, red , lightyellow);height:130px;">
<h1 align="center">管理页面</h1>
</td>
</tr>
<tr>
<td style="width:15%;vertical-align:top;height:600px;">
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_page.jsp">菜单首页</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/douserselect">查看所有信息</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/doGradeselect">查看所有成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_setgrade.jsp">设置成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_adduser.jsp">添加学生账户</a></b></div>
<br><br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/loginchoose.jsp">退出</a></b></div>
</td>
<td style="background-color:#eeeeee;height:600px;width:85%;vertical-align:top;font-size:30px;">
<div align="center">
姓名:罗腾龙<br>
班级:软件18-2班<br>
学号:3182052051132<br>
</div>
</td>
</tr>
<tr>
<td colspan="2" style="background-image: linear-gradient(to right, lightyellow,red , lightyellow);text-align:center;height:50px;">
@成绩管理系统</td>
</tr>
</table>
</body>
</html>
查看所有信息页面代码:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>后台管理页面</title>
</head>
<body>
<table width=100% border="0">
<tr>
<td colspan="2" style="background-image: linear-gradient(Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);height:130px;">
<h1 align="center">查看全部信息</h1>
</td>
</tr>
<tr>
<td style="width:15%;vertical-align:top;height:600px;">
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_page.jsp">菜单首页</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/douserselect">查看所有信息</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/doGradeselect">查看所有成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_setgrade.jsp">设置成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_adduser.jsp">添加学生账户</a></b></div>
<br><br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/loginchoose.jsp">退出</a></b></div>
</td>
<td style="background-color:#eeeeee;height:600px;width:85%;vertical-align:top;font-size:30px;">
信息显示在这里
<table border="1">
<tr>
<th>账号</th>
<th>姓名</th>
<th>密码</th>
<th>性别</th>
<th>手机</th>
</tr>
<c:forEach var="u" items="${userlist}">
<tr>
<td>${u.user_id}</td>
<td>${u.user_name}</td>
<td>${u.user_password}</td>
<td>${u.user_sex=='xy'?'男':'女'}</td>
<td>${u.user_phone }</td>
</tr>
</c:forEach>
</table>
<div>
共${tsum} 条记录,当前${cpage}/${tpage} 页
<br>
<a href="douserselect?cp=1">首页</a>
<a href="douserselect?cp=${cpage-1 <1?1:cpage-1}">上一页</a>
<a href="douserselect?cp=${cpage+1>tpage?tpage:cpage+1}">下一页</a>
<a href="douserselect?cp=${tpage}">尾页</a>
</div>
</tr>
<tr>
<td colspan="2" style="background-image: linear-gradient(Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);text-align:center;height:50px;">
@成绩管理系统</td>
</tr>
</table>
</body>
</html>
查看所有成绩代码:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>查看成绩</title>
</head>
<body>
<table width=100% border="0">
<tr>
<td colspan="2" style="background-image: linear-gradient(to left,Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);height:130px;">
<h1 align="center">查看全部成绩</h1>
</td>
</tr>
<tr>
<td style="width:15%;vertical-align:top;height:600px;">
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_page.jsp">菜单首页</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/douserselect">查看所有信息</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/doGradeselect">查看所有成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_setgrade.jsp">设置成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_adduser.jsp">添加学生账户</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/loginchoose.jsp">退出</a></b></div>
</td>
<td style="background-color:#eeeeee;height:600px;width:85%;vertical-align:top; font-size:30px;">
信息显示在这里
<table border="1">
<tr>
<th>账号</th>
<th>姓名</th>
<th>java</th>
<th>C语言</th>
<th>web</th>
<th>python</th>
<th>SQL</th>
<th>总分</th>
</tr>
<c:forEach var="u" items="${userlist}">
<tr>
<td>${u.user_id}</td>
<td>${u.user_name}</td>
<td>${u.user_java}</td>
<td>${u.user_C}</td>
<td>${u.user_web }</td>
<td>${u.user_python }</td>
<td>${u.user_SQL }</td>
<td>${u.user_java+u.user_C+u.user_web+u.user_python+u.user_SQL}</td>
</tr>
</c:forEach>
</table>
<div>
共${tsum} 条记录,当前${cpage}/${tpage} 页
<br>
<a href="doGradeselect?cp=1">首页</a>
<a href="doGradeselect?cp=${cpage-1 <1?1:cpage-1}">上一页</a>
<a href="doGradeselect?cp=${cpage+1>tpage?tpage:cpage+1}">下一页</a>
<a href="doGradeselect?cp=${tpage}">尾页</a>
</div>
</tr>
<tr>
<td colspan="2" style="background-image: linear-gradient(to left,Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);text-align:center;height:50px;">
@成绩管理系统</td>
</tr>
</table>
</body>
</html>
设置成绩页面:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>后台管理页面</title>
<script src="js/jquery-1.12.4.min.js"></script>
<script src="js/function.js"></script>
<style type="text/css">
.fn{
height:25px;
}
</style>
</head>
<body>
<table width=100% border="0">
<tr>
<td colspan="2" style="background-image: linear-gradient(to right, Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);height:130px;">
<h1 align="center">设置成绩</h1>
</td>
</tr>
<tr>
<td style="width:15%;vertical-align:top;height:600px;">
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_page.jsp">菜单首页</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/douserselect">查看所有信息</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/doGradeselect">查看所有成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_setgrade.jsp">设置成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_adduser.jsp">添加学生账户</a></b></div>
<br><br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/loginchoose.jsp">退出</a></b></div>
</td>
<td style="background-color:#eeeeee;height:600px;width:85%;vertical-align:top;">
<h1 style="font-size:30px">成绩在这里设置</h1>
<form action="/Student_grade/admin/setgrade" method="post" onsubmit="return grade(this)">
<table border="1" style="font-size:25px;">
<tr>
<td>学号</td>
<td><input type="text" name="userid" size="30" class="fn"/></td>
</tr>
<tr>
<td>姓名</td>
<td><input type="text" name="username" size="30" class="fn"/></td>
</tr>
<tr>
<td>java</td>
<td><input type="text" name="userjava" size="30" class="fn"/></td>
</tr>
<tr>
<td>C语言</td>
<td><input type="text" name="userc" size="30" class="fn"/></td>
</tr>
<tr>
<td>web</td>
<td><input type="text" name="userweb" size="30" class="fn"/></td>
</tr>
<tr>
<td>python</td>
<td><input type="text" name="userpython"size="30" class="fn"/></td>
</tr>
<tr>
<td>SQL</td>
<td><input type="text" name="usersql"size="30" class="fn"/></td>
</tr>
</table>
<input type="submit" value="确定" style="font-size:25px;"/>
<input type="reset" value="重置" style="font-size:25px;"/>
</form>
</tr>
<tr>
<td colspan="2" style="background-image: linear-gradient(to right, Ivory, orange, yellow, LavenderBlush , lightblue, Lavender , Khaki);text-align:center;height:50px;">
@成绩管理系统</td>
</tr>
</table>
</body>
</html>
添加用户页面代码:
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>后台管理页面</title>
<style type="text/css">
.fn{
height:25px;
}
</style>
</head>
<body>
<table width=100% border="0">
<tr>
<td colspan="2" style="background-image: linear-gradient(#e66465, #9198e5);height:130px;">
<h1 align="center">添加学生账户</h1>
</td>
</tr>
<tr>
<td style="width:15%;vertical-align:top;height:600px;">
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_page.jsp">菜单首页</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/douserselect">查看所有信息</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/admin/doGradeselect">查看所有成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_setgrade.jsp">设置成绩</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="admin_adduser.jsp">添加学生账户</a></b></div>
<br>
<br>
<div style="border:2px solid #0099CC;height:40px;font-size:25px;background-color:lightyellow;"><b><a href="/Student_grade/loginchoose.jsp">退出</a></b></div>
</td>
<td style="background-color:#eeeeee;height:600px;width:85%;vertical-align:top;">
<h1 style="font-size:30px">学生账户在这里添加</h1>
<form action="/Student_grade/admin/adminadduser" method="post" >
<div style="font-size:20px">
<br>
<p align="">
<b style="font-size:25px;">姓 名:</b>
<input type="text" name="username" size="30" value="" placeholder="请输入名字" class="fn" />
</p>
<p>
<b style="font-size:25px;">性 别:</b>
<input type="radio" value="xy" name="sex" checked="checked"/>男
<input type="radio" value="xx" name="sex" />女
</p>
<p>
<b style="font-size:25px;">账 号:</b>
<input type="text" name="userid" size="30" value="" placeholder="请输入账号"class="fn" />
</p>
<p>
<b style="font-size:25px;">密 码:</b>
<input type="password" name="password" size="30" value="" placeholder="请输入密码"class="fn" />
</p>
<p>
<b style="font-size:25px;">确认密码:</b>
<input type="password" name="repassword" size="30" value="" placeholder="请确认密码"class="fn" />
</p>
<p>
<b style="font-size:25px;">电 话:</b>
<input type="text" name="phone" size="30" value="" placeholder="请输入电话"class="fn" />
</p>
<input type="submit" value="提交"/style="font-size:25px;">
<input type="reset" value="重置"/style="font-size:25px;">
</div>
</form>
</td>
</tr>
<tr>
<td colspan="2" style="background-image: linear-gradient(#e66465, #9198e5);text-align:center;height:50px;">
@成绩管理系统</td>
</tr>
</table>
</body>
</html>
以及一些相关的servlet,和所有页面代码和数据库代码等等,有需要的自行获取。
链接:https://pan.baidu.com/s/1e5MiWwR1MKKkRWKRoOL9VQ
提取码:zdmn
2021-06-11修改 这个是数据库的文件
链接:https://pan.baidu.com/s/1z-S4qV4FnoiW0-kiSSVq8g
提取码:4h49