tomcat的内存分配是默认的64M
程序代码如下:
/*
<%
SQLProxy sqlp=new SQLProxy("name");
if(null==sqlp){
out.println("无法与数据库建立连接。");
return;
}
String sql = "";
%>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<%
try{
sqlCount="select count(*) total from mnnews where classid=" + classid;
sql = "select * from (select rownum srnum,newsid,title,content,systime from (select * from mnnews where classid="+classid+" order by systime desc)) where srnum ";
sqlp.getPageBreak(String.valueOf(pageid),sqlCount,sql,15);
pagecount=sqlp.getAllPage();
if(pageid > pagecount || pageid < 2){
pageid=1;
}
while(sqlp.nextRow()){
newsid = sqlp.getFieldString("newsid");
%>
<tr>
<td width="16" height="25"><img src="../img/menu_arrow.gif" width="16" height="16"></td>
<td><a href="show_news.jsp?newsid=<%=newsid%>"><%=sqlp.getField("title")%></a>
(<%=sqlp.getFieldString("systime").substring(5,10)%> <font color=red><%=sqlp.getField("count")%></font>次点击)</td>
</tr>
<%} //end while
%>
</table>
<%wo.freeConnection();%>
*/
程序代码如下:
/*
<%
SQLProxy sqlp=new SQLProxy("name");
if(null==sqlp){
out.println("无法与数据库建立连接。");
return;
}
String sql = "";
%>
<table width="580" border="0" cellspacing="0" cellpadding="0" align="center">
<%
try{
sqlCount="select count(*) total from mnnews where classid=" + classid;
sql = "select * from (select rownum srnum,newsid,title,content,systime from (select * from mnnews where classid="+classid+" order by systime desc)) where srnum ";
sqlp.getPageBreak(String.valueOf(pageid),sqlCount,sql,15);
pagecount=sqlp.getAllPage();
if(pageid > pagecount || pageid < 2){
pageid=1;
}
while(sqlp.nextRow()){
newsid = sqlp.getFieldString("newsid");
%>
<tr>
<td width="16" height="25"><img src="../img/menu_arrow.gif" width="16" height="16"></td>
<td><a href="show_news.jsp?newsid=<%=newsid%>"><%=sqlp.getField("title")%></a>
(<%=sqlp.getFieldString("systime").substring(5,10)%> <font color=red><%=sqlp.getField("count")%></font>次点击)</td>
</tr>
<%} //end while
%>
</table>
<%wo.freeConnection();%>
*/
解决方案 »
- Environment variable ORACLE_UNQNAME not defined.
- 各位大虾,oracle中如何存储图像,声音文件,而又如何调出来显示为相应的图像声音,谢!!!
- 急急急 大家帮帮忙 十分感谢
- select max(ID) from organization 把它取出来后怎么处理才能 insert到 varchar类型的列里?
- 高手们,此问题万分火急,在线等待,请高手指点!!!
- 求sql语句(急)
- Oracle 存储过程测试问题!非常简单!!!!!
- 简单问题--创建视图sql语句
- sqlplus登陆提示协议适配器错误。。。
- 如何对一个取出的字段,进行编辑
- 求助:关于错误Error while trying to retrieve text for error ORA-12154
- 当表修改记录时,在外部程序触发一事件,怎么处理?请指教
/*
Runtime.getRuntime().gc();
out.println("总数:"+Runtime.getRuntime().totalMemory() +" 剩余:"+ Runtime.getRuntime().freeMemory()+"<br>");
out.println("使用:"+(Runtime.getRuntime().totalMemory() - Runtime.getRuntime().freeMemory())) ;
*/
输出结果:总数:20910080 剩余:9619616 使用:11290864 我想一定是我哪个环节有问题,否则,不可能只是那么点操作就导致内存溢出,因为我知道很多公司的海量数据操作都用oracle+jsp+tomcat,所以oracle+jsp+tomcat一定有很好的性能
春困秋乏夏打盹,睡不醒的冬三月 ^^!