读书人

JDBC怎么读写B/CLOB

发布时间: 2012-01-03 22:16:06 作者: rapoo

JDBC如何读写B/CLOB
望高手指点!~~由于刚接触这个概念,希望能浅显易懂些!~

[解决办法]

Java code
        Statement stmt = connection.createStatement();        ResultSet rs = stmt.executeQuery("SELECT col_blob FROM mysql_all_table");            if (rs.next()) {            // Get the BLOB from the result set            Blob blob = rs.getBlob("col_blob");                // Get the number bytes in the BLOB            long blobLength = blob.length();                // Get bytes from the BLOB in a byte array            int pos = 1;   // position is 1-based            int len = 10;            byte[] bytes = blob.getBytes(pos, len);                // Get bytes from the BLOB using a stream            InputStream is = blob.getBinaryStream();            int b = is.read(); 

读书人网 >Eclipse开发

热点推荐