DELIMITER // DROP TRIGGER IF EXISTS TRG_UPDATE_ACCOUNT // CREATE TRIGGER TRG_UPDATE_ACCOUNT AFTER INSERT ON _record FOR EACH ROW BEGIN UPDATE _account SET balance=balance+NEW.*NEW.money WHERE userid=NEW.userid AND account=NEW.account; END; // DELIMITER ;
DELIMITER $$ CREATE TRIGGER TRG_UPDATE_ACCOUNT AFTER INSERT ON _record FOR EACH ROW BEGIN UPDATE _account SET balance=balance+NEW.*NEW.money WHERE userid=NEW.userid AND account=NEW.account; END; $$ DELIMITER ;
DROP TRIGGER IF EXISTS TRG_UPDATE_ACCOUNT //
CREATE TRIGGER TRG_UPDATE_ACCOUNT AFTER INSERT ON _record FOR EACH ROW
BEGIN
UPDATE _account SET balance=balance+NEW.*NEW.money WHERE userid=NEW.userid AND account=NEW.account;
END;
//
DELIMITER ;
CREATE TRIGGER TRG_UPDATE_ACCOUNT AFTER INSERT ON _record FOR EACH ROW
BEGIN
UPDATE _account SET balance=balance+NEW.*NEW.money WHERE userid=NEW.userid AND account=NEW.account;
END;
$$
DELIMITER ;
DELIMITER $$
无关紧要,还可以很多 DELIMITER ## , DELIMITER ||
public void add(Record r) {
Connection conn = DB.createConn();
String sql = "insert into _record values (null, ?, ?, ?, ?, ?, ?, ?, now())";
PreparedStatement ps = DB.prepare(conn, sql);
try {
ps.setInt(1, r.getUserid());
ps.setFloat(2, r.getMoney());
ps.setString(3, r.getAccount());
ps.setString(4, r.getType());
ps.setInt(5, r.getMark());
ps.setString(6, r.getDate());
ps.setString(7, r.getRe());
ps.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
}
DB.close(ps);
DB.close(conn);
}