Java源码社

基于javaweb的JSP+Servlet新闻发布管理系统(java+jsp+servlet+mysql)

更新于

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

后台：管理新闻类型、新闻、评论、链接

前台：看新闻、评论

540123112502

后台

470123112502

480123112502

490123112502

500123112502

520123112502

530123112502

前台

430123112502

440123112502

450123112502

460123112502

技术框架

JSP Servlet MySQL JDBC Tomcat jQuery Bootstrap JavaScript

基于javaweb的JSP+Servlet新闻发布管理系统(java+jsp+servlet+mysql)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
		this.newsTypeDelete(request, response);
	}
	
}


private void newsTypePreSave(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	String newsTypeId=request.getParameter("newsTypeId");
	Connection con=null;
	try{
		con=dbUtil.getCon();
		if(StringUtil.isNotEmpty(newsTypeId)){
			NewsType newsType=newsTypeDao.getNewsTypeById(con, newsTypeId);
			request.setAttribute("newsType", newsType);
		}
		
		if(StringUtil.isNotEmpty(newsTypeId)){
			request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别修改"));
		}else{
			request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别添加"));
		}
		request.setAttribute("mainPage", "/background/newsType/newsTypeSave.jsp");
		request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		try {
			dbUtil.closeCon(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

private void newsTypeSave(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	Connection con=null;
	String newsTypeId=request.getParameter("newsTypeId");
	String typeName=request.getParameter("typeName");
	
	NewsType newsType=new NewsType(typeName);
	
	if(StringUtil.isNotEmpty(newsTypeId)){
		newsType.setNewsTypeId(Integer.parseInt(newsTypeId));
	}
	try{
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
}
package com.demo.web;



public class ImageUploadServlet extends HttpServlet {

    /**
     *
     */
    private static final long serialVersionUID = 1L;

    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        this.doPost(request, response);
    }

    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        response.setContentType("text/html;charset=UTF-8");
        request.setCharacterEncoding("UTF-8");
        response.setCharacterEncoding("UTF-8");
        PrintWriter out = response.getWriter();
        FileItemFactory factory = new DiskFileItemFactory();
        ServletFileUpload upload = new ServletFileUpload(factory);

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
		}
	}
	
	private void newsDelete(HttpServletRequest request,
			HttpServletResponse response) throws ServletException, IOException{
		String newsId=request.getParameter("newsId");
		Connection con=null;
		boolean delFlag;
		try{
			con=dbUtil.getCon();
			int delNums=newsDao.newsDelete(con, newsId);
			if(delNums==1){
				delFlag=true;
			}else{
				delFlag=false;
			}
			ResponseUtil.write(delFlag, response);
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			try {
				dbUtil.closeCon(con);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
}
package com.demo.web;





public class NewsTypeServlet extends HttpServlet{

	/**
	 * 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
			dbUtil.closeCon(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}


private void newsTypeBackList(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	Connection con=null;
	try{
		con=dbUtil.getCon();
		List<NewsType> newsTypeBackList=newsTypeDao.newsTypeList(con);
		request.setAttribute("newsTypeBackList", newsTypeBackList);
		request.setAttribute("navCode", NavUtil.genNewsManageNavigation("新闻类别管理", "新闻类别维护"));
		request.setAttribute("mainPage", "/background/newsType/newsTypeList.jsp");
		request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		try {
			dbUtil.closeCon(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
}

private void newsTypeDelete(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	String newsTypeId=request.getParameter("newsTypeId");
	Connection con=null;
	try{
		con=dbUtil.getCon();
		JSONObject result=new JSONObject();
		boolean exist=newsDao.existNewsWithNewsTypeId(con, newsTypeId);
		if(exist){
			result.put("errorMsg", "该新闻类别下有新闻，不能删除此新闻类别");
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
		commentSave(request,response);
	}else if("backList".equals(action)){
		commentBackList(request,response);
	}else if("delete".equals(action)){
		commentDelete(request,response);
	}
	
}

private void commentSave(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	String newsId=request.getParameter("newsId");
	String content=request.getParameter("content");
	String userIP=request.getRemoteAddr();
	Comment comment=new Comment(Integer.parseInt(newsId), content, userIP);
	Connection con=null;
	try{
		con=dbUtil.getCon();
		commentDao.commentAdd(con, comment);
		request.getRequestDispatcher("news?action=show&newsId="+newsId).forward(request, response);
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		try {
			dbUtil.closeCon(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

private void commentBackList(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	String s_bCommentDate=request.getParameter("s_bCommentDate");
	String s_aCommentDate=request.getParameter("s_aCommentDate");
	String page=request.getParameter("page");
	HttpSession session=request.getSession();
	if(StringUtil.isEmpty(page)){
		page="1";
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
protected void doGet(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	this.doPost(request, response);
}

@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	request.setCharacterEncoding("utf-8");
	String action=request.getParameter("action");
	if("login".equals(action)){
		login(request,response);
	}else if("logout".equals(action)){
		logout(request,response);
	}
	
}

private void login(HttpServletRequest request, HttpServletResponse response)
		throws ServletException, IOException {
	String userName=request.getParameter("userName");
	String password=request.getParameter("password");
	
	HttpSession session=request.getSession();
	Connection con=null;
	try{
		con=dbUtil.getCon();
		User user=new User(userName,password);
		User currentUser=userDao.login(con, user);
		if(currentUser==null){
			request.setAttribute("error", "用户名或者密码错误！");
			request.setAttribute("password", password);
			request.setAttribute("userName", userName);
			request.getRequestDispatcher("/background/login.jsp").forward(request, response);
		}else{
			session.setAttribute("currentUser", currentUser);
			request.setAttribute("mainPage", "/background/default.jsp");
			request.getRequestDispatcher("/background/mainTemp.jsp").forward(request, response);
		}
	}catch(Exception e){
		e.printStackTrace();
	}finally{
		try {
			dbUtil.closeCon(con);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}

项目链接：
https://javayms.github.io?id=222221050607102an
https://javayms.pages.dev?id=222221050607102an