详解jdbc实现对CLOB和BLOB数据类型的操作

详解jdbc实现对CLOB和BLOB数据类型的操作

1、 读取操作

CLOB 

//获得数据库连接      Connection con = ConnectionFactory.getConnection();      con.setAutoCommit(false);      Statement st = con.createStatement();      //不需要“for update”      ResultSet rs = st.executeQuery("select CLOBATTR from TESTCLOB where ID=1");      if (rs.next())      {        java.sql.Clob clob = rs.getClob("CLOBATTR");        Reader inStream = clob.getCharacterStream();        char[] c = new char[(int) clob.length()];        inStream.read(c);        //data是读出并需要返回的数据，类型是String        data = new String(c);        inStream.close();      }      inStream.close();      con.commit();      con.close();