JavaWeb企业云资源管理系统实验

**

数据库设计

**
1.用户表

2.图片存储路径表

3.用户留言表

4.上传文件存储表

5.发布日志信息表

核心代码

1.项目结构

2.添加过滤器验证登录

public void doFilter(ServletRequest arg0, ServletResponse arg1, FilterChain chain)
			throws IOException, ServletException {
		// TODO 自动生成的方法存根
		HttpServletRequest request=(HttpServletRequest) arg0;//获取request
		HttpServletResponse response=(HttpServletResponse) arg1;//获取response
		HttpSession session=request.getSession();//获取session
		int attribute=-1;
		attribute = (Integer) session.getAttribute("a");
		if(attribute>0) {
			chain.doFilter(request, response);
		}else
			response.sendRedirect("login.html");
	}

3.用户登录

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
		String name = request.getParameter("uname");
		String pwd = request.getParameter("upwd");
		BlogServiceImpl service = new BlogServiceImpl();
		int id = service.queryYonghu();
		Yonghu yonghu = new Yonghu(id,name,pwd);
		int result = service.quaryYonghu(yonghu);
		if(result>0) {
			HttpSession session = request.getSession();
			session.setAttribute("a", 1);
			session.setAttribute("name", name);
			request.getRequestDispatcher("IndexJump").forward(request, response);
		}else
			request.getRequestDispatcher("login.html").forward(request, response);
	}

4.发布日志

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html; charset=UTF-8");
		boolean isMultipart = ServletFileUpload.isMultipartContent(request);
		if(isMultipart) {
			Date date=new Date();
			SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
			String s= format.format(date);
			String title="0";
			String message="0";
			String rPath="0";
			FileItemFactory factory=new DiskFileItemFactory();
			ServletFileUpload upload = new ServletFileUpload(factory);
			try {
				List<FileItem> item = upload.parseRequest(request);
				Iterator<FileItem> itor = item.iterator();
				System.out.println(itor.toString());
				while(itor.hasNext()) {
					FileItem next = itor.next();
					String name = next.getFieldName();
					if(next.isFormField())//判断是否是表单字段
					{
						if(name.equals("title")) {
							title=next.getString("utf-8");
						}else if(name.equals("neirong")) {
							message=next.getString("utf-8");
						}
					}
					else {//获取文件名
						//制定上传路径
						if(next.getSize()!=0) {
							String fileName = next.getName();
	//						String realPath = request.getSession().getServletContext().getRealPath("photo");
							String realPath = "D:\\blog";
							File file = new File(realPath, fileName);
							next.write(file);//上传
							rPath="/image/"+fileName;
						}
					}
				}
			} catch (FileUploadException e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			} catch (Exception e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			}
			Rizhi rizhi = new Rizhi(s, title, message, rPath);
			IBlogService service = new BlogServiceImpl();
			int result = service.SaveRizhiService(rizhi);
			if(result>0) {
				request.getRequestDispatcher("WenzhangServlet?page=0").forward(request, response);
			}
		}
	}

5.用户留言

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub}
		request.setCharacterEncoding("UTF-8");
		response.setCharacterEncoding("UTF-8");
		response.setContentType("text/html; charset=UTF-8");
		String name=request.getParameter("namen");
		String email=request.getParameter("emailn");
		String context=request.getParameter("messagen");
		
		IBlogService blogservice = new BlogServiceImpl();
		int queryPage = blogservice.queryPage();
		int id = queryPage + 1;
		People people=new People(id,name,email,context);
		int rs = blogservice.AddPeopleService(people);
		
		PrintWriter out = response.getWriter();
		if(rs>0) {
			out.write("true");;
		}
	}

6.上传文件

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		request.setCharacterEncoding("utf-8");
		response.setCharacterEncoding("utf-8");
		response.setContentType("text/html; charset=UTF-8");
		boolean isMultipart = ServletFileUpload.isMultipartContent(request);
		if(isMultipart) {
			String rpath="0";
			String name="0";
			try {
			FileItemFactory factory=new DiskFileItemFactory();
			ServletFileUpload upload = new ServletFileUpload(factory);
			List<FileItem> item = upload.parseRequest(request);
			Iterator<FileItem> itor = item.iterator();
			while(itor.hasNext()) {
				FileItem next = itor.next();//获取item中的内容
				if(next.isFormField()) {//判断是否为表单字段
					
				}else {
					name = next.getName();
					String realPath = "D:\\blog\\file";
					File file = new File(realPath, name);
					next.write(file);//上传
					rpath="/file/"+name;
				}
				IBlogService blogservice= new BlogServiceImpl();
				int id = blogservice.queryWenjian();
				Date date = new Date();
				SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
				String format = simpleDateFormat.format(date);
				Wenjian wenjian = new Wenjian(id,format,name, rpath);
				int result = blogservice.addWenjian(wenjian);
				if(result>0) {
					request.getRequestDispatcher("AllWenjianServlet").forward(request, response);
				}else
				{
					request.getRequestDispatcher("AllWenjianServlet").forward(request, response);
				}
			}
			} catch (FileUploadException e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			} catch (Exception e) {
				// TODO 自动生成的 catch 块
				e.printStackTrace();
			}
		}
	}