Connection并发问题

最新推荐文章于 2021-10-18 09:49:35 发布

walk_net

最新推荐文章于 2021-10-18 09:49:35 发布

阅读量372

点赞数

文章标签： JDBC thread

本文链接：https://blog.csdn.net/walk_net/article/details/83639033

版权


Connection lock = getConnection();
lock.setAutoCommit(false);
lock.createStatement().execute("select * from zhaojianyong for update");

final Connection connection = getConnection();
connection.setAutoCommit(false);

new Thread(){

    @Override
    public void run() {
        try {
            Thread.sleep(10 * 1000);
        } catch (InterruptedException ex) {
            ex.printStackTrace();
        }
        try {
            System.out.println("begin commit");
            connection.commit();
            System.out.println("end commit");
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

}.start();

connection.createStatement().execute("update zhaojianyong set id= 8 where id != 0");