public void list(HttpServletRequest request) throws Exception
{
String sql = "select *from gongji order by chk desc , id desc";
PreparedStatement pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
ArrayList<GongjiDto> glist = new ArrayList<GongjiDto>();
while(rs.next())
{
GongjiDto gdto = new GongjiDto();
gdto.setId(rs.getInt("id"));
gdto.setTitle(rs.getString("title"));
gdto.setWriteday(rs.getString("writeday"));
gdto.setReadnum(rs.getInt("readnum"));
gdto.setChk(rs.getInt("chk"));
glist.add(gdto);
}
request.setAttribute("glist", glist);
}
<%@ page import="java.util.ArrayList" %>
<%
GongjiDao gdao = new GongjiDao();
gdao.list(request);
ArrayList<GongjiDto> glist=(ArrayList<GongjiDto>)request.getAttribute("glist");
%>
<%
for(int i=0;i<glist.size();i++)
{
String imsi="";
if(glist.get(i).getChk()==1)
imsi="<b style='color:red;'>[중요]</b>";
%>
<tr>
<td><a href="readnum.jsp?id=<%=glist.get(i).getId()%>"> <%=imsi%> <%=glist.get(i).getTitle()%> </a></td>
<td align="center">관리자</td>
<td align="center"><%=glist.get(i).getReadnum()%></td>
<td align="center"><%=glist.get(i).getWriteday()%></td>
</tr>
<%
}
%>
<%
// 관리자만 공지사항 쓰기가 보이게
if(session.getAttribute("userid")!=null)
{
if(session.getAttribute("userid").equals("admin"))
{
%>
<tr>
<td colspan="4" align="center">
<a href="write.jsp">공지사항 글쓰기</a>
</td>
</tr>
<%
}
}
%>
</table>