模拟Spring的JdbcTemplate实现DAO

通常情况下,普通DAO的实现大概是这样的:

 

1、实体类:

public class Emp {
	private Integer id;
	private String name;
	private String sex;
	private Float sal;
                //getter and setter methods...
}

 2、DAO接口:

public interface EmpDAO {
	public int insert(Emp emp)throws SQLException;
	public int delete(Emp emp)throws SQLException;
	public int update(Emp emp)throws SQLException;
	public Emp findById(Emp emp)throws SQLException;
	public String findName(Emp emp)throws SQLException;
}

 

3、DAO实现类:

public class EmpDAOImpl implements EmpDAO {
	public int delete(Emp emp) throws SQLException {
		String sql = "delete from emp where id=?";
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setInt(1, emp.getId());
			return ps.executeUpdate();
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(null, ps, conn);
		}
	}
	public Emp findById(Emp emp) throws SQLException {
		String sql = "select id,name,sal,sex from emp where id=?";
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		Emp currEmp = null;

		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setInt(1, emp.getId());
			rs = ps.executeQuery();
			if (rs.next()) {
				currEmp = new Emp();
				currEmp.setId(rs.getInt("id"));
				currEmp.setName(rs.getString("name"));
				currEmp.setSal(rs.getFloat("sal"));
				currEmp.setSex(rs.getString("sex"));
			}
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(rs, ps, conn);
		}
		return currEmp;
	}
	public String findName(Emp emp) throws SQLException {
		String sql = "select name from emp where id=?";
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		String name = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setInt(1, emp.getId());
			rs = ps.executeQuery();
			if (rs.next()) {
				name = rs.getString("name");
			}
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(rs, ps, conn);
		}
		return name;

	}
	public int insert(Emp emp) throws SQLException {
		String sql = "insert into emp(name,sal,sex) values(?,?,?)";
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, emp.getName());
			ps.setFloat(2, emp.getSal());
			ps.setString(3, emp.getSex());
			return ps.executeUpdate();
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(null, ps, conn);
		}
	}
	public int update(Emp emp) throws SQLException {
		String sql = "update emp set name=?,sal=?,sex=? where id=?";
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			ps.setString(1, emp.getName());
			ps.setFloat(2, emp.getSal());
			ps.setString(3, emp.getSex());
			ps.setInt(4, emp.getId());
			return ps.executeUpdate();
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(null, ps, conn);
		}
	}
}

 

以下是改造后的实现方式:

 

1、实体类同上

2、接口同上

3、用于处理查询结果的接口:

public interface RowMapper {
	public Object mapperRow(ResultSet rs)throws SQLException;
}

 

4、模拟JdbcTemplate类

public class JdbcTemplate {
	public int update(String sql, Object[] args) throws SQLException {
		Connection conn = null;
		PreparedStatement ps = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			for (int i = 0; i < args.length; i++) {
				ps.setObject(i + 1, args[i]);
			}
			return ps.executeUpdate();
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(null, ps, conn);
		}
	}
	public Object find(String sql, Object[] args, RowMapper rowMapper)
			throws SQLException {
		Connection conn = null;
		PreparedStatement ps = null;
		ResultSet rs = null;
		Object obj = null;
		try {
			conn = DBUtil.getConnection();
			ps = conn.prepareStatement(sql);
			for (int i = 0; i < args.length; i++) {
				ps.setObject(i + 1, args[i]);
			}
			rs = ps.executeQuery();
			if (rs.next()) {
				obj = rowMapper.mapperRow(rs);
			}
		} catch (SQLException e) {
			throw e;
		} finally {
			DBUtil.close(rs, ps, conn);
		}
		return obj;
	}

 5、DAO实现类:

public class EmpDAOJdbcTemplateImpl implements EmpDAO {
	private JdbcTemplate jdbcTemplate = new JdbcTemplate();
	public int delete(Emp emp) throws SQLException {
		String sql = "delete from emp where id=?";
		Object[] args = new Object[] { emp.getId() };
		return jdbcTemplate.update(sql, args);
	}
	public Emp findById(Emp emp) throws SQLException {
		String sql = "select id,name,sal,sex from emp where id=?";
		Object[] args = new Object[] { emp.getId() };
		Object obj = jdbcTemplate.find(sql, args, new RowMapper() {
			@Override
			public Object mapperRow(ResultSet rs) throws SQLException {
				Emp emp = new Emp();
				emp.setId(rs.getInt("id"));
				emp.setName(rs.getString("name"));
				emp.setSal(rs.getFloat("sal"));
				emp.setSex(rs.getString("sex"));
				return emp;
			}
		});
		return (Emp) obj;
	}
	public String findName(Emp emp) throws SQLException {
		String sql = "select name from emp where id=?";
		Object[] args = new Object[] { emp.getId() };
		Object obj = jdbcTemplate.find(sql, args, new RowMapper() {
			@Override
			public Object mapperRow(ResultSet rs) throws SQLException {
				return rs.getString("name");
			}
		});
		return (String) obj;

	}
	public int insert(Emp emp) throws SQLException {
		String sql = "insert into emp(name,sal,sex) values(?,?,?)";
		Object[] args = new Object[] { emp.getName(), emp.getSal(),
				emp.getSex() };
		return jdbcTemplate.update(sql, args);

	}
	public int update(Emp emp) throws SQLException {
		String sql = "update emp set name=?,sal=?,sex=? where id=?";
		Object[] args = new Object[] { emp.getName(), emp.getSal(),
				emp.getSex(), emp.getId() };
		return jdbcTemplate.update(sql, args);
	}

}

 

为什么我们要使用通用DAO接口呢,因为我们的数据库操作无非是增删改查,CRUD操作,我们不需要为每个实体去编写一个dao接口,对于相似的实体操作可以只编写一个通用接口,然后采用不同的实现DAO已经成为持久层的标准模式,DAO使结构清晰,面向接口编程为代码提供了规范。而泛型DAO是一个类型安全的,代码精简的设计模式(相对于传统DAO),尤其在DAO组件数量庞大的时候,代码量的减少更加明显。 泛型DAO的核心是定义一个GenericDao接口,声明基本的CRUD操作: 用hibernate作为持久化解决方案的GenericHibernateDao实现类,被定义为抽象类,它提取了CRUD操作,这就是简化代码的关键,以便于更好的重用,这个就不给例子了,增删改都好写,查就需要各种条件了。 然后是各个领域对象的dao接口,这些dao接口都继承GenericDao接口,这样各个领域对象的dao接口就和传统dao接口具有一样的功能了。 下一步是实现类了,个自领域对象去实现各自的接口,还要集成上面的抽象类,这样就实现了代码复用的最大化,实现类中只需要写出额外的查询操作就可以了。当然还要获得域对象的Class实例,这就要在构造方法中传入Class实例。用spring提供的HibernateTemplate注入到GenericHibernateDao中,这样在各个实现类就可以直接调用HibernateTemplate来实现额外的查询操作了。 如果在实现类中不想调用某个方法(例如:update()),就可以覆盖它,方法中抛出UnsupportedOperationException()异常。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值