@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); }