?? queryalldo.java
字號(hào):
package com.lovo.servlet;
import java.io.IOException;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.lovo.bo.BlockBO;
import com.lovo.factory.BOFactory;
import com.lovo.po.AreaPO;
import com.lovo.po.BlockPO;
import com.lovo.po.PublishPO;
import com.lovo.po.UserPO;
import com.lovo.util.Page;
public class QueryAllDO extends HttpServlet {
protected void doGet(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
this.doPost(request, response);
}
protected void doPost(HttpServletRequest request,
HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
response.setCharacterEncoding("utf-8");
RequestDispatcher rd = null;
ServletContext application = this.getServletContext();
HttpSession session = request.getSession(true);
Boolean isLogSuc = (Boolean) session.getAttribute("isLogSuc");
if (isLogSuc != null) {
rd = request.getRequestDispatcher("web/jsp/homeindex.jsp");
} else {
rd = request.getRequestDispatcher("web/login.jsp");
}
if(isLogSuc == null) {
UserPO user = new UserPO();
user.setName("visitor");
session.setAttribute("user", user);
}
this.TheNewestPublish(session);
this.theWealthUser(session);
this.allArea(session);
this.newFiveReg(session);
this.onLine(session, application);
this.onLineReg(session, application);
// 最新精華帖
try {
PublishPO theNewestDigestPublish = BOFactory.getPublishBOInstance().queryByDigestdate();
if(theNewestDigestPublish == null) {
theNewestDigestPublish = new PublishPO();
theNewestDigestPublish.setTitle("暫時(shí)沒有精華貼");
}
session.setAttribute("theNewestDigestPublish", theNewestDigestPublish);
} catch (SQLException e) {
e.printStackTrace();
session.setAttribute("errorInfo", "查找最新精華貼出錯(cuò)");
response.sendRedirect("web/error.jsp");
return;
}
// 最新推薦貼
try {
PublishPO theNewestRecommendPublish = BOFactory.getPublishBOInstance().queryByRecomendate();
if(theNewestRecommendPublish == null) {
theNewestRecommendPublish = new PublishPO();
theNewestRecommendPublish.setTitle("暫時(shí)沒有推薦貼");
}
session.setAttribute("theNewestRecommendPublish", theNewestRecommendPublish);
} catch (SQLException e) {
e.printStackTrace();
session.setAttribute("errorInfo", "查找最新推薦貼出錯(cuò)");
response.sendRedirect("web/error.jsp");
return;
}
rd.forward(request, response);
}
public void newFiveReg(HttpSession session) {
// 最近注冊(cè)的五位會(huì)員
List<UserPO> newRegUserList = BOFactory.getUserBOInstance()
.queryUserByRegisterTime();
List<UserPO> newestFiveRegUserList = new ArrayList<UserPO>();
if (newRegUserList.size() < 5) {
for (int i = 0; i < newRegUserList.size(); i++) {
newestFiveRegUserList.add(newRegUserList.get(i));
}
} else {
for (int i = 0; i <= 4; i++) {
newestFiveRegUserList.add(newRegUserList.get(i));
}
}
session.setAttribute("fiveNewReg", newestFiveRegUserList);
}
public void theWealthUser(HttpSession session) {
// 最富有的五位會(huì)員
Page page = new Page();
page.setCurrPage(1);
List<UserPO> wealthUserList = BOFactory.getUserBOInstance()
.queryUserByWealth(page);
List<UserPO> fiveWealthList = new ArrayList<UserPO>();
if (wealthUserList.size() < 5) {
for (int i = 0; i < wealthUserList.size(); i++) {
fiveWealthList.add(wealthUserList.get(i));
}
} else {
for (int i = 0; i <= 4; i++) {
fiveWealthList.add(wealthUserList.get(i));
}
}
session.setAttribute("fiveWealth", fiveWealthList);
}
public void TheNewestPublish(HttpSession session) {
// 最新的五個(gè)帖子
List<PublishPO> newPubList = BOFactory.getPublishBOInstance()
.queryByPublishDate();
List<PublishPO> newFivePubList = new ArrayList<PublishPO>();
if (newPubList.size() < 5) {
for (int i = 0; i < newPubList.size(); i++) {
newFivePubList.add(newPubList.get(i));
}
} else {
for (int i = 0; i <= 4; i++) {
newFivePubList.add(newPubList.get(i));
}
}
session.setAttribute("newFivePubList", newFivePubList);
// 最新的帖子
PublishPO theNewestPublish = new PublishPO();
if (newPubList.size() == 0) {
theNewestPublish.setTitle("暫時(shí)沒有新帖");
} else {
theNewestPublish = newPubList.get(0);
}
session.setAttribute("theNewestPublish", theNewestPublish);
}
public void allArea(HttpSession session) {
// 所有的區(qū)域 //所有區(qū)域下的版塊
List<AreaPO> allAreaList = BOFactory.getAreaBOInstance().queryArea();
BlockBO blockBO = BOFactory.getBlockBOInstance();
for (int i = 0; i < allAreaList.size(); i++) {
AreaPO area = allAreaList.get(i);
List<BlockPO> blockList = blockBO.queryBlockByArea(area.getId());
area.setBlockList(blockList);
List<UserPO> areaAdminList = BOFactory.getUserBOInstance().queryAreaAdmin(area.getId());
area.setAreaAdminList(areaAdminList);
}
session.setAttribute("allAreaList", allAreaList);
}
public void onLine(HttpSession session, ServletContext application) {
int onLineNum = 0;
int onLineNumApp = 0;//存在application里的session的個(gè)數(shù)
int onLineNumSes = 0;//session的個(gè)數(shù)
Integer onLineApp = (Integer) application.getAttribute("onLineNum");
if(onLineApp == null) {
onLineNum = ((Integer) session.getAttribute("onLineNum")).intValue();
} else {
onLineNumSes = ((Integer) session.getAttribute("onLineNum")).intValue();
onLineNumApp = ((Integer) application.getAttribute("onLineNum")).intValue();
if(onLineNumSes > onLineNumApp) {
onLineNum = onLineNumSes;
} else {
onLineNum = onLineNumApp;
}
}
application.setAttribute("onLineNum", onLineNum);
}
public void onLineReg(HttpSession session, ServletContext application) {
// 在線人數(shù)多少是注冊(cè)用戶
List<UserPO> userRegList = (List)application.getAttribute("userRegList");
if(userRegList == null) {
userRegList = new ArrayList<UserPO>();
}
UserPO userReg = (UserPO) session.getAttribute("user");
boolean isAdd = ((Boolean)session.getAttribute("isAdd")).booleanValue();
if (!userReg.getName(). equals("visitor") &&!isAdd ) {
userRegList.add(userReg);
isAdd = true;
session.setAttribute("isAdd", isAdd);
}
application.setAttribute("userRegList", userRegList);
int regNum = userRegList.size();
session.setAttribute("regNum", regNum);
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -