jsp出错了，急，急，急，急，在线等！！！

[anly1109]

原码：<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.SimpleDateFormat" %>
<%@ page import="javax.servlet.http.Cookie" %>
<%

//µÃµ½sessionÖµ
String act = request.getParameter("act"); //È¡ËùÊô»î¶¯±àºÅ
if("".equals(act) && act!=null)
{
act="0";
}

String c1 = request.getParameter("c1"); //Ö÷¸±ÇþµÀ±àºÅ
if(!"".equals(c1) && c1!=null)
{
session.setAttribute("c1",c1);
}
else
{
c1="0";
}

String c2 = request.getParameter("c2"); //µÃµ½²ÎÊýc2
if(!"".equals(c2) && c2!=null)
{
session.setAttribute("c2",c2);
}
else
{
c2="0";
}

String uin = request.getParameter("uin"); //Ìá½»µÄQQºÅÂë
if(!"".equals(uin) && uin!=null)
{
session.setAttribute("uin",uin);
}
else
{
uin="0";
}

String n1 = request.getParameter("n1"); //Ò³Ãæµã»÷Êý
if("".equals(n1) || n1==null )
{
n1="0";
}

String n2 = request.getParameter("n2"); //Ò³ÃæÌá½»Êý
if("".equals(n2) || n2==null)
{
n2="0";
}

String n3 = request.getParameter("n3"); //Ò³ÃæÌá½»×ܶQ±Ò£©£¬¼´³¢ÊÔ¶î
if(!"".equals(n3) && n3!=null)
{
session.setAttribute("n3",n3); //±£´æ³¢ÊÔ½ð¶î
}
else
{
n3="0";
}

String n4 = request.getParameter("n4"); //³É¹¦½»Ò×±ÊÊý
if("".equals(n4) || n4==null)
{
n4="0";
}

String n5 = request.getParameter("n5"); //µÃµ½²ÎÊýn5//³É¹¦½»Ò××ܶQ±Ò£©
if(!"".equals(n5) && n5!=null)
{
session.setAttribute("n5",n5);
}
else
{
n5="0";
}

String n6 = request.getParameter("n6"); //ÆعâÊý
if("".equals(n6) || n6==null)
{
n6="0";
}

if (session.getAttribute("uin")!=null)
{
uin=(String)session.getAttribute("uin");
}

if (session.getAttribute("c1")!=null)
{
c1=(String)session.getAttribute("c1");
}

if (session.getAttribute("c2")!=null)
{
c2=(String)session.getAttribute("c2");
}

if (session.getAttribute("n5")!=null)
{
n5=(String)session.getAttribute("n5");
}

if (session.getAttribute("n3")!=null)
{
n3=(String)session.getAttribute("n3");
}

//È¡µ±ÌìµÄÈÕÆÚ
SimpleDateFormat mydate = new SimpleDateFormat("yyyyMMdd");
java.util.Date date = new java.util.Date();
String today = mydate.format(date);
String strTime = String.valueOf(date.getTime());
strTime = strTime.substring(0,strTime.length()-3);

//×é×°¸üмǼµÄÌõ¼þ
String strWhere = new String("");
StringBuffer sbWhere = new StringBuffer();
strWhere = sbWhere.append(" date_id = '").append(today).append("' and act = '").append(act).append("' and c1 = '").append(c1).append("' and c2 = '").append(c2).append("'").toString();

//×é×°¸üмǼµÄ×Ö¶Î
String strUpdate = new String("");
StringBuffer sbUpdate = new StringBuffer();
if(!"0".equals(n1))
{
sbUpdate.append(" n1=n1+1,");
}

if(!"0".equals(n2))
{
sbUpdate.append(" n2=n2+1,");
}

if(!"0".equals(n3))
{
sbUpdate.append(" n3=n3+").append(n3).append(",");
}

System.out.println("--- act = " + act + " --- n4 = " + n4 + " -- c1 = " + c1 + " -- c2 = " + c2);

if(!"0".equals(n4))
{
sbUpdate.append(" n4=n4+1,").append(" n5=n5+").append(n3).append(",");
}

if(!"0".equals(n6))
{
sbUpdate.append(" n6=n6+1,");
}
strUpdate = sbUpdate.toString();
int iLen = strUpdate.length();
if(iLen>1)
{
strUpdate = strUpdate.substring(1,iLen-1);
}
else
{
strUpdate = " n1=n1+1 ";
}

//×é×°¸üеÄsqlÓï¾ä
StringBuffer sb = new StringBuffer();
String sqlStr = sb.append("update qd_boss_stat.t_activity_stat set ").append(strUpdate).append(" where ").append(strWhere).toString();
System.out.println("sqlStr = " + sqlStr);
%>

<%

Connection conn = null;
//String host = "192.168.8.33";
String host = "177.16.88.12";
String port = "3306";
String database = "qd_boss_stat";
String user = "root";
String passwd = "";
Statement stmt = null;
ResultSet rs = null;

//È¡Ò»¸öÊý¾Ý¿âµÄÁ¬½Ó
try
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
}
catch (Exception E)
{
System.out.println("Unable to load driver.");
}

try
{
conn= java.sql.DriverManager.getConnection ("jdbc:mysql://" + host + ":" + port + "/" + database + "?useUnicode=true&characterEncoding=gb2312",user,"");
}
catch (Exception ex)
{
ex.printStackTrace();
System.out.println("Unable to connect database.");
}

//×¼±¸²åÈëÐÂÓû§
String strInsert = "insert into qd_boss_act_flow.t_"+today+"(uin,act,c1,c2,time) values('"+uin+"','"+ act +"','"+ c1 +"','"+c2+"','"+strTime+"')";

try
{
stmt = conn.createStatement();
int dd= stmt.executeUpdate(sqlStr);
}
catch(Exception ex)
{
System.out.println("update fail.");
}
if(!"0".equals(n4))
{
if(!"0".equals(uin) && uin != null)
{
try
{
System.out.println("strInsert = " + strInsert);
int k= stmt.executeUpdate(strInsert);
}
catch(Exception ex)
{
System.out.println("insert uin fail.");
//System.out.println("strInsert = " + strInsert);
}
}
}
try
{
stmt.close();
conn.close();
}
catch(Exception e)
{
System.out.println("close stmt fail.");
}
%>

错误：Oct 13, 2005 10:40:06 AM org.apache.tomcat.util.threads.ThreadPool$ControlRunnable run
SEVERE: Caught exception (java.lang.OutOfMemoryError) executing org.apache.tomcat.util.net.TcpWorkerThread@1dddba, terminating thread
Oct 13, 2005 10:40:12 AM org.apache.jasper.runtime.JspFactoryImpl internalGetPageContext
SEVERE: Exception initializing page context
java.lang.OutOfMemoryError

[chinatelly]

太长了，看不出来

[vvpang]

java.lang.OutOfMemoryError 这个错误。。。

你是不是一次打开存放的数据太多了。。。

[vvpang]

那个异常的意思是，内存溢出了。。

[akins]

提示的是内存溢出,是不是你插入的数据的值大于数据库里定义的字段的大小

[anly1109]

tomcat每秒有700个进程。是否进程太多了。

[baobao1003]

总之 综上所述 很有可能是 你开的进程或打开的数据太多让内存溢出了

[haodong2006]

代码太长，建议楼主把其中一些通用的java代码放到一个bean里封装到一个包里，用到的就调用，这样方便调试和维护。