selectclob.tag

某石油系统正在使用的实时报表平台系统

<%@ tag body-content="empty" %>
<%@ attribute name="table"   required="true" %>
<%@ attribute name="clobvar" required="true" %>
<%@ attribute name="where"   required="true" %>
<%@ attribute name="var" type="java.lang.String" rtexprvalue="false" required="true" %>
<%@ variable name-from-attribute="var" alias="clobcts" scope="AT_END" %>

<%@include file="/Connections/oraConn.jsp"%>
<%
String clobcts = "";
String strsql = "SELECT " + clobvar + " FROM " + table + " WHERE "+ where;

java.sql.Driver driver=(java.sql.Driver)Class.forName(MM_oraConn_DRIVER).newInstance();
java.sql.Connection oraConn=java.sql.DriverManager.getConnection(MM_oraConn_STRING,MM_oraConn_USERNAME,MM_oraConn_PASSWORD);

oracle.jdbc.driver.OracleStatement stmt;
stmt=(oracle.jdbc.driver.OracleStatement)oraConn.createStatement();
oracle.jdbc.driver.OracleResultSet rs=(oracle.jdbc.driver.OracleResultSet)stmt.executeQuery(strsql);
if (rs.next())
{
	try
	{
		oracle.sql.CLOB cts = (oracle.sql.CLOB)(rs.getCLOB(1));
		if(cts!=null)
				for(long pos=1; pos <= cts.length(); pos += 2000)
					clobcts += cts.getSubString(pos,2000);
	}
	catch(Exception e)
	{
		out.println("\n\r<br>Error occured when Reading CLOB Contents: ");
		out.println(e);
	}
	finally
	{
		rs.close();
		stmt.close();
		oraConn.close();
		
		clobcts = clobcts.replaceAll("\n","");
		clobcts = clobcts.replaceAll("\r","");
		clobcts = clobcts.replaceAll("\'","\\'");

		jspContext.setAttribute("clobcts", new String(clobcts));
	}
}
%>