_showconsumer1.java

精美的画面。完善的功能

  /*@lineinfo:filename=/showConsumer1.jsp*/
  /*@lineinfo:generated-code*/

import oracle.jsp.runtime.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import Flower.model.DBConnect;


public class _showConsumer1 extends com.orionserver.http.OrionHttpJspPage {

  public final String _globalsClassName = null;

  // ** Begin Declarations


  // ** End Declarations

  public void _jspService(HttpServletRequest request, HttpServletResponse response) throws java.io.IOException, ServletException {

    response.setContentType( "text/html;charset=GBK");
    /* set up the intrinsic variables using the pageContext goober:
    ** session = HttpSession
    ** application = ServletContext
    ** out = JspWriter
    ** page = this
    ** config = ServletConfig
    ** all session/app beans declared in globals.jsa
    */
    PageContext pageContext = JspFactory.getDefaultFactory().getPageContext( this, request, response, null, true, JspWriter.DEFAULT_BUFFER, true);
    // Note: this is not emitted if the session directive == false
    HttpSession session = pageContext.getSession();
    if (pageContext.getAttribute(OracleJspRuntime.JSP_REQUEST_REDIRECTED, PageContext.REQUEST_SCOPE) != null) {
      pageContext.setAttribute(OracleJspRuntime.JSP_PAGE_DONTNOTIFY, "true", PageContext.PAGE_SCOPE);
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
      return;
}
    int __jsp_tag_starteval;
    ServletContext application = pageContext.getServletContext();
    JspWriter out = pageContext.getOut();
    _showConsumer1 page = this;
    ServletConfig config = pageContext.getServletConfig();

    try {
      // global beans
      // end global beans


      out.write(__oracle_jsp_text[0]);
      /*@lineinfo:user-code*//*@lineinfo:2^1*/      
       if(session.getAttribute("midentity")==null)
          {
            //  request.setAttribute("result","您没有权力进入此页");
             // getServletContext().getRequestDispatcher("display.jsp").forward(request,response);
              response.sendRedirect("FlowerIndex.jsp");
          }
      
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[1]);
      /*@lineinfo:user-code*//*@lineinfo:42^15*/      
                        Connection con=null;
                        PreparedStatement pstmt=null;
                        ResultSet rs=null;
                        try
                        {
                            con=DBConnect.getConnection();
                            pstmt=con.prepareStatement("select ConsumerInfo.ConsumerId,ConsumerLogin.ConsumerName,ConsumerInfo.realname,ConsumerInfo.ConsumerSex,ConsumerInfo.IdentityCard,ConsumerInfo.Address,ConsumerInfo.Zipcode,ConsumerInfo.Email,ConsumerInfo.Tel from Consumerinfo,ConsumerLogin where ConsumerINfo.Consumerid=ConsumerLogin.Consumerid");
                            rs=pstmt.executeQuery();
                            while(rs.next())
                            {
                    
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[2]);
      /*@lineinfo:user-code*//*@lineinfo:55^21*/      out.print(rs.getString(1));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[3]);
      /*@lineinfo:user-code*//*@lineinfo:56^21*/      out.print(rs.getString(2));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[4]);
      /*@lineinfo:user-code*//*@lineinfo:57^21*/      out.print(rs.getString(3));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[5]);
      /*@lineinfo:user-code*//*@lineinfo:58^21*/      out.print(rs.getString(4));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[6]);
      /*@lineinfo:user-code*//*@lineinfo:59^21*/      out.print(rs.getString(5));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[7]);
      /*@lineinfo:user-code*//*@lineinfo:60^21*/      out.print(rs.getString(6));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[8]);
      /*@lineinfo:user-code*//*@lineinfo:61^21*/      out.print(rs.getString(7));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[9]);
      /*@lineinfo:user-code*//*@lineinfo:62^21*/      out.print(rs.getString(8));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[10]);
      /*@lineinfo:user-code*//*@lineinfo:63^21*/      out.print(rs.getString(9));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[11]);
      /*@lineinfo:user-code*//*@lineinfo:64^67*/      out.print(rs.getString(1));
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[12]);
      /*@lineinfo:user-code*//*@lineinfo:67^15*/      
                        }
                        rs.close();
                        pstmt.close();
                        con.close();
                        }
                        catch(Exception ex)
                        {
                            ex.printStackTrace();
                        }
                    
      /*@lineinfo:generated-code*/
      out.write(__oracle_jsp_text[13]);
      out.write(__oracle_jsp_text[14]);
      out.write(__oracle_jsp_text[15]);


    }
    catch( Throwable e) {
      try {
        if (out != null) out.clear();
      }
      catch( Exception clearException) {
      }
      pageContext.handlePageException( e);
    }
    finally {
      OracleJspRuntime.extraHandlePCFinally(pageContext,false);
      JspFactory.getDefaultFactory().releasePageContext(pageContext);
    }

  }
  private static final char __oracle_jsp_text[][]=new char[16][];
  static {
    try {
    __oracle_jsp_text[0] = 
    "\n".toCharArray();
    __oracle_jsp_text[1] = 
    "\n<html>\n  <head>\n    <meta http-equiv=\"Content-Type\" content=\"text/html; charset=GBK\">\n    <title>untitled</title>\n    <link href=\"css/jdeveloper.css\" rel=\"stylesheet\" media=\"screen\"/>\n    <link href=\"css/oracle.css\" rel=\"stylesheet\" media=\"screen\"/>\n    <link href=\"css/blaf.css\" rel=\"stylesheet\" media=\"screen\"/>\n  </head>\n  <body>\n   \n    <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\" width=\"578\" align=\"left\">\n      <tr>\n        <td>\n          <H1 align=\"center\">用户信息查看</H1>\n          <form action=\"registerservlet\" method=\"post\">\n            <table cellspacing=\"0\" cellpadding=\"0\" border=\"1\" width=\"90%\" align=\"center\">\n              <tr>\n                <td>用户编号</td>\n                <td>用户昵称</td>\n                <td>用户真实姓名</td>\n                <td>性别</td>\n                <td>身份证号</td>\n                <td>地址</td>\n                <td>邮政编码</td>\n                <td>Email</td>\n                <td>联系电话</td>\n                <td>\n                  <P>&nbsp;</P>\n                </td>\n               \n              </tr>\n              \n              ".toCharArray();
    __oracle_jsp_text[2] = 
    "\n              <tr>\n                <td>".toCharArray();
    __oracle_jsp_text[3] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[4] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[5] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[6] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[7] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[8] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[9] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[10] = 
    "</td>\n                <td>".toCharArray();
    __oracle_jsp_text[11] = 
    "</td>\n                <td><a href=registerservlet?action=del&Consumerid=".toCharArray();
    __oracle_jsp_text[12] = 
    ">删除</a></td>\n              \n              </tr>\n              ".toCharArray();
    __oracle_jsp_text[13] = 
    "\n            </table>\n            <P>\n              ".toCharArray();
    __oracle_jsp_text[14] = 
    "\n              ".toCharArray();
    __oracle_jsp_text[15] = 
    "\n            </P>\n          </form>\n          <P>&nbsp;</P>\n          <P>&nbsp;</P>\n        </td>\n      </tr>\n    </table>\n  </body>\n</html>\n".toCharArray();
    }
    catch (Throwable th) {
      System.err.println(th);
    }
}
}