public MessageDetailsVO getMessageById(long id) throws Exception { SqlSession session = ConnectionFactory.getSession().openSession(); MessageDetailsDAO dao = session.getMapper(MessageDetailsDAO.class); MessageDetailsVO messageDetailsVO = dao.getMessageById(id); session.close(); return messageDetailsVO; }
public List<MessageDetailsVO> getMessages() throws Exception { SqlSession session = ConnectionFactory.getSession().openSession(); MessageDetailsDAO dao = session.getMapper(MessageDetailsDAO.class); List<MessageDetailsVO> users = dao.getAllMessages(); session.close(); return users; }
public int deleteMessage(MessageDetailsVO vo) throws Exception { SqlSession session = ConnectionFactory.getSession().openSession(); MessageDetailsDAO dao = session.getMapper(MessageDetailsDAO.class); int cnt = dao.doDeleteMessage(vo); session.commit(); session.close(); return cnt; }
public MessageDetailsVO updateMessage(MessageDetailsVO vo) throws Exception { SqlSession session = ConnectionFactory.getSession().openSession(); MessageDetailsDAO dao = session.getMapper(MessageDetailsDAO.class); dao.doUpdateMessage(vo); session.commit(); session.close(); return vo; }