java调用oracle含有clob参数的存储过程.doc

java调用oracle含有clob参数的存储过程Posted on 2011/03/30 by koalashanpackage com.db;import java.io.Writer;import java.sql.*;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.*;import java.util.Date;import oracle.sql.ARRAY;import oracle.sql.ArrayDescriptor;import oracle.sql.CLOB;public class DBTest /* * param args */public static void main(String args) try call(); catch (Exception e) e.printStackTrace();public static Connection getConnection() Connection conn = null;String DBDRIVER = oracle.jdbc.driver.OracleDriver;String DBURL = jdbc:oracle:thin:127.0.0.1:1521:dbtest;String DBUSER = sr;String DBPASSWORD = sr;try Class.forName(DBDRIVER);conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD); catch (ClassNotFoundException e) e.printStackTrace(); catch (SQLException e) e.printStackTrace();return conn;public static void call() throws Exception Connection conn = null;CallableStatement proc = null;StringBuffer xml=new StringBuffer();xml.append().append().append(20).append(A0000020850E1F).append().append().append(1).append(900001598).append().append().append().append(3).append(900001598).append().append().append().append(4).append(920000009).append().append().append().append();try conn = getConnection();String call = call srforcrm.feesubsidyvalidate(?,?); / 调用语句proc = conn.prepareCall(call); / 调用存储过程oracle.sql.CLOB _oClob = (CLOB) getCLOB(conn,xml.toString();proc.setObject(1,_oClob);proc.registerOutParameter(2, Types.VARCHAR); / 声明输出参数是什么类型的proc.execute(); / 执行String out = proc.getString(2); / 获得输出参数System.out.println(out is +out); catch (SQLException e) System.err.println(e.getMessage(); finally try proc.close();conn.close(); catch (SQLException e) System.err.println(e.getMessage();public static Clob getCLOB(Connection conn, String clobData)throws Exception CLOB tempClob = null;/ try/ / create a new temporary CLOBtempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION);/ Open the temporary CLOB in readwrite mode to enable writingtempClob.open(CLOB.MODE_READWRITE);/ Get the output stream to writeWriter tempClobWriter = tempClob.getCharacterOutputStream();/ Write the data into the temporary CLOBtempClobWriter.write(clobData);/ Flush and close