JAVAEE框架学习——Spring——整合JDBC|JAVAEE框架学习——Spring——整合JDBC aop中的事物 JAVAEE框架学习——Spring——整

Spring整合JDBC Spring中提供了一个可以操作数据库的对象，封装了JDBC技术 JDBCTemplate => JDBC模板对象
与DBUtils中的QueryRunner非常相似

//准备连接池 ComboPooledDataSource dataSource = new ComboPooledDataSource(); dataSource.setDriverClass("com.mysql.jdbc.Driver"); dataSource.setJdbcUrl("jdbc:mysql://103.249.130.173:3306/hibernate_crm?useUnicode=true& characterEncoding=UTF8"); dataSource.setUser("appUser"); dataSource.setPassword("AA1122BB"); //创建JDBC模板对象 JdbcTemplate jt = new JdbcTemplate(); jt.setDataSource(dataSource); //书写sql语句并执行 String sql = "insert into t_user values(null,'rose')"; jt.update(sql);

Spring整合Dao 数据库步骤
1 导包

4+2 spring包
spring-test、spring-aop、junit4类库
c3p0连接池 JDBC驱动
spring-jdbc spring-tx事务

2 准备数据库

JAVAEE框架学习——Spring——整合JDBC|JAVAEE框架学习——Spring——整合JDBC aop中的事物

文章图片
数据库书写Dao

public interface TUserDao { //增 void save(TUser user); //删除 void delete(Integer id); //改 void update(TUser user); //查 TUser getById(Integer id); int getTotalCount(); List getAllTUser(); }

书写实现类impl

public class TUserDaoImpl implements TUserDao { private JdbcTemplate jt; @Override public void save(TUser user) { String sql = "insert into t_user values(null,?)"; jt.update(sql, user.getName()); }@Override public void delete(Integer id) { String sql = "delete from t_user where id = ?"; jt.update(sql, id); }@Override public void update(TUser user) { String sql = "update t_user set name = ? where id =?"; jt.update(sql, user.getName(), user.getId()); }@Override public TUser getById(Integer id) { String sql = "select * from t_user where id = ?"; TUser tUser = jt.queryForObject(sql, new RowMapper() { @Override public TUser mapRow(ResultSet resultSet, int i) throws SQLException { TUser tUser = new TUser(); tUser.setId(resultSet.getInt("id")); tUser.setName(resultSet.getString("name")); return tUser; } }, id); return tUser; }@Override public int getTotalCount() { String sql = "select count(*) from t_user"; Integer count = jt.queryForObject(sql, Integer.class); return count; }@Override public List getAllTUser() { String sql = "select * from t_user"; List query = jt.query(sql, new RowMapper() { @Override public TUser mapRow(ResultSet resultSet, int i) throws SQLException { TUser tUser = new TUser(); tUser.setId(resultSet.getInt("id")); tUser.setName(resultSet.getString("name")); return tUser; } }); return query; }public JdbcTemplate getJt() { return jt; }public void setJt(JdbcTemplate jt) { this.jt = jt; } }

实现配置

进阶内容 JDBCDaoSupport
JDBCDapSupport根据连接池创建JDBC模板
不需要手动准备JDBC模板，从父类方法中获得即可