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

arrow
arrow
    全站熱搜

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