JDBC总结4中,我们的查询依然是放在每个DAO中,而不是DBHelp类中,这样还是不够简化的!下面简化一下:
在util包中建立一个接口:
package com.hanchao.util;
import java.sql.ResultSet;
import java.sql.SQLException;
/***********************
* @author:han
* @version:1.0
* @created:2015-10-11
***********************
*/
public interface RowMapper {
public Object mapRow(ResultSet rs) throws SQLException;
}
3.在dao包中,package com.hanchao.dao;
import java.util.List;
import com.hanchao.entity.Account;
import com.hanchao.util.DBHelp;
/***********************
* @author:han
* @version:1.0
* @created:2015-10-11
***********************
*/
public class AccountDao {
private DBHelp dbHelp = new DBHelp();
/**
* 保存
* *******************
* @param accout
* @return
* *******************
* @author:wind
* 2015-10-11 下午9:31:28
* *******************
*/
public int save(Account accout) {
String sql = "insert into t_account(username,password,money,enable) value(?,?,?,?)";
return dbHelp.executeSQL(sql, accout.getUsername(),accout.getMoney(),accout.getMoney(),accout.isEnable());
}
/**
* update
* *******************
* @param account
* @return
* *******************
* @author:wind
* 2015-10-11 下午9:37:53
* *******************
*/
public int update(Account account) {
String sql = "update t_account set username=?,password=?,money=?,enable=? where id = ?";
return dbHelp.executeSQL(sql, account.getUsername(),account.getPassword(),account.getMoney(),account.isEnable(),account.getId());
}
/**
* detele
* *******************
* @param id
* @return
* *******************
* @author:wi