利用Javaweb(jsp)做一个具有登录注册查询等功能的系统网页之管理员操作页面(六(完))

时隔多月,我终于想起了这个内容没有更新完成。

接着上次的内容,管理员有自己的登录页面,
在这里插入图片描述

<%@ 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>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<input type="submit" value="登录" style="font-size:18px;"/>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" value="重置" style="font-size:18px;"/>
<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<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;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;名:</b>
<input type="text" name="username" size="30" value="" placeholder="请输入名字"  class="fn" />
</p>
<p>
<b style="font-size:25px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;别:</b>
<input type="radio" value="xy" name="sex" checked="checked"/><input type="radio" value="xx" name="sex" /></p>

<p>
<b style="font-size:25px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;号:</b>
<input type="text" name="userid" size="30"  value=""  placeholder="请输入账号"class="fn" />
</p>
<p>
<b style="font-size:25px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码:</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;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;话:</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

  • 15
    点赞
  • 125
    收藏
    觉得还不错? 一键收藏
  • 5
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值