📄 grades_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public final class grades_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static java.util.List _jspx_dependants;
public Object getDependants() {
return _jspx_dependants;
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
JspFactory _jspxFactory = null;
PageContext pageContext = null;
HttpSession session = null;
ServletContext application = null;
ServletConfig config = null;
JspWriter out = null;
Object page = this;
JspWriter _jspx_out = null;
PageContext _jspx_page_context = null;
try {
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
_jspx_page_context = pageContext;
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
_jspx_out = out;
out.write("\r\n");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<title>学生成绩查询</title>\r\n");
out.write("</head>\r\n");
myexam.myexam sanswer = null;
synchronized (_jspx_page_context) {
sanswer = (myexam.myexam) _jspx_page_context.getAttribute("sanswer", PageContext.PAGE_SCOPE);
if (sanswer == null){
sanswer = new myexam.myexam();
_jspx_page_context.setAttribute("sanswer", sanswer, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
myexam.myexam squestion = null;
synchronized (_jspx_page_context) {
squestion = (myexam.myexam) _jspx_page_context.getAttribute("squestion", PageContext.PAGE_SCOPE);
if (squestion == null){
squestion = new myexam.myexam();
_jspx_page_context.setAttribute("squestion", squestion, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
myexam.myexam sstudent = null;
synchronized (_jspx_page_context) {
sstudent = (myexam.myexam) _jspx_page_context.getAttribute("sstudent", PageContext.PAGE_SCOPE);
if (sstudent == null){
sstudent = new myexam.myexam();
_jspx_page_context.setAttribute("sstudent", sstudent, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
myexam.myexam ssubject = null;
synchronized (_jspx_page_context) {
ssubject = (myexam.myexam) _jspx_page_context.getAttribute("ssubject", PageContext.PAGE_SCOPE);
if (ssubject == null){
ssubject = new myexam.myexam();
_jspx_page_context.setAttribute("ssubject", ssubject, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
myexam.myexam ssuccess = null;
synchronized (_jspx_page_context) {
ssuccess = (myexam.myexam) _jspx_page_context.getAttribute("ssuccess", PageContext.PAGE_SCOPE);
if (ssuccess == null){
ssuccess = new myexam.myexam();
_jspx_page_context.setAttribute("ssuccess", ssuccess, PageContext.PAGE_SCOPE);
}
}
out.write('\r');
out.write('\n');
String snum="";
snum=(String)session.getAttribute("num1");
String str2="";
str2=(String)session.getAttribute("sbnum1");
int sbnum=Integer.parseInt(str2);
String str1="";
str1=(String)session.getAttribute("pnum2");
int pnum=Integer.parseInt(str1);
String sql3="select qnum,keys from answer where snum='"+snum+"' and sbnum="+sbnum+" and pnum="+pnum;
String sql4="select qnum,type,keys from question where sbnum="+sbnum+" and pnum="+pnum;
//查询成绩
String sql2="";
sql2="select success from success where snum='"+snum+"' and sbnum="+sbnum;
ResultSet rs5;
int score=0;
rs5=ssuccess.executeQuery(sql2);
if(rs5.next()){
score=rs5.getInt("success");
}
ssuccess.closeStmt();
ssuccess.closeConn();
ResultSet rs3;
ResultSet rs4;
out.write("\r\n");
out.write("\r\n");
out.write("<body bottommargin=\"0\" topmargin=\"0\" leftmargin=\"120\" rightmargin=\"120\" bgcolor=\"#cccccc\">\r\n");
out.write("<table background=\"images/bg.gif\" height=\"100%\" width=\"100%\">\r\n");
out.write("<tr>\r\n");
out.write(" <td align=\"center\" colspan=\"16\" height=\"90\"><img src=\"images/blank_banner.gif\"></td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>\r\n");
out.write(" <table width=\"274\">\r\n");
out.write("<tr>\r\n");
out.write(" <td width=\"89\" >准考证号：</td><td width=\"173\" colspan=\"15\">");
out.print(snum);
out.write("</td>\r\n");
out.write("</tr>\r\n");
ResultSet rs;
String sql="select sno,sname from student where snum='"+snum+"'";
rs=sstudent.executeQuery(sql);
if(rs.next()){
out.write("\r\n");
out.write("<tr>\r\n");
out.write(" <td>姓 名：</td>\r\n");
out.write(" <td colspan=\"15\">");
out.print(rs.getString("sname"));
out.write("</td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>学 号：</td>\r\n");
out.write(" <td>");
out.print(rs.getInt("sno"));
out.write("</td>\r\n");
out.write("</tr>\r\n");
}
sstudent.closeStmt();
sstudent.closeConn();
ResultSet rs1;
String sql1="select sbname from subject where sbnum="+sbnum;
rs1=ssubject.executeQuery(sql1);
if(rs1.next()){
out.write("\r\n");
out.write("<tr>\r\n");
out.write(" <td>科目名称：</td>\r\n");
out.write(" <td colspan=\"15\">");
out.print(rs1.getString("sbname"));
out.write("</td>\r\n");
out.write("</tr>\r\n");
}
ssubject.closeStmt();
ssubject.closeConn();
out.write("\r\n");
out.write("<tr>\r\n");
out.write(" <td>试 卷 号：</td>\r\n");
out.write(" <td>第");
out.print(pnum);
out.write("套</td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>分 数：</td>\r\n");
out.write(" <td>");
out.print(score);
out.write(" 分</td>\r\n");
out.write("</tr>\r\n");
out.write("</table>\r\n");
out.write("</td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td colspan=\"16\">下面是您的答案：</td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>\r\n");
out.write(" <table border=\"1\">\r\n");
out.write(" <tr>\r\n");
out.write("\t <td>题号</td>\r\n");
out.write("\t ");
rs3=sanswer.executeQuery(sql3);
while(rs3.next()){
out.print("<td>"+rs3.getInt("qnum")+"</td>");
}
sanswer.closeStmt();
sanswer.closeConn();
out.write("\r\n");
out.write("\t </tr>\r\n");
out.write("\t <tr>\r\n");
out.write("\t <td>答案</td>\r\n");
out.write("\t ");
rs3=sanswer.executeQuery(sql3);
while(rs3.next()){
if(rs3.getString("keys").equals("NUL")){
out.print("<td>无</td>");
}
else{
if(rs3.getString("keys").equals("1")){
out.print("<td>正确</td>");
}
else{
if(rs3.getString("keys").equals("0")){
out.print("<td>错误</td>");
}
else{
out.print("<td>"+rs3.getString("keys")+"</td>");
}
}
}
}
sanswer.closeStmt();
sanswer.closeConn();
out.write("\r\n");
out.write("\t </tr>\r\n");
out.write(" </table>\r\n");
out.write(" </td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>下面是标准答案：</td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>\r\n");
out.write(" <table border=\"1\">\r\n");
out.write(" <tr>\r\n");
out.write(" <td>题号</td>\r\n");
out.write("\t");
rs4=squestion.executeQuery(sql4);
while(rs4.next()){
out.print("<td>"+rs4.getInt("qnum")+"</td>");
}
squestion.closeStmt();
squestion.closeConn();
out.write("\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>答案</td>\r\n");
out.write("\t");
rs4=squestion.executeQuery(sql4);
while(rs4.next()){
if(rs4.getString("keys").equals("1")){
out.print("<td>正确</td>");
}
else{
if(rs4.getString("keys").equals("0")){
out.print("<td>错误</td>");
}
else{
out.print("<td>"+rs4.getString("keys")+"</td>");
}
}
}
squestion.closeStmt();
squestion.closeConn();
out.write("\r\n");
out.write(" </tr>\r\n");
out.write(" </table>\r\n");
out.write(" </td>\r\n");
out.write("</tr>\r\n");
out.write("<tr>\r\n");
out.write(" <td>\r\n");
out.write(" <table>\r\n");
out.write(" <tr>\r\n");
out.write(" <td align=\"center\">\r\n");
out.write(" <div>\r\n");
out.write(" <object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0\" width=\"103\" height=\"24\">\r\n");
out.write(" <param name=\"movie\" value=\"button5.swf\">\r\n");
out.write(" <param name=\"quality\" value=\"high\">\r\n");
out.write(" <param name=\"bgcolor\" value=\"#0099CC\">\r\n");
out.write(" <embed src=\"button5.swf\" quality=\"high\" pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" type=\"application/x-shockwave-flash\" width=\"103\" height=\"24\" bgcolor=\"#0099CC\"></embed>\r\n");
out.write(" </object>\r\n");
out.write("\t </div>\r\n");
out.write(" </td>\r\n");
out.write(" <td align=\"center\">\r\n");
out.write(" <div>\r\n");
out.write("\t <object classid=\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0\" width=\"103\" height=\"24\">\r\n");
out.write(" <param name=\"movie\" value=\"button7.swf\">\r\n");
out.write(" <param name=\"quality\" value=\"high\">\r\n");
out.write(" <param name=\"bgcolor\" value=\"#0099CC\">\r\n");
out.write(" <embed src=\"button7.swf\" quality=\"high\" pluginspage=\"http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash\" type=\"application/x-shockwave-flash\" width=\"103\" height=\"24\" bgcolor=\"#0099CC\"></embed>\r\n");
out.write(" </object>\r\n");
out.write("\t </div>\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write("\t</table>\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write("</table>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -