家人们，我来更新今天的新内容啦，昨天的是登录和增加功能，今天我们要讲的是删除和修改功能还有数据详情功能~
大家好好听课哦~
目录
一.数据库准备工作：
1.建一个主题表，往表里插入几条数据
2.再新建一个新闻表
3. 再往里面增加几条数据，增加完记得加 commit（提交）
二.新闻发布系统功能
<%@ 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="/Web_5/bootstrap-3.3.7-dist/css/bootstrap.css"> <script src="/Web_5/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script> <script src="/Web_5/bootstrap-3.3.7-dist/js/bootstrap.js"></script> <style> * { outline: none !important; } html, body { background: #1abe9c; } form { width: 300px; background: #ebeff2; box-shadow: 0px 0px 50px rgba(0, 0, 0, .5); border-radius: 5px; padding: 20px; position: absolute; left: 50%; top: 50%; transform: translate(-50%, -50%); } .btn-group { width: 100%; } .btn-group button { width: 50%; } </style> </head> <body> <form action="doLogin.jsp" method="post" id="Myform"> <h3 class="text-center">欢迎使用🐖币新闻管理</h3> <div class="form-group"> <input id="uname" name="yh" type="text" class="form-control" placeholder="请输入您的用户名"> </div> <div class="form-group"> <input id="upwd" name="mm" type="password" class="form-control" placeholder="请输入您的密码"> </div> <div class="btn-group"> <button type="submit" class="btn btn-primary">登录</button> <button type="button" class="btn btn-danger" onclick='location=href="regiest.html"'>没有账号?</button> </div> </form> <script type="text/javascript"> $("#Myform").submit(()=>{ if($("#uname").val().lenth==0){ alert("用户名不能为空"); return false;//返回的值为false，代表不提交 } if($("#upwd").val().lenth==0){ alert("密码不能为空"); return false;//返回的值为false，代表不提交 } return true; }) </script> </body></html>
登录功能界面（判断用户是否在数据库中存在）
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.DriverManager"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
request.setCharacterEncoding("utf-8");
String yh=request.getParameter("yh");
String mm=request.getParameter("mm");
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.定义连接字符
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//3.获得连接
Connection con=DriverManager.getConnection(url, "scott", "tlt1516131462qmt");
//4.获取执行对象
PreparedStatement ps=con.prepareStatement("select * from web01_user where uname=? and upwd=?");
ps.setString(1,yh);
ps.setString(2,mm);
//5.获得结果集
ResultSet rs=ps.executeQuery();
//6.判断结果
if(rs.next()){
request.getRequestDispatcher("index.jsp").forward(request, response);
}else{
//使用重定向（1.重定向是客户端行为，转发是服务器行为）
//（2.重定向不能携带数据，转发可以携带）（3.重定向会改变地址，转发不会）
//(localhost:8080/web04/)跳转的时候： a.jsp 跳转到当前路径(同级目录)的a.jsp
// ../a.jsp 跳转到上一级路径下的a.jsp(localhost:8080/a.jsp)
// /a.jsp 根目录的a.jsp(localhost:8080/a.jsp)
response.sendRedirect("Login.jsp");
}
//7.关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.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>bootstrap</title>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="/Web_4/bootstrap-3.3.7-dist/css/bootstrap.css">
<script src="/Web_4/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script src="/Web_4/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="Add.jsp">新闻发布</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>
<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" 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">
<%
//查数据库需要先连接数据库
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection con=DriverManager.getConnection(url,"scott","tlt1516131462qmt");
PreparedStatement ps=con.prepareStatement("select * from T_news");
ResultSet rs=ps.executeQuery();
while(rs.next()){
%>
<li class="list-group-item">
<h4 class="list-group-item-heading">
<a href="${pageContext.request.contextPath}/read.jsp?newId=<%=rs.getInt(1)%>" data-toggle="tooltip" data-placement="bottom" 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(7) %></code></span>
<span class="glyphicon glyphicon-tag"><code><%=rs.getInt(8) %></code></span>
<span class="glyphicon glyphicon-time"><code><%=rs.getString(5) %></code></span>
</p>
</li>
</ul>
</div>
<%
}
if(!con.isClosed()){
con.close();
}
ps.close();
rs.close();
%>
<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>
点击一条
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@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="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;
}
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="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
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection con=DriverManager.getConnection(url,"scott","tlt1516131462qmt");
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(7);
}
%>
<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}/doDel.jsp?newId=<%=newId%>" type="button" class="btn btn-danger">删除</a>
</div>
<div class="btn-group">
<a href="${pageContext.request.contextPath}/Update.jsp?newId=<%=newId%>" type="button" 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;">
<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>我是一条非常好看的评论.</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>
</div>
</div>
<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>我是一条非常好看的评论.</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>
</div>
</div>
</div>
<form class="container" style="background: rgba(239, 231, 231, 0.9);border-radius:10px;margin-top: 10px;padding: 30px;">
<div class="form-group">
<label for="">Name</label>
<input type="text" class="form-control" placeholder="用户名称" required>
</div>
<div class="form-group">
<label for="">Email</label>
<input type="email" class="form-control" placeholder="评论内容" required>
</div>
<button type="submit" class="btn btn-default">发布评论</button>
</form>
<div style="height: 50px;"></div>
</body></html>
删除功能的代码：
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@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"%>
<%
//这是删除功能
//获得新闻的id
String newId=request.getParameter("newId");
//去数据库做删除操作
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection con=DriverManager.getConnection(url,"scott","tlt1516131462qmt");
PreparedStatement ps=con.prepareStatement("delete from T_news where news_id=?");
//设置占位符
ps.setInt(1,Integer.parseInt(newId));
//执行并获得结果
int i=ps.executeUpdate();
if(i>0){//删除成功
out.print("<script>alert('删除成功！');location.href='index.jsp'</script>");
}else{//删除失败
out.print("<script>alert('删除失败！');history.go(-1)</script>");
}
%>修改界面：
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@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="zh">
<head>
<meta charset="UTF-8">
<title>bootstrap</title>
<meta content="width=device-width, initial-scale=1" name="viewport">
<link href="/Web_4/bootstrap-3.3.7-dist/css/bootstrap.css" rel="stylesheet">
<script src="/Web_4/bootstrap-3.3.7-dist/js/jquery-3.5.1.js"></script>
<script src="/Web_4/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>
<%
//获得新闻的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","tlt1516131462qmt");
PreparedStatement ps=con.prepareStatement("select * from t_news where news_id=?");
//设置占位符
ps.setInt(1,Integer.parseInt(newId));
ResultSet rs=ps.executeQuery();
//定义需要的值
String title="";//标题
String author="";//作者
String publisher="";//时间
String content="";//内容
int topic=0;//类别
if(rs.next()){
//赋值
title=rs.getString(2);
publisher=rs.getString(5);
author=rs.getString(4);
content=rs.getString(6);
topic=rs.getInt(3);
}
%>
<body>
<nav class="navbar navbar-default hidden-sm hidden-xs">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="Update.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>
<form action="doUpdate.jsp" class="container" method="post">
<div class="panel panel-info">
<input value="<%=newId%>" name="newId" type="hidden">
<div class="panel-heading">新闻标题</div>
<input value="<%=topic %>" class="form-control" name="title" maxlength="50" placeholder="标题控制在30个字之内哦~~~" required>
<div class="panel-heading">新闻类别</div>
<select class=" form-control" name="topic">
<%
//查询对应的类型信息
ps=con.prepareStatement("select * from t_topic");
rs=ps.executeQuery();
while(rs.next()){
%>
<option<%=topic==rs.getInt(1)?"selected":""%> value="<%=rs.getInt(1)%>"><%=rs.getString(2)%></option>
<%
}
%>
</select>
<div class="panel-heading">新闻作者</div>
<input value="<%=author%>" class="form-control" name="author" maxlength="10" placeholder="名字控制在10个字之内哦~~~" required>
<div class="panel-heading">发布时间</div>
<input value="<%=publisher %>" class="form-control" name="publisher" required type="date">
<div class="panel-heading">新闻内容</div>
<textarea class="form-control" name="content" placeholder="🙅达咩~~~~这是必填的" required rows="10">
<%=content %></textarea>
<div class="panel-footer">
<button class="btn btn-primary">修改</button>
<button class="btn btn-danger">取消</button>
</div>
</div>
</form>
</body>
</html>
修改功能：
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@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 title=request.getParameter("title");
String author=request.getParameter("author");
String publisher=request.getParameter("publisher");
String content=request.getParameter("content");
String topic=request.getParameter("topic");
//根据id去数据库做修改
Class.forName("oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@localhost:1521:orcl";
Connection con=DriverManager.getConnection(url,"scott","tlt1516131462qmt");
PreparedStatement ps=con.prepareStatement("update t_news set news_title=?,news_topic=?,news_author=?,news_publisher=?,news_content=? where news_id=?");
ps.setString(1,title);
ps.setString(3,author);
ps.setInt(2,Integer.parseInt(topic));
ps.setString(4,publisher);
ps.setString(5,content);
ps.setInt(6,Integer.parseInt(newId));
//执行并获得结果
int i=ps.executeUpdate();
if(i>0){//修改成功
out.print("<script>alert('修改成功！');location.href='index.jsp'</script>");
}else{//修改失败
out.print("<script>alert('修改失败！');history.go(-1)</script>");
}
//.关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
%>今天的代码就到这里结束啦~
咱们下期见！
再忙也要捕捉快乐呀.
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
