日期:2014-05-17 浏览次数:21057 次
<%
List<Content> list = DBshowContent.show();
User user = (User)session.getAttribute("user");
String username = user.getUsername();
%>
public static List<Content> show(){
connect();
String sql = "select * from content order by content_id desc";
try {
PreparedStatement psmt = conn.prepareStatement(sql);
ResultSet set = psmt.executeQuery();
while(set.next()){
Content content = new Content();
content.setContent_id(set.getInt(1));
content.setUsername(set.getString(2));
content.setTitle(set.getString(3));
content.setContent(set.getString(4));
content.setDate(set.getString(5));
content.setCount(set.getInt(6));
list.add(content);
}
psmt.close();
set.close();
} catch (SQLException e) {
e.printStackTrace();
}
return list;
}req.setAttribute("list",list);
req.setAttribute("content",content);
resp.sendRedirect("review.jsp");