欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

Postgres:如何使用JDBC API读oid值,postgresoid,conn.setAuto

来源: javaer 分享于  点击 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();
相关栏目:

用户点评