201819101039苏娜--作业3（2020.09.18）

于 2020-09-18 11:46:09 发布
阅读量91 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_45180451/article/details/108662387
版权

1.首页

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>首页</title>
</head>
<body>
<center>
<h2>在线测试系统</h2>
	<p>
		<font color="#4b5cc4">冷静思考，认真答题</font>
		|
		<a href="scorelist.jsp">成绩榜</a>
	</p>
	<form name="form1" method="get">
		用户名:<input type="text" name="username" />
		<br>
		<br>
		密&nbsp&nbsp&nbsp&nbsp码:<input type="password" name="psd" />
		<br>
		<br>
		<input type="button" value="登录" onclick="document.form1.action='check.jsp';document.form1.submit()">
		&nbsp&nbsp&nbsp&nbsp
		<input type="button" value="注册" onclick="document.form1.action='register.jsp';document.form1.submit()">
		<%!int pageCount = 0;%>
		<% pageCount++; %>
	    <p>Copyright @ 2019 | 访问次数：<%=pageCount%></p>
		<h5><font color="red" >如果已有账号，请直接登录；如果没有账号，则填入信息后直接点击注册</font></h5>
		</center>
	</form>
</body>
</html>

2.注册

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!--写一个java bean来存储你的数据库信息，下面之间调用就好了-->
<jsp:useBean id="mysql" class="beans.SQL_login" scope="page"/>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册</title>
</head>
<body>
	<center>
	<% 
		//获取用户名和密码
		String uname=request.getParameter("username");
		String pwd=request.getParameter("psd");
		if(uname!=null && pwd!=null && uname!="" && pwd!=""){
			//连接数据库，查找用户名和密码
			Connection conn= null;
	        conn=mysql.getConnection();
	        Statement stmt=conn.createStatement();
	        String sql="INSERT INTO login VALUES('"+uname+"','"+pwd+"')";
	        int re=stmt.executeUpdate(sql);
	        //处理结果
	        if(re==1){
	        	out.print("注册成功！点击");
	        	%>
	        <a href="Index.jsp">此处</a>
	        	<% 
	        	out.print("返回首页");
	        }else{
	        	%>
	        	<a href="Index.jsp">注册失败！请重新注册</a>
	        	<% 
	        }

		}else{
			%>
			<a href="Index.jsp">用户名或密码不能为空！请重新注册</a>
        	<% 
		}
				
	%>
	</center>
</body>
</html>

3.登录

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="mysql" class="beans.SQL_login" scope="page"/>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录</title>
</head>
<body>
<center>
			<%
				ResultSet re = null;
			//获取用户名和密码
				request.setCharacterEncoding("UTF-8");
				String uname=request.getParameter("username");
				String pwd=request.getParameter("psd");
				
			//连接数据库，查找用户名和密码
				Connection conn= null;
                conn=mysql.getConnection();
                Statement stmt=conn.createStatement();
                String sql="SELECT * FROM login WHERE username='"+uname+"' and password='"+pwd+"'";
                re=stmt.executeQuery(sql);
        
                //处理结果
                if(re!=null && re.next()){
                	session.setAttribute("username",uname);
                	%>
                	<h2>欢迎<%=uname %><a href='test.jsp'>开始测试</a></h2>
                	<%
                }else{
                	%>
                	<h2>请先注册！3秒后返回首页...</h2>
                	<%
                	response.setHeader("refresh", "3;url='Index.jsp'");
                }
                
              //关闭连接
                mysql.closeConnection(conn);	
               %>
               </center>
</body>
</html>

4.答题页

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="mysql" class="beans.SQL_login" scope="page"/>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>在线考试</title>
</head>
<body>
 
<%

String username=(String)session.getAttribute("username"); 
if(username==null){
	out.print("未登陆，3秒钟后重新登录");
	response.setHeader("refresh", "3;url='Index.jsp'");
}
else{
	%>
	
	考生:<%=session.getAttribute("username") %>
<center>
<h3>在线测试题</h3>
<form action="submit.jsp" onsubmit="return confirm('确定提交吗？')" method="get">

<%
	int i=0;
	Connection conn= null;
	conn=mysql.getConnection();
	Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	//随机出5道题
	String sql="SELECT * FROM test_topic ORDER BY RAND() LIMIT 5";
	ResultSet rs=stmt.executeQuery(sql);%>
	<table>
		<%
		while(rs.next()){	%>
		<tr><!-- 获取题目和选项  -->
			<td><%=++i%>.<%=rs.getString("topic")%><%=rs.getString("currect") %><br/>
			<input type="radio" value="A" name="q<%=i %>"><%=rs.getString("A")%><br/>
			<input type="radio" value="B" name="q<%=i %>"><%=rs.getString("B")%><br/>
			<input type="radio" value="C" name="q<%=i %>"><%=rs.getString("C")%><br/>
			<input type="radio" value="D" name="q<%=i %>"><%=rs.getString("D")%><br/><br/></td>
			<input type="hidden" name="id<%=i %>" value="<%=rs.getString("topicID")%>">
		</tr>
		<%}
		}%>
		
	</table>

		
		<button type="submit">提交</button>
		</center>
</form>
</body>
</html>

5.验证页

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<jsp:useBean id="mysql" class="beans.SQL_login" scope="page"/>
<!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>
<%
String username=(String)session.getAttribute("username"); 
if(username==null){
	out.print("未登陆，3秒钟后重新登录");
	response.setHeader("refresh", "3;url='Index.jsp'");
}
else{
	%>
	<h2>考生:<%=session.getAttribute("username") %><h2>
	<%
}

	int score=0;
	Connection con= mysql.getConnection();
	Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	//将题号插入列表
	String id1=request.getParameter("id1");
	String id2=request.getParameter("id2");
	String id3=request.getParameter("id3");
	String id4=request.getParameter("id4");
	String id5=request.getParameter("id5");
	List<String> da=new ArrayList();
	da.add(id1);
	da.add(id2);
	da.add(id3);
	da.add(id4);
	da.add(id5);
	//选取选项
	String q1=request.getParameter("q1");
	String q2=request.getParameter("q2");
	String q3=request.getParameter("q3");
	String q4=request.getParameter("q4");
	String q5=request.getParameter("q5");
		List<String> zq=new ArrayList();
		zq.add(q1);
		zq.add(q2);
		zq.add(q3);
		zq.add(q4);
		zq.add(q5);
		//提取正确答案
		for(int i=0;i<da.size();i++){
			if(zq.get(i)!=null){
				int a=Integer.parseInt(da.get(i));//遍历题号
				String b=zq.get(i);//遍历选项
				String sql="select currect from test_topic where topicID='"+a+"'";//查找题号所代表的题
				ResultSet rs=stmt.executeQuery(sql);
				if(rs.next()){
					if(b.equals(rs.getString("currect"))){//选项和答案比较
						score+=20;
					}
				}
			}else{
				score+=0;
		}
	}
	//将成绩存入成绩榜
	String sql1="INSERT INTO scorelist VALUES('"+username+"','"+score+"')";
	stmt.executeUpdate(sql1);
%>
<center>
	<h2>你的成绩是：<%=score %></h2></br>
	查看<a href="scorelist.jsp">成绩榜</a>
</center>
</body>
</html>

6.成绩榜

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="mysql" class="beans.SQL_login" scope="page"/>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>成绩榜</title>
</head>
<body>
<% 
	Connection conn= null;
	conn=mysql.getConnection();
	Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	String sql="select * from scorelist";
    ResultSet rs=stmt.executeQuery(sql);
    rs.last();
%>
<center>
<h2>成绩榜</h2>
	<table border="2" bgcolor= "CCCEEE" width="600">
                <tr bgcolor="CCCCCC" align="center">
                	<th>编号</th>
                    <th>姓名</th>
                    <th>成绩</th>
                </tr>
                <%
                    rs.beforeFirst(); //移至第一条记录之前
                    while(rs.next()){
                %>
                <tr align="center">
                    <td><%= rs.getRow()%></td>
                    <td><%= rs.getString("username")%> </td>
                    <td><%= rs.getString("score")%> </td>
                </tr>
                <%} 
                    mysql.closeConnection(conn);
                %>
      </table>
      <a href="Index.jsp">返回首页</a>
</center>
</body>
</html>

7.

苏良好
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值