📄 _arrangeld_0sch__jsp.java
字号:
/*
* JSP generated by Resin-3.1.1 (built Mon, 07 May 2007 09:32:40 PDT)
*/
package _jsp._admin;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Date;
public class _arrangeld_0sch__jsp extends com.caucho.jsp.JavaPage
{
private static final java.util.HashMap<String,java.lang.reflect.Method> _jsp_functionMap = new java.util.HashMap<String,java.lang.reflect.Method>();
private boolean _caucho_isDead;
public void
_jspService(javax.servlet.http.HttpServletRequest request,
javax.servlet.http.HttpServletResponse response)
throws java.io.IOException, javax.servlet.ServletException
{
javax.servlet.http.HttpSession session = request.getSession(true);
com.caucho.server.webapp.WebApp _jsp_application = _caucho_getApplication();
javax.servlet.ServletContext application = _jsp_application;
com.caucho.jsp.PageContextImpl pageContext = com.caucho.jsp.QJspFactory.allocatePageContext(this, _jsp_application, request, response, null, session, 8192, true, false);
javax.servlet.jsp.JspWriter out = pageContext.getOut();
final javax.el.ELContext _jsp_env = pageContext.getELContext();
javax.servlet.ServletConfig config = getServletConfig();
javax.servlet.Servlet page = this;
response.setContentType("text/html;charset=GB2312");
request.setCharacterEncoding("GB2312");
try {
out.write(_jsp_string0, 0, _jsp_string0.length);
String gestnam = (String) session.getAttribute("name");
String gestpsw = (String) session.getAttribute("password");
if("".equals(gestnam)||gestnam==null & "".equals(gestpsw)||gestpsw==null)
{
response.sendRedirect("..//index.jsp");
}
out.write(_jsp_string1, 0, _jsp_string1.length);
admin.dbcont dbcon;
dbcon = (admin.dbcont) pageContext.getAttribute("dbcon");
if (dbcon == null) {
dbcon = new admin.dbcont();
pageContext.setAttribute("dbcon", dbcon);
}
out.write(_jsp_string2, 0, _jsp_string2.length);
dbcon.getcon();
ResultSet rs;
rs=dbcon.stmt.executeQuery("Select count(Distinct arrangeId) arrangelen from arrangeld");
rs.next();
int arrangelen=rs.getInt("arrangelen");
String ArrangeId[]=new String[arrangelen];
String LessonName[]=new String[arrangelen];
String Class_Name[]=new String[arrangelen];
rs=dbcon.stmt.executeQuery("Select * from arrangeld,lessons,classes "
+"where arrangeld.LessonId=lessons.LessonId "
+"and arrangeld.class_Id=classes.class_Id");
out.write(_jsp_string3, 0, _jsp_string3.length);
for(int i=0;i<ArrangeId.length;i++)
{
rs.next();
ArrangeId[i]=rs.getString("ArrangeId");
LessonName[i]=rs.getString("LessonName");
Class_Name[i]=rs.getString("Class_Name");
out.write(_jsp_string4, 0, _jsp_string4.length);
out.print((ArrangeId[i]));
out.write(_jsp_string5, 0, _jsp_string5.length);
out.print((ArrangeId[i]));
out.write(')');
out.print((LessonName[i]));
out.write(':');
out.print((Class_Name[i]));
out.write(_jsp_string6, 0, _jsp_string6.length);
}
out.write(_jsp_string7, 0, _jsp_string7.length);
String strsmt=request.getParameter("smt");
if(strsmt==null)
{
String strsql="select arrangeid,lessonname,teacher,class_name,hours,"
+"lessonType,termName,kaoshiTime from lessons,terms,arrangeld,classes "
+"where lessons.lessonId=arrangeld.lessonId "
+"and classes.Class_Id=arrangeld.Class_Id "
+"and terms.termId=arrangeld.termId";
rs=dbcon.stmt.executeQuery(strsql);
out.write(_jsp_string8, 0, _jsp_string8.length);
while(rs.next())
{
String arrangeId=rs.getString("arrangeId");
String lessonName=rs.getString("lessonName");
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((arrangeId));
out.write(_jsp_string10, 0, _jsp_string10.length);
out.print((lessonName));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((rs.getString("Teacher")));
out.write(_jsp_string12, 0, _jsp_string12.length);
out.print((rs.getString("class_Name")));
out.write(_jsp_string10, 0, _jsp_string10.length);
out.print((rs.getString("Hours")));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((rs.getString("LessonType")));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((rs.getString("termName")));
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((rs.getString("kaoshiTime")));
out.write(_jsp_string14, 0, _jsp_string14.length);
}
rs.close();
dbcon.close();
out.write(_jsp_string15, 0, _jsp_string15.length);
}
else
{
out.write(_jsp_string16, 0, _jsp_string16.length);
String strtxt=request.getParameter("text");
String ArrangeId1=request.getParameter("ArrangeId");
String strsql1="Select * from Arrangeld,Classes,Lessons,Terms "
+"where Teacher='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or LessonType='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or ArrangeId='"+ArrangeId1+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or TermName='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or Lessons.LessonId='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or LessonName='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or Classes.Class_Id='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id "
+"or Class_Name='"+strtxt+"' "
+"and Arrangeld.LessonId=Lessons.LessonId "
+"and Arrangeld.TermId=Terms.TermId "
+"and Arrangeld.Class_Id=Classes.Class_Id ";
rs=dbcon.stmt.executeQuery(strsql1);
out.write(_jsp_string17, 0, _jsp_string17.length);
while(rs.next())
{
String arrangeId=rs.getString("arrangeId");
String lessonName=rs.getString("lessonName");
out.write(_jsp_string9, 0, _jsp_string9.length);
out.print((arrangeId));
out.write(_jsp_string10, 0, _jsp_string10.length);
out.print((lessonName));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((rs.getString("Teacher")));
out.write(_jsp_string12, 0, _jsp_string12.length);
out.print((rs.getString("class_Name")));
out.write(_jsp_string10, 0, _jsp_string10.length);
out.print((rs.getString("Hours")));
out.write(_jsp_string11, 0, _jsp_string11.length);
out.print((rs.getString("LessonType")));
out.write(_jsp_string13, 0, _jsp_string13.length);
out.print((rs.getString("termName")));
out.write(_jsp_string14, 0, _jsp_string14.length);
}
rs.close();
dbcon.close();
out.write(_jsp_string15, 0, _jsp_string15.length);
}
out.write(_jsp_string18, 0, _jsp_string18.length);
} catch (java.lang.Throwable _jsp_e) {
pageContext.handlePageException(_jsp_e);
} finally {
com.caucho.jsp.QJspFactory.freePageContext(pageContext);
}
}
private java.util.ArrayList _caucho_depends = new java.util.ArrayList();
public java.util.ArrayList _caucho_getDependList()
{
return _caucho_depends;
}
public void _caucho_addDepend(com.caucho.vfs.PersistentDependency depend)
{
super._caucho_addDepend(depend);
com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
}
public boolean _caucho_isModified()
{
if (_caucho_isDead)
return true;
if (com.caucho.server.util.CauchoSystem.getVersionId() != -6891698089151209809L)
return true;
for (int i = _caucho_depends.size() - 1; i >= 0; i--) {
com.caucho.vfs.Dependency depend;
depend = (com.caucho.vfs.Dependency) _caucho_depends.get(i);
if (depend.isModified())
return true;
}
return false;
}
public long _caucho_lastModified()
{
return 0;
}
public java.util.HashMap<String,java.lang.reflect.Method> _caucho_getFunctionMap()
{
return _jsp_functionMap;
}
public void init(ServletConfig config)
throws ServletException
{
com.caucho.server.webapp.WebApp webApp
= (com.caucho.server.webapp.WebApp) config.getServletContext();
super.init(config);
com.caucho.jsp.TaglibManager manager = webApp.getJspApplicationContext().getTaglibManager();
com.caucho.jsp.PageContextImpl pageContext = new com.caucho.jsp.PageContextImpl(webApp, this);
}
public void destroy()
{
_caucho_isDead = true;
super.destroy();
}
public void init(com.caucho.vfs.Path appDir)
throws javax.servlet.ServletException
{
com.caucho.vfs.Path resinHome = com.caucho.server.util.CauchoSystem.getResinHome();
com.caucho.vfs.MergePath mergePath = new com.caucho.vfs.MergePath();
mergePath.addMergePath(appDir);
mergePath.addMergePath(resinHome);
com.caucho.loader.DynamicClassLoader loader;
loader = (com.caucho.loader.DynamicClassLoader) getClass().getClassLoader();
String resourcePath = loader.getResourcePathSpecificFirst();
mergePath.addClassPath(resourcePath);
com.caucho.vfs.Depend depend;
depend = new com.caucho.vfs.Depend(appDir.lookup("admin/arrangeld_sch.jsp"), 6819612365245450721L, false);
com.caucho.jsp.JavaPage.addDepend(_caucho_depends, depend);
}
private final static char []_jsp_string3;
private final static char []_jsp_string15;
private final static char []_jsp_string0;
private final static char []_jsp_string16;
private final static char []_jsp_string6;
private final static char []_jsp_string5;
private final static char []_jsp_string9;
private final static char []_jsp_string1;
private final static char []_jsp_string12;
private final static char []_jsp_string4;
private final static char []_jsp_string7;
private final static char []_jsp_string11;
private final static char []_jsp_string14;
private final static char []_jsp_string18;
private final static char []_jsp_string2;
private final static char []_jsp_string10;
private final static char []_jsp_string17;
private final static char []_jsp_string8;
private final static char []_jsp_string13;
static {
_jsp_string3 = "\r\n </select>\r\n\u8bfe\u7a0b\u5b89\u6392\u67e5\u8be2: <select name=\"ArrangeId\" size=1>\r\n <option value=\"\">\u8bf7\u9009\u62e9\u5df2\u7ecf\u5b89\u6392\u7684\u8bfe\u7a0b\u540d\u79f0</option>\r\n ".toCharArray();
_jsp_string15 = "\r\n </table>\r\n</center></b>\r\n".toCharArray();
_jsp_string0 = "\r\n\r\n\r\n".toCharArray();
_jsp_string16 = "\r\n<center>\r\n\r\n ".toCharArray();
_jsp_string6 = "</option>\r\n ".toCharArray();
_jsp_string5 = "\">(".toCharArray();
_jsp_string9 = "\r\n <tr bgcolor=cyan>\r\n <td bgcolor=\"#FFFFFF\"><b>\r\n <div><center>".toCharArray();
_jsp_string1 = "\r\n<html>\r\n \r\n\r\n<head>\r\n <title></title>\r\n</head>\r\n<body>\r\n\r\n <form action=\"arrangeld_sch.jsp\" name=\"frm\" method=\"post\">\r\n <b><center>\r\n <font size=4 color=red>\u5b66\u751f\u6210\u7ee9\u67e5\u8be2\r\n <input name=\"text\" type=\"text\" size=10>\r\n".toCharArray();
_jsp_string12 = "\r\n </center></div></b></td>\r\n <td bgcolor=\"#FFFFFF\"><b>\r\n <div><center>".toCharArray();
_jsp_string4 = "\r\n <option value=\"".toCharArray();
_jsp_string7 = "\r\n </select>\r\n \r\n <input type=\"submit\" name=\"smt\" value=\"\u67e5\u8be2\">\r\n <hr><br><b></center>\r\n </form>\r\n <center>\r\n".toCharArray();
_jsp_string11 = "\r\n </center></div></b></td>\r\n <td bgcolor=\"#FFFFFF\"><b>\r\n <div><center>".toCharArray();
_jsp_string14 = "\r\n </center></div></b></td>\r\n </tr>\r\n ".toCharArray();
_jsp_string18 = "\r\n</body>\r\n</html>".toCharArray();
_jsp_string2 = "\r\n".toCharArray();
_jsp_string10 = " \r\n </center></div></b></td>\r\n <td bgcolor=\"#FFFFFF\"><b>\r\n <div><center>".toCharArray();
_jsp_string17 = "\r\n <table bgcolor=#CCCCCC>\r\n <tr bgcolor=#FFFFCC>\r\n \r\n <td bordercolor=\"#CCCCCC\"><b>\r\n <div><center>\u8bfe\u7a0b\u5b89\u6392\u7f16\u53f7\r\n </center></div></b></td>\r\n <td><b>\r\n <div><center>\u8bfe\u7a0b\u540d\u79f0</center></div></b></td>\r\n <td><b>\r\n <div><center>\u6388\u8bfe\u8001\u5e08</center></div></b></td>\r\n <td><b>\r\n <div><center>\u73ed\u7ea7</center></div></b></td>\r\n <td><b>\r\n <div><center>\u5b66\u65f6</center></div></b></td>\r\n <td><b>\r\n <div><center>\u8bfe\u7a0b\u7c7b\u578b</center></div></b></td>\r\n <td><b>\r\n <div><center>\u5b66\u671f\u540d\u79f0</center></div></b></td>\r\n </tr>\r\n ".toCharArray();
_jsp_string8 = "\r\n \r\n <table bgcolor=#CCCCCC>\r\n <tr bgcolor=#FFFFCC>\r\n \r\n <td bordercolor=\"#CCCCCC\"><b>\r\n <div><center>\u8bfe\u7a0b\u5b89\u6392\u7f16\u53f7\r\n </center></div></b></td>\r\n <td><b>\r\n <div><center>\u8bfe\u7a0b\u540d\u79f0</center></div></b></td>\r\n <td><b>\r\n <div><center>\u6388\u8bfe\u8001\u5e08</center></div></b></td>\r\n <td><b>\r\n <div><center>\u73ed\u7ea7</center></div></b></td>\r\n <td><b>\r\n <div><center>\u5b66\u65f6</center></div></b></td>\r\n <td><b>\r\n <div><center>\u8bfe\u7a0b\u7c7b\u578b</center></div></b></td>\r\n <td><b>\r\n <div><center>\u5b66\u671f\u540d\u79f0</center></div></b></td>\r\n <td><b>\r\n <div><center>\u8003\u8bd5\u65f6\u95f4</center></div></b></td>\r\n </tr>\r\n ".toCharArray();
_jsp_string13 = "\r\n </center></div></b></td>\r\n <td bgcolor=\"#FFFFFF\"><b>\r\n <div><center>".toCharArray();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -