public void add(NotePage notePage) { if (notePage.getObid() == null || notePage.getObid().trim().equals("")) { notePage.setObid(UUID.randomUUID().toString()); } NoteEntity t = new NoteEntity(); BeanUtils.copyProperties(notePage, t); noteEntityDao.save(t); }
private String addWhere(NotePage notePage, String hql, List<Object> values) { // 循环查询条件Page的所有[Integer][String]类型的字段,如果字段不为空则动态加上查询条件 // ----------------------------------------------------- StringBuffer hqlbf = new StringBuffer(hql); NoteEntity noteEntity = new NoteEntity(); BeanUtils.copyProperties(notePage, noteEntity); SearchSqlGenerateUtil.createSearchParamsHql(hqlbf, values, noteEntity); hql = hqlbf.toString(); // ----------------------------------------------------- if (notePage.getCcreatedatetimeStart() != null) { hql += " and createDt>=? "; values.add(notePage.getCcreatedatetimeStart()); } if (notePage.getCcreatedatetimeEnd() != null) { hql += " and createDt<=? "; values.add(notePage.getCcreatedatetimeEnd()); } if (notePage.getCmodifydatetimeStart() != null) { hql += " and modifyDt>=? "; values.add(notePage.getCmodifydatetimeStart()); } if (notePage.getCmodifydatetimeEnd() != null) { hql += " and modifyDt<=? "; values.add(notePage.getCmodifydatetimeEnd()); } return hql; }
private List<NoteEntity> find(NotePage notePage) { String hql = "from NoteEntity t where 1=1 "; List<Object> values = new ArrayList<Object>(); hql = addWhere(notePage, hql, values); if (notePage.getSort() != null && notePage.getOrder() != null) { hql += " order by " + notePage.getSort() + " " + notePage.getOrder(); } return noteEntityDao.find(hql, notePage.getPage(), notePage.getRows(), values); }
public NoteEntity get(NotePage notePage) { return noteEntityDao.get(NoteEntity.class, notePage.getObid()); }
public void update(NotePage notePage) throws Exception { NoteEntity t = noteEntityDao.get(NoteEntity.class, notePage.getObid()); if (t != null) { MyBeanUtils.copyBeanNotNull2Bean(notePage, t); } }