⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 adminlyb_0002ejsp_jsp.java

📁 网上选课程序:a.使用JSP/Servlet开发
💻 JAVA
字号:
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import org.apache.jasper.runtime.*;


public class adminlyb_0002ejsp_jsp extends HttpJspBase {

    // begin [file="/adminlyb.jsp";from=(2,0);to=(2,62)]
    // end

    static {
    }
    public adminlyb_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="/adminlyb.jsp";from=(0,69);to=(1,0)]
                out.write("\r\n");

            // end
            // HTML // begin [file="/adminlyb.jsp";from=(1,33);to=(2,0)]
                out.write("\r\n");

            // end
            // begin [file="/adminlyb.jsp";from=(2,0);to=(2,62)]
                wsxk.ConDB sts = null;
                boolean _jspx_specialsts  = false;
                 synchronized (pageContext) {
                    sts= (wsxk.ConDB)
                    pageContext.getAttribute("sts",PageContext.PAGE_SCOPE);
                    if ( sts == null ) {
                        _jspx_specialsts = true;
                        try {
                            sts = (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("sts", sts, PageContext.PAGE_SCOPE);
                    }
                 } 
                if(_jspx_specialsts == true) {
            // end
            // begin [file="/adminlyb.jsp";from=(2,0);to=(2,62)]
                }
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(2,62);to=(3,0)]
                out.write("\r\n");

            // end
            // begin [file="/adminlyb.jsp";from=(3,2);to=(18,0)]
                
                	int  intPage;
                	int currentPage = 1;
                	int PageNumbers = 5;
                	if(request.getParameter("page")!= null && request.getParameter("page")!="")
                		{intPage = Integer.parseInt(request.getParameter("page"));
                		currentPage=intPage;}
                	else
                		intPage = 1;
                	int totalRecord = 0;
                	ResultSet counters = sts.executeQuery("select count(*) as mesid from message");
                	if(counters.next())
                	{
                		totalRecord = Integer.parseInt(counters.getString("mesid"));
                	}
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(18,2);to=(108,68)]
                out.write("\r\n\r\n\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\n.style1 {color: #FFFFFF}\r\nbody,td,th {\r\n\tcolor: #FFFFFF;\r\n\tfont-weight: bold;\r\n\tfont-size: 12px;\r\n}\r\na:link {\r\n\tcolor: #FFFFFF;\r\n}\r\na:visited {\r\n\tcolor: #FFFFFF;\r\n}\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\" valign=\"bottom\">\r\n            <div align=\"center\">\r\n              <p><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\"><strong><a href=\"adminstudent.jsp\">【学生管理】</a></strong></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminteacher.jsp\">【教师<strong>管理</strong>】</a></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"admincourse.jsp\">【课程<strong>管理</strong>】</a></div></td>\r\n                </tr>\r\n              </table>\r\n              <p>  <strong><font color=\"#2DFFFF\" size=\"5\"> </font></strong></p>\r\n            </div>\r\n          </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\">                  <div align=\"left\">\r\n                  <table width=\"483\" height=\"217\" border=\"0\">\r\n                    <tr>\r\n                      <td height=\"14\"><a href=\"index1.htm\">首页</a>&gt;<a href=\"index3.jsp\">后台管理</a>&gt;查看留言</td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td height=\"16\"><span class=\"style1\">分页: 留言总数:");

            // end
            // begin [file="/adminlyb.jsp";from=(108,71);to=(108,82)]
                out.print(totalRecord);
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(108,84);to=(109,26)]
                out.write(" <a href=\"adminlyb.jsp?page=1\">[首页]</a>\r\n                          ");

            // end
            // begin [file="/adminlyb.jsp";from=(109,28);to=(123,0)]
                
                	if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
                	{
                		out.print("<a href='adminlyb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
                		out.print("<a href='adminlyb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
                		out.print("<a href='adminlyb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
                	}
                	if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
                		out.print("<a href='adminlyb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
                	if(intPage == 1)
                	{
                		out.print("<a href='adminlyb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
                		out.print("<a href='adminlyb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
                	}
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(123,2);to=(126,29)]
                out.write("\r\n\r\n\r\n                          页次:");

            // end
            // begin [file="/adminlyb.jsp";from=(126,32);to=(126,43)]
                out.print(currentPage);
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(126,45);to=(126,46)]
                out.write("/");

            // end
            // begin [file="/adminlyb.jsp";from=(126,49);to=(126,86)]
                out.print((totalRecord+PageNumbers)/PageNumbers);
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(126,88);to=(126,89)]
                out.write(" ");

            // end
            // begin [file="/adminlyb.jsp";from=(126,92);to=(126,103)]
                out.print(PageNumbers);
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(126,105);to=(135,1)]
                out.write("篇/页</span></td>\r\n                    </tr>\r\n\r\n                    <tr>\r\n                      <td></td>\r\n                    </tr>\r\n                    <tr>\r\n                      <td>\r\n\r\n\t");

            // end
            // begin [file="/adminlyb.jsp";from=(135,3);to=(147,22)]
                String strSQL = "select mesid ,stuname ,mescontent from message order by mesid desc  ";
                	ResultSet rs = sts.executeQuery(strSQL);
                	int i=0;
                	int tmpid;
                	while(rs.next())
                	{
                
                		if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
                		{
                			String stuname = rs.getString("stuname");
                			String mescontent = rs.getString("mescontent");
                			tmpid =rs.getInt("mesid");
                			out.print(stuname);
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(147,24);to=(148,7)]
                out.write("同学:\r\n\t\t\t<br>");

            // end
            // begin [file="/adminlyb.jsp";from=(148,9);to=(161,0)]
                //out.print(mescontent);
                			int tmp =0;
                		for ( int j=0 ; j < mescontent.length();j++)
                		{
                		if (mescontent.charAt(j)=='\n'||j==mescontent.length()-1)
                		{out.print("&nbsp;&nbsp;");
                        	 out.print(mescontent.substring(tmp,j+1));
                        	 out.print("<br>");
                
                		 tmp = j+1;
                
                		}}
                
            // end
            // begin [file="/adminlyb.jsp";from=(161,4);to=(161,321)]
                out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='adminlyb2.jsp?delpage=" +tmpid + "'>删除</a>");
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(161,323);to=(161,331)]
                out.write("<br><br>");

            // end
            // begin [file="/adminlyb.jsp";from=(161,333);to=(166,0)]
                
                			//out.print("<TD>□ <a href=\"wz.jsp?id="+id+"\">" + title + "    (" + time + ")" + "</a></td><td></td></tr>");
                		}
                		i++;
                	}
            // end
            // HTML // begin [file="/adminlyb.jsp";from=(166,2);to=(219,7)]
                out.write("\r\n\t\t\t<br></td>\r\n                    </tr>\r\n                  </table>\r\n                </div></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\" valign=\"top\"><div align=\"center\">\r\n            <p><font color=\"#2DFFFF\" size=\"5\"> </font></p>\r\n              <table width=\"200\" border=\"1\">\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"admincourse.jsp\">【课程分配】</a></div></td>\r\n                </tr>\r\n                <tr>\r\n                  <td><div align=\"center\"><a href=\"adminscore.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              <br>\r\n              <br>\r\n              <table width=\"200\" border=\"0\">\r\n                <tr>\r\n                  <td><div align=\"center\">查看留言</div></td>\r\n                </tr>\r\n              </table>\r\n              <p align=\"center\"><br>\r\n              <a href=\"index1.htm\" class=\"ccc\">[退出系统]</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 + -