Spring Jdbc -- 使用最少的代码和配置完成你的项目。
Spring Jdbc的接口比较丰富,其中大部分接口都由内部消化了,我们只需要关注少量接口即可。
JdbcOperations 和 NamedParameterJdbcOperations
对应的实现类:
JdbcTemplate 和 NamedParameterJdbcTemplate
Spring Jdbc 的核心接口和实现,其他的接口几乎都是给这两个接口提供服务的。提供了非常方便的数据库操作方法,包括CRUD、函数与存过调用、批量处理等。
RowMapper
实现该接口可以非常方便的对结果集进行处理,常用的实现为 BeanPropertyRowMapper。
SqlParameterSource
实现该接口可以非常方便地绑定参数值到SQL的命名参数上,常用的实现为 BeanPropertySqlParameterSource。
BeanPropertyRowMapper
根据类的属性名把结果集转换成业务对象,支持属性名和下划线风格的列名。
BeanPropertySqlParameterSource
根据对象实例属性名转换成SQL中的命名参数,自动绑定参数值为实例的属性值。
BeanPropertyRowMapper 和 BeanPropertySqlParameterSource 类都使用了反射机制,在反射时都使用了缓存机制,完全不需要担心高并发和高频率下的性能问题。
Spring Jdbc 与 MyBatis 比较:
各新建一个完全相同的实体类 Employeer
Spring Jdbc 的CRUD实现:
编码长度:1400字
涉及文件:接口、实现
进化版:高封装、CRUD的SQL根据反射生成、增删字段后无须修改
public class EmployeerDao {
/*省略JdbcOperations注入*/
public Employeer findEmployeerById(String employeerId) {
String sql = "select * from `employeer` where employeer_id = ?";
return this.getJdbcOperations().update(sql, BeanPropertyRowMapper.newInstance(Employeer.class),employeerId);
}
public boolean addEmployeer(Employeer employeer) {
String sql = "insert into `employeer`(employeer_id,employeer_name,employeer_age,employeer_department,employeer_worktype) " +
" values(:employeerId,:employeerName,:employeerAge,:employeerDepartment,:employeerWorktype)";
return this.getNamedParamOperations().update(sql, new BeanPropertySqlParameterSource(employeer)) > 0;
}
public boolean deleteEmployeer(String employeerId) {
String sql = "delete from `employeer` where employeer_id = ?";
return this.getJdbcOperations().update(sql, employeerId) > 0;
}
public boolean updateEmployeer(Employeer employeer) {
String sql = "update employeer set employeer_name = :employeerName,employeer_age= :employeerAge,employeer_department = employeerDepartment " +
",employeer_worktype= :employeerWorktype where employeer_id = :employeerId";
return this.getNamedParamOperations().update(sql, new BeanPropertySqlParameterSource(employeer)) > 0;
}
}
MyBatis 的CRUD实现:
编码长度:3000字
涉及文件:接口、实现、配置文件
进化版:接口注解(但不能使用功能丰富的标签了),增删字段后须要修改
<mapper namespace="com.mucfc.model.EmployeerMapper">
<!-- 查找 -->
<select id="findEmployeerByID" parameterType="int" resultType="Employeer">
select* from `employeer` where employeer_id =#{employeer_id}
</select>
<!-- 插入 -->
<insert id="addEmployeer" parameterType="Employeer">
insert into `employeer`(employeer_id,employeer_name,employeer_age,employeer_department,employeer_worktype)
values(#{employeer_id},#{employeer_name},#{employeer_age},#{employeer_department},#{employeer_worktype})
</insert>
<!-- 删除 -->
<delete id="deleteEmployeer" parameterType="int">
delete from `employeer` where employeer_id = #{employeer_id}
</delete>
<!-- 修改 -->
<update id="updateEmployeer" parameterType="Employeer">
update employeer set employeer_name = #{employeer_name},employeer_age= #{employeer_age},employeer_department = #{employeer_department}
,employeer_worktype=#{employeer_worktype} where employeer_id = #{employeer_id}
</update>
</mapper>
public class EmployeerDao {
/*省略sqlSessionFactory注入*/
/**
* 查找
*/
public Employeer findEmployeerById(int id) {
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
return (Employeer) session.selectOne(
"com.mucfc.model.EmployeerMapper.findEmployeerByID", 1);
} finally {
session.close();
}
}
/**
* 增加
*/
public boolean addEmployeer(Employeer employeer){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
boolean result = session.insert("com.mucfc.model.EmployeerMapper.addEmployeer", employeer ) > 0;
session.commit() ;
return result;
} finally {
session.close();
}
}
/**
* 删除
*
*/
public boolean deleteEmployeer(int id){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
boolean result = session.delete("com.mucfc.model.EmployeerMapper.deleteEmployeer",id) > 0;
session.commit() ;
return result;
} finally {
session.close();
}
}
/**
* 更改
*/
public boolean updateEmployeer(Employeer employeer){
SqlSession session = null;
try {
session = sqlSessionFactory.openSession();
boolean result = session.update("com.mucfc.model.EmployeerMapper.updateEmployeer",employeer) > 0;
session.commit() ;
return result;
} finally {
session.close();
}
}
}
经过比较,Spring Jdbc 的开发效率比 MyBatis 要高出不少,可配合 Spring Cache、Transacation、Bean使用。