sharding-jdbc 强制查询走主库

// 查
// 只对下面第一条查询有效
HintManager.getInstance().setMasterRouteOnly();
Broker broker = jdbcTemplate.queryForObject(
        "select id, uname, broker_id brokerId, create_time createTime, deleted from broker where id = 26",
        Broker.class);
System.out.println(broker.toString());

// 删
jdbcTemplate.update("delete from broker where id = ?", 26);
posted @ 2019-12-13 11:17  慢慢行  阅读(370)  评论(0)    收藏  举报