查询公告

//服务器端获取notice

public ArrayList<NoticeBean> getNotice(String id) {
		// id转成整型
		// int _id = Integer.parseInt(id);
		// 查询a.gradeid如果是1则返回普通,否则返回紧急
		ArrayList<NoticeBean> list = new ArrayList<NoticeBean>();
		String str = "select case a.gradeid when 1 then '0' else '1' end, a.content, a.starttime, a.endtime, a.publishtime  from ec_affiche a, ec_posaffiche b where a.state=0 and a.id=b.afficheid  and b.resourceid=?";
		PreparedStatement pstmt;

		ResultSet rest;
		DBUtil db = new DBUtil();
		Connection con = db.getConnectionInformix();
		if (con != null) {
			try {
				pstmt = con.prepareStatement(str);
				pstmt.setString(1, id);
				rest = pstmt.executeQuery();
				//				
				while (rest.next()) {
					NoticeBean _notice = new NoticeBean();
					_notice.set_type(StringUtils.getChinese(rest.getString(1)));
					_notice.set_content(StringUtils.getChinese(rest
							.getString(2)));
					_notice.set_startTime(rest.getString(3));
					_notice.set_endTime(rest.getString(4));
					_notice.set_publishTime(rest.getString(5));
					list.add(_notice);
				}
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		return list;
	}

根据id查询公告

/**
	 * 根据id查询公告
	 * 
	 * @param id
	 * @return
	 */
	public ArrayList<NoticeBean> getNotice(String id) {
		// id转成整型
		// int _id = Integer.parseInt(id);
		// 查询a.gradeid如果是1则返回普通,否则返回紧急
		ArrayList<NoticeBean> list = new ArrayList<NoticeBean>();
		String str = "select case a.gradeid when 1 then '0' else '1' end, a.content, a.starttime, a.endtime, a.publishtime  from ec_affiche a, ec_posaffiche b where a.state=0 and a.id=b.afficheid  and b.resourceid=?";
		PreparedStatement pstmt;

		ResultSet rest;
		DBUtil db = new DBUtil();
		Connection con = db.getConnectionInformix();
		if (con != null) {
			try {
				pstmt = con.prepareStatement(str);
				pstmt.setString(1, id);
				rest = pstmt.executeQuery();
				//				
				while (rest.next()) {
					NoticeBean _notice = new NoticeBean();
					_notice.set_type(StringUtils.getChinese(rest.getString(1)));
					_notice.set_content(StringUtils.getChinese(rest
							.getString(2)));
					_notice.set_startTime(rest.getString(3));
					_notice.set_endTime(rest.getString(4));
					_notice.set_publishTime(rest.getString(5));
					list.add(_notice);
				}
			} catch (Exception e) {
				// TODO: handle exception
			}
		}
		return list;
	}