这里有java/golang的示例，可以参考下
# 悲观事务
connection.createStatement().executeUpdate(txnComment + "begin pessimistic");
# 乐观事务
connection.createStatement().executeUpdate(txnComment + "begin optimistic");
https://docs.pingcap.com/zh/tidb/stable/dev-guide-optimistic-and-pessimistic-transaction#悲观事务