spring jdbctemplate基本的增删改查

@Autowired
@Qualifier("caseJdbcTemplate")
private JdbcTemplate jdbcTemplate;

/**
 * 添加
 * @param caseCaseVideo
 * @return
 */
@Override
public int saveVideo(CaseCaseVideo caseCaseVideo) {
    String uuid = UUID.randomUUID().toString().replaceAll("-", "").toLowerCase();
    String sql = "insert into t_case_case_video (cvid,case_id,case_stage,start_time,end_time,video_desc) values (?,?,?,?,?,?)";
    return jdbcTemplate.update(sql, uuid,caseCaseVideo.getCaseId(),caseCaseVideo.getCaseStage(),caseCaseVideo.getStartTime(),caseCaseVideo.getEndTime(),caseCaseVideo.getVideoDesc());
}

/**
 * 删除
 * @param cvid
 * @return
 */
@Override
public int deleteCaseCaseVideo(String cvid) {
    String sql="delete from t_case_case_video  where cvid=?";
    return jdbcTemplate.update(sql,cvid);
}

/**
 * 修改
 * @param caseCaseVideo
 * @return
 */
@Override
public int updateCaseCaseVideo(CaseCaseVideo caseCaseVideo) {
    String sql = "update t_case_case_video  set case_id=?,case_stage=?,start_time=?,end_time=?,video_desc=? where cvid=?";
    return jdbcTemplate.update(sql,  new Object[]{caseCaseVideo.getCaseId(),caseCaseVideo.getCaseStage(),caseCaseVideo.getStartTime(),caseCaseVideo.getEndTime(),caseCaseVideo.getVideoDesc(),caseCaseVideo.getCvid()});
}

/**根据ID查询vid详情
 * @param cvid
 * @return
 */
@Override
public  CaseCaseVideo getCaseCaseVideo(String cvid) {
    String sql = "select * from t_case_case_video  where cvid = ? ";
    CaseCaseVideo caseVideo = jdbcTemplate.queryForObject(sql, new CaseCaseVideoRowMapper(),cvid);
    return caseVideo;
}

/**
 * 列表
 * @return
 */
@Override
public List<CaseCaseVideo> queryCaseCaseVideo(int startNum, int endNum) {
    StringBuffer  stringBuffer = new StringBuffer("select * from t_case_case_video  where 1 = 1");
    stringBuffer.append(" limit "+startNum+","+endNum);
    String sql = stringBuffer.toString();
    List<CaseCaseVideo> list = jdbcTemplate.query(sql, new CaseCaseVideoRowMapper());
    return list;
}

/**
 * 查询总记录数
 * @return
 */
@Override
public int countCaseCaseVideo() {
    StringBuffer stringBuffer = new StringBuffer("select count(*) from t_case_case_video  where 1 = 1");
    String sql = stringBuffer.toString();
    return jdbcTemplate.queryForObject(sql, Integer.class);
}