<%@ 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>
浙公网安备 33010602011771号