526互联

课堂测试2

发布时间 2023-05-31 22:04:09作者: 布吉岛？？？
<%@ 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>
<form action="gerenxinxi1.jsp" method="get">
<table align="center" border="1" width="500">
			
			<tr>

				<td>姓名</td>

				<td><input type="text" name="name" /></td>

			</tr>
			<tr>

				<td>性别</td>

				<td><input type="text" name="sex" /></td>

			</tr>
			<tr>

				<td>年龄</td>

				<td><input type="text" name="age" /></td>

			</tr>
			<tr>

				<td>班级（所教授课程）</td>

				<td><input type="text" name="banji" /></td>

			</tr>
			<tr>

				<td>学号（教师号）</td>

				<td><input type="text" name="number" /></td>

			</tr>

			<tr align="center">

				<td colspan="2"><input type="submit" value="提交" /></td>

			</tr>


</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	<%@ page import="Util.dao"%>
	<%@ page import="Util.util"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String name = request.getParameter("name");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String number = request.getParameter("number");
String banji = request.getParameter("banji");
dao.xinxizeng(name,sex,age,banji,number);
%>
</body>
</html>

　　

<%@ 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>
<h1 style="text-align: center;">管理员界面界面</h1>
<center><input type="button" onclick="window.location.href='zhuce.jsp';" value="用户注册"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='deletexinxi.jsp';" value="删除用户信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatezhucexinxi.jsp';" value="修改用户身份"><br>

<br>
<center><input type="button" onclick="window.location.href='seeall.jsp';" value="查看所有用户信息"><br>
<center><input type="button" onclick="window.location.href='bujige.jsp';" value="查询不及格"><br>
<center><input type="button" onclick="window.location.href='youxiu.jsp';" value="查询优秀"><br>
</body>
</html>

　　

<%@ 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>
<h1 style="text-align: center;">教师界面</h1>
<center><input type="button" onclick="window.location.href='gerenxinxi.jsp';" value="完善个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='seexinxi.jsp';" value="查看个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatexinxi.jsp';" value="修改个人基本信息"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='addchengji.jsp';" value="录入个人所教授考试科目成绩"><br>
<br>
<br>
<center><input type="button" onclick="window.location.href='updatechengji.jsp';" value="修改个人所教授考试科目成绩"><br>

<br>
<center><input type="button" onclick="window.location.href='seebanjichengji.jsp';" value="查看所教授班级成绩"><br>
</body>
</html>

　　

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	<%@ page import="Util.util"%>
	<%@ page import="java.sql.Connection"%> 
<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 


<%
   java.sql.Connection sqlCon; //数据库连接对象
   java.sql.Statement sqlStmt; //SQL语句对象
   java.sql.ResultSet sqlRst;  //结果集对象
   java.lang.String strCon;    //数据库连接字符串
   java.lang.String strSQL;    //SQL语句
   int intPageSize;           //一页显示的记录数
   int intRowCount;           //记录总数
   int intPageCount;          //总页数
   int intPage;               //待显示页码
   java.lang.String strPage; 
   
   int i;
   //设置一页显示的记录数
   intPageSize = 3;

   //取得待显示页码
   strPage = request.getParameter("page");

   if(strPage==null){
       //表明在QueryString中没有page这一个参数，此时显示第一页数据
       intPage = 1;
   } else {
       //将字符串转换成整型
       intPage =java.lang.Integer.parseInt(strPage);
       if(intPage<1) intPage = 1;
   }
   Class.forName("com.mysql.cj.jdbc.Driver").newInstance();  
   String username = "root"; //用户名
   String password = "NN06280055"; //密码
   String url="jdbc:mysql://localhost:3306/kaoshi?useUnicode=true&characterEncoding=UTF-8";
   //连接数据库
   sqlCon=java.sql.DriverManager.getConnection(url,username,password);
   //创建语句对象
   sqlStmt =sqlCon.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
   //创建查询语句
	strSQL = "select * from xinxi";
   //执行SQL语句并获取结果集
  sqlRst = sqlStmt.executeQuery(strSQL);
   //获取记录总数
   sqlRst.last();
   intRowCount = sqlRst.getRow();
   //记算总页数
   intPageCount = (intRowCount+intPageSize-1) /intPageSize;
   //调整待显示的页码
   if(intPage>intPageCount) intPage = intPageCount;
%>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
        <title>数据分页显示</title>
    </head>
    <body>

        <center><table border=1 cellspacing=0 cellpadding=0>

            <tr>

               <td align=center width=100% colspan=5 bgcolor=#3399ff>


               </td>

            </tr>

            <tr>
	        
	        <td align="center" >姓名</td>
	        <td align="center" >性别</td>
	        <td align="center" >年龄</td>
	        	        <td align="center" >班级</td>
	        <td align="center" >学号</td>
	        </tr>
            <% if(intPageCount>0) {

                   //将记录指针定位到待显示页的第一条记录上

                   sqlRst.absolute((intPage-1)* intPageSize + 1);

                   //显示数据

                   i = 0;

                   while(i<intPageSize &&!sqlRst.isAfterLast()){

            %>

                <tr>
			<td><%=(sqlRst.getString("name")) %></td>
			<td><%=(sqlRst.getString("sex")) %></td>
			<td><%=(sqlRst.getString("age")) %></td>
						<td><%=(sqlRst.getString("banji")) %></td>
			<td><%=(sqlRst.getString("number")) %></td>
			</tr>




            <% sqlRst.next();

               i++;

               }

               }

            %>

        </table></center><br>



    <center>

        第<%=intPage%>页 共<%=intPageCount%>页



        <% //以下是分页的“上一页”“下一页”，有上一页就有链接，没有就为文字，下一页同理%>

        <% if(intPage>1){ %>

            <a href="seeall.jsp?page=<%=intPage-1%>">上一页</a>

        <% }else{ %>

            上一页

        <%}%>



        <% if(intPage<intPageCount){ %>

            <a href="seeall.jsp?=page=<%=intPage+1%>">下一页</a>

        <% }else{ %>

            下一页

        <%}%>

     <center>

    </body>



</html>



<%

   //关闭结果集

   sqlRst.close();

   //关闭SQL语句对象

   sqlRst.close();

   //关闭数据库

   sqlRst.close();

%>

　　

<%@ 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>
<form action="seebanjichengji1.jsp" method="get">
<table align="center" border="1" width="500">
			
			<tr>

				<td>班级</td>
				<td><input type="text" name="banji" /></td>
			</tr>
						<tr align="center">

				<td colspan="2"><input type="submit" value="提交" /></td>

			</tr>
			
</body>
</html>

　　

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	<%@ page import="Util.util"%>
	<%@ page import="java.sql.Connection"%> 
	<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
	         <tr>
	        <td align="center" >学号</td>
	        <td align="center" >班级</td>
	        <td align="center" >高数</td>
	        <td align="center" >信息</td>
	        <td align="center" >数据库</td>
	        </tr>
<%
String banji = request.getParameter("banji");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
	String sql = "SELECT * FROM chengji where banji='"+banji+"' ";
	ps = connection.prepareStatement(sql);
	ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
	while(rs.next()){
%>
			 <tr>
			<td><%=(rs.getString("xuehao")) %></td>//获取数据表中的信息
			<td><%=(rs.getString("banji")) %></td>
			<td><%=(rs.getString("gaoshu")) %></td>
			<td><%=(rs.getString("xinxi")) %></td>
			<td><%=(rs.getString("shujvku")) %></td>
			</tr>	
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

<%@ 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>
<form action="seechengji1.jsp" method="get">
<table align="center" border="1" width="500">
			
			<tr>

				<td>学号</td>
				<td><input type="text" name="xuehao" /></td>
			</tr>
						<tr align="center">

				<td colspan="2"><input type="submit" value="提交" /></td>

			</tr>
			
</body>
</html>

　　

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	<%@ page import="Util.util"%>
	<%@ page import="java.sql.Connection"%> 
	<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
	         <tr>
	        <td align="center" >学号</td>
	         <td align="center" >班级</td>
	        <td align="center" >高数</td>
	        <td align="center" >信息</td>
	        <td align="center" >数据库</td>
	        </tr>
<%
String xuehao = request.getParameter("xuehao");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
	String sql = "SELECT * FROM chengji where xuehao='"+xuehao+"' ";
	ps = connection.prepareStatement(sql);
	ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
	while(rs.next()){
%>
			 <tr>
			<td><%=(rs.getString("xuehao")) %></td>//获取数据表中的信息
			<td><%=(rs.getString("banji")) %></td>
			<td><%=(rs.getString("gaoshu")) %></td>
			<td><%=(rs.getString("xinxi")) %></td>
			<td><%=(rs.getString("shujvku")) %></td>
			</tr>	
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

<%@ 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>
<form action="seexinxi1.jsp" method="get">
<table align="center" border="1" width="500">
			
			<tr>

				<td>姓名</td>
				<td><input type="text" name="name" /></td>
			</tr>
						<tr align="center">

				<td colspan="2"><input type="submit" value="提交" /></td>

			</tr>
			
</body>
</html>

　　

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
	<%@ page import="Util.util"%>
	<%@ page import="java.sql.Connection"%> 
	<%@ page import="java.sql.PreparedStatement"%> 
<%@ page import="java.sql.SQLException"%> 
<%@ page import="java.sql.Statement"%> 
<%@ page import="java.sql.ResultSet"%> 
<%@page import="Util.dao" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在此处插入标题</title>
</head>
<body>
<jsp:useBean id="util" class="Util.util" scope="page" />
<table border="1"style="text-align:center;">
	         <tr>
	        <td align="center" >姓名</td>
	        <td align="center" >性别</td>
	        <td align="center" >年龄</td>
	        <td align="center" >班级（所教授课程）</td>
	        <td align="center" >学号（教师号）</td>
	        </tr>
<%
String name = request.getParameter("name");
Connection connection = util.getConnection();
PreparedStatement ps = null;
try {
	String sql = "SELECT * FROM xinxi where name='"+name+"' ";
	ps = connection.prepareStatement(sql);
	ResultSet rs = ps.executeQuery();//要用statement类的executeQuery()方法来下达select指令以查询数据库，executeQuery()方法会把数据库响应的查询结果存放在ResultSet类对象中供我们使用。即语句：ResultSet rs=s.executeQuery(sql);
	while(rs.next()){
%>
			 <tr>
			<td><%=(rs.getString("name")) %></td>//获取数据表中的信息
			<td><%=(rs.getString("sex")) %></td>
			<td><%=(rs.getString("age")) %></td>
			<td><%=(rs.getString("banji")) %></td>
			<td><%=(rs.getString("number")) %></td>
			</tr>	
<%
            }
        } catch (Exception e) {
            out.println(e);
        }
    %>
</body>
</html>

　　

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>在此处插入标题</title>
</head>
<body>
     <form action="updatechengji1.jsp" method="get">
<table align="center" border="1" width="500">
			
			<tr>

				<td>学号</td>
				<td><input type="text" name="xuehao" /></td>
			</tr>
						
			<tr>

				<td>高数成绩</td>
				<td><input type="text" name="gaoshu" /></td>
			</tr>
						<tr>

				<td>信息成绩</td>
				<td><input type="text" name="xinxi" /></td>
			</tr>
						<tr>

				<td>数据库成绩成绩</td>
				<td><input type="text" name="shujvku" /></td>
			</tr>
						<tr align="center">

				<td colspan="2"><input type="submit" value="提交" /></td>

			</tr>
</body>
</html>

　　

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
		<%@ page import="Util.dao"%>
	<%@ page import="Util.util"%>
<%@ page language="java" contentType="text/html; charset=GB18030"
    pageEncoding="GB18030"%>
<meta http-equiv="Content-Type" content="text/html; charset=GB18030">
<title>在此处插入标题</title>
</head>
<body>
<%
String xuehao = request.getParameter("xuehao");
String gaoshu = request.getParameter("gaoshu");
String xinxi = request.getParameter("xinxi");
String shujvku = request.getParameter("shujvku");
dao.updatechengji(xuehao,gaoshu,xinxi,shujvku);
%>
</body>
</html>