📄 studentxkd_0002ejsp_jsp.java
字号:
import java.sql.*;
import java.util.*;
import java.io.*;
import java.lang.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;
public class studentxkd_0002ejsp_jsp extends HttpJspBase {
// begin [file="/studentxkd.jsp";from=(6,0);to=(6,59)]
// end
static {
}
public studentxkd_0002ejsp_jsp( ) {
}
private static boolean _jspx_inited = false;
public final void _jspx_init() throws org.apache.jasper.runtime.JspException {
}
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;
String _value = null;
try {
if (_jspx_inited == false) {
synchronized (this) {
if (_jspx_inited == false) {
_jspx_init();
_jspx_inited = true;
}
}
}
_jspxFactory = JspFactory.getDefaultFactory();
response.setContentType("text/html; charset=gb2312");
pageContext = _jspxFactory.getPageContext(this, request, response,
"", true, 8192, true);
application = pageContext.getServletContext();
config = pageContext.getServletConfig();
session = pageContext.getSession();
out = pageContext.getOut();
// HTML // begin [file="/studentxkd.jsp";from=(0,50);to=(1,0)]
out.write("\r\n");
// end
// HTML // begin [file="/studentxkd.jsp";from=(1,46);to=(2,0)]
out.write("\r\n");
// end
// HTML // begin [file="/studentxkd.jsp";from=(2,31);to=(3,0)]
out.write("\r\n");
// end
// HTML // begin [file="/studentxkd.jsp";from=(3,29);to=(5,0)]
out.write("\r\n\r\n");
// end
// HTML // begin [file="/studentxkd.jsp";from=(5,31);to=(6,0)]
out.write("\r\n");
// end
// begin [file="/studentxkd.jsp";from=(6,0);to=(6,59)]
wsxk.ConDB subject = null;
boolean _jspx_specialsubject = false;
synchronized (pageContext) {
subject= (wsxk.ConDB)
pageContext.getAttribute("subject",PageContext.PAGE_SCOPE);
if ( subject == null ) {
_jspx_specialsubject = true;
try {
subject = (wsxk.ConDB) java.beans.Beans.instantiate(this.getClass().getClassLoader(), "wsxk.ConDB");
} catch (ClassNotFoundException exc) {
throw new InstantiationException(exc.getMessage());
} catch (Exception exc) {
throw new ServletException (" Cannot create bean of class "+"wsxk.ConDB", exc);
}
pageContext.setAttribute("subject", subject, PageContext.PAGE_SCOPE);
}
}
if(_jspx_specialsubject == true) {
// end
// begin [file="/studentxkd.jsp";from=(6,0);to=(6,59)]
}
// end
// HTML // begin [file="/studentxkd.jsp";from=(6,59);to=(7,0)]
out.write("\r\n");
// end
// begin [file="/studentxkd.jsp";from=(7,2);to=(14,0)]
String teaname = new String();
String couid1 = new String();
String teaid1 = new String();
int temscid = 0;
// end
// HTML // begin [file="/studentxkd.jsp";from=(14,2);to=(110,49)]
out.write("\r\n<html>\r\n<head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<link href=\"_notes/aaa.css\" rel=\"stylesheet\" type=\"text/css\">\r\n<style type=\"text/css\">\r\n<!--\r\n@import url(\"_notes/ccc\");\r\nbody,td,th {\r\n\tfont-size: 12px;\r\n\tcolor: #FFFFFF;\r\n\tfont-weight: bold;\r\n}\r\na {\r\n\tfont-size: 12px;\r\n\tcolor: #FFFFFF;\r\n}\r\na:visited {\r\n\tcolor: #FFFFFF;\r\n}\r\n.style1 {font-size: 14px}\r\n-->\r\n</style>\r\n</HEAD>\r\n<BODY BGCOLOR=#0D85A6 BACKGROUND=\"images/bg.gif\" >\r\n\r\n<br>\r\n<br>\r\n<TABLE WIDTH=750 height=\"494\" BORDER=0 align=\"center\" CELLPADDING=0 CELLSPACING=0>\r\n <TR>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=231 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=4 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=75 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=110 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=105 HEIGHT=1></TD>\r\n <TD> <IMG SRC=\"images/spacer.gif\" WIDTH=5 HEIGHT=1></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=4> <IMG SRC=\"images/temp_01.jpg\" WIDTH=420 HEIGHT=15></TD>\r\n <TD COLSPAN=4> <IMG SRC=\"images/temp_02.jpg\" WIDTH=330 HEIGHT=15></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <IMG SRC=\"images/temp_03.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n </TR>\r\n <TR>\r\n <TD>\r\n <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"226\" background=\"images/left_top.jpg\">\r\n <tr>\r\n <td width=\"231\">\r\n <div align=\"center\">\r\n <p> </p>\r\n <p> </p>\r\n <p> 总选课单 <br>\r\n <br>\r\n <br>\r\n <font color=\"#2DFFFF\" size=\"5\"><strong> </strong></font></p>\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"studentwsxk.jsp\">【网上选课】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\"><a href=\"studentcjcx.jsp\">【成绩查询】</a></div></td>\r\n </tr>\r\n <tr>\r\n <td><div align=\"center\">【书籍购买】</div></td>\r\n </tr>\r\n </table>\r\n <p> <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n </div> </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n <TD ROWSPAN=2> <IMG SRC=\"images/temp_05.jpg\" WIDTH=4 HEIGHT=455></TD>\r\n <TD COLSPAN=5 ROWSPAN=2>\r\n <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\" background=\"images/main_bg.jpg\">\r\n <tr>\r\n <td width=\"510\">\r\n <table width=\"510\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"455\">\r\n <tr>\r\n <td width=\"510\" height=\"78\">\r\n <div align=\"center\"><img src=\"images/blank_banner.gif\" width=\"468\" height=\"60\"></div>\r\n </td>\r\n </tr>\r\n <tr>\r\n <td valign=\"top\">\r\n <div align=\"left\"></div> <table width=\"91%\" height=\"66\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n <tr>\r\n <td height=\"2\" colspan=\"7\">\r\n <p> <a href=\"index1.htm\">首页</a>><a href=\"index1.jsp\">学生</a>>选课单<br>\r\n <br>\r\n</p>\r\n <div align=\"center\"></div></td>\r\n </tr>\r\n <tr>\r\n <td height=\"3\" colspan=\"7\">");
// end
// begin [file="/studentxkd.jsp";from=(110,51);to=(118,0)]
String sql = "select stuname from student where stuid = '"+session.getValue("wnum")+"'";
ResultSet rs=subject.executeQuery(sql);
while (rs.next())
{
out.print(rs.getString("stuname"));
teaname = rs.getString("stuname");
}
// end
// HTML // begin [file="/studentxkd.jsp";from=(118,2);to=(137,24)]
out.write("\r\n同学 ：</td>\r\n </tr>\r\n <tr>\r\n <td height=\"5\" colspan=\"7\"><div align=\"center\">您这学期总选课单如下<br>\r\n <br>\r\n </div></td>\r\n </tr>\r\n <tr>\r\n <td width=\"10%\" height=\"11\"><div align=\"center\"></div></td>\r\n <td width=\"12%\">点击退选</td>\r\n <td width=\"19%\"><div align=\"center\">授课教师</div></td>\r\n <td width=\"23%\"><div align=\"center\">课程说明</div></td>\r\n <td width=\"13%\"><div align=\"center\">课程名称</div></td>\r\n <td width=\"12%\"><div align=\"center\">学分</div></td>\r\n <td width=\"11%\"><div align=\"center\"></div></td>\r\n </tr>\r\n <tr>\r\n <td height=\"22\" colspan=\"7\"><br>\r\n ");
// end
// begin [file="/studentxkd.jsp";from=(137,26);to=(166,4)]
//String sql2 = "select couid,couname,coumark,couback from course where couid in (select couid from tc where teaid = '"+session.getValue("wnum")+"')";
String sql2 = "select scid,teaid,couid from sc where stuid = '"+session.getValue("wnum")+"'";
ResultSet rs2=subject.executeQuery(sql2);
while (rs2.next())
{ temscid = rs2.getInt("scid");
out.print (" ");
out.print ("<a href='studentxkd2.jsp?tuixuan=" +temscid + "'>退选</a>");
teaid1 = rs2.getString("teaid");
String sql4 = "select teaname from teacher where teaid = '"+teaid1+"'";
ResultSet rs4 = subject.executeQuery(sql4);
while (rs4.next())
{
out.print (" ");
out.print (rs4.getString("teaname"));
}
couid1 = rs2.getString("couid");
//out.print("tttt");
String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
ResultSet rs3=subject.executeQuery(sql3);
while (rs3.next())
{out.print(" ");
out.print(rs3.getString("couback"));
out.print(" ");
out.print(rs3.getString("couname"));
out.print(" ");
out.print(rs3.getString("coumark"));
//out.print(rs3.getString("couback"));
}
// end
// HTML // begin [file="/studentxkd.jsp";from=(166,6);to=(168,24)]
out.write("\r\n <br> <br>\r\n ");
// end
// begin [file="/studentxkd.jsp";from=(168,26);to=(179,2)]
//couid1 = rs2.getString("couid");
//teaname = rs.getString("teaname");
}
/*String sql3 = "select couid,couname,coumark,couback from course where couid = '"+couid1+"'";
ResultSet rs3=subject.executeQuery(sql3);
while (rs3.next())
{
out.print("tttt");
}*/
// end
// HTML // begin [file="/studentxkd.jsp";from=(179,4);to=(222,7)]
out.write("</td>\r\n </tr>\r\n <tr>\r\n <td colspan=\"7\"> </td>\r\n </tr>\r\n </table></td>\r\n </tr>\r\n </table>\r\n </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n <TD ROWSPAN=2> <IMG SRC=\"images/temp_07.jpg\" WIDTH=5 HEIGHT=455></TD>\r\n </TR>\r\n <TR>\r\n <TD>\r\n <table width=\"231\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" height=\"229\" background=\"images/left_bottom.jpg\">\r\n <tr>\r\n <td width=\"231\" height=\"222\">\r\n <div align=\"center\">\r\n <table width=\"200\" border=\"1\">\r\n <tr>\r\n <td><div align=\"center\"><a href=\"lyb.jsp\">【留言板】</a></div></td>\r\n </tr>\r\n </table>\r\n <p> <font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n <p> </p>\r\n <p> <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n <p class=\"aaa\"><a href=\"index1.htm\" class=\"style1\">[退出系统]</a></p>\r\n </div>\r\n </td>\r\n </tr>\r\n </table>\r\n </TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <IMG SRC=\"images/temp_09.jpg\" WIDTH=750 HEIGHT=5></TD>\r\n </TR>\r\n <TR>\r\n <TD COLSPAN=8> <img src=\"images/temp_10.jpg\" width=752 height=20></TD>\r\n </TR>\r\n</TABLE>\r\n</BODY>\r\n</HTML>");
// end
} catch (Throwable t) {
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (pageContext != null) pageContext.handlePageException(t);
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(pageContext);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -