急救!解决方案

2012-02-16

急救!!%@includefile ../SystemFile/share/share_function.jsp %%@includefile ../SystemFile/sha

急救!!
<%@ include file= "../SystemFile/share/share_function.jsp " %>
<%@ include file= "../SystemFile/share/const.jsp " %>
<%@ page contentType= "text/html;charset=GBK " pageEncoding= "GBK "%>
<%
try{

int COLIndex=1; //set for the intro folder

String strSql = " ";
ResultSet rs,rs2;//
String FolderName =FOLDER_INTRO;
String FolderColumnID=FOLDER_INTRO_COLUMNID;
String strINFO_ID = Util.strTrim(Util.get88591Str(request.getParameter( "INFO_ID ")));
if (strINFO_ID.equals( " ")) strINFO_ID= "0 ";
%>
<html>
<head>
<title> <%= SystemName%> </title>
<meta http-equiv= "Content-Type " content= "text/html; charset=GBK " pageEncoding= "GBK ">
<link href= "../css/css.css " rel= "stylesheet " type= "text/css ">
<style type= "text/css ">
.f7 {font-size:7px;}
.f24{font-size:24px;}
.f12{font-size:12px;}
.f14{font-size:14px;}
.l17 {line-height:170%;}
</style>
</head>
<body leftmargin= "0 " topmargin= "0 ">
<%@ include file= "../include/top.jsp "%>
<SCRIPT src= "../js/main.js "> </SCRIPT>
<SCRIPT SRC= "../module/Module_config.js "> </script>
<div align= "center ">
<center>

<table width= "750 " height= "100% " border= "0 " cellpadding= "0 " cellspacing= "0 " style= "border-collapse: collapse " bordercolor= "#111111 ">
<tr valign= "top ">
<td width= "204 " bgcolor= "#C9D3E9 ">
<%@ include file= "../module/L_index.jsp "%>
</td>

<td width= "2 "> <img src= "images/blank.gif " width= "2 " height= "1 "> </td>

<td>
<table width= "552 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td height= "35 " background= "../images/guidebg.gif " class= "guide "> 您现在的位置： <a href= "../index.jsp "> 首页 </a>  >

<%
int ll=strCOLUMN_ID.length()/2;
for (int i=1;i <=ll;i++){
strSql = "select COLUMN_ID,COLUMN_NAME,GoToURL from TB_MOBIL_COLUMN WHERE COLUMN_ID= ' " +strCOLUMN_ID.substring(0,i*2) + " ' ";
rs= dbcon.executeQuery(strSql);
while(rs.next()){
String column_id =Util.strTrim(rs.getString(1));
String column_name=Util.strTrim(rs.getString(2));
String column_url =Util.strTrim(rs.getString(3));
%>
<a href= " <%if (!column_url.equals( " ")){out.println(column_url);}else{ out.println( "index.jsp?COLUMN_ID= "+column_id); }%> "> <%=column_name%> </a>  /
<%
}
}
%>

</td>
</tr>
</table>
<script language= "javascript "> document.write(set[ <%=COLIndex%> ][1]); </script>
</p>

<%
int iRecord=0;
int iVIEW_NUM=0;
strSql = "select ViewNum from TB_MOBIL_TEXT where INFO_ID = " + strINFO_ID ;
//out.println(strSql );
rs = dbcon.executeQuery(strSql);

while(rs.next())
{
iVIEW_NUM=rs.getInt(1)+1;
break;
}

strSql = "Update TB_MOBIL_TEXT set ViewNum = " + iVIEW_NUM + " where INFO_ID = " + strINFO_ID ;
//out.println(strSql );
dbcon.executeQuery(strSql);
//dbcon.executeQuery( "commit ");

String strDbTitle = " "; //信息标题
String strDbMODIFY_DATE = " "; //录入时间
String strDbText = " "; //信息内容
String strAuthor = " "; //信息录入人
String strWEBADDRESS = " "; //信息来源
String strPERSON_ID = " ";
strSql = "select Title,MODIFY_DATE,CONTENT,WEBADDRESS,AUTHOR,PERSON_ID from TB_MOBIL_TEXT where INFO_ID = " + strINFO_ID;
//out.println(strSql );
rs = dbcon.executeQuery(strSql);

while(rs.next())
{

strDbTitle = Util.strTrim(rs.getString(1));
strDbMODIFY_DATE = Util.strTrim(rs.getString(2));
//strDbText = strTrim(rs.getString(3));
Clob clob=rs.getClob( "CONTENT ");
BufferedReader clobStream = new BufferedReader(clob.getCharacterStream());
StringBuffer stringBuffer = new StringBuffer();

int nchars = 0;
char[] buffer = new char[10];
while((nchars = clobStream.read(buffer)) != -1 )
stringBuffer.append(buffer, 0, nchars);
clobStream.close();
strDbText = Util.strTrim(stringBuffer.toString());

strWEBADDRESS = Util.strTrim(rs.getString(4));
strAuthor = Util.strTrim(rs.getString(5));
strPERSON_ID = Util.strTrim(rs.getString(6));

break;
}
%>
<table width= "96% " border= "0 " cellspacing= "3 " cellpadding= "0 " align= "center ">

<tr>

<td background= "../images/bg_line.gif " height= "22 " valign= "top ">

<p align= "center "> </td>

</tr>

<tr>

<td class= "line20 " id= "content ">

<%=Util.replace(strDbText, "[$SYSTEM_IMG_PATH$] ",SystemShowImagesPath)%>

</td>
</tr>
<tr>
<td height= "50 ">

<p align= "center ">

【 <a href= "javascript:doZoom(16) "> 大 </a> <a href= "javascript:doZoom(14) "> 中 </a> <a href= "javascript:doZoom(12) "> 小 </a> 】

【 <a href= "javascript:window.print() "> 打印 </a> 】
<br>

</td>

</tr>
</table>

</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<script language= "JavaScript ">
function doZoom(c) {
content.style.fontSize=c;
}
</script>
<%@ include file= "../include/down.jsp "%>
</body>
</html>
<%
}catch(Exception ex){
out.println(ex);
}finally
{
dbcon.release();
dbconn.release();
}
%>
上面页面出现以下两个异常,请问那里出错了?在线等
1.ArrayIndexOutOfBoundsException
2.java.io.IOException: ORA-21560: argument is null, invalid, or out of range ORA-06512: at "SYS.DBMS_LOB ", line 715 ORA-06512: at line 1

[解决办法]
char[] buffer = new char[10];
while((nchars = clobStream.read(buffer)) != -1 )
stringBuffer.append(buffer, 0, nchars);
好像只有这里有数组耶，是不是这里的呢？

热点排行

Java Web开发

急救!解决方案