//服务器端获取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;
}