spring架构下的数据访问层编写

创建抽象接口

public interface TestDao {
	// 增
	public void insertUser(Map userMap);
	// 查
	public List<Map> queryUser(Map userMap);
	// 删
	public void deleteUser(Map userMap);
	// 改
	public void updateUser(Map userMap);
}

对应的实现类

public class TestDaoImpl implements TestDao {
	@Override
	public void insertUser(Map userMap) {
		ContextUtil.getSqlMap("sqlMap").insert("user.insertUser", userMap);
	}
	
	public void deleteUser(Map userMap) {
		ContextUtil.getSqlMap("sqlMap").delete("user.deleteUser", userMap);
	}

	public void updateUser(Map userMap) {
		ContextUtil.getSqlMap("sqlMap").update("user.deleteUser", userMap);
	}

	public List<Map> queryUser(Map userMap) {
		return ContextUtil.getSqlMap("sqlMap").queryForList("user.queryUser", userMap);
	}
}