/*
 * JSP generated by Resin-3.0.8 (built Tue, 08 Jun 2004 02:25:40 PDT)
 */

package _jsp._web._1;
import javax.servlet.*;
import javax.servlet.jsp.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import java.sql.*;

public class _spzs__jsp extends com.caucho.jsp.JavaPage{
  private boolean _caucho_isDead;
  
  public void
  _jspService(javax.servlet.http.HttpServletRequest request,
              javax.servlet.http.HttpServletResponse response)
    throws java.io.IOException, javax.servlet.ServletException
  {
    javax.servlet.http.HttpSession session = request.getSession(true);
    com.caucho.server.webapp.Application _jsp_application = _caucho_getApplication();
    javax.servlet.ServletContext application = _jsp_application;
    com.caucho.jsp.PageContextImpl pageContext = com.caucho.jsp.QJspFactory.allocatePageContext(this, _jsp_application, request, response, null, session, 8192, true);
    javax.servlet.jsp.JspWriter out = pageContext.getOut();
    javax.servlet.ServletConfig config = getServletConfig();
    javax.servlet.Servlet page = this;
    response.setContentType("text/html;charset=gb2312");
    request.setCharacterEncoding("GB2312");
    try {
      out.write(_jsp_string0, 0, _jsp_string0.length);
      Connection con;
Statement stmt;
ResultSet rs;
Class.forName("com.mysql.jdbc.Driver");
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
String dbUrl="jdbc:mysql://localhost:3306/laba?useUnicode=true&characterEncoding=GB2312";
String dbUser="root";
String dbPwd="1982o7o9";
con=java.sql.DriverManager.getConnection(dbUrl,dbUser,dbPwd);
stmt=con.createStatement();

      out.write(_jsp_string1, 0, _jsp_string1.length);
      
String webname="\u4f01\u5bcc\u7f51"                              ; 
String WebUrl="http://www.qifo.com"                  ;
String serverEmail="finaler@163.com"                 ;
String servetel="13543040545"                        ;
String webfax=" 0756-2000000"                        ;
String webCompany="\u4f01\u5bcc\u6709\u9650\u516c\u53f8"                     ;
String address="\u5e7f\u4e1c\u7701\u73e0\u6d77\u5e02\u91d1\u9f0e"        ;
String webpost="519000"                              ;
String pat="1000\u5143\u4eba\u6c11\u5e01"                            ;
String QQ="6955125"                                   ;
String adminname="\u6881\u5148\u751f"                            ;
String ver="V1.0\u7248"                                  ;
String banzu="finaler"                               ;
String banzuid="2"                               ;

      out.write(_jsp_string1, 0, _jsp_string1.length);
      String memid = (String)request.getParameter("id");
rs=stmt.executeQuery("SELECT * from qyml where id='"+memid+"'");
rs.next();

      out.write(_jsp_string2, 0, _jsp_string2.length);
      out.print((rs.getString("qymc")));
      out.write(_jsp_string3, 0, _jsp_string3.length);
      out.print((rs.getString("qymc")));
      out.write(_jsp_string4, 0, _jsp_string4.length);
      out.print((memid));
      out.write(_jsp_string5, 0, _jsp_string5.length);
      out.print((memid));
      out.write(_jsp_string6, 0, _jsp_string6.length);
      out.print((memid));
      out.write(_jsp_string7, 0, _jsp_string7.length);
      out.print((memid));
      out.write(_jsp_string8, 0, _jsp_string8.length);
      out.print((memid));
      out.write(_jsp_string9, 0, _jsp_string9.length);
      out.print((rs.getString("id")));
      out.write(_jsp_string10, 0, _jsp_string10.length);
      out.print((rs.getString("email")));
      out.write(_jsp_string11, 0, _jsp_string11.length);
      
rs=stmt.executeQuery("SELECT * from showbar where memid='"+memid+"' order by id desc");
String pages = request.getParameter("page") ;
int pageInt =  1 ,i=0 ;
if(pages==null){}else{pageInt = Integer.parseInt(pages);}
while(i<20*(pageInt-1)&&rs.next()){i++ ;}
i=0;
while(rs.next()&i<20){
i++ ;

      out.write(_jsp_string12, 0, _jsp_string12.length);
      out.print((rs.getString("id")));
      out.write(_jsp_string13, 0, _jsp_string13.length);
      out.print((rs.getString("showphoto")));
      out.write(_jsp_string14, 0, _jsp_string14.length);
      out.print((rs.getString("id")));
      out.write(_jsp_string15, 0, _jsp_string15.length);
      out.print((rs.getString("showname")));
      out.write(_jsp_string16, 0, _jsp_string16.length);
      out.print((rs.getString("showxing")));
      out.write(_jsp_string17, 0, _jsp_string17.length);
      out.print((rs.getString("showaddress")));
      out.write(_jsp_string18, 0, _jsp_string18.length);
      out.print((rs.getString("id")));
      out.write(_jsp_string19, 0, _jsp_string19.length);
      
}

      out.write(_jsp_string20, 0, _jsp_string20.length);
      
rs=stmt.executeQuery("SELECT count(*) from showbar where memid='"+memid+"' order by id desc");
while(rs.next()) i = rs.getInt(1) ;

      out.write(_jsp_string21, 0, _jsp_string21.length);
      out.print((i));
      out.write(_jsp_string22, 0, _jsp_string22.length);
      out.print(((i+20)/20));
      out.write(_jsp_string23, 0, _jsp_string23.length);
      out.print((pageInt));
      out.write(_jsp_string24, 0, _jsp_string24.length);
      for(int j=1;j<(i+40)/20;j++){
      out.write(_jsp_string25, 0, _jsp_string25.length);
      out.print((j));
      out.write(_jsp_string26, 0, _jsp_string26.length);
      out.print((memid));
      out.write(_jsp_string27, 0, _jsp_string27.length);
      out.print((j));
      out.write(_jsp_string28, 0, _jsp_string28.length);
      }
      out.write(_jsp_string29, 0, _jsp_string29.length);
      
rs=stmt.executeQuery("SELECT * from qyml where id='"+memid+"'");
rs.next();

      out.write(_jsp_string30, 0, _jsp_string30.length);
      out.print((rs.getString("qymc")));
      out.write(_jsp_string31, 0, _jsp_string31.length);
    } catch (java.lang.Throwable _jsp_e) {
      pageContext.handlePageException(_jsp_e);
    } finally {
      com.caucho.jsp.QJspFactory.freePageContext(pageContext);
    }
  }

  private com.caucho.java.LineMap _caucho_line_map;
  private java.util.ArrayList _caucho_depends = new java.util.ArrayList();

  public java.util.ArrayList _caucho_getDependList()
  {
    return _caucho_depends;
  }

  public void _caucho_addDepend(com.caucho.make.PersistentDependency depend)
  {