updateclob.tag

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

<%@ tag body-content="empty" %>
<%@ attribute name="table"   required="true" %>
<%@ attribute name="clobvar" required="true" %>
<%@ attribute name="clobvalue"   required="true" %>
<%@ attribute name="where"   required="true" %>

<%@include file="/Connections/oraConn.jsp"%>
<%
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);
oraConn.setAutoCommit(false);

String strsql = "SELECT " + clobvar + " FROM " + table + " WHERE "+ where + " FOR UPDATE";

oracle.jdbc.driver.OracleStatement stmt;
stmt=(oracle.jdbc.driver.OracleStatement)oraConn.createStatement();

stmt.executeUpdate("UPDATE " + table + " SET " + clobvar + "=EMPTY_CLOB() WHERE " + where);
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));
	java.io.Writer ctsWriter = cts.getCharacterOutputStream();
	ctsWriter.write(clobvalue);
	ctsWriter.flush();
	ctsWriter.close();
	oraConn.commit();
}
catch(Exception e)
{
	oraConn.rollback();
	out.println("\n\r<br>Error when Writing CLOB Contents: ");
	out.println(e);
}
}
rs.close();
stmt.close();
oraConn.close();
%>