以下实验仅在MYSQL 5.0.45做的实验.
方法1:用mysql命令锁住表.
publicvoidtest() {
String sql ="lock tables aa1 write";
// 或String sql = "lock tables aa1 read";
// 如果想锁多个表 lock tables aa1 read ,aa2 write , .....
String sql1 ="select * from aa1 ";
String sql2 ="unlock tables";
try{
this.pstmt = conn.prepareStatement(sql);
this.pstmt1 = conn.prepareStatement(sql1);
this.pstmt2 = conn.prepareStatement(sql2);
pstmt.executeQuery();
pstmt1.executeQuery();
pstmt2.executeQuery();
}catch(Exception e) {
System.out.println("异常"+ e.getMessage());
}
}public void test() {
String sql = "lock tables aa1 write";
// 或String sql = "lock tables aa1 read";
// 如果想锁多个表 lock tabl