JSP+SQL微博系统(毕业设计)

package weibo.servlet; import java.io.IOException; import java.io.PrintWriter; import java.sql.SQLException; import java.util.List; import javax.servlet.RequestDispatcher; 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 weibo.dao.ArticleDAO; import weibo.valuebean.articleBean; public class ArticleServlet extends HttpServlet { private static final long serialVersionUID = 922978702076462486L; public ArticleServlet() { super(); } public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); String action = (String) request.getParameter("action"); if (action == null) { out.println("出错了！"); } else if (action.equals("addart")) { try { addart(request, response); } catch (SQLException e) { e.printStackTrace(); } }else if (action.equals("getallart")) { try { getallart(request, response); } catch (SQLException e) { e.printStackTrace(); } }else if (action.equals("getfrendart")) { try { getfrendart(request, response); } catch (SQLException e) { e.printStackTrace(); } } } /** * 发布微博 * @param request * @param response * @throws ServletException * @throws IOException * @throws SQLException */ private void addart(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException, SQLException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); String textarea = request.getParameter("textarea"); String user=(String) request.getSession(true).getAttribute("user"); ArticleDAO art=new ArticleDAO(); boolean b=art.addariticle(user,textarea); if(b){ //out.print("发布微博成功"); // RequestDispatcher rd=request.getRequestDispatcher("../mypage.jsp"); //rd.forward(request,response); response.sendRedirect("../mypage.jsp"); }else{ out.print("发布微博失败！"); } } /** * 获取指定用户的所有微博集合 * @param request * @param response * @throws ServletException * @throws IOException * @throws SQLException */ private void getallart(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException, SQLException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); String user=(String) request.getSession(true).getAttribute("user"); ArticleDAO art=new ArticleDAO(); List<articleBean> artlist=art.getallart(user); request.setAttribute("artlist",artlist); RequestDispatcher rd=request.getRequestDispatcher("../mypage.jsp"); rd.forward(request,response); } /** * 获取指定好友的所有微博集合 * @param request * @param response * @throws ServletException * @throws IOException * @throws SQLException */ private void getfrendart(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException, SQLException { request.setCharacterEncoding("UTF-8"); response.setCharacterEncoding("UTF-8"); response.setContentType("text/html; charset=UTF-8"); PrintWriter out = response.getWriter(); String username=request.getParameter("username"); ArticleDAO art=new ArticleDAO(); List<articleBean> frendartlist=art.getallart(username); request.setAttribute("frendartlist",frendartlist); RequestDispatcher rd=request.getRequestDispatcher("../frenweibo.jsp"); rd.forward(request,response); } public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException { doPost(request,response); } public void init() throws ServletException { } }