__resultq.java

税务端受理系统java版 增值税网上认证

/* compiled from JSP: /ResultQ.jsp
*
* This code was automatically generated at 14:14:24 on 2005-11-23
* by weblogic.servlet.jsp.Jsp2Java -- do not edit.
*/

package jsp_servlet;

import java.io.*;
import java.util.*;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import javax.servlet.jsp.tagext.*;

// User imports
import java.sql.*; //[ /ResultQ.jsp; Line: 1]
import java.io.PrintStream; //[ /ResultQ.jsp; Line: 2]


// built-in init parameters:
// boolean             _verbose -- wants debugging

// Well-known variables:
// JspWriter out                  -- to write to the browser
// HttpServletRequest  request    -- the request object.
// HttpServletResponse response   -- the response object.
// PageContext pageContext        -- the page context for this JSP
// HttpSession session            -- the session object for the client (if any)
// ServletContext application     -- The servlet (application) context
// ServletConfig config           -- The ServletConfig for this JSP
// Object page                    -- the instance of this page's implementation class (i.e., 'this')

/**
* This code was automatically generated at 14:14:24 on 2005-11-23
* by weblogic.servlet.jsp.Jsp2Java -- do not edit.
*
* Copyright (c) 2005 by BEA Systems, Inc. All Rights Reserved.
*/
public final class __resultq
extends
weblogic.servlet.jsp.JspBase
implements weblogic.servlet.jsp.StaleIndicator
{
    
    // StaleIndicator interface
    public boolean _isStale() {
        weblogic.servlet.jsp.StaleChecker sci =(weblogic.servlet.jsp.StaleChecker)(getServletConfig().getServletContext());
        java.io.File f = null;
        long lastModWhenBuilt = 0L;
        if (sci.isResourceStale("/ResultQ.jsp", 1105946498000L, "WebLogic Server 7.0  Thu Apr 25 17:16:22 PDT 2002 180709 ")) return true;
        return false;
    }
    
    public static boolean _staticIsStale(weblogic.servlet.jsp.StaleChecker sci) {
        java.io.File f = null;
        long lastModWhenBuilt = 0L;
        if (sci.isResourceStale("/ResultQ.jsp", 1105946498000L, "WebLogic Server 7.0  Thu Apr 25 17:16:22 PDT 2002 180709 ")) return true;
        return false;
    }
    
    
    
    
    public void _jspService(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws java.io.IOException, javax.servlet.ServletException 
    {  
        
        // declare and set well-known variables:
        javax.servlet.ServletConfig config = getServletConfig();
        javax.servlet.ServletContext application = config.getServletContext();
        javax.servlet.jsp.tagext.Tag _activeTag = null;
        // variables for Tag extension protocol
        
        Object page = this;
        javax.servlet.jsp.JspWriter out;
        javax.servlet.jsp.PageContext pageContext =
        javax.servlet.jsp.JspFactory.getDefaultFactory().getPageContext(this, request, response, null, true, 8192, true);
        
        response.setHeader("Content-Type", "text/html; charset=gb2312");
        out = pageContext.getOut();
        JspWriter _originalOut = out;
        
        javax.servlet.http.HttpSession session = request.getSession(true);
        
        
        
        try { // error page try block
            
            response.setContentType("text/html; charset=gb2312");
            
            out.print("\r\n");
            out.print("\r\n");
            acceptsvr.LoginBean LoginBean = null; //[ /ResultQ.jsp; Line: 3]
            LoginBean = (acceptsvr.LoginBean)pageContext.getAttribute("LoginBean"); //[ /ResultQ.jsp; Line: 3]
            if (LoginBean == null) { // begin 'LoginBean' instantiation block... //[ /ResultQ.jsp; Line: 3]
                { // Don't need to synchronize on page scope //[ /ResultQ.jsp; Line: 3]
                    LoginBean = (acceptsvr.LoginBean)pageContext.getAttribute("LoginBean"); //[ /ResultQ.jsp; Line: 3]
                    if (LoginBean == null) { // begin 'LoginBean' synchronized instantiation block... //[ /ResultQ.jsp; Line: 3]
                        LoginBean = new acceptsvr.LoginBean(); //[ /ResultQ.jsp; Line: 3]
                        pageContext.setAttribute("LoginBean", LoginBean); //[ /ResultQ.jsp; Line: 3]
                    } // end synchronized bean instantiation block... //[ /ResultQ.jsp; Line: 3]
                } // end synchronized bean scope block... //[ /ResultQ.jsp; Line: 3]
            } // end bean instantiation block... //[ /ResultQ.jsp; Line: 3]
            out.print("\r\n");
            out.print("\r\n");
            //[ /ResultQ.jsp; Line: 5]
            String sql,Userid,Username,strpage,strNetType,strUserType; //[ /ResultQ.jsp; Line: 6]
            int pagesize,pageno,pagecurrno,pagenos,rows; //[ /ResultQ.jsp; Line: 7]
            pagesize=25; //[ /ResultQ.jsp; Line: 8]
            int i=0; //[ /ResultQ.jsp; Line: 9]
            Userid=request.getParameter("UserID"); //[ /ResultQ.jsp; Line: 10]
            Username=new String(request.getParameter("UserName").getBytes("ISO-8859-1")); //[ /ResultQ.jsp; Line: 11]
            strNetType=new String(request.getParameter("donet_type").getBytes("ISO-8859-1")); //[ /ResultQ.jsp; Line: 12]
            strUserType=new String(request.getParameter("douser_type").getBytes("ISO-8859-1")); //[ /ResultQ.jsp; Line: 13]
            if(Username==null) Username=""; //[ /ResultQ.jsp; Line: 14]
            sql="select * from UserInfo where userid like '"+Userid+"%' and username like '%"+Username+"%'"; //[ /ResultQ.jsp; Line: 15]
            if(strNetType != null && !strNetType.equals("")) sql=sql+" and net_type='"+strNetType+"'"; //[ /ResultQ.jsp; Line: 16]
            if(strUserType != null && !strUserType.equals("")) sql=sql+" and user_type='"+strUserType+"'"; //[ /ResultQ.jsp; Line: 17]
            System.out.println("sql="+sql); //[ /ResultQ.jsp; Line: 18]
            ResultSet rs=LoginBean.executeQuery2(sql) ; //[ /ResultQ.jsp; Line: 19]
            rs.last(); //[ /ResultQ.jsp; Line: 20]
            rows=rs.getRow(); //[ /ResultQ.jsp; Line: 21]
            pagenos=(rows+pagesize-1)/pagesize; //[ /ResultQ.jsp; Line: 22]
            strpage=request.getParameter("page"); //[ /ResultQ.jsp; Line: 23]
            if(strpage==null){pageno=1;} //[ /ResultQ.jsp; Line: 24]
            else{pageno=Integer.parseInt(strpage); //[ /ResultQ.jsp; Line: 25]
                if(pageno<1) pageno=1;} //[ /ResultQ.jsp; Line: 26]
            if(pageno>pagenos) pageno=pagenos; //[ /ResultQ.jsp; Line: 27]
            out.print("\r\n<HTML>\r\n<HEAD >\r\n<link href=\"Admin_STYLE.CSS\" rel=\"stylesheet\" type=\"text/css\">\r\n\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"><title>结果页</title></HEAD>\r\n<BODY bgcolor=\"#E1F4EE\" topmargin=\"0\">\r\n<font color=\"#000000\" size=\"+1\"></font>\r\n<table width=\"100%\" border=\"0\">\r\n  <tr>\r\n    <td><div align=\"center\" class=\"topbg\"><font color=\"#000000\" ><strong><font color=\"#FFFFFF\">查询结果：</font></strong></font></div></td>\r\n  </tr>\r\n</table>\r\n<table width=\"100%\" border=\"0\" class=\"border\" cellspacing=\"1\" cellpadding=\"2\" >\r\n  <tr class=\"title\">\r\n    <td width=\"20%\"><div align=\"center\"><font color=\"#000000\">企业识别号</font></div></td>\r\n    <td width=\"30%\" class=\"title\"><div align=\"center\"><font color=\"#000000\">企业名称</font></div></td>\r\n    <td width=\"10%\"><div align=\"center\"><font color=\"#000000\">密　码</font></div></td>\r\n    <td width=\"10%\"><div align=\"center\"><font color=\"#000000\">开户时间</font></div></td>\r\n    <td width=\"10%\"><div align=\"center\"><font color=\"#000000\">类　别</font></div></td>\r\n\t<td width=\"10%\"><div");
            out.print(" align=\"center\"><font color=\"#000000\">使用软件</font></div></td>\r\n    <td width=\"10%\"><div align=\"center\"><font color=\"#000000\">认证方式</font></div></td>\r\n  </tr>\r\n");
            //[ /ResultQ.jsp; Line: 51]
            if(pagenos>0){ //[ /ResultQ.jsp; Line: 52]
                rs.absolute((pageno-1)*pagesize+1);} //[ /ResultQ.jsp; Line: 53]
            i=0; //[ /ResultQ.jsp; Line: 54]
            while (i<pagesize && !rs.isAfterLast() && rows>0){ //[ /ResultQ.jsp; Line: 55]
                //[ /ResultQ.jsp; Line: 55]
                out.print("\r\n  <tr class=\"tdbg\">\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                out.print(rs.getString("UserId")); //[ /ResultQ.jsp; Line: 57]
                //[ /ResultQ.jsp; Line: 57]
                out.print("</font></div></td>\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                out.print(rs.getString("UserName")); //[ /ResultQ.jsp; Line: 58]
                //[ /ResultQ.jsp; Line: 58]
                out.print("</font></div></td>\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                out.print(rs.getString("Password")); //[ /ResultQ.jsp; Line: 59]
                //[ /ResultQ.jsp; Line: 59]
                out.print("</font></div></td>\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                out.print(rs.getString("Begindate")); //[ /ResultQ.jsp; Line: 60]
                //[ /ResultQ.jsp; Line: 60]
                out.print("</font></div></td>\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                out.print(rs.getString("Operate")); //[ /ResultQ.jsp; Line: 61]
                //[ /ResultQ.jsp; Line: 61]
                out.print("</font></div></td>\r\n\t<td><div align=\"left\"><font color=\"#000000\">");
                if (rs.getString("user_type")==null ){out.print("&nbsp;");}else{out.print(rs.getString("user_type"));} //[ /ResultQ.jsp; Line: 62]
                //[ /ResultQ.jsp; Line: 62]
                out.print("</font></div></td>\r\n    <td><div align=\"left\"><font color=\"#000000\">");
                if(rs.getString("net_type")==null){out.print("&nbsp;");}else{out.print(rs.getString("net_type"));} //[ /ResultQ.jsp; Line: 63]
                //[ /ResultQ.jsp; Line: 63]
                out.print("</font></div></td>\r\n  </tr>\r\n");
                //[ /ResultQ.jsp; Line: 65]
                i=i+1; //[ /ResultQ.jsp; Line: 66]
                rs.next(); //[ /ResultQ.jsp; Line: 67]
            }; //[ /ResultQ.jsp; Line: 68]
            rs.close(); //[ /ResultQ.jsp; Line: 69]
            out.print("\r\n</table>\r\n\r\n<font color=\"#000000\">共有");
            out.print(String.valueOf(rows));  //[ /ResultQ.jsp; Line: 73]
            out.print("条记录!&nbsp;&nbsp;&nbsp;</font>\r\n第");
            out.print(String.valueOf(pageno));  //[ /ResultQ.jsp; Line: 74]
            out.print("页共");
            out.print(String.valueOf(pagenos));  //[ /ResultQ.jsp; Line: 74]
            out.print("页");
            if(pageno<pagenos){ //[ /ResultQ.jsp; Line: 74]
                //[ /ResultQ.jsp; Line: 74]
                out.print("<a href=\"ResultQ.jsp?page=");
                out.print(String.valueOf(pageno+1));  //[ /ResultQ.jsp; Line: 74]
                out.print("&UserID=");
                out.print(String.valueOf(Userid));  //[ /ResultQ.jsp; Line: 74]
                out.print("&UserName=");
                out.print(String.valueOf(Username));  //[ /ResultQ.jsp; Line: 74]
                out.print("&donet_type=");
                out.print(String.valueOf(strNetType));  //[ /ResultQ.jsp; Line: 74]
                out.print("&douser_type=");
                out.print(String.valueOf(strUserType));  //[ /ResultQ.jsp; Line: 74]
                out.print("\">\r\n下一页</a>");
            } //[ /ResultQ.jsp; Line: 75]
            //[ /ResultQ.jsp; Line: 75]
            out.print(" ");
            if(pageno>1){ //[ /ResultQ.jsp; Line: 75]
                //[ /ResultQ.jsp; Line: 75]
                out.print("<a href=\"ResultQ.jsp?page=");
                out.print(String.valueOf(pageno-1));  //[ /ResultQ.jsp; Line: 75]
                out.print("&UserID=");
                out.print(String.valueOf(Userid));  //[ /ResultQ.jsp; Line: 75]
                out.print("&UserName=");
                out.print(String.valueOf(Username));  //[ /ResultQ.jsp; Line: 75]
                out.print("&donet_type=");
                out.print(String.valueOf(strNetType));  //[ /ResultQ.jsp; Line: 75]
                out.print("&douser_type=");
                out.print(String.valueOf(strUserType));  //[ /ResultQ.jsp; Line: 75]
                out.print("\">上一页</a>");
            } //[ /ResultQ.jsp; Line: 75]
            //[ /ResultQ.jsp; Line: 75]
            out.print("\r\n<P>&nbsp;</P>\r\n<P>&nbsp;</P>\r\n\r\n</BODY>\r\n</HTML>\r\n");
        } catch (Throwable __ee) {
            while (out != null && out != _originalOut) out = pageContext.popBody();
            ((weblogic.servlet.jsp.PageContextImpl)pageContext).handlePageException((Throwable)__ee);
        }
        
        
        //before final close brace...
    }
    
    
}