spring jdbc 数据持久层操作实现代码

@Repository(value = "deptDao")
public class DeptDaoImpl implements DeptDao {
    @Resource
    private JdbcTemplate jdbcTemplate;

    /**
     * 添加系别
     * @param dept
     * @return
     */
    @Override
    public int addDept(Dept dept) {
        String sql = "insert into tb_dept(dept_id, dept_name) value (?,?)";
        Object[] obj = {dept.getDeptId(),dept.getdeptName()};
        int rows = jdbcTemplate.update(sql,obj);
        return rows;
    }

    /**
     * 更新系别
     * @param dept
     * @return
     */
    @Override
    public int updateDept(Dept dept) {
        String sql = "update tb_dept set dept_name=? where dept_id=? ";
        Object[] obj = {dept.getdeptName(),dept.getDeptId()};
        int rows = jdbcTemplate.update(sql,obj);
        return rows;
    }

    /**
     * 删除系别
     * @param id
     * @return
     */
    @Override
    public int deleteDeptById(int id) {
        String sql = "delete from tb_dept where dept_id=?";
        Object[] obj = {id};
        int rows = jdbcTemplate.update(sql,obj);
        return rows;
    }

    /**
     * 查询系别 返回实体类
     * @param id
     * @return
     */
    @Override
    public Dept finDeptById(int id) {
        String sql = "select * from tb_dept where dept_id=?";
        RowMapper<Dept> rowMapper = new BeanPropertyRowMapper<>(Dept.class);
        return  jdbcTemplate.queryForObject(sql,rowMapper,id);
    }

    /**
     * 查询dept 列表
     * @return
     */
    @Override
    public List<Dept> findAllDept() {
        String sql = "select * from tb_dept";
        RowMapper<Dept> rowMapper = new BeanPropertyRowMapper<>(Dept.class);
        return jdbcTemplate.query(sql,rowMapper);
    }
}