0eeee840f25eac229297728c85bb64dc69b4f54b.svn-base 753 B

12345678910111213141516171819202122232425262728
  1. package com.sinosoft.em.alert.notice.manage.dao;
  2. import com.persistence.service.JDBCHelper;
  3. import com.persistence.service.exception.PersistenceException;
  4. /**
  5. * 通知单管理dao实现类
  6. * @author zhuanghuiliang
  7. * @date 2015-09-15
  8. */
  9. public class NoticeDaoImpl implements NoticeDaoAble{
  10. /**
  11. * 改变预警通知单状态
  12. *
  13. * @param jdbc
  14. * @param fd_id 主键id
  15. * @param state 状态值
  16. * @return
  17. * @throws PersistenceException
  18. */
  19. @Override
  20. public int changeState(JDBCHelper jdbc, String fd_id,String state) throws PersistenceException {
  21. // TODO Auto-generated method stub
  22. String sql = "update ECM_EM_PUBLISH_ALERT_NOTICE set state='"+state+"' where fd_objectid='"+fd_id+"'";
  23. return jdbc.executeUpdateSQL(sql);
  24. }
  25. }