jdbcTemplate

1.导入依赖

        
            mysql
            mysql-connector-java
            5.1.47
        
        
            com.alibaba
            druid
            1.0.15
        
        
            org.springframework
            spring-jdbc
            5.0.8.RELEASE
        
        
            org.springframework
            spring-tx
            5.0.8.RELEASE
        
    

2.配置数据库连接信息

jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/db
jdbc.username = root
jdbc.password = 123456

3.配置数据源和jdbcTemplate

4.编写UserDao接口

public interface UserDao {
    public int insert(User user);
    public int update(User user);
    public int delete(User user);
    public int selectCount();
    public User selectOne(int id);
    public List selectAll();
}

5.编写UserDaoImpl接口实现类

@Repository
public class UserDaoImpl implements UserDao {
    @Autowired
    private JdbcTemplate jdbcTemplate;
    //插入操作
    public int insert(User user) {
        return jdbcTemplate.update("insert into tbl_user values(?, ?, ?)", user.getId(), user.getName(), user.getAge());
    }
    //修改操作
    public int update(User user) {
        return jdbcTemplate.update("update tbl_user set name = ?, age = ? where id = ?",user.getName(),user.getAge(),user.getId());
    }
    //删除操作
    public int delete(User user) {
        return jdbcTemplate.update("delete from tbl_user where id = ?",user.getId());
    }
    //查询值
    public int selectCount() {
        return jdbcTemplate.queryForObject("select count(*) from tbl_user",Integer.class);
    }
    //查询对象
    public User selectOne(int id) {
        return jdbcTemplate.queryForObject("select * from tbl_user where id = ?",new BeanPropertyRowMapper(User.class),id);
    }
    //查询集合
    public List selectAll() {
        return jdbcTemplate.query("select * from tbl_user",new BeanPropertyRowMapper(User.class));
    }
}