一、完成标题模糊查询
一般情况下我们可能需要查看某一类新闻,或者网上购物时在搜索框中输入自己所需的物品的关键字来查找物品,这个功能就是我们程序员所说的模糊查询功能!!下面我们来看一下该功能实现的代码吧。
根据输入的标题关键字进行模糊查询(例如:输入“疫情”则出现如下新闻)
模糊查询是在首页进行操作 代码在首页代码里面:
<%@page import="java.nio.charset.StandardCharsets"%>
<%@page import="sun.nio.cs.UTF_8"%>
<%@page import="sun.nio.cs.UTF_8"%>
<%@page import="sun.nio.cs.UTF_8"%>
<%@page import="java.sql.ResultSet"%>
<%@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"%>
<!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: 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="/web04/news/add.jsp">新闻发布</a></li>
<li class="divider"></li>
<li><a href="/web04/news/show.jsp">类别管理</a></li>
</ul>
</li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a><%=request.getParameter("yh") %></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 action="${pageContext.request.contextPath}/news/index.jsp" 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 name="newName" class="form-control" placeholder="请在此输入搜索的关键字" type="text">
<span class="input-group-btn">
<button class="btn btn-primary" type="submit">搜索🔍</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);
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con=DriverManager.getConnection(url,"scott","123123");
//获得执行对象(查询所有的新闻数据)
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>«</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>»</span></a>
</li>
</ul>
</div>
<script>
$(function () {
$('[data-toggle="tooltip"]').tooltip({
trigger: "hover"
})
})
</script>
</body>
</html>
二、阅读界面的完善
点击文章进行阅读 点击量+1
效果如下:
<%@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"%>
<!DOCTYPE html>
<html lang="">
<head>
<meta charset="UTF-8">
<title>bootstrap</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="/web04/bootstrap-3.3.7-dist/css/bootstrap.css">
<script src="/web04/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script src="/web04/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;
}
input,
select,
textarea,
.panel-heading {
border: none !important;
border-radius: 0px !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.html" 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("yh") %></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去数据库做查询操作
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con=DriverManager.getConnection(url,"scott","123123");
//获得执行对象(查询所有的新闻数据)
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">删除</a>
</div>
<div class="btn-group">
<a href="${pageContext.request.contextPath}/news/upd.jsp?newId=<%=newId %>" class="btn btn-info">修改</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) %>" class="btn btn-danger">删除</a> </div>
</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</label>
<input type="text" class="form-control" name="author" placeholder="用户名称" required>
</div>
<div class="form-group">
<label for="">content</label>
<input type="text" class="form-control" name="content" placeholder="评论内容" required>
</div>
<button type="submit" class="btn btn-default">发布评论</button>
</form>
<div style="height: 50px;"></div>
</body></html>
2.完成评论添加
添加成功后的效果图如下
处理评论添加的代码:
<%@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","123123");
//主键不能不填
//主键没有自增的选项(触发器+序列)
//获得执行对象(数据插入之前先把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();
}
%>
3.完成评论删除
阅读界面 删除评论的重点代码(先绑值再删除)
<a href="${pageContext.request.contextPath}/news/doDelPl.jsp?newId=<%=newId %>&&id=<%=rs.getInt(1) %>" class="btn btn-danger">删除</a>
处理评论删除的代码:
<%@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","123123");
//获得执行对象(查询所有的新闻数据)
//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();
}
%>
三、完成页面标题分类
点击首页左上角的新闻管理 选择类别选择
页面标题界面如下:
深颜色代表选中了那一类别 结果如下显示
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.Connection"%>
<%@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>Document</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>
</head>
<body>
<nav class="navbar navbar-default hidden-sm hidden-xs">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" style="font-size: 25px;">当前是新闻首页</a>
</div>
<ul class="nav navbar-nav navbar-right" style="margin-right: 20px;">
<li><a href="${pageContext.request.contextPath}/login.jsp">返回管理员登录界面<span class="glyphicon glyphicon-road"></span></a></li>
</ul>
</div>
</nav>
<div class="container" style="margin: 10px auto;">
<div class="btn-group btn-group-justified">
<%
String topicId=request.getParameter("topicId");
//导入驱动(sqlserver,oracle,mysql),一定要执行 build path,且需要导入对应的jar包
//OracleDriver
Class.forName("oracle.jdbc.driver.OracleDriver");//这里使用的是oracle的驱动
//编写连接语句
String URL="jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con=DriverManager.getConnection(URL, "scott", "123123");
//获得预编译对象(执行对象)
PreparedStatement ps=con.prepareStatement("SELECT * FROM T_TOPIC");
//获得结果集
ResultSet rs=ps.executeQuery();
while(rs.next()){
if(topicId!=null){
%>
<a href="show.jsp?topicId=<%=rs.getInt(1) %>" type="button" class="btn btn-success <%=rs.getInt(1)==Integer.parseInt(topicId)?"active":"" %>"><%=rs.getString(2)%></a>
<%
}else{
%>
<a href="show.jsp?topicId=<%=rs.getInt(1) %>" type="button" class="btn btn-success"><%=rs.getString(2)%></a>
<%
}
}
%>
</div>
</div>
<div class="container">
<ul class="list-group">
<%
String sql="SELECT * FROM T_NEWS";
if(topicId!=null){
sql+=" WHERE NEWS_TOPIC="+topicId;//这里需要在语句前面加上一个空格
}
ps=con.prepareStatement(sql);
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?newsId=<%=rs.getInt(1) %>&userId=<%=request.getParameter("userId") %>" data-placement="bottom" data-toggle="tooltip" title="<%=rs.getString(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>
<%
}
%>
</ul>
</div>
</body>
</html>
今天的分享就到这里结束啦