如何实例化JAVA.SQL.BLOB类

[calvinsmith]

RT~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

[imasmallbird]

假如你的表中两个字段
TABLE (ID VARCHAR2(32), FILE BLOB)

使用JDBC操作,大概就是这样：

pstmt = conn.prepareStatement("SELECT FILE FROM TABLE WHERE ID =?");
pstmt.setString(1, "1");
rs = pstmt.executeQuery();
if (rs.next()) {
   java.sql.Blob bb = rs.getBlob("FILE");//得到实例～～
}