lock table 語法
CallableStatement cstmt = sb.pg.con.prepareCall("LOCK TABLE tx005 IN SHARE MODE");
cstmt.execute();
cstmt = sb.pg.con.prepareCall("LOCK TABLE tx007 IN SHARE MODE");
cstmt.execute();


限制筆數
CallableStatement cstmt = pg.con.prepareCall("set rowcount 3");
cstmt.execute();

shikua 發表在 痞客邦 PIXNET 留言(0) 人氣()