📄 score.java
字号:
//Logindenglu.java
//验证密码,验证是否以参加考试,传送参数
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.*;
import java.sql.*;
import java.util.*;
public class Score extends HttpServlet
{
//初始化数据库类
static Connection conn;
DBConnectionBean dbcb = new DBConnectionBean();
//定义doPost方法用来接受数据
public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
{
//定义输出流
req.setCharacterEncoding("gb2312");
res.setContentType("text/html;charset=gb2312");
PrintWriter out = res.getWriter();
//提取表单数据
String DuserID = req.getParameter("textfield");
int iDuserID = new Integer(DuserID).intValue();
try
{
//桥接连接数据库
conn = dbcb.openConnection();
System.out.println("数据库连接成功....");
//定义sql命令,验证密码
PreparedStatement s = conn.prepareStatement
("select Score,tag,fullname,sex,class from allStuday where SID=?");
s.setInt(1,iDuserID);
ResultSet result = s.executeQuery();
boolean rowfound = false;
rowfound = result.next();
System.out.println("发送SQL命令成功....");
int ScoreR = result.getInt(1);
int tag=result.getInt(2);
String name=result.getString(3);
String Rsex = result.getString(4);
String Rclass = result.getString(5);
if(tag==0)
{
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv=Content-Type content='text/html; charset=gb2312'>");
out.println("<title>无标题文档</title>");
out.println
("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/fun.js'>");
out.println("</script>");
out.println("</head>");
out.println("<body >");
out.println("此学号还未参加考试！");
out.println("</body>");
out.println("</html>");
out.close();
}
else
{
out.println("<html>");
out.println("<head>");
out.println("<meta http-equiv='Content-Type' content='text/html; charset=gb2312'>");
out.println("<title>");
out.println("已答题完毕");
out.println("</title>");
out.println("<script language='JavaScript' type='text/JavaScript' src='/myside/examin/img/youno.js'>");
out.println("</script>");
out.println("<link href='/myside/examin/img/cssexamin.css' rel='stylesheet' type='text/css'>");
out.println("</head>");
out.println("<body>");
out.println("<div align='center'>");
out.println("<table width='75%' border='0' cellpadding='0' cellspacing='0' class='table'>");
out.println("<tr> <td><p>相关考试信息:</p> </td></tr>");
out.println("<tr> <td>姓名:"+name+"</td> </tr>");
out.println("<tr> <td>性别:"+Rsex+"</td> </tr>");
out.println("<tr> <td><p>班级:"+Rclass+"</p></td> </tr>");
out.println("<center>学号"+iDuserID);
out.println("的成绩:"+ScoreR);
out.println("</center><p>");
out.println("</p>");
out.println("</div>");
out.println("</body>");
out.println("</html>");
out.close();
}
}
//三个常见异常
catch(SQLException e)
{
System.out.println(e.toString());
}
catch(Exception e)
{
System.out.println(e.toString());
}
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -