h2 jbdc

// @Transactional(readOnly = false, propagation = Propagation.REQUIRED)
// public void saveDimension(Dimension dimension) {
// dimension.setObjectId(UUID.randomUUID().toString());
// try {
// jdbcTemplate.update("insert into db_dimension values(?, ?, ?, ?, ?)", new Object[]{ConvertUtil.inCode(dimension.getObjectId()), ConvertUtil.inCode(dimension.getDimensionName()), ConvertUtil.inCode(dimension.getDimensionDescription()), ConvertUtil.inCode(dimension.getCreateTime()), ConvertUtil.inCode(dimension.getUpdateTime())});
// } catch (Exception e) {
// e.printStackTrace();
// }
// }
//
// @Transactional(readOnly = false, propagation = Propagation.REQUIRED)
// public void updateDimension(Dimension dimension) {
// try {
// jdbcTemplate.update("update db_dimension set dimensionname=?, dimensiondescription=?, createtime=?, updatetime=? where objectid=?", new Object[]{ConvertUtil.inCode(dimension.getDimensionName()), ConvertUtil.inCode(dimension.getDimensionDescription()), ConvertUtil.inCode(dimension.getCreateTime()), ConvertUtil.inCode(dimension.getUpdateTime()), ConvertUtil.inCode(dimension.getObjectId())});
// } catch (Exception e) {
// e.printStackTrace();
// }
// }
//
// @Transactional(readOnly = false, propagation = Propagation.REQUIRED)
// public void delete(String objectId) {
// jdbcTemplate.update("delete from db_dimension where objectid=?", new Object[]{ConvertUtil.inCode(objectId)});
// jdbcTemplate.update("delete from db_dimensionitem where dimension_id=?", new Object[]{ConvertUtil.inCode(objectId)});
// jdbcTemplate.update("delete from db_table_dimensionitem where dimension_id=?", new Object[]{ConvertUtil.inCode(objectId)});
// }
//
// public Dimension findByKey(String objectId) {
// String query = QUERY_STR + "where a.objectid=?";
// SqlRowSet srs = jdbcTemplate.queryForRowSet(query, new Object[]{ConvertUtil.inCode(objectId)});
// List dimensionList = fillDimension(srs);
// if (dimensionList.size() != 0) {
// return (Dimension)dimensionList.get(0);
// } else {
// return null;
// }
// }
//
public List<Dimension> findAll() {
try {
String query = QUERY_STR + "order by a.createtime";
SqlRowSet srs = jdbcTemplate.queryForRowSet(query);
return fillDimension(srs);
} catch (Exception ex) {
ex.printStackTrace();
return null;
}
}
//
// private List<Dimension> fillDimension(SqlRowSet srs) {
// List<Dimension> dimensionList = new ArrayList<Dimension>();
// if (srs != null) {
// while (srs.next()) {
// Dimension dimension = new Dimension();
// dimension.setObjectId(ConvertUtil.outCode(srs.getString(1)));
// dimension.setDimensionName(ConvertUtil.outCode(srs.getString(2)));
// dimension.setDimensionDescription(ConvertUtil.outCode(srs.getString(3)));
// dimension.setCreateTime(ConvertUtil.outCode(srs.getString(4)));
// dimension.setUpdateTime(ConvertUtil.outCode(srs.getString(5)));
// dimensionList.add(dimension);
// }
// }
// return dimensionList;
// }