用語法 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();