show_jsp.java

Name: Book shop manager. 开发语言: Java

package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.io.*;
import java.sql.*;
import java.util.*;
import bookmanager.*;

public final class show_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {


                       bookmanager.dbconnBean dbconn1=new bookmanager.dbconnBean();
                        ResultSet rs1,rs2,rs3;
                        int i=0;
                        int m;
                        String [] a;
			String [] b;
			String [] c;
			String sql1="SELECT TOP 5 bkname FROM book WHERE (bkcid <> 315003) ORDER BY regdate DESC";
			String sql2="SELECT bkname FROM book WHERE (bkid IN  (SELECT TOP 5 bkid   FROM borrow   GROUP BY bkid     ORDER BY COUNT(*) DESC))";
   		         String sql3="SELECT TOP 5 bkname FROM book WHERE (bkcid = 315003) ORDER BY regdate DESC";
		
  private static java.util.Vector _jspx_dependants;

  public java.util.List 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,
      			"login_error.jsp", 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\r\n\r\n");
      bookmanager.dbconnBean dbconn = null;
      synchronized (_jspx_page_context) {
        dbconn = (bookmanager.dbconnBean) _jspx_page_context.getAttribute("dbconn", PageContext.PAGE_SCOPE);
        if (dbconn == null){
          dbconn = new bookmanager.dbconnBean();
          _jspx_page_context.setAttribute("dbconn", dbconn, PageContext.PAGE_SCOPE);
        }
      }
      out.write('\r');
      out.write('\n');
      out.write("\r\n                         ");

                        try{
			 rs1=dbconn1.executeQuery(sql1);

			 i=0;
			while(rs1.next())
			{
				a[i]=rs1.getString("bkname");i++;
			}
			 //rs2=dbconn1.executeQuery(sql2);
			 rs2=rs1;
			 rs3=rs1;

			while(rs2.next())
			{
				b[i]=rs2.getString("bkname");i++;
			}
			 //rs3=dbconn1.excuteQuery(sql3);
			 i=0;
			while(rs3.next())
			{
				c[i]=rs3.getString("bkname");i++;
			}

			}catch(Exception e){}
			out.print("<table width=100 border=0 cellpadding=0 cellspacing=0>"
          +"<tr>"
          + " <td width=280 height=32><img src=images/01.gif width=280 height=32></td>"
          + " <td width=280><img src=images/02.gif width=280 height=30></td>"
         +" </tr>");

			for(i=0;i<5;){
			for(int j=0;j<b.length;j++){out.print(" <tr>"
            +"<td><p>.....................................</p>"
             +" <p>&nbsp;</p></td>"
			 +"<td><p>..........................b[j]</p>"
              +"<p>&nbsp;</p></td>"
                +"</tr>");
				i++;}
				out.print(" <tr>"
            +"<td><p>.....................................</p>"
             + "<p>&nbsp;</p></td>"
			 +"<td><p>.....................................</p>"
              +"<p>&nbsp;</p></td>"
                +"</tr>");
				}

				out.print("<tr>"
            +"<td><img src=images/04.gif width=280 height=32></td>"
           + "<td><img src=images/03.gif width=280 height=32></td>"
          +"</tr>");

				 m=(a.length>c.length?a.length:c.length);
				for(i=0;i<5;){
			for(int j=0;j<m;j++){
			if(m<=c.length){
			out.print(" <tr>"
            +"<td><p>.....................................a[j]</p>"
             + "<p>&nbsp;</p></td>"
			 +"<td><p>..........................c[j]</p>"
              +"<p>&nbsp;</p></td>"
                +"</tr>");}
				else
				out.print(" <tr>"
            +"<td><p>.....................................a[j]</p>"
             + "<p>&nbsp;</p></td>"
			 +"<td><p>.....................................</p>"
              +"<p>&nbsp;</p></td>"
                +"</tr>");

				i++;}
				out.print(" <tr>"
            +"<td><p>.....................................</p>"
             + "<p>&nbsp;</p></td>"
			 +"<td><p>.....................................</p>"
              +"<p>&nbsp;</p></td>"
                +"</tr>");
				}






		
    } 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);
    }
  }
}