java的获取pg分区表的api_JAVA存取PG大对象类型OID数据

转载地址：http://my.oschina.net/liuyuanyuangogo/blog/151537

//VM配置:256M-512M

//通过lo_import(‘文件路径’)函数向oid字段插入二进制文件，通过(不会内存溢出)。

/**

*

* @author Liu Yuanyuan

*/

private void insertOid()

{

String driver = "org.postgresql.Driver";//"com.highgo.jdbc.Driver";//192.168.100.125

String url = "jdbc:postgresql://" + "127.0.0.1" + ":" + "5866" + "/" + "db1";

Connection conn = null;

Statement stmt = null;

try

{

Class.forName(driver);

System.out.println("success find class");

conn = DriverManager.getConnection(url, "highgo", "hg");

System.out.println("success connect");

stmt = conn.createStatement();

//driectly insert

String f = "d:/1.jpg";

stmt = conn.prepareStatement("INSERT INTO oidtable VALUES (11, lo_import(\'"+f+"\'))");

//or by update

//String f = "d://2.jpg";

//PreparedStatement ps = conn.prepareStatement("update oidtable set obj = lo_import(\'"+f+"\') where id=?");

//ps.setInt(1,11);

ps.executeUpdate();

}

catch(Exception ex)

{

ex.printStackTrace(System.out);

}

finally

{

try

{

if(stmt!=null)

stmt.close();

if(conn!=null)

conn.close();

}

catch(Exception ex)

{

ex.printStackTrace(System.out);

}

finally

{

System.out.println("finally");

}

}

}

//VM配置:256M-512M

//直接通过setLong()向oid插入1GB的文件，通过(2分钟之内插入完毕);