用两个不同的stmt试试:
stmt1.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + fromBalance + " WHERE AccountNumber =" + myAccountNumber); //(1)
stmt2.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + toBalance + " WHERE AccountNumber =" + myTranferAccountNumber);//(2)
stmt1.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + fromBalance + " WHERE AccountNumber =" + myAccountNumber); //(1)
stmt2.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + toBalance + " WHERE AccountNumber =" + myTranferAccountNumber);//(2)
stmt.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + fromBalance + " WHERE AccountNumber =" + myAccountNumber); //(1) stmt.executeUpdate("UPDATE AccountInfo" + " SET Balance =" + toBalance + " WHERE AccountNumber =" + myTranferAccountNumber);//(2)PreparedStatement pstmt=con.prepareStatement("update AccountInfo set Balance=? where AccountNumber=?");//(3)
pstmt.setInt(1,toBalance);//(4)
pstmt.setInt(2,myTranferAccountNumber);//(5)
pstmt.executeUpdate();//(6)
pstmt.close();//(7)
却可以拉,不知为何?按理说(3)-(7)句等效于(2)句的????
忘了说句谢谢,着里补上!!!!!!!!!!!