用語法 lock table

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();