/** * ����Ʒ��Ϣ * * @param members */ public boolean UpdateIsSendMsg(String memberId) { boolean b = false; try { dbHelper = DBFactory.CreateDatabase(); memberLevelDAO = new MemberLevelDAO(dbHelper, memberLevel); b = memberLevelDAO.UpdateIsSendMsg(memberId); } catch (Exception e) { dbHelper.close(); } finally { dbHelper.close(); } return b; }
public boolean Save(FileUploadLog fileupload) { boolean b = false; try { dbHelper = DBFactory.CreateDatabase(); dao = new FileUploadLogDAO(dbHelper, fileupload); b = dao.Save(); } catch (Exception e) { dbHelper.close(); e.printStackTrace(); } finally { dbHelper.close(); } return b; }
public List<FileUploadLog> QueryFileMgrByName(String name, int oid) { List<FileUploadLog> ilist = new ArrayList<FileUploadLog>(); try { dbHelper = DBFactory.CreateDatabase(); dao = new FileUploadLogDAO(dbHelper); ilist = (List) dao.QueryByName(name, oid); } catch (Exception e) { e.printStackTrace(); dbHelper.close(); } finally { dbHelper.close(); } return ilist; }
/** * @param memberId * @return * @throws Exception */ public Smstext GetReturnMsg(String memberId) throws Exception { Smstext sms = null; try { dbHelper = DBFactory.CreateDatabase(); memberLevelDAO = new MemberLevelDAO(dbHelper, memberLevel); sms = memberLevelDAO.GetReturnMsg(memberId); dbHelper.close(); } catch (Exception e) { dbHelper.close(); } finally { dbHelper.close(); } return sms; }
public boolean Clear(int filemgrid) { boolean b = false; try { dbHelper = DBFactory.CreateDatabase(); dao = new FileUploadLogDAO(dbHelper); dbHelper.beginTransaction(); b = dao.Clear(filemgrid); dbHelper.commitTransaction(); } catch (Exception e) { e.printStackTrace(); dbHelper.close(); } finally { dbHelper.close(); } return b; }
/** @return */ public List<Smstext> queryReduceMmberMsg() { List<Smstext> smstextList = null; try { dbHelper = DBFactory.CreateDatabase(); memberLevelDAO = new MemberLevelDAO(dbHelper, memberLevel); smstextList = (List) memberLevelDAO.QueryReduceMmberMsg(); dbHelper.close(); } catch (Exception e) { dbHelper.close(); } finally { dbHelper.close(); } return smstextList; }
/** @return */ public List<MemberLevel> findByWhereSQL() { try { dbHelper = DBFactory.CreateDatabase(); memberLevelDAO = new MemberLevelDAO(dbHelper, memberLevel); memberLevelDAO.setSqlWhere(getSqlWhere()); memberLevelDAO.setSqlOrder(getSqlOrder()); memberLevelList = (List) memberLevelDAO.findByWhereSQL(); dbHelper.close(); } catch (Exception e) { dbHelper.close(); } finally { dbHelper.close(); } return memberLevelList; }
/** @return */ public MemberLevel findByMemberId(String memberId) { MemberLevel level = null; try { dbHelper = DBFactory.CreateDatabase(); memberLevelDAO = new MemberLevelDAO(dbHelper, memberLevel); memberLevelDAO.setSqlWhere(" and memberId='" + memberId + "'"); memberLevelList = (List) memberLevelDAO.findByWhereSQL(); if (memberLevelList != null && memberLevelList.size() > 0) { level = memberLevelList.get(0); } dbHelper.close(); } catch (Exception e) { dbHelper.close(); } finally { dbHelper.close(); } return level; }