javaweb新闻管理系统03

一麟yl

已于 2022-04-07 00:12:50 修改

阅读量1.5k

点赞数 4

文章标签： web eclipse java

于 2022-03-31 23:44:58 首次发布

本文链接：https://blog.csdn.net/m0_67376124/article/details/123886613

版权

数据库更新

一，主页(实现模糊功能)index.jsp

二，实现评论功能

1增加评论(doAddPl.jsp)

2.删除评论(doDelPl.jsp)

三，阅读界面(点击量的实现)read.jsp

四，实现主页中的类别管理界面(show.jsp)

数据库更新

--评论表
CREATE TABLE T_COMMENT(
       COMMENT_ID NUMBER PRIMARY KEY,--评论编号
       COMMENT_FROM NUMBER NOT NULL,--评论来源
       COMMENT_PUBLISHER VARCHAR2(20) NOT NULL,--评论发布时间
       COMMENT_AUTHOR VARCHAR2(20) NOT NULL,--评论作者
       COMMENT_CONTENT VARCHAR2(255) --评论内容
)

项目完整的文件目录

一，主页(实现模糊功能)index.jsp

效果图如下：

代码展示：

<%@page import="java.nio.charset.StandardCharsets"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%
/**
*新闻主页
*/
%>

<!DOCTYPE html>
<html lang="zh">

<head>
<meta charset="UTF-8">
<title>bootstrap</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet"
	href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css">
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
<style>
* {
	outline: none !important;
}

body, html {
	background: #7f8d90;
}

nav, .breadcrumb {
	border-radius: 0px !important;
	margin-bottom: 0px !important;
}

.breadcrumb {
	margin-bottom: 20px !important;
	background: #36485c;
	color: white;
}

li h4 {
	width: 300px;
	overflow: hidden;
	text-overflow: ellipsis;
	white-space: nowrap;
}

.breadcrumb .active {
	color: yellow;
}
</style>
</head>

<body>
	<nav class="navbar navbar-default hidden-sm hidden-xs">
		<div class="container-fluid">
			<div class="navbar-header">
				<a class="navbar-brand" href="index.jsp" style="font-size: 25px;">🐖</a>
			</div>
			<ul class="nav navbar-nav">
				<li class="dropdown"><a class="dropdown-toggle"
					data-toggle="dropdown"> 新闻管理 <span class="caret"></span>
				</a>
					<ul class="dropdown-menu">
						<li><a href="${pageContext.request.contextPath}/news/add.jsp">新闻发布</a></li>
						<li class="divider"></li>
						<li><a href="${pageContext.request.contextPath}/news/show.jsp">类别管理</a></li>
					</ul></li>
			</ul>
			<ul class="nav navbar-nav navbar-right">
				<li><a><%=request.getParameter("name")%>></a></li>
				<li><a href="${pageContext.request.contextPath}/login.jsp">退出<span class="glyphicon glyphicon-off"></span></a></li>
			</ul>
		</div>
	</nav>

	<ol class="breadcrumb">
		<li>您当前的位置是</li>
		<li>新闻发布系统</li>
		<li class="active">首页</li>
	</ol>

	<form class="form-inline" style="margin: 0px auto 20px;">
		<div class="form-group" style="display: block; text-align: center;">
			<div class="input-group">
				<div class="input-group-addon">新闻标题</div>
				<input type="text" name="newName" class="form-control" placeholder="请在此输入搜索的关键字">
				<span class="input-group-btn">
					<button type="submit" class="btn btn-primary">搜索🔍</button>
				</span>
			</div>
		</div>
	</form>

	<div class="container">
		<ul class="list-group">
			<%
			//点击表单后应该在页面上携带newname用来充当查询的关键字
			String newName = request.getParameter("newName");
			if (newName == null) {
				newName = "";//进行查询所有
			}
			//拿值的时候会发现出现乱码的情况，这个时候可以将数据先变成字节的形式再变成字符的形式(破碎重组)
			
			//newName = new String(newName.getBytes(StandardCharsets.ISO_8859_1), StandardCharsets.UTF_8);
			//OracleDriver
			//加载驱动
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//连接字符串
			String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
			//获得连接
			Connection con = DriverManager.getConnection(URL, "scott", "sa123");
			//查询所有的新闻数据
			PreparedStatement ps = con.prepareStatement("select * from t_news where news_title like ?");
			ps.setString(1, "%" + newName + "%");
			//得到结果集
			ResultSet rs = ps.executeQuery();
			//遍历结果集
			while (rs.next()) {
			%>
			<li class="list-group-item">
				<h4 class="list-group-item-heading">
					<a href="${pageContext.request.contextPath}/news/read.jsp?newId=<%=rs.getInt(1)%>" data-placement="bottom" data-toggle="tooltip" href="" title="国家卫健委：昨日新增确诊病例29例，其中本土病例2例"> <%=rs.getString(2)%></a>
				</h4>
				<p class="list-group-item-text text-right">
					<span class="glyphicon glyphicon-user"><code><%=rs.getString(4)%></code></span>
					<span class="glyphicon glyphicon-eye-open"><code><%=rs.getInt(8)%></code></span>
					<span class="glyphicon glyphicon-tag"><code><%=rs.getInt(9)%></code></span>
					<span class="glyphicon glyphicon-time"><code><%=rs.getString(5)%></code></span>
				</p>
			</li>
			<%
			}
			//资源的关闭
			if (con != null && !con.isClosed()) {
			con.close();
			}
			if (ps != null) {
			ps.close();
			}
			if (rs != null) {
			rs.close();
			}
			%>
		</ul>
	</div>
	<div class="container text-center">
		<ul class="pagination" style="margin: 20px auto;">
			<li><a href="#"><span>&laquo;</span></a></li>
			<li><a href="#">1</a></li>
			<li><a href="#">2</a></li>
			<li><a href="#">3</a></li>
			<li><a href="#">4</a></li>
			<li><a href="#">5</a></li>
			<li><a href="#"><span>&raquo;</span></a></li>
		</ul>
	</div>
	<script>
		$(function() {
			$('[data-toggle="tooltip"]').tooltip({
				trigger : "hover"
			})
		})
	</script>
</body>
</html>

二，实现评论功能

1增加评论(doAddPl.jsp)

效果图：

代码如下：

<%@page import="java.util.Date"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
//接收评论的数据
String newId = request.getParameter("newId");
String author = request.getParameter("author");
String content = request.getParameter("content");
String publisher = new Date().toLocaleString();
//新闻的添加
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con = DriverManager.getConnection(url, "scott", "sa123");
//主键不能不填
//主键没有自增的选项（触发器+序列）
//获得执行对象（数据插入之前先把id主键查询出来）

PreparedStatement ps = con.prepareStatement("select nvl(max(comment_id),0) from t_comment");
ResultSet rs = ps.executeQuery();
int id = 0;
if (rs.next()) {
	id = rs.getInt(1) + 1;
}

//插入评论的操作
ps = con.prepareStatement("insert into t_comment values(?,?,?,?,?)");
//赋值
ps.setInt(1, id);
ps.setInt(2, Integer.parseInt(newId));
ps.setString(3, publisher);
ps.setString(4, author);
ps.setString(5, content);

//执行结果
int n = ps.executeUpdate();
if (n > 0) {
	//3号新闻进行评论添加
	//返回3号新闻
	out.print("<script>alert('增加成功');location.href='read.jsp?newId=" + newId + "'</script>");
} else {
	out.print("<script>alert('增加失败');history.go(-1)</script>");
}

if (con != null && !con.isClosed()) {
	con.close();
}
if (ps != null) {
	ps.close();
}
%>

2.删除评论(doDelPl.jsp)

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<%
//
//获得新闻的id

String id = request.getParameter("id");//评论id
String newId = request.getParameter("newId");//类目id
//根据id去数据库做删除操作
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con = DriverManager.getConnection(url, "scott", "sa123");
//获得执行对象（查询所有的新闻数据）
//String sql="delete from t_comment where comment_id="+id ;
PreparedStatement ps = con.prepareStatement("delete from t_comment where comment_id=?");
ps.setInt(1, Integer.parseInt(id));
//得到结果集   
//i表示受到影响的行数
int i = ps.executeUpdate();
if (i > 0) {
	//location.href='read.jsp'
	out.print("<script>alert('删除成功');location.href='read.jsp?newId=" + newId + "'</script>");
} else {
	out.print("<script>alert('删除失败');history.go(-1)</script>");
}
if (con != null && !con.isClosed()) {
	con.close();
}
if (ps != null) {
	ps.close();
}
%>

三，阅读界面(点击量的实现)read.jsp

代码：

<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Connection"%>
<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<!DOCTYPE html>
<html lang="zh">

<head>
<meta charset="UTF-8">
<title>bootstrap</title>
<meta content="width=device-width, initial-scale=1" name="viewport">
<link
	href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css"
	rel="stylesheet">
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
<style>
* {
	outline: none !important;
}

body, html {
	background: #7f8d90;
}

nav, .breadcrumb {
	border-radius: 0 !important;
	margin-bottom: 0 !important;
}

.breadcrumb {
	margin-bottom: 20px !important;
	background: #36485c;
	color: white;
}

input, select, textarea, .panel-heading {
	border: none !important;
	border-radius: 0 !important;
}

.breadcrumb .active {
	color: yellow;
}
</style>
</head>

<body>
	<nav class="navbar navbar-default hidden-sm hidden-xs">
		<div class="container-fluid">
			<div class="navbar-header">
				<a class="navbar-brand"
					href="${pageContext.request.contextPath}/news/index.jsp"
					style="font-size: 25px;">🐖</a>
			</div>
			<ul class="nav navbar-nav">
				<li class="dropdown"><a class="dropdown-toggle"
					data-toggle="dropdown"> 新闻管理 <span class="caret"></span>
				</a>
					<ul class="dropdown-menu">
						<li><a href="#">新闻发布</a></li>
						<li class="divider"></li>
						<li><a href="#">类别管理</a></li>
					</ul></li>
			</ul>
			<ul class="nav navbar-nav navbar-right">
				<li><a>245@qq.com</a></li>
				<li><a href="#">退出<span class="glyphicon glyphicon-off"></span></a></li>
			</ul>
		</div>
	</nav>

	<ol class="breadcrumb">
		<li>您当前的位置是</li>
		<li>新闻发布系统</li>
		<li class="active">新闻阅读</li>
	</ol>
	<%
	//获得新闻的id
	String newId = request.getParameter("newId");//从主页获取新闻编号
	//根据新闻id去数据库做查询操作
	//oracledriver
	//加载驱动
	Class.forName("oracle.jdbc.driver.OracleDriver");
	//定义连接字符串
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	//获得连接
	Connection con = DriverManager.getConnection(url, "scott", "sa123");
	//查询所有新闻数据
	PreparedStatement ps = con.prepareStatement("select * from T_NEWS where NEWS_ID=?");
	//设置占位符
	ps.setInt(1, Integer.parseInt(newId));
	//获得结果集
	ResultSet rs = ps.executeQuery();
	//定义初始值
	String title = "";
	int count = 0;
	String author = "";
	String publisher = "";
	String content = "";
	if (rs.next()) {
		title = rs.getString(2);
		publisher = rs.getString(5);
		author = rs.getString(4);
		content = rs.getString(6);
		count = rs.getInt(8) + 1;//指的是当前自己也阅读了一次
	}
	//已经阅读过了->修改阅读次数
	ps = con.prepareStatement("update t_news set news_count=news_count+1 where news_id=?");
	ps.setInt(1, Integer.parseInt(newId));
	ps.executeUpdate();//无需判断,无论如何都要进行下去的
	%>
	<div class="container"
		style="background: rgba(239, 231, 231, 0.9); border-radius: 10px;">
		<h1><%=title%></h1>
		<h3 class="text-right">
			<small> <span class="glyphicon glyphicon-user"><span
					class="label label-default"><%=author%></span></span> <span
				class="glyphicon glyphicon-eye-open"><span
					class="label label-default"><%=count%></span></span> <span
				class="glyphicon glyphicon-time"><span
					class="label label-info"><%=publisher%></span></span>
			</small>
		</h3>
		<samp><%=content%></samp>
		<div class="btn-group btn-group-justified"
			style="margin-bottom: 20px;">
			<div class="btn-group">
				<a
					href="${pageContext.request.contextPath}/news/doDel.jsp?newId=<%=newId%>"
					class="btn btn-danger" type="button">删除</a>
			</div>
			<div class="btn-group">
				<a
					href="${pageContext.request.contextPath}/news/upd.jsp?newId=<%=newId%>"
					class="btn btn-info" type="button">修改</a>
			</div>
		</div>
	</div>

	<div class="container"
		style="background: rgba(239, 231, 231, 0.9); border-radius: 10px; margin-top: 10px;">
		<%
		ps = con.prepareStatement("select * from t_comment where comment_from=?");
		ps.setInt(1, Integer.parseInt(newId));
		rs = ps.executeQuery();
		while (rs.next()) {
		%>
		<div class="panel panel-default" style="margin-top: 20px;">
			<div class="panel-heading">
				<span class="glyphicon glyphicon-user"><span
					class="label label-success">毛泽东</span></span>
				<p style="margin-top: 10px; text-indent: 2em;">
					<samp><%=rs.getString(5)%></samp>
				</p>
				<p class="text-right">
					<span class="glyphicon glyphicon-time"><span
						class="label label-info">2020/1/1 10:23:04</span></span>
				</p>
				<a
					href="${pageContext.request.contextPath}/news/doDelPl.jsp?newId=<%=newId%>&&id=<%=rs.getInt(1)%>"></a>

			</div>
			<%
			}
			%>

			<form action="doAddpl.jsp" class="container"
				style="background: rgba(239, 231, 231, 0.9); border-radius: 10px; margin-top: 10px; padding: 30px;">
				<input type="hidden" name="newId" value="<%=newId%>">
				<div class="form-group">
					<label for="name">Name</label> <input id="name"
						class="form-control" placeholder="用户名称" required type="text">
				</div>
				<div class="form-group">
					<label for="email">Email</label> <input id="email"
						class="form-control" placeholder="评论内容" required type="email">
				</div>
				<button class="btn btn-default" type="submit">发布评论</button>
			</form>

			<div style="height: 50px;"></div>
</body>
</html>

四，实现主页中的类别管理界面(show.jsp)

代码如下：

<%@ page import="java.sql.DriverManager"%>
<%@ page import="java.sql.PreparedStatement"%>
<%@ page import="java.sql.ResultSet"%>
<%@ page import="java.sql.Connection"%>
<%@ page contentType="text/html;charset=UTF-8" language="java"%>
<!DOCTYPE html>
<html lang="zh">

<head>
<meta charset="UTF-8">
<title>bootstrap</title>
<meta content="width=device-width, initial-scale=1" name="viewport">
<link
	href="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/css/bootstrap.css"
	rel="stylesheet">
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script
	src="${pageContext.request.contextPath}/bootstrap-3.3.7-dist/js/bootstrap.js"></script>
<style>
* {
	outline: none !important;
}

body, html {
	background: #7f8d90;
}

nav, .breadcrumb {
	border-radius: 0 !important;
	margin-bottom: 0 !important;
}

.breadcrumb {
	margin-bottom: 20px !important;
	background: #36485c;
	color: white;
}

input, select, textarea, .panel-heading {
	border: none !important;
	border-radius: 0 !important;
}

.breadcrumb .active {
	color: yellow;
}
</style>
</head>

<body>
	<nav class="navbar navbar-default hidden-sm hidden-xs">
		<div class="container-fluid">
			<div class="navbar-header">
				<a class="navbar-brand" href="${pageContext.request.contextPath}/news/index.jsp" style="font-size: 25px;">🐖</a>
			</div>
			<ul class="nav navbar-nav">
				<li class="dropdown"><a class="dropdown-toggle" data-toggle="dropdown"> 新闻管理 <span class="caret"></span></a>
					<ul class="dropdown-menu">
						<li><a href="#">新闻发布</a></li>
						<li class="divider"></li>
						<li><a href="#">类别管理</a></li>
					</ul></li>
			</ul>
			<ul class="nav navbar-nav navbar-right">
				<li><a><%=request.getParameter("name")%></a></li>
				<li><a href="${pageContext.request.contextPath}/login.jsp">退出<span class="glyphicon glyphicon-off"></span></a></li>
			</ul>
		</div>
	</nav>

	<ol class="breadcrumb">
		<li>您当前的位置是</li>
		<li>新闻发布系统</li>
		<li class="active">新闻阅读</li>
	</ol>
	<%
	//获得新闻的id
	String newId = request.getParameter("newId");//从主页获取新闻编号
	//根据新闻id去数据库做查询操作
	//oracledriver
	//加载驱动
	Class.forName("oracle.jdbc.driver.OracleDriver");
	//定义连接字符串
	String url = "jdbc:oracle:thin:@localhost:1521:orcl";
	//获得连接
	Connection con = DriverManager.getConnection(url, "scott", "sa123");
	//查询所有新闻数据
	PreparedStatement ps = con.prepareStatement("select * from T_NEWS where NEWS_ID=?");
	//设置占位符
	ps.setInt(1, Integer.parseInt(newId));
	//获得结果集
	ResultSet rs = ps.executeQuery();
	//定义初始值
	String title = "";
	int count = 0;
	String author = "";
	String publisher = "";
	String content = "";
	if (rs.next()) {
		title = rs.getString(2);
		publisher = rs.getString(5);
		author = rs.getString(4);
		content = rs.getString(6);
		count = rs.getInt(8) + 1;//指的是当前自己也阅读了一次
	}
	//已经阅读过了->修改阅读次数
	ps = con.prepareStatement("update t_news set news_count=news_count+1 where news_id=?");
	ps.setInt(1, Integer.parseInt(newId));
	ps.executeUpdate();//无需判断,无论如何都要进行下去的
	%>
	<div class="container"
		style="background: rgba(239, 231, 231, 0.9); border-radius: 10px;">
		<h1><%=title%></h1>
		<h3 class="text-right">
			<small> <span class="glyphicon glyphicon-user"><span
					class="label label-default"><%=author%></span></span> <span
				class="glyphicon glyphicon-eye-open"><span
					class="label label-default"><%=count%></span></span> <span
				class="glyphicon glyphicon-time"><span
					class="label label-info"><%=publisher%></span></span>
			</small>
		</h3>
		<samp><%=content%></samp>
		<div class="btn-group btn-group-justified"
			style="margin-bottom: 20px;">
			<div class="btn-group">
				<a href="${pageContext.request.contextPath}/news/doDelete.jsp?newId=<%=newId%>" class="btn btn-danger" type="button">删除</a>
			</div>
			<div class="btn-group">
				<a href="${pageContext.request.contextPath}/news/update.jsp?newId=<%=newId%>" class="btn btn-info" type="button">修改</a>
			</div>
		</div>
	</div>

	<div class="container" style="background: rgba(239, 231, 231, 0.9); border-radius: 10px; margin-top: 10px;">
		<%
		ps = con.prepareStatement("select * from t_comment where comment_from=?");
		ps.setInt(1, Integer.parseInt(newId));
		rs = ps.executeQuery();
		while (rs.next()) {
		%>
		<div class="panel panel-default" style="margin-top: 20px;">
			<div class="panel-heading">
				<span class="glyphicon glyphicon-user"><span class="label label-success"><%=rs.getString(4) %></span></span>
				<p style="margin-top: 10px; text-indent: 2em;">
					<samp><%=rs.getString(5)%></samp>
					<!-- 显示评论的内容 -->
				</p>
				<p class="text-right">
					<span class="glyphicon glyphicon-time"><span class="label label-info"><%=rs.getString(3) %></span></span>
				</p>
				<a href="${pageContext.request.contextPath}/news/doDelPl.jsp?newId=<%=newId%>&&id=<%=rs.getInt(1)%>">删除</a>
			</div>
			<%
			}
			%>

			<form action="doAddPl.jsp" class="container" style="background: rgba(239, 231, 231, 0.9); border-radius: 10px; margin-top: 10px; padding: 30px;">
				<input type="hidden" name="newId" value="<%=newId%>">
				<div class="form-group">
					<label for="name">Name</label> <input name="author" class="form-control" placeholder="用户名称" required type="text">
				</div>
				<div class="form-group">
					<label for="email">content</label> <input name="content" class="form-control" placeholder="评论内容" required type="text">
				</div>
				<button class="btn btn-default" type="submit">发布评论</button>
			</form>

			<div style="height: 50px;"></div>
</body>
</html>

新闻管理系统的大部分功能就在这儿了，后期还会完善这个项目的小功能！

一麟yl

关注

4
点赞
踩
18

收藏

觉得还不错? 一键收藏
打赏
4
评论
javaweb新闻管理系统03

目录数据库更新一，主页(实现模糊功能)index.jsp二，实现评论功能1增加评论(doAddPl.jsp)2.删除评论(doDelPl.jsp)三，阅读界面(点击量的实现)read.jsp四，实现主页中的类别管理界面(show.jsp)数据库更新--评论表CREATE TABLE T_COMMENT( COMMENT_ID NUMBER PRIMARY KEY,--评论编号 COMMENT_FROM NUMBER NOT NUL...
复制链接

扫一扫