记jsp+servlet+jdbc实现的新闻管理系统

最新推荐文章于 2024-01-16 19:46:50 发布

Charry.H

最新推荐文章于 2024-01-16 19:46:50 发布

阅读量6.5k

点赞数 12

分类专栏： Java Web

本文链接：https://blog.csdn.net/weixin_42635052/article/details/104239585

版权

1.工具：eclipse+SQLyog
2.介绍：实现的内容就是显示新闻的基本信息，然后一个增删改查和分页的操作。
3.数据库表设计

列名	中文名称	数据类型	长度	非空
newsId	文章ID	int	11	√
newsTitle	文章标题	varchar	20	√
newsContent	文章内容	text
newsStatus	是否审核	varchar	10
newsType	文章类型	varchar	20
createtime	创建时间	varchar	20

news表(newsId为主键) 4.冗余代码比较多，后期再来修改。
5.功能实现:

主页

在这里插入图片描述

添加页

在这里插入图片描述

修改页

6.代码:
News.java

package com.entity;

/*
 * 新闻表
 */
public class News {
   

	private Integer newsId;
	private String newsTitle;
	private String newsContent;
	private String newsStatus;
	private String newsType;
	private String createTime;

	public Integer getNewsId() {
   
		return newsId;
	}

	public void setNewsId(Integer newsId) {
   
		this.newsId = newsId;
	}

	public String getNewsTitle() {
   
		return newsTitle;
	}

	public void setNewsTitle(String newsTitle) {
   
		this.newsTitle = newsTitle;
	}

	public String getNewsContent() {
   
		return newsContent;
	}

	public void setNewsContent(String newsContent) {
   
		this.newsContent = newsContent;
	}

	public String getNewsStatus() {
   
		return newsStatus;
	}

	public void setNewsStatus(String newsStatus) {
   
		this.newsStatus = newsStatus;
	}

	public String getNewsType() {
   
		return newsType;
	}

	public void setNewsType(String newsType) {
   
		this.newsType = newsType;
	}

	public String getCreateTime() {
   
		return createTime;
	}

	public void setCreateTime(String createTime) {
   
		this.createTime = createTime;
	}

	@Override
	public String toString() {
   
		return "News [newsId=" + newsId + ", newsTitle=" + newsTitle + ", newsContent=" + newsContent + ", newsStatus="
				+ newsStatus + ", newsType=" + newsType + ", createTime=" + createTime + "]";
	}

	public News(Integer newsId, String newsTitle, String newsContent, String newsStatus, String newsType,
			String createTime) {
   
		this.newsId = newsId;
		this.newsTitle = newsTitle;
		this.newsContent = newsContent;
		this.newsStatus = newsStatus;
		this.newsType = newsType;
		this.createTime = createTime;
	}

	public News() {
   

	}

}

index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>新闻主页</title>
</head>
<script type="text/javascript">
	location.href="NewsServlet";
</script>
<body>
</body>
</html>

NewsServlet.java

package com.servlet;

import java.io.IOException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dao.NewsDao;
import com.entity.News;

@WebServlet("/NewsServlet")
public class NewsServlet extends HttpServlet {
   
	private static final long serialVersionUID = 1L;

	private NewsDao newsDao;

	@Override
	public void init() throws ServletException {
   
		newsDao = new NewsDao();
	}

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

	protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
   
		request.setCharacterEncoding("utf-8");
		response.setContentType("text/html;charset=utf-8");
		String oprate = request.getParameter("oprate");
		// 如果该次请求是添加新闻
		if ("addNews".equals(oprate)) {
   
			String newsTitle = request.getParameter("newsTitle");
			String newsType = request.getParameter("newsType");
			String newsContent = request.getParameter("newsContent");
			int row = newsDao.addNews(newsTitle, newsType, newsContent);
			response.sendRedirect("NewsServlet");
			
		} else if("delete".equals(oprate)) {
   
			Integer id = Integer.valueOf(request.getParameter("id"));
		    int row = newsDao.deleteNewsById(id);
		    response.sendRedirect("NewsServlet");
		} else if("allDelete".equals(oprate)) {
   
			String[] deleteId = request.getParameterValues("deleteId");
			for (String string : deleteId) {
   
				Integer did = Integer.valueOf(string);
				//循环一次删一次
				newsDao.deleteNewsById(did);
			}
			response.sendRedirect("NewsServlet");
		} else if("allPass".equals

最低0.47元/天解锁文章

Charry.H

关注

12
点赞
踩
67

收藏

觉得还不错? 一键收藏
9
评论
记jsp+servlet+jdbc实现的新闻管理系统

1.工具：eclipse+SQLyog2.介绍：实现的内容就是显示新闻的基本信息，然后一个增删改查的操作。3.数据库表设计列名中文名称数据类型长度非空newsId文章IDint11√newsTitle文章标题varchar20√newsContent文章内容textnewsStatus是否审核varchar10news...
复制链接

扫一扫