/** 更具通知ID得到通知属性 */ public Notic getNotic(int j) throws ManagerException { Notic notic = new Notic(); DBUtil db = new DBUtil(); String sql = "select a.*,b.user_name from TD_SD_NOTIC a,td_sm_user b " + "where a.notic_planner_id = b.user_id and NOTIC_ID=" + j + ""; try { db.executeSelect(sql); for (int i = 0; i < db.size(); i++) { notic.setBeginTime(db.getDate(i, "begintime")); notic.setEndTime(db.getDate(i, "endtime")); notic.setContent(db.getString(i, "content")); notic.setExecutorID(db.getInt(i, "executor_id")); notic.setPlace(db.getString(i, "place")); notic.setNoticPlannerName(db.getString(i, "user_nasme")); notic.setStatus(db.getInt(i, "status")); notic.setTopic(db.getString(i, "topic")); notic.setSource(db.getString(i, "source")); notic.setNoticPlannerID(db.getInt(i, "notic_planner_id")); return notic; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return notic; }
/** 得到通知列表 */ public ListInfo getNoticList(String sql, int offset, int maxItem) throws ManagerException { DBUtil dbUtil = new DBUtil(); try { dbUtil.executeSelect(sql, offset, maxItem); ListInfo listInfo = new ListInfo(); List list = new ArrayList(); for (int i = 0; i < dbUtil.size(); i++) { Notic notic = new Notic(); notic.setNoticID(dbUtil.getInt(i, "NOTIC_ID")); notic.setBeginTime(dbUtil.getDate(i, "begintime")); notic.setEndTime(dbUtil.getDate(i, "endtime")); notic.setContent(dbUtil.getString(i, "content")); notic.setPlace(dbUtil.getString(i, "place")); notic.setExecutorID(dbUtil.getInt(i, "executor_id")); notic.setNoticPlannerName(dbUtil.getString(i, "user_name")); notic.setNoticPlannerRealName(dbUtil.getString(i, "user_realname")); notic.setSource(dbUtil.getString(i, "source")); notic.setStatus(dbUtil.getInt(i, "status")); notic.setTopic(dbUtil.getString(i, "topic")); list.add(notic); } listInfo.setDatas(list); listInfo.setTotalSize(dbUtil.getTotalSize()); return listInfo; } catch (SQLException e) { e.printStackTrace(); throw new ManagerException(e.getMessage()); } }