关于JSP+RESIN+MYSQL 速度变慢问题

Question

硬件应该可以保证的
Intel(R) Xeon (TM) cpu 2.80GHZ
2.79GHz
1.00GB的内存

Answer 1

resin配置文件resin.conf<!--
   - The Resin configuration file.
   -
   - This example file is more complicated than is needs to be because
   - it makes several configurations explicit that can be simplified and
   - because it needs to configure the examples.
   -
   - Look in conf/samples for more realistic sample configurations.
   -   conf/samples/simple.conf - a simple, basic configuration
   -   conf/samples/deploy.conf - a simple configuration for deployment
   -
   - The configuration is based on a purely element-based XML.  To make
   - it easier to read, attributes can be used as syntactic sugar.
   -
   - The following are equivalent:
   - <foo><bar>13</bar></foo>  - canonical representation, but verbose
   - <foo bar=13/>             - typical configuration
   - <foo><bar id=13/></foo>   - sometimes useful
  -->
<caucho.com><!-- Resin logging.  You can uncomment the following useful log.
   -
   - <log id='/caucho.com/tcp-server'
   -      href='stderr:'
   -      timestamp='[%H:%M:%S.%s]'/>
  --><!-- Security providers.  Adding JSSE looks like:
   - <security-provider id='com.sun.net.ssl.internal.ssl.Provider'/>
  --><!--
   - You can change the compiler to "internal" or jikes
   - and change the work-dir
  -->
<java compiler="internal" compiler-args="" work-dir='work'/><!--
   - Sample database pool configuration
   - The JDBC name is java:comp/env/jdbc/test
  -->
<resource-ref>
  <res-ref-name>ynedudb</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <init-param driver-name="org.gjt.mm.mysql.Driver"/>
  <init-param url="jdbc:mysql://127.0.0.1/eastdb"/>
  <init-param user="xsz"/>
  <init-param password="xsz"/>
  <init-param max-connections="20"/>
  <init-param max-idle-time="30"/>
  <init-param enable-transaction="false"/>
</resource-ref><!--
   - Use precompiled JSP classes if available.
   - 'static-encoding' - optimization if you stick to one character set
  -->
<jsp precompile='true' static-encoding='true' recompile-on-error='true'/><!--
   - For production sites, change class-update-interval to something
   - like 60, so it only checks for updates every minute.
  -->
<http-server>
  <!--
     - The root file directory of the server.  Apache users will change
     - this to /usr/local/apache/htdocs and IIS users will change it
     - to d:\inetpub\wwwroot
    -->
  <app-dir>doc/websit</app-dir>  <!-- the http port -->
  <http port='8080'/>  <!--
     - The srun port, read by both JVM and plugin
     - 127.0.0.1 is the localhost
    -->
  <srun host='127.0.0.1' port='6802'/>  <!--
     - How to add SSL:
     -
     - <http port=8443>
     -   <ssl>true</ssl>
     -   <key-store-type>pkcs12</key-store-type>
     -   <key-store-file>keys/server_cert.p12</key-store-file>
     -   <key-store-password>changeit</key-store-password>
     - </http>
    -->  <!--
     - Select an error page to display when the connection fails.
     -
     - <error-page location='connection' location='/my-error-page.html'/>
    -->  <!-- To disable /caucho-status, set this to false -->
  <caucho-status>true</caucho-status>  <!-- maximum number of threads -->
  <thread-max>150</thread-max>  <!--
     - How many threads to wait for keepalives.  Should be at least the
     - number of Apache processes to get good performance.
    -->
  <thread-keepalive id='100'/>
  <!--
     - How long an idle keepalive connection should listen to the socket.
    -->
  <request-timeout id='30s'/>
  <!--
     - How many sockets to hold in the buffer before failing requests.
    -->
  <accept-buffer-size id='256'/>
  <!--
     - Maximum number of request threads which will wait for a socket.
    -->
  <thread-min id='5'/>  <!--
     - Ping to test if the web server is still up.  You can uncomment this
     - and point it to pages on the webserver that exercise your main
     - logic (like database access).  If the GET fails, it will restart
     - the server.  This will catch deadlocks, but not JDK freezes.
     -
     - <ping sleep-time='1m' retry-count='3' retry-time='1s'>
     -   <url>http://localhost:8080/ping/ping.jsp</url>
     - </ping>
    -->  <!--
     - Enables/disables exceptions when the browser closes a connection.
    -->
  <ignore-client-disconnect>true</ignore-client-disconnect>  <!--
     - Enable internal caching.
     - 'dir' is the directory containing the cache
     - 'size' is the memory size in kb
     - 'entries' is the number of entries in the memory cache
    -->
  <cache dir='cache' size='1024' entries='8192'/>  <!-- default host if no other host matches -->
  <host id=''>
    <!--
       - The standalone server should uncomment for access logging.
       - With another web server, like Apache, the web server will
       - log this information.
    <access-log id='log/access.log' 
          format='%h %l %u %t "%r" %s %b "%{Referer}i" "%{User-Agent}i"'/>
      -->    <error-log id='log/error.log'/>    <!--
       - Specifies an automatically-expanding .war dir.  Any foo.war
       - file will be expanded to a /foo application.
      -->
    <war-dir id='webapps'/>    <web-app id='/'>
              <directory-servlet>none</directory-servlet>
      <!-- how often to check servlets for changes (id used for brevity) -->
      <class-update-interval id='2'/>      <!--
         - The classpath directive may be repeated.  Source is optional
         - Servlets and beans generally belong in WEB-INF/classes
        -->
      <classpath id='WEB-INF/classes'
                 source='WEB-INF/classes'
                 compile='true'/>

Answer 2

//接上...
      <!--
         - Expires time for a cacheable file.  Production sites will
         - normally change this to '15m'
        -->
      <cache-mapping url-pattern='/' expires='2s'/>      <!--
         - set the pages to be used as welcome (index) files
        -->
      <welcome-file-list>index.xtp, index.jsp, index.html</welcome-file-list>      <session-config>
        <session-max>4096</session-max>
        <session-timeout>30</session-timeout>
        <enable-cookies>true</enable-cookies>
        <enable-url-rewriting>true</enable-url-rewriting>        <!--
           - Store sessions in the filesystem, so they can persist across
           - servlet and class changes.
           -
           - Uncomment this during development.
          -->
        <!--
           -  <file-store>WEB-INF/sessions</file-store>
          -->
      </session-config>      <!-- enable multipart-mime/form processing -->
      <!--
         - <multipart-form upload-max='-1'/>
        -->      <!--
         - special mapping so /servlet/pkg.MyServlet invokes pkg.MyServlet
        -->
      <servlet-mapping url-pattern='/servlet/*' servlet-name='invoker'/>      <servlet-mapping url-pattern='*.xtp'
                       servlet-name='com.caucho.jsp.XtpServlet'/>
      <servlet-mapping url-pattern='*.jsp'
                       servlet-name='com.caucho.jsp.JspServlet'/>      <!-- 
         - The following entries configuration the examples.  You may safely
         - delete anything from here down.
        -->      <!-- Application init parameters, see Env.java to get the values -->
      <context-param info='An application information string'/>      <!-- snoop-servlet handles all urls starting with /snoop -->
      <servlet-mapping url-pattern='/snoop/*' servlet-name='snoop-servlet'/>      <!-- configure snoop-servlet with init parameters -->
      <servlet servlet-name='snoop-servlet' servlet-class='Env'>
        <init-param info='A servlet information string'/>
      </servlet>      <!-- /~user maps to user directories -->
      <path-mapping url-regexp='^/~([^/]*)' real-path='/home/$1/public_html/'/>      
    </web-app>    <!-- Define applications (ServletContexts) for the examples.
       - Since applications are entirely separate from one another,
       - including session variables and servlet-mappings, the
       - servlet-mapping declarations need to be repeated.
      -->
    <web-app id='examples/basic'/>    <web-app id='examples/tags'/>    <web-app id='examples/tictactoe'/>
 
    <web-app id='examples/navigation'/>    <web-app id='examples/xsl'/>    <web-app id='examples/templates'>
      <servlet-mapping url-pattern='/servlet/*' servlet-name='invoker'/>
      <servlet-mapping url-pattern='/GuestJsp' servlet-name='GuestJsp'/>
      <servlet-mapping url-pattern='/GuestXtp' servlet-name='GuestXtp'/>
      <servlet-mapping url-pattern='/RSS' servlet-name='jsp.RSS'/>      <servlet servlet-name='GuestJsp' servlet-class='jsp.GuestJsp'/>
      <servlet servlet-name='GuestXtp' servlet-class='jsp.GuestXtp'/>
    </web-app>
    <web-app id='/examples/login'/>
    
<servlet>
<servlet-name>DisplayChart</servlet-name>
<servlet-class>org.jfree.chart.servlet.DisplayChart</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>DisplayChart</servlet-name>
<url-pattern>/servlet/DisplayChart</url-pattern>
</servlet-mapping>    
  </host>  <!--
     - Known broken browsers.  These should no longer be necessary, but
     - you can uncomment them if they become a problem.
     -
     - <browser-mapping regexp="MSIE 4\.0b2" force10/>
     - <browser-mapping regexp="RealPlayer 4\.0" force10/>
     - <browser-mapping regexp="Java/1\\.0" force10/>
     - <browser-mapping regexp="JDK/1\\.0" force10/>
    -->
</http-server><http-server app-dir='c:/apache/apache2/htdocs/websit'>
<error-log id='log/error.log'/>
<classpath id='WEB-INF/classes' source='WEB-INF/classes' compile='true'/>
<servlet-mapping url-pattern='/servlets/*' servlet-name='invoker'/>
<servlet-mapping url-pattern='*.xtp' servlet-name='com.caucho.jsp.XtpServlet'/>
<servlet-mapping url-pattern='*.jsp' servlet-name='com.caucho.jsp.JspServlet'/>
</http-server></caucho.com>

Answer 3

数据连接 oradb.java
// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   oradb.javapackage ynedu;import com.caucho.sql.DBPool;
import java.io.PrintStream;
import java.sql.*;public class oradb
{    private DBPool pool;
    private Connection conn;
    private Statement stmt;
    private static String initialPoolName = null;
    private int connflag;
    ResultSet rs;    public oradb()
    {
        pool = null;
        conn = null;
        stmt = null;
        connflag = 0;
        rs = null;
        try
        {
            pool = DBPool.getPool("ynedudb");
            conn = pool.getConnection();
        }
        catch(SQLException _ex)
        {
            System.out.println("DataSource or JNDI caught erro");
        }
    }    public void closeDB()
    {
        try
        {
            conn.close();
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace();
        }
    }    public void closeStmt()
    {
        try
        {
            if(stmt != null)
                stmt.close();
        }
        catch(Exception exception)
        {
            exception.printStackTrace();
        }
    }    public ResultSet executeQuery(String s)
    {
        rs = null;
        try
        {
            stmt = conn.createStatement(1004, 1007);
            rs = stmt.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return rs;
    }    public ResultSet executeUnCommitQuery(String s)
    {
        rs = null;
        try
        {
            conn.setAutoCommit(false);
            stmt = conn.createStatement(1004, 1007);
            rs = stmt.executeQuery(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return rs;
    }    public int executeUpdate(String s)
    {
        int i = 0;
        try
        {
            stmt = conn.createStatement();
            i = stmt.executeUpdate(s);
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery: " + sqlexception.getMessage());
        }
        return i;
    }    public int isconn()
    {
        if(conn != null)
            connflag = 1;
        return connflag;
    }    public void setCommit()
    {
        try
        {
            conn.setAutoCommit(true);
            conn.commit();
            stmt.close();
            conn.close();
        }
        catch(SQLException sqlexception)
        {
            sqlexception.printStackTrace();
        }
    }}

Answer 4

郁闷同一用户不能连续三次回复,换了一个号再贴以下是网站中其中一个调用数据库的文件
index.jsp<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java"
         import="java.sql.*,
         java.util.*,
         java.net.*"
%>
<%
String sql1;
ResultSet rs1;
String sql2;
ResultSet rs2;
String Date1=new java.util.Date().toLocaleString(); //得到当前时间
%>
<jsp:useBean id="DbQuery" class="ynedu.oradb" scope="page" />
<jsp:useBean id="convert" class="ynedu.Stringcovert" scope="page" />
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>CRM（客户关系管理中心）</title>
<script for=window event=onbeforeunload> 
if (event.clientX>document.body.clientWidth &&event.clientY<0||event.altKey) 
return("请问您要退出008大卖场吗？") 
//confirm
</script> 
<script language="javascript">
<!--
function goto() {
  this.location.href='http://www.d008.com/email/registe1.aspx';
}function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<link href="css.css" rel="stylesheet" type="text/css">
</head><body leftmargin="0" topmargin="0">
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="15" background="images/bktop.gif"></td>
  </tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="80">
<div align="center" class="text-blue">
        <table width="770" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr> 
            <td width="284" rowspan="2"> <div align="left"><img src="images/logo1.jpg" width="273" height="78"></div></td>
            <td colspan="4"><table width="355" border="0" align="right" cellpadding="0" cellspacing="0">
                <tr> 
                  <td width="25" height="25" valign="top"><img src="images/logoin.gif" width="20" height="20"></td>
                  <td width="55"><a href="member/RegMember.jsp" target="_blank" class="text-blue9onl">会员注册</a></td>
                  <td width="25"><img src="images/products.gif" width="20" height="21"></td>
                  <td width="55" class="text-blue9"><a href="gsk/product/" target="_blank" class="text-blue9onl">产品展台</a></td>
                  <td width="30"><img src="images/help.gif" width="25" height="23"></td>
                  <td width="55" class="text-blue9"><a href="easthelp/index.jsp" target="_blank" class="text-blue9onl">会员助手</a></td>
                  <td width="25" class="text-blue9"><img src="images/help01.gif" width="20" height="18"></td>
                  <td width="55" class="text-blue9"><div align="center"><a href="/help.jsp" target="_blank" class="text-blue9onl">获取帮助</a> 
                    </div></td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td width="119" height="55"><div align="right"><a href="stock/index.jsp" target="_blank"><img src="images/my_botton02.gif" width="119" height="51" border="0"></a></div></td>
            <td width="120"> <div align="right"><a href="stock/sindex.jsp" target="_blank"><img src="images/my_botton03.gif" width="119" height="51" border="0"></a></div></td>
            <td width="126"> <div align="right"><a href="gsk/" target="_blank"><img src="images/botton01.gif" width="125" height="51" border="0"></a></div></td>
            <td width="121"> <div align="right"><a href="serach.jsp" target="_blank"><img src="images/ss.gif" width="120" height="51" border="0"></a></div></td>
          </tr>
        </table>
      </div></td>
  </tr>
</table>

Answer 5

接上<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" class="bg-newblue">
  <tr> 
    <td width="26" height="25" background="images/bk-img.jpg" class="text-white9">&nbsp; 
    </td>
    <td width="750" background="images/bk-img.jpg" class="text-white9"><a href="#" class="text-white9">首页</a> 
      | <a href="http://www.d008.com/email/login.aspx" target="_blank" class="text-white9">邮件系统</a> 
      | <a href="easthelp/index.jsp" target="_blank" class="text-white9">会员助手</a> 
      | <a href="cen/index.jsp" target="_blank" class="text-white9">CRM商友社区</a> 
      | <a href="easthelp/chat/newschat.jsp" target="_blank" class="text-white9">语音视频商务</a> 
      | <a href="easthelp/stock/viewstock.jsp?ok=2" target="_blank" class="text-white9">进出口贸易</a> 
      | <a href="gsk/product/index.jsp" target="_blank" class="text-white9">产品展台</a> 
      | 商业知识 | <a href="/advertise/advertise.jsp" target="_blank" class="text-white9">广告服务</a> 
      | <a href="#" target="_blank" class="text-white9">企业建站</a> | <a href="/help.jsp" target="_blank" class="text-white9">帮助</a></td>
  </tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0" class="text-black9">
  <tr> 
    <td width="164" height="30" background="images/bk-img1.jpg" class="text-black9">　您的位置：首页</td>
    <td width="614" background="images/bk-img1.jpg"> <%@ include file="report/adv_report.jsp"%> </td>
  </tr>
  <tr> 
    <td height="2" colspan="2" class="text-black9"></td>
  </tr>
</table>
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="200" height="337" valign="top"> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="5" valign="bottom"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr> 
                <td height="25" valign="bottom" background="images/1-1.gif"> 
                  <div align="right" class="text-green"><a href="member/mem_s.jsp" target="_blank" class="text-green">会员说明</a></div></td>
              </tr>
            </table>
            <table width="200" border="0" cellpadding="0" cellspacing="0" class="bg-yellow">
              <tr bgcolor="#90E490"> 
                <td colspan="3"> 
                  <%
    if(session.getAttribute("username")!=null){
%> 
                  <table width="99%" border="0" align="center" cellpadding="4" cellspacing="0" class="text-green">
                    <tr> 
                      <td height="30">欢迎您：<%=session.getAttribute("username").toString()%></td>
                    </tr>
                    <tr> 
                      <td height="30">离开时请别忘了&nbsp;<a href="/easthelp/logout.jsp" class="text-green">退出登录</a></td>
                    </tr>
                  </table>
                  <%
  } else {
%> <table width="99%" border="0" align="center" cellpadding="0" cellspacing="0" class="text-blue">
                    <form name="form1" method="post" action="member/login.jsp">
                      <tr> 
                        <td width="30%" height="30"> <div align="center" class="text-green">用户名：</div></td>
                        <td width="66%"><input name="username" type="text" id="username" size="16" maxlength="20"></td>
                      </tr>
                      <tr> 
                        <td height="30"> <div align="center" class="text-green">密　码：</div></td>
                        <td><input name="passw" type="password" id="passw" size="16" maxlength="20"></td>
                      </tr>
                      <tr> 
                        <td height="40" colspan="2"> <div align="center"> 
                            <p> 
                              <input name="imageField" type="image" src="images/1.gif" width="65" height="22" border="0">
                              <a href="member/regmember.jsp" target="_blank"><img src="images/2.gif" width="65" height="22" border="0"></a> 
                              <a href="#" class="text-green" onClick="MM_openBrWindow('member/back.jsp','','width=300,height=200')">找回密码</a></p>
                          </div></td>
                      </tr>
                    </form>
                  </table>
                  <%}%> </td>
              </tr>
              <%
//        <tr> 
//          <td width="26" height="1"></td>
//          <td width="147" bgcolor="#AFDAF5"></td>
//          <td width="25"></td>
//        </tr>
%>
            </table></td>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td height="10"></td>
        </tr>
        <tr> 
          <td height="10"><table width="200" border="0" cellpadding="0" cellspacing="0" class="bg-green">
              <tr> 
                <td colspan="3"><img src="images/shou-yy-2.gif" width="200" height="105"></td>
              </tr>
            </table></td>
        </tr>
        <tr>
          <td height="10"></td>
        </tr>
      </table>
      <TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
        <TBODY>
          <TR> 
            <TD width=13 bgColor=#ffffff><IMG height=25 
            src="images/ti2_l.gif" 
            width=13></TD>
            <TD bgColor=#4a94de> <DIV align=center class="text-white9"><img src="images/gq.gif" width="175" height="25" border="0" usemap="#Map"></DIV></TD>
            <TD width=13 bgColor=#ffffff><IMG height=25 
            src="images/ti2_r.gif" 
            width=13></TD>
          </TR>
        </TBODY>
      </TABLE>

Answer 6

...
太长了
我把关键的列出来吧<%@ page contentType="text/html;charset=gb2312"%>
<%@ page language="java"
         import="java.sql.*,
         java.util.*,
         java.net.*"
%>
<%
String sql1;
ResultSet rs1;
String sql2;
ResultSet rs2;
String Date1=new java.util.Date().toLocaleString(); //得到当前时间
%>
<jsp:useBean id="DbQuery" class="ynedu.oradb" scope="page" />  //调用上面的连接数据库的JAVABEAN文件
<jsp:useBean id="convert" class="ynedu.Stringcovert" scope="page" />
以下为我的数据库操作代码   sql="select * from layout where proextract=1 and procommend=1 and procommenddate>='"+Date1+"' limit 0,3";
   try {
      rs=DbQuery.executeQuery(sql);
     }
    catch(Exception e)
     {
      e.printStackTrace();
     }   while(rs.next()){
%>
                <td width="93" height="100"> <p align="center"><span class="text-blue"> 
                    <a href="gsk/layout/<%=rs.getString("layoutfilename")%>" target="_blank"><img 
            height=80 
            src="gsk/layout/pic/<%=rs.getString("picfilename")%>" 
            width=80 border=0></a><br>
                    </span> </p></td>
                <td width="93" height="20" class="text-blue"> <a href="gsk/layout/<%=rs.getString("layoutfilename")%>" target="_blank"> 
                  <% if(rs.getString("productname").length()<=7){
      out.println("<span class=text-blue9onl>"+rs.getString("productname")+"</span>");
 }else{
      out.println("<span class=text-blue9onl>"+rs.getString("productname").substring(0,7)+"</span>");
 }%>
                  </a><br>
                  优惠价:<%=rs.getString("unitprice")%> </td>
                <%
}//while/第一行
%>