登录页面
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js.js"></script>
<script src="js/bootstrap.bundle.js.js"></script>
<style>
.top
{
margin-top: 15%;
}
.panel-group a
{
color: black;
}
.panel-group
{
margin-top: 10%;
}
.table
{
width: 50%;
}
</style>
<head>
<title>首页</title>
</head>
<body style="background-image:url(img/1.jpg) " >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column" align="center">
<div class="top"> <h1>欢迎登录考试系统！</h1><br></div>
<div class="panel-group" id="panel-451462">
<table class="table">
<tr>
<td>
<div class="panel-heading">
<a class="panel-title collapsed" data-toggle="collapse" data-parent="#panel-451462" href="javascript:on(1);"><font size="+3">教师</font></a>
</div>
</td>
<td>
<div class="panel-body" id="teacher-finally" style="display: none">
<form action="teachergo.jsp">
<div class="form-group">
<label for="teachername">编号：</label><input type="text" class="form-control" id="teacherid" name="teacherid"/>
</div>
<div class="form-group">
<label for="teachername">账号：</label><input type="text" class="form-control" id="teachername" name="teachername"/>
</div>
<div class="form-group">
<label for="teacherpass">密码:</label><input type="password" class="form-control" id="teacherpass" name="teacherpass"/>
</div>
<div class="checkbox">
</div> <button type="submit" class="btn btn-default">提交</button>
</form>
</div>
</td>
</tr>
<tr class="error">
<td>
<div class="panel-heading">
<a class="panel-title" data-toggle="collapse" data-parent="#panel-451462" href="javascript:on(2);"><font size="+3">学生</font></a>
</div>
</td>
<td>
<div class="panel-body"id="student-finally" style="display: none">
<form action="studentgo.jsp">
<div class="form-group">
<label for="studentname">学号：</label><input type="text" class="form-control" id="studentid" name="studentid"/>
</div>
<div class="form-group">
<label for="studentname">账号：</label><input type="text" class="form-control" id="studentname" name="studentname"/>
</div>
<div class="form-group">
<label for="studentpass">密码:</label><input type="password" class="form-control" id="studentpass" name="studentpass" />
</div>
<div class="checkbox">
</div> <button type="submit" class="btn btn-default">提交</button>
</form>
</div>
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
</body>
<script language="JavaScript">
function on(i) {
if(i%2!=0)
{
document.getElementById("teacher-finally").style.display="";
document.getElementById("student-finally").style.display="none";
}
else
{
document.getElementById("student-finally").style.display="";
document.getElementById("teacher-finally").style.display="none";
}
}
</script>
教师登录判断
<%
String teachername=request.getParameter("teachername");
String teacherpass=request.getParameter("teacherpass");
int teacherid=Integer.parseInt(request.getParameter("teacherid"));
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from teacher where id=? and name=? and pass=?";
PreparedStatement ps=connection.prepareStatement(sql);
ps.setInt(1,teacherid);
ps.setString(2,teachername);
ps.setString(3,teacherpass);
ResultSet rs=ps.executeQuery();
if(rs.next())
{
session.setAttribute("username",teachername);
response.sendRedirect("teacherok.jsp");
}
else {
out.print("<h1>账号或密码错误,3秒后返回登录页面</h1>");
response.setHeader("refresh","3,url=1.jsp");
}
%>
教师登录成功页面
<head>
<title>教师系统</title>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js.js"></script>
<script src="js/bootstrap.bundle.js.js"></script>
</head>
<%
if (session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else {
} String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<style>
.col-md-12
{
margin-top: 10%;
}
#tablediv
{
align-content: center;
}
.table1
{
align-content: center;
margin-top: 3%;
height: 35%;
}
.table1 a
{
color: #212529;
}
</style>
<body style="background-image: url(img/ok1.jpg)">
<div class="col-md-12 column" align="center">
<h3>
<% out.print("欢迎"+session.getAttribute("username")+"教师");%>
</h3>
<a id="modal-522867" href="#modal-container-522868" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>修改密码</font></button></a>
<div align="center">
<div class="modal fade" id="modal-container-522868" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="updateteacher.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
修改密码
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">原密码</label><input type="text" class="form-control" id="exampleInputEmail1" name="teachertext"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">新密码</label><input type="password" class="form-control" id="exampleInputPassword1" name="teachertext2" />
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table1">
<tr>
<td>
<a href="studentnews.jsp"><font size="+3">查看学生信息</font></a>
</td>
</tr>
<tr>
<td>
<a href="javascript:out()"><font size="+3">查看考试题目</font></a>
<div id="testdiv" style="display: none;">
<table>
<tr>
<ul type="square"><Li><a href="danxvan.jsp" ><font size="+2">单项选择题</font></a></Li>
<li> <a href="duoxvan.jsp" ><font size="+2">多项选择题</font></a></li>
<li> <a href="panduan.jsp" ><font size="+2">判断题</font></a></li>
</ul>
</tr>
</table>
</div>
</td></tr>
<tr>
<td>
<a href="selectresult.jsp"><font size="+3">查看考试成绩</font></a>
</td>
</tr>
</table>
</div>
</div>
</body>
<script language="JavaScript">
var i=0;
function out() {
i++;
if (i%2==0)
{
document.getElementById("testdiv").style.display="none";
}
else
{
document.getElementById("testdiv").style.display="";
}
}
</script>
教师查看学生页面
<head>
<title>学生信息</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from student ";
PreparedStatement pstm=connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")!=null)
{
}
else
{
response.sendRedirect("1.jsp");
} String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="Idselectstudentnews.jsp"><input type="text" name="IdSelect" value="按编号查找学生"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>教师！</h2>
<a id="modal-522867" href="#modal-container-522867" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>插入</font></button></a>
<a id="modal-522877" href="teacherok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回教师系统</font></button></a>
<div class="modal fade" id="modal-container-522867" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="insertnewstudent.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
添加学生
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">用户名</label><input type="text" class="form-control" id="exampleInputEmail1" name="text1"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">密码</label><input type="password" class="form-control" id="exampleInputPassword1" name="pass1" />
</div>
<div class="form-group">
<label for="exampleInputEmail2">年龄</label><input type="text" class="form-control" id="exampleInputEmail2" name="text2"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">性别</label><input type="text" class="form-control" id="exampleInputPassword2" name="text3"/>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
用户名
</th>
<th>
密码
</th>
<th>
年龄
</th>
<th>
性别
</th>
<th>
操作
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("name")+
"</td><td>"+rs.getString("pass")+
"</td><td>"+rs.getString("age")+
"</td><td>"+rs.getString("sex")+
"</td><td COLSPAN=2><a href='deletestudent.jsp?id="+rs.getString("id")+"'>删除</a>"
+" <a href='updatastudent.jsp?id="+rs.getString("id")+"'>修改</a>"+"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
教师查看单选题、判断题、多选题页面
<head>
<title>单项选择题</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from danxvan ";
PreparedStatement pstm=connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="Idselectdanxvan.jsp"><input type="text" name="IdSelect" value="按编号查找单项选择题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>教师！</h2>
<a id="modal-522867" href="#modal-container-522867" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>插入</font></button></a>
<a id="modal-522877" href="teacherok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回教师系统</font></button></a>
<div class="modal fade" id="modal-container-522867" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="insertdanxvan.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
添加试题
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">题目：</label><input type="text" class="form-control" id="exampleInputEmail1" name="text1"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">选项A：</label><input type="text" class="form-control" id="exampleInputPassword1" name="text2" />
</div>
<div class="form-group">
<label for="exampleInputEmail2">选项B：</label><input type="text" class="form-control" id="exampleInputEmail2" name="text3"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">选项C:</label><input type="text" class="form-control" id="exampleInputPassword2" name="text4"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">选项D:</label><input type="text" class="form-control" id="exampleInputPassword3" name="text5"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">答案:</label><input type="text" class="form-control" id="exampleInputPassword4" name="text6"/>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th>
选项
</th>
<th>
选项B
</th>
<th>
选项C
</th>
<th >
选项D
</th>
<th colspan="3">
答案
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("first")+
"</td><td>"+rs.getString("second")+
"</td><td>"+rs.getString("third")+
"</td><td>"+rs.getString("forth")+
"</td><td>"+rs.getString("result")+
"</td><td ><a href='deletedanxvan.jsp?id="+rs.getString("id")+"'>删除</a></td>"
+" <td><a href='updatedanxvan.jsp?id="+rs.getString("id")+"'>修改</a>"+"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
<head>
<title>多项选择题</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from duoxvan ";
PreparedStatement pstm=connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="Idselectduoxvan.jsp"><input type="text" name="IdSelect" value="按编号查找多项选择题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>教师！</h2>
<a id="modal-522867" href="#modal-container-522867" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>插入</font></button></a>
<a id="modal-522877" href="teacherok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回教师系统</font></button></a>
<div class="modal fade" id="modal-container-522867" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="insertduoxvan.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
添加试题
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">题目：</label><input type="text" class="form-control" id="exampleInputEmail1" name="text1"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">选项A：</label><input type="text" class="form-control" id="exampleInputPassword1" name="text2" />
</div>
<div class="form-group">
<label for="exampleInputEmail2">选项B：</label><input type="text" class="form-control" id="exampleInputEmail2" name="text3"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">选项C:</label><input type="text" class="form-control" id="exampleInputPassword2" name="text4"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">选项D:</label><input type="text" class="form-control" id="exampleInputPassword3" name="text5"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">选项E:</label><input type="text" class="form-control" id="exampleInputPassword6" name="text6"/>
</div>
<div class="form-group">
<label for="exampleInputPassword2">答案:</label><input type="text" class="form-control" id="exampleInputPassword7" name="text7"/>
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th>
选项A
</th>
<th>
选项B
</th>
<th>
选项C
</th>
<th>
选项D
</th>
<th >
选项E
</th>
<th colspan="3">
答案
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("first")+
"</td><td>"+rs.getString("second")+
"</td><td>"+rs.getString("third")+
"</td><td>"+rs.getString("forth")+
"</td><td>"+rs.getString("fifth")+
"</td><td>"+rs.getString("result")+
"</td><td ><a href='deleteduoxvan.jsp?id="+rs.getString("id")+"'>删除</a></td>"
+" <td><a href='updateduoxvan.jsp?id="+rs.getString("id")+"'>修改</a>"+"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
<head>
<title>判断题</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from panduan ";
PreparedStatement pstm=connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="Idselectpanduan.jsp"><input type="text" name="IdSelect" value="按编号查找判断题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>教师！</h2>
<a id="modal-522867" href="#modal-container-522867" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>插入</font></button></a>
<a id="modal-522877" href="teacherok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回教师系统</font></button></a>
<div class="modal fade" id="modal-container-522867" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="insertpanduan.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
添加试题
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">题目：</label><input type="text" class="form-control" id="exampleInputEmail1" name="text1"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">正误：</label><input type="text" class="form-control" id="exampleInputPassword1" name="text2" />
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th colspan="2">
正误
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("fals")+
"</td><td ><a href='deletepanduan.jsp?id="+rs.getString("id")+"'>删除</a></td>"
+" <td><a href='updatepanduan.jsp?id="+rs.getString("id")+"'>修改</a>"+"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
教师查看成绩页面
<html>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js.js"></script>
<script src="js/bootstrap.bundle.js.js"></script>
<head>
<title>查看成绩</title>
</head>
<style>
.col-md-12
{
margin-top: 10%;
}
#tablediv
{
align-content: center;
}
.table1
{
align-content: center;
margin-top: 3%;
height: 35%;
}
.table1 a
{
color: #212529;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from result ";
PreparedStatement pstm=connection.prepareStatement(sql);
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="Idselectresult.jsp"><input type="text" name="IdSelect" value="按编号查找学生"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>教师！</h2>
<a id="modal-522877" href="teacherok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回教师系统</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
姓名
</th>
<th>
日期
</th>
<th>
时间
</th>
<th>
成绩
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("name")+
"</td><td>"+rs.getString("date")+
"</td><td>"+rs.getString("time")+
"</td><td>"+rs.getString("test")+
"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
学生登录页面
<head>
<title>学生考试</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js.js"></script>
<script src="js/bootstrap.bundle.js.js"></script>
<%
String username=session.getAttribute("username").toString();
int userid=Integer.parseInt(session.getAttribute("userid").toString());
if (session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else {
}
session.setAttribute("username",username);
session.setAttribute("userid",userid);
%>
<style>
.col-md-12
{
margin-top: 10%;
}
#tablediv
{
align-content: center;
}
.table1
{
align-content: center;
height: 120%;
margin-top: 5%;
}
.table1 a
{
color: #212529;
}
</style>
<body style="background-image: url(img/ok1.jpg)">
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column" align="center">
<h3>
<% out.print("欢迎"+session.getAttribute("username")+"同学");%>
</h3>
<a id="modal-522867" href="#modal-container-522868" role="button" class="btn" data-toggle="modal"><button type="button" class="btn btn-default btn-primary" ><font>修改密码</font></button></a>
<div align="center">
<div class="modal fade" id="modal-container-522868" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog">
<form role="form" action="updatestudent3.jsp">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="myModalLabel">
修改密码
</h4>
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
</div>
<div class="modal-body">
<div class="form-group">
<label for="exampleInputEmail1">原密码</label><input type="text" class="form-control" id="exampleInputEmail1" name="text1"/>
</div>
<div class="form-group">
<label for="exampleInputPassword1">新密码</label><input type="password" class="form-control" id="exampleInputPassword1" name="text2" />
</div>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal">关闭</button> <button type="submit" class="btn btn-primary">提交</button>
</div>
</div>
</form>
</div>
</div>
<table class="table1">
<tr>
<td>
<a href="updatestudent4.jsp"><font size="+3">修改信息 </font></a>
</td>
</tr>
<tr>
<td>
<a href="javascript:out()"><font size="+3">查看考题</font></a>
<div id="testdiv" style="display: none;">
<table>
<tr>
<ul type="square"><Li><a href="sdanxvan.jsp" ><font size="+2">单选</font></a></Li>
<li> <a href="sduoxvan.jsp" ><font size="+2">多选</font></a></li>
<li> <a href="spanduan.jsp" ><font size="+2">判断</font></a></li>
</ul>
</tr>
</table>
</div>
</td></tr>
<tr>
<td>
<a href="test.jsp"><font size="+3">在线考试</font></a>
</td>
</tr>
<tr>
<td>
<a href="resultnews.jsp"><font size="+3" >成绩查询</font></a>
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
</body>
<script language="JavaScript">
var i=0;
function out() {
i++;
if (i%2==0)
{
document.getElementById("testdiv").style.display="none";
}
else
{
document.getElementById("testdiv").style.display="";
}
}
</script>
学生修改信息页面
<head>
<title>修改信息</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<body>
<form action="updatestudent5.jsp" method="get">
<%
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from student where name=?";
PreparedStatement pstm=connection.prepareStatement(sql);
pstm.setString(1,username);
ResultSet rs=pstm.executeQuery();
%>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<h2 align="center">修改用户！</h2>
<a id="modal-522877" href="studentok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回学生考试</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th></th>
<th>
用户名
</th>
<th>
年龄
</th>
<th>
性别
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print("<td>原信息</td>"+
"</td><td>"+rs.getString("name")+
"</td><td>"+rs.getInt("age")+
"</td><td>"+rs.getString("sex")+
"</td>");
out.print("</tr>");
}%>
<tr>
<td>修改信息</td>
<td><input type="text" name="name" ></td>
<td><input type="text" name="age"></td>
<td><input type="text" name="sex"></td>
</tr>
<tr><td colspan="5" style="text-align: center;"><input type="submit" value="提交"></td></tr>
</tbody>
</table>
</div>
</div>
</div>
</form>
</body>
学生查看单选、多选、判断
<head>
<title>按编号查找单选</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from danxvan where id=?";
PreparedStatement pstm=connection.prepareStatement(sql);
pstm.setInt(1,Integer.parseInt(request.getParameter("IdSelect")));
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="sIdselectdanxvan.jsp"><input type="text" name="IdSelect" value="按编号查找单项选择题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>同学！</h2>
<a id="modal-522877" href="studentok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回学生考试</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th>
选项
</th>
<th>
选项B
</th>
<th>
选项C
</th>
<th >
选项D
</th>
<th colspan="3">
答案
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("first")+
"</td><td>"+rs.getString("second")+
"</td><td>"+rs.getString("third")+
"</td><td>"+rs.getString("forth")+
"</td><td>"+rs.getString("result")+
"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
<head>
<title>按编号查找多选</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from duoxvan where id=?";
PreparedStatement pstm=connection.prepareStatement(sql);
pstm.setInt(1,Integer.parseInt(request.getParameter("IdSelect")));
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="sIdselectduoxvan.jsp"><input type="text" name="IdSelect" value="按编号查找单项选择题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>同学！</h2>
<a id="modal-522877" href="studentok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回学生考试</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th>
选项A
</th>
<th>
选项B
</th>
<th>
选项C
</th>
<th>
选项D
</th>
<th >
选项E
</th>
<th colspan="3">
答案
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("first")+
"</td><td>"+rs.getString("second")+
"</td><td>"+rs.getString("third")+
"</td><td>"+rs.getString("forth")+
"</td><td>"+rs.getString("fifth")+
"</td><td>"+rs.getString("result")+
"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
<head>
<title>按编号查找判断</title>
</head>
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.bundle.js"></script>
<script src="js/bootstrap.js"></script>
<style>
.col-md-12
{
margin-top: 100px;
}
</style>
<%
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from panduan where id=?";
PreparedStatement pstm=connection.prepareStatement(sql);
pstm.setInt(1,Integer.parseInt(request.getParameter("IdSelect")));
ResultSet rs=pstm.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
%>
<body >
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<div align="right"><form action="sIdselectpanduan.jsp"><input type="text" name="IdSelect" value="按编号查找单项选择题"><input type="submit"value="查找"></form></div>
<h2 align="center">欢迎<%out.print(username);%>同学！</h2>
<a id="modal-522877" href="studentok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回学生考试</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
题目
</th>
<th colspan="2">
正误
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("title")+
"</td><td>"+rs.getString("fals")+
"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
学生考试页面
<head>
<title>考试页面</title>
</head>
<%
response.setHeader("refresh","1800,url=test2.jsp");
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql1="select * from danxvan ";
PreparedStatement pstm1=connection.prepareStatement(sql1);
ResultSet rs1=pstm1.executeQuery();
String sql2="select * from duoxvan ";
PreparedStatement pstm2=connection.prepareStatement(sql2);
ResultSet rs2=pstm2.executeQuery();
String sql3="select * from panduan ";
PreparedStatement pstm3=connection.prepareStatement(sql3);
ResultSet rs3=pstm3.executeQuery();
if(session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else
{
}
String username=session.getAttribute("username").toString();
session.setAttribute("username",username);
int userid=Integer.parseInt(session.getAttribute("userid").toString());
session.setAttribute("userid",userid);
%>
<body onload="show()">
<div >
<h2 align="center">欢迎<%out.print(username);%>同学！</h2>
<div align="right"><div align="right">
<span id="_m"> </span>:
<span id="_s"> </span></div></div>
<form action="test2.jsp">
<table width="100%">
<tr><td colspan="5"><h3>一、单项选择题</h3></td></tr>
<%
int i=1;
while( rs1.next())
{
out.print(
"<tr><td width='1%'>"+rs1.getString("id")+'.'+
"</td><td colspan="+4+">"+rs1.getString("title")+
"</td></tr><tr><td></td><td>A.<input type='radio' id='dx"+i*10+"1' name='dx"+i+"' value='A'>"+rs1.getString("first")+
"</td><td>B.<input type='radio' id='dx"+i*10+"2' name='dx"+i+"' value='B'>"+rs1.getString("second")+
"</td><td>C.<input type='radio' id='dx"+i*10+"3' name='dx"+i+"' value='C'>"+rs1.getString("third")+
"</td><td>D.<input type='radio' id='dx"+i*10+"4' name='dx"+i+"' value='D'>"+rs1.getString("forth")+
"</td></tr>");
i++;
}%>
</table>
<table width="100%">
<tr><td colspan="6"><h3>二、多项选择题</h3></td></tr>
<%
int j=1;
while( rs2.next())
{
out.print(
"<tr><td width='1%'>"+rs2.getString("id")+'.'+
"</td><td colspan="+5+">"+rs2.getString("title")+
"</td></tr><tr><td></td><td>A.<input type='checkbox' id='bx"+j*10+"1' name='bx"+j+"' value='A'>"+rs2.getString("first")+
"</td><td>B.<input type='checkbox' id='bx"+j*10+"2' name='bx"+j+"' value='B'>"+rs2.getString("second")+
"</td><td>C.<input type='checkbox' id='bx"+j*10+"3' name='bx"+j+"' value='C'>"+rs2.getString("third")+
"</td><td>D.<input type='checkbox' id='bx"+j*10+"4' name='bx"+j+"' value='D'>"+rs2.getString("forth")+
"</td><td>E.<input type='checkbox' id='bx"+j*10+"5' name='bx"+j+"' value='E'>"+rs2.getString("fifth")+
"</td></tr>");
j++;
}%>
</table>
<table width="100%">
<tr><td colspan="3"><h3>三、判断题</h3></td></tr>
<%
int k=1;
while( rs3.next())
{
out.print(
"<tr><td width='1%'>"+rs3.getString("id")+'.'+
"</td><td>"+rs3.getString("title")+
"</td><td> <input type='text' id='pd"+k*10+"1' name='pd"+k+"' size='1px' >"+
"</td></tr>");
k++;
}%>
</table>
<div align="right" style="margin-top: 5%; width: 80%;"><input type="submit" value="提交"></div>
</form>
</div>
</body>
<script language="JavaScript">
function show() {
alert("答题时间为半小时，计时开始")
start();
}
// new Date("日期").getTime()为指定日期毫秒数
var wtime = new Date().getTime()+1800000;//数获取当前时间加半小时的毫秒数
function start() {
var newtime=new Date().getTime();
var lefttime = (wtime-newtime)/1000;//获取指定日期和当前时间的相差的秒数
var min = parseInt(lefttime/60%60);//转化为分钟数
var sec = parseInt(lefttime%60);//转化为秒数
document.getElementById("_m").innerHTML = min;
document.getElementById("_s").innerHTML = sec;
setInterval(start,1000);
}
</script>
学生成绩查询页面
<link rel="stylesheet" href="css/bootstrap.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.js.js"></script>
<script src="js/bootstrap.bundle.js.js"></script>
<head>
<title>成绩信息</title>
</head><style>
.col-md-12
{
margin-top: 10%;
}
#tablediv
{
align-content: center;
}
.table1
{
align-content: center;
margin-top: 3%;
height: 35%;
}
.table1 a
{
color: #212529;
}
</style>
<%
String username=session.getAttribute("username").toString();
int userid=Integer.parseInt(session.getAttribute("userid").toString());
session.setAttribute("username",username);
session.setAttribute("userid",userid);
if (session.getAttribute("username")==null)
{
response.sendRedirect("1.jsp");
}
else {
}
Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/homework";
Connection connection= DriverManager.getConnection(url,"root","root");
String sql="select * from result where id=?";
PreparedStatement pstm=connection.prepareStatement(sql);
pstm.setInt(1,userid);
ResultSet rs=pstm.executeQuery();
%>
<body>
<div class="container">
<div class="row clearfix">
<div class="col-md-12 column">
<h2 align="center">欢迎<%out.print(username);%>同学！</h2>
<a id="modal-522877" href="studentok.jsp" class="btn" ><button type="button" class="btn btn-default btn-primary" ><font>返回学生考试页面</font></button></a>
<table class="table table-hover table-striped">
<thead>
<tr>
<th>
编号
</th>
<th>
姓名
</th>
<th>
日期
</th>
<th>
时间
</th>
<th>
成绩
</th>
</tr>
</thead>
<tbody>
<%
while( rs.next())
{
out.print("<tr>");
out.print(
"<td>"+rs.getString("id")+
"</td><td>"+rs.getString("name")+
"</td><td>"+rs.getString("date")+
"</td><td>"+rs.getString("time")+
"</td><td>"+rs.getString("test")+
"</td>");
out.print("</tr>");
}%>
</tbody>
</table>
</div>
</div>
</div>
</body>
9932
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
