Java学习12.17

javaweb数据库增删改查——学生成绩管理系统（2）

接上一篇博客，此篇博客主要写的是前端jsp文件

(1)增加成员

addpeople.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>

<a href="manager.jsp">返回主页</a>
    <div class="content">
        <div class="main">
        <form name="form" action="servletpeople?method=add" method="post" onsubmit="return check()">
        <table align="center" border="1" width="1000"> 
           
                <tr>
                    <td>学号</td>
                    <td><input type="text" id="IDnumber" name="IDnumber" onkeyup="value=value.replace(/^(0+)|[^\d]+/g,'')"/></td>
                </tr>
                <tr>
                    <td>姓名</td>
                    <td><input type="text" id="name" name="name"  /></td>
                </tr>
                <tr>
                    <td>班级</td>
                    <td><input type="text" id="classroom" name="classroom"  /></td>
                </tr>
                <tr>
            <td>课程名称</td>
            <td>
                <input type="radio"name="major"value="大学英语"checked>大学英语
                <input type="radio"name="major"value="高等数学">高等数学
                <input type="radio"name="major"value="Java程序设计">Java程序设计
                <input type="radio"name="major"value="大学物理">大学物理
                <input type="radio"name="major"value="数据结构">数据结构
                
            </td>
        </tr>
                <tr>
                    <td>分数</td>
                    <td><input type="text" id="score" name="score" /></td>
                </tr>
                <tr>
                    <td><input type="submit" value="提交" /></td>
                    <td><input type="reset" value="重置" /></td>
                </tr>
            </table>
        </form>

        </div>
    </div>
</body>

<script type="text/javascript">
function check()                        //封装一个<body>中做成点击事件的函数
{
    
    if(document.getElementById('number').value=='') {
          alert('学号不能为空！');
          document.getElementById('number').focus();
          isInterger(housingArea);
          return false;
         }
    
    if(document.getElementById('name').value=='') {
          alert('姓名不能为空！');
          document.getElementById('name').focus();
          return false;
         }
    
    if(document.getElementById('classroom').value=='') {
          alert('教室不能为空！');
          document.getElementById('classroom').focus();
          return false;
         }
    if(document.getElementById('major').value=='') {
          alert('课程不能为空！');
          document.getElementById('major').focus();
          return false;
         }
     if(document.getElementById('score').value=='') {
          alert('分数不能为空！');
          document.getElementById('score').focus();
          return false;
         }
    return true;
}


</script>
</html>

 

（2）删除成员

deletepeople.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>
<script type="text/javascript">
function check(form)
{
    var name=form.name.value;
    if(name=="")
    {
        alert("名称不能为空");
        form.name.focus();
        return false;
    }
}
</script>
<h1 align="center">删除学生</h1>
<div class="content">
    <div class="main">
    <a href="manager.jsp">返回主页</a>
    <br><br>
        <form name="form" action="servletpeople?method=getbyname" method="post" onsubmit="return check(form)">
                <a>学生姓名:</a>&nbsp;&nbsp;<input type="text" id="name" name="name" />
                <br>
                <input type="submit" value="删除" />
                <br>
        </form>
        </div>
    </div>
</body>
</html>

 

(3)浏览页面

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<style type="text/css">
    .button{
                width: 1000px;
                height: 100px;
                
            }
</style>

<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>
     <h1>学生信息列表</h1>
    <div class="content">
        <div class="button">
        <a href="manager.jsp">返回主页</a>
            <form action="servletpeople?method=list" method="post" onsubmit="return check()">
             <table align="center">
            <tr>
                    <td><input type="submit" value="全部查询" /></td>
                    
                </tr>
      
            <tr>
                <th>学号</th>
                <th>姓名</th>
                <th>班级</th>
                <th>课程</th>
                <th>分数</th>
            </tr>
           <tbody id="list"> 
                <c:forEach items="${tens}" var="item">
                 
                <tr>
                  
                 <td>${item.IDnumber}</td>
                 <td>${item.name}</td>
                 <td>${item.classroom}</td>
                 <td>${item.major}</td>
                 <td>${item.socre}</td>
                    
                 <td><a href="xiugai.jsp">修改</a></td>
                </tr>
                </c:forEach>
                </tbody>
               
        </table>
        </form>
    </div>
    </div>
</body>
</html>

 

(4)查询j结果页面

list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>
     <h1>学生信息列表</h1>
    <div class="content">
        <div class="main">
        <a href="manager.jsp">返回主页</a>
        
        <table align="center">
         <tr>
                <th>学号</th>
                <th>姓名</th>
                <th>班级</th>
                <th>课程</th>
                <th>分数</th>
            </tr>
                <c:forEach items="${tens}" var="item">
                <tr>
                    <td><a href="servletpeople?method=getbyname&&name=${item.name}"></a></td>
                    <td>${item.IDnumber}</td>
                    <td>${item.name}</td>
                    <td>${item.classroom}</td>
                    <td>${item.major}</td>
                    <td>${item.socre}</td>
                </tr>
                </c:forEach>
        </table>
      
    </div>
</body>
</html>

(5)功能目录页面

manager.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>首页</title>
<style>
    .a{
        font-size: 26px;
        margin-top: 20px;
    }
</style>
</head>
<body style="background-color:  pink ">
    <%
         Object message = request.getAttribute("message");
         if(message!=null && !"".equals(message)){
     
    %>
         <script type="text/javascript">
              alert("<%=request.getAttribute("message")%>");
         </script>
    <%} %>
    <div align="center">
        <h1 style="color: red;">功能页</h1>
        <div class="a">
            <a href="addpeople.jsp">增加学生</a>
        </div>
        <div class="a">
            <a href="deletepeople.jsp">删除学生</a>
        </div>
        
        <div class="a">
            <a href="searchpeople.jsp">查找学生成绩</a>
        </div>
        <div class="a">
            <a href="sortscore.jsp">按成绩排序</a>
        </div>
        <div class="a">
            <a href="list.jsp">浏览</a>
        </div>
       
    </div>
</body>
</html>

 

(6)查询

searchpeople.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>
<h1>查找成绩</h1>
    <div class="content">
        <div class="main">
        <a href="manager.jsp">返回主页面</a>
        <br><br>
        <form name="form" action="servletpeople?method=search" method="post" >
    
            <a>学号</a>&nbsp;&nbsp;<input type="text" name="IDnumber" />
            <br><br>
            <a>姓名</a>&nbsp;&nbsp;<input type="text" name="name" />
            <br><br>
            <input type="submit" value="查找" />
        </form>
        </div>
    </div>
</body>
</html>

(7)修改

xiugai.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    <%@ page import="java.util.*" %>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>修改</title>
</head>
<body>
<%
          Object message = request.getAttribute("message");
          if(message!=null && !"".equals(message)){
      
     %>
          <script type="text/javascript">
               alert("<%=request.getAttribute("message")%>");
          </script>
     <%} %>

<a href="manager.jsp">返回主页</a>
    <div class="content">
        <div class="main">
        <form name="form" action="servletpeople?method=searchxiugai" method="post" onsubmit="return check()">
        <table align="center" border="1" width="1000"> 
            <tr>
                    <td>学号</td>
                    <td><input type="text" id="IDnumber" name="IDnumber" onkeyup="value=value.replace(/^(0+)|[^\d]+/g,'')"/></td>
                </tr>
                <tr>
                    <td>姓名</td>
                    <td><input type="text" id="name" name="name"  /></td>
                </tr>     
             <tr>
                <td>班级</td>
                <td><input type="text" id="classroom" name="classroom"  /></td>
            </tr>
            <tr>
                <td>课程名称</td>
                <td>
                    <input type="radio"name="major"value="大学英语"checked>大学英语
                    <input type="radio"name="major"value="高等数学">高等数学
                    <input type="radio"name="major"value="Java程序设计">Java程序设计
                    <input type="radio"name="major"value="大学物理">大学物理
                    <input type="radio"name="major"value="数据结构">数据结构
                </td>
           </tr>
            <tr>
                    <td>分数</td>
                    <td><input type="text" id="score" name="score" /></td>
            </tr>
           <tr>
                    <td><input type="submit" value="提交" /></td>
                    <td><input type="reset" value="重置" /></td>
            </tr>
                
           
            
        </table>
        </form>

        </div>
    </div>
</body>

<script type="text/javascript">
function check()                        //封装一个<body>中做成点击事件的函数
{
    
    if(document.getElementById('number').value=='') {
          alert('学号不能为空！');
          document.getElementById('number').focus();
          isInterger(housingArea);
          return false;
         }
    
    if(document.getElementById('name').value=='') {
          alert('姓名不能为空！');
          document.getElementById('name').focus();
          return false;
         }
    
    if(document.getElementById('classroom').value=='') {
          alert('教室不能为空！');
          document.getElementById('classroom').focus();
          return false;
         }
    if(document.getElementById('major').value=='') {
          alert('课程不能为空！');
          document.getElementById('major').focus();
          return false;
         }
     if(document.getElementById('score').value=='') {
          alert('分数不能为空！');
          document.getElementById('score').focus();
          return false;
         }
    return true;
}


</script>
</html>

 

<%@ page language="java" contentType="text/html; charset=UTF-8"    pageEncoding="UTF-8"%><%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%><!DOCTYPE html><html><head><meta charset="UTF-8"><title>Insert title here</title></head><body><%          Object message = request.getAttribute("message");          if(message!=null && !"".equals(message)){           %>          <script type="text/javascript">               alert("<%=request.getAttribute("message")%>");          </script>     <%} %>     <h1>学生信息列表</h1>    <div class="content">        <div class="main">        <a href="manager.jsp">返回主页</a>                <table align="center">         <tr>                <th>学号</th>                <th>姓名</th>                <th>班级</th>                <th>课程</th>                <th>分数</th>            </tr>                <c:forEach items="${tens}" var="item">                <tr>                    <td><a href="servletpeople?method=getbyname&&name=${item.name}"></a></td>                    <td>${item.IDnumber}</td>                    <td>${item.name}</td>                    <td>${item.classroom}</td>                    <td>${item.major}</td>                    <td>${item.socre}</td>                </tr>                </c:forEach>        </table>          </div></body></html>

 

posted on 2020-12-17 15:19  桑榆非晚柠月如风  阅读(62)  评论(0)  编辑  收藏  举报

Powered by: 博客园 Copyright © 2024 桑榆非晚柠月如风
Powered by .NET 8.0 on Kubernetes