📄 panduanti.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.text.*"%>
<%@ page import="java.util.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>判断题</title>
<link href="css/site.css" rel="stylesheet" type="text/css" />
</head>
<body class="chinese">
<hr />
<p align="left">
<%!
int i=0;
int rightcount=0;
int times=0;
%>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String driver = "jdbc:microsoft:sqlserver://localhost:1433";
String user="jsp";
String password="820728";
Connection conn = DriverManager.getConnection(driver,"","");
Statement stmt = conn.createStatement();
int zhang=1;//Integer.parseInt(request.getParameter("zhang"));
ResultSet rs=stmt.executeQuery("SELECT * FROM panduanti where zhang="+zhang);
//判断request对象是否获得窗体数据
//若未获得则产生题目，若有获得数据，则将计算成绩
if(request.getParameter("submit1")==null)
{i=0;
rightcount=0;%>
<!--下面的窗体将以post方法，将数据传送给xuanze.jsp文件-->
<!-- 此为隐藏字段，其默认值为系统时间-->
<form name="allmyans" action="panduanti.jsp" method="post">
<input type="hidden" name="zhang" value="<%=zhang%>">
<table width="85%" border=0>
<%
String answer;
String answer1;
String answer2;
String answer3;
String answer4;
while(rs.next()){
i++;
%>
<tr>
<td><%=i%>、<%String Qus=rs.getString("tigan");%><%=Qus%>
<%//session.setAttribute("i",i);
answer=rs.getString("daan");
session.setAttribute("Qus"+i,Qus);
session.setAttribute("Ans"+i,answer);
%></td>
</tr>
<table>
<tr>
<td><input name="myans<%=i%>" type="radio" value="t" />T.</td>
<td><input name="myans<%=i%>" type="radio" value="f" />F.</td>
</tr>
</table>
<tr>
<td></td>
</tr>
<tr></tr>
<%}
if(i!=0)
{
%>
</table>
<table width="294" border="0">
<tr>
<td width="147"><input name="submit1" type="submit" class="button1" value="提交" /></td>
<td width="137"><input name="submit2" type="reset" class="button1" value="清除" /></td>
</tr>
</table>
</form>
<%
}
if(i==0)
{%>
本章暂时没有判断题题目……
<%
}
}
else
{
String zhang1=request.getParameter("zhang");
System.out.println(zhang1);
//int i=(int)session.getAttribute("i");
int j=1;
for(j=1;j<=i;j++)
{%>
<p>第<%=j%>题您
<%
//从session对象中获得题目与答案
String Ans=(String)session.getAttribute("Ans"+j);
String UserAns=request.getParameter("myans"+j);
%>
<%
if(UserAns==null)
{%>
<FONT size="4" color="RED">未作答</FONT><BR>题目是
<font color="green"><B>
<!--输出题目-->
<%=session.getAttribute("Qus"+j)%>
</B></font><br>答案是<font color="brown"><B><!--输出答案-->
[<%=Ans%>]</B></font>
<%
}else if(UserAns.equals(Ans))
{
//System.out.println(UserAns);
rightcount++;
%>
答<font size="4" color="blue" >对</font>了
</p>
<%
}
else {
%>答<font size="4" color="red">错</font>了</p>
题目是
<font color="green"><B>
<!--输出题目-->
<%=session.getAttribute("Qus"+j)%>
</B></font><br>答案是<font color="brown"><B><!--输出答案-->
[<%=Ans%>]</B></font>
<%}
}
%>
<h3><%=i%>题中您共答对了<%=rightcount%>题</h3>
<a href=panduanti.jsp?zhang=<%=zhang1%>>不甘心！再来一次</a>
<%
/*String uid="fafa";
String career=null;
int id=0;
int zhang=1;
times++;
String sql="insert into custom (id,uid,career,zhang,rightcount,times) values('"+id+"','"+uid+"','"+career+"','"+zhang+"','"+rightcount+"','"+times+"','"+"')";
stmt.executeUpdate(sql);*/
String uid="fafa";//(String)session.getAttribute("uid");
String career=null;
int id=0;
//int zhang=1;
times++;
java.util.Date today;
String dateOut,dateOut1;
Locale currentLocale=new Locale("zh","CN");
DateFormat formatter;
formatter = DateFormat.getDateInstance(DateFormat.LONG,currentLocale);
DateFormat formatter1;
formatter1=DateFormat.getTimeInstance(DateFormat.LONG,currentLocale);
today = new java.util.Date();
dateOut = formatter.format(today);
dateOut1=formatter1.format(today);
//System.out.println(dateOut + " " + currentLocale.toString());
//System.out.println(dateOut1 + " " + currentLocale.toString());
dateOut=dateOut+dateOut1;
String sql="insert into students_panduan values('"+uid+"','"+career+"',"+zhang+","+rightcount+","+times+",'"+dateOut+"')";
//stmt.executeUpdate(sql);
}
rs.close();
stmt.close();
conn.close();
%>
<p align="center"> </p>
<p align="center"> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -