当前位置: 代码迷 >> Eclipse >> JDBC怎么读写B/CLOB
  详细解决方案

JDBC怎么读写B/CLOB

热度:487   发布时间:2016-04-23 18:58:51.0
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();
  相关解决方案