java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction

Question

每次执行都报错，提示的错误位置还不一定
for(...){
...
Connection conn = null;

Statement stmt = null;

...
stmt = conn.createStatement();

int n=stmt.executeUpdate("update 表1 set ... where ...");
stmt.executeUpdate("delete from 表2 where...");
stmt.executeUpdate("update 表2,表3 set ... where  ...");
stmt.executeUpdate("update 表2 set ... where ...");
while(){
....
rs = stmt.executeQuery(sql.toString());
...
rs = stmt.executeQuery(sql.toString());
...
}
}

Answer 1

Connection 和statement要在for循环之前创建， 如： Connection conn=getConnection();          stmt =  conn.createStatement();    for(.......){.................}