📄 exportscore_jsp.java
字号:
package org.apache.jsp;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.util.*;
import com.bean.util.DbConn;
public final class exportscore_jsp extends org.apache.jasper.runtime.HttpJspBase
implements org.apache.jasper.runtime.JspSourceDependent {
private static final JspFactory _jspxFactory = JspFactory.getDefaultFactory();
private static java.util.List _jspx_dependants;
private javax.el.ExpressionFactory _el_expressionfactory;
private org.apache.AnnotationProcessor _jsp_annotationprocessor;
public Object getDependants() {
return _jspx_dependants;
}
public void _jspInit() {
_el_expressionfactory = _jspxFactory.getJspApplicationContext(getServletConfig().getServletContext()).getExpressionFactory();
_jsp_annotationprocessor = (org.apache.AnnotationProcessor) getServletConfig().getServletContext().getAttribute(org.apache.AnnotationProcessor.class.getName());
}
public void _jspDestroy() {
}
public void _jspService(HttpServletRequest request, HttpServletResponse response)
throws java.io.IOException, ServletException {
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 {
response.setContentType("text/html;charset=gbk");
pageContext = _jspxFactory.getPageContext(this, request, response,
null, 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');
out.write('\n');
if(session.getAttribute("user")==null||!session.getAttribute("role").toString().equals("teacher")){
response.sendRedirect("login.jsp");
return;
}
else{
}
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
out.write("\r\n");
out.write("\r\n");
out.write("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">\r\n");
out.write("<html>\r\n");
out.write(" <head>\r\n");
out.write(" <base href=\"");
out.print(basePath);
out.write("\">\r\n");
out.write(" <title>My JSP 'exportscore.jsp' starting page</title>\r\n");
out.write(" \r\n");
out.write("\t<meta http-equiv=\"pragma\" content=\"no-cache\">\r\n");
out.write("\t<meta http-equiv=\"cache-control\" content=\"no-cache\">\r\n");
out.write("\t<meta http-equiv=\"expires\" content=\"0\"> \r\n");
out.write("\t<meta http-equiv=\"keywords\" content=\"keyword1,keyword2,keyword3\">\r\n");
out.write("\t<meta http-equiv=\"description\" content=\"This is my page\">\r\n");
out.write("\t<script type=\"text/javascript\" charset=\"utf-8\">\r\n");
out.write("\t\tfunction getResult(stateVal) {\r\n");
out.write("\t\t\tif(stateVal==\"\"){\r\n");
out.write("\t\t\t\t//alert(\"所选课程暂无授课班级\");\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t\telse{\r\n");
out.write("\t\t\t\tvar url = \"");
out.print(basePath);
out.write("FirstAjax?cour_id=\"+stateVal;\r\n");
out.write("\t\t\t\tif (window.XMLHttpRequest) {\r\n");
out.write("\t\t\t\t\treq = new XMLHttpRequest();\r\n");
out.write("\t\t\t\t}\r\n");
out.write("\t\t\t\telse if (window.ActiveXObject) {\r\n");
out.write("\t\t\t\t\treq = new ActiveXObject(\"Microsoft.XMLHTTP\");\r\n");
out.write("\t\t\t\t}\r\n");
out.write("\t\t\t\tif(req){\r\n");
out.write("\t\t\t\t\treq.open(\"GET\",url, true);\r\n");
out.write("\t\t\t\t\treq.onreadystatechange = complete;\r\n");
out.write("\t\t\t\t\treq.send(null);\r\n");
out.write("\t\t\t\t}\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t}\r\n");
out.write("\t\t\r\n");
out.write("\t\tfunction complete(){\r\n");
out.write("\t\t\tif (req.readyState == 4) {\r\n");
out.write("\t\t\t\tif (req.status == 200) {\r\n");
out.write("\t\t\t\t\tvar class_name = req.responseXML.getElementsByTagName(\"class_name\");\r\n");
out.write("\t\t\t\t\t//alert(class_name.length);\r\n");
out.write("\t\t\t\t\tvar str=new Array();\r\n");
out.write("\t\t\t\t\tif(class_name==null){}\r\n");
out.write("\t\t\t\t\telse{\r\n");
out.write("\t\t\t\t\t\tfor(var i=0;i<class_name.length;i++){\r\n");
out.write("\t\t\t\t\t\t\tstr[i]=class_name[i].firstChild.data;\r\n");
out.write("\t\t\t\t\t\t}\r\n");
out.write("\t\t\t\t\t\t//alert(document.getElementById(\"class_name\"));\r\n");
out.write("\t\t\t\t\t\tbuildSelect(str,document.getElementById(\"class_name\"));\r\n");
out.write("\t\t\t\t\t}\r\n");
out.write("\t\t\t\t}\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t}\r\n");
out.write("\t\t\r\n");
out.write("\t\tfunction buildSelect(str,sel) {\r\n");
out.write("\t\t\t//alert(str.length);\r\n");
out.write("\t\t\tsel.options.length=0;\r\n");
out.write("\t\t\t//document.all.class_name.options.add(new Option('请选择','请选择'));\r\n");
out.write("\t\t\tfor(var i=0;i<str.length;i++)\r\n");
out.write("\t\t\t {\r\n");
out.write("\t\t\t\t//sel.options[i]=new Option(str[i],str[i])\r\n");
out.write("\t\t\t\tdocument.all.class_name.options.add(new Option(str[i],str[i]));\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t}\r\n");
out.write("\t</script>\r\n");
out.write("\t<script type=\"text/javascript\">\r\n");
out.write("\t\tfunction check()\r\n");
out.write("\t\t{\r\n");
out.write("\t\t\tif(document.all.cour_id.value==\"\")\r\n");
out.write("\t\t\t{\r\n");
out.write("\t\t\t\talert(\"请选择课程\");\r\n");
out.write("\t\t\t\t return false;\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t\tif(document.all.class_name.value==\"\")\r\n");
out.write("\t\t\t{\r\n");
out.write("\t\t\t\talert(\"请选择班级\");\r\n");
out.write("\t\t\t\t return false;\r\n");
out.write("\t\t\t}\r\n");
out.write("\t\t}\r\n");
out.write("\t</script>\r\n");
out.write(" </head>\r\n");
out.write("<body>\r\n");
out.write("\t<form id=\"export\" name=\"export\" method=\"post\" action=\"");
out.print(basePath);
out.write("Export_score\">\r\n");
out.write("\t\t<h2>导出成绩</h2>\r\n");
out.write("\t \t<div class=\"articles\">\r\n");
out.write("\t\t<ul style=\"list-style:none\">\r\n");
out.write("\t\t");
DbConn conn=new DbConn();
String th_id=session.getAttribute("user").toString();
String sql="select b.cour_id,b.cour_name from th_course a,courses b where a.th_id='"+th_id+"' and a.cour_id=b.cour_id";
String[][] cour_info=conn.getData(sql);
if(cour_info==null){
out.println("暂无授课班级");
}
else{
out.write("\r\n");
out.write("\t\t\t<li>请选择课程：\r\n");
out.write("\t\t\t\t<select id=\"cour_id\" name=\"cour_id\" style=\"width:200px\" onChange=\"getResult(this.value)\">\r\n");
out.write("\t\t\t\t\t<option value=\"\">请选择</option>\r\n");
out.write("\t\t\t\t\t");
for(int i=0;i<cour_info.length;i++)
{
out.print("<option value="+cour_info[i][0]+">"+cour_info[i][1]+"</option>");
}
out.write("\r\n");
out.write("\t\t\t\t</select>\r\n");
out.write("\t\t\t</li><br><br>\r\n");
out.write("\t\t\t<li>请选择班级：\r\n");
out.write("\t\t\t<select id=\"class_name\" name=\"class_name\" style=\"width:200px\">\r\n");
out.write("\t\t\t\t<option value=\"\">请选择</option>\r\n");
out.write("\t\t\t</select></li><br><br>\r\n");
out.write("\t\t\t<li><div style=\"margin-left:120px\"><input type=\"submit\" name=\"submit\" value=\"提交\" onClick=\"return check();\" ><input type=\"reset\" name=\"reset\" value=\"重置\"></div></li>\r\n");
out.write("\t\t");
}
out.write("\r\n");
out.write("\t\t</ul>\r\n");
out.write("\t\t</div>\r\n");
out.write("\t</form>\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)
try { out.clearBuffer(); } catch (java.io.IOException e) {}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -