Postgres:如何使用JDBC API读oid值,postgresoid,conn.setAuto
分享于 点击 18420 次 点评:61
Postgres:如何使用JDBC API读oid值,postgresoid,conn.setAuto
conn.setAutoCommit(false);// Get the Large Object Manager to perform operations withLargeObjectManager lobj = ((org.postgresql.PGConnection)conn).getLargeObjectAPI();PreparedStatement ps = con.prepareStatement("SELECT imgoid FROM imageslo WHERE imgname = ?");ps.setString(1, "myimage.gif");ResultSet rs = ps.executeQuery();if (rs != null) { while (rs.next()) { // Open the large object for reading int oid = rs.getInt(1); LargeObject obj = lobj.open(oid, LargeObjectManager.READ); // Read the data byte buf[] = new byte[obj.size()]; obj.read(buf, 0, obj.size()); // Do something with the data read here // Close the object obj.close(); } rs.close();}ps.close();conn.commit();
用户点评