accountdaoimpl.java

来自「自己做的关于spring框架的使用」· Java 代码 · 共 21 行

package myspring.v3.ts;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.support.JdbcDaoSupport;

public class AccountDaoImpl extends JdbcDaoSupport implements AccountDao {

	//付款，即从对应帐户中扣除金额
	public boolean pay(int accountId, float sum) {
		// TODO Auto-generated method stub
		String sql = "update account set balance = balance - ? where id=?";
		JdbcTemplate jt = getJdbcTemplate();
		if (jt.update(sql, new Object[]{sum, accountId,}) == 1){
			return true;
		} else {
			return false;
		}
	}

}