create database jdbcdemo02;
use jdbcdemo02;
create table account(
id int primary key auto_increment,
name varchar(20),
money double
);
insert into account values (null,'aaa',10000);
insert into account values (null,'bbb',10000);
insert into account values (null,'ccc',10000);
public static void transferAccounts() {
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = JDBCUtil.getConn();
/*
* 完成转账的代码;
* 扣除一个账号的钱
* 给另一个账号价钱
* */
String sql ="update account set money = money + ? where name = ?";
pstmt = conn.prepareStatement(sql);
pstmt.setDouble(1, 100);
pstmt.setString(2, "aaa");
int i = pstmt.executeUpdate();
int a =