**
Web05项目增删
数据库关系图
新闻主界面
index jsp主界面代码
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<!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="${pageContext.request.contextPath}/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}/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><%=request.getParameter("yh") %>
</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: 0 auto 20px;">
<div class="form-group" style="display: block;text-align: center;">
<div class="input-group">
<div class="input-group-addon">新闻标题</div>
<input 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">
<%
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con = DriverManager.getConnection(url, "scott", "123");
//查询所有的新闻数据
PreparedStatement ps = con.prepareStatement("select * from t1_news");
//得到结果集
ResultSet rs = ps.executeQuery();
//结果集中有很多数据
while (rs.next()) {
%>
<!--两个《%%》里面的内容会跟随迭代器一起迭代-->
<li class="list-group-item">
<h4 class="list-group-item-heading">
<!-- ?newId= 取到get路径上的值,将数据库中的id传给read界面 -->
<a href=" ${pageContext.request.contextPath}/read.jsp?newId=<%=rs.getInt(1)%>" data-placement="bottom" data-toggle="tooltip" title="国家卫健委:昨日新增确诊病例29例,其中本土病例2例">
<%=rs.getString(2)%>
</a>
</h4>
<p class="list-group-item-text text-right">
<!-- rs.getString(4)拿到数据库数据,=在网页打印 -->
<span class="glyphicon glyphicon-user"><code><%=rs.getString(4)%></code></span>
<span class="glyphicon glyphicon-time"><code><%=rs.getString(5)%></code></span>
</p>
</li>
<%
}
if (!con.isClosed()) {
con.close();
}
ps.close();
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.upd.jsp修改界面
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.ResultSet" %>
<%@ page import="java.sql.Connection" %>
<!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>
<%
// http://localhost:8080/web04/news/upd.jsp?newId=4
//从read界面获得新闻的id,根据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", "123");
//查询所有的新闻数据
PreparedStatement ps = con.prepareStatement("select * from t1_news where news_id=?");
//占位符的设置
ps.setInt(1,Integer.parseInt(newId));
//得到结果集
ResultSet rs = ps.executeQuery();
//定义需要的值
String title="";
int topic=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);
//topic是t1_news表中的第三列news_topic!!!
topic=rs.getInt(3);
}
%>
<!-- 修改界面内容的数据了过大,所以要用post,get有长度限制 -->
<form action="doUpd.jsp" class="container" method="post">
<div class="panel panel-info">
<!--将带id的框隐藏type=隐藏框hidden,只用于传给doUpd做修改,不在页面显示,将输入框的值改为数据库的值=newId-->
<input type="hidden" value="<%=newId%>" name="newId">
<div class="panel-heading">新闻标题</div>
<input value="<%=title%>" class="form-control" name="title" maxlength="50" placeholder="标题控制在30个字之内哦~~~" required>
<div class="panel-heading">新闻类别</div>
<select class=" form-control" name="topic">
<%
//查询对应的类目的信息,直接用连接了数据库后的ps,rs
ps=con.prepareStatement("select * from T1_TOPIC");
rs=ps.executeQuery();
while(rs.next()){
%>
<!--每查出一条数据就生成一个下拉框 ? :三元运算符-->
<!-- topic==rs.getInt(1)如果数据库中话题列和 -->
<!--topic是t1_news表中的第三列news_topic!!!-->
<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 onclick="history.go(-1)" class="btn btn-danger">取消</button>
</div>
</div>
</form>
</body>
</html>
新闻的删除 根据id删除
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.PreparedStatement" %>
<%@ page import="java.sql.Connection" %>
<%
//删除没有界面del,只有doDel后台,在read界面点击删除按钮就会执行这个后台
//获得新闻的id,根据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", "123");
//查询所有的新闻数据
PreparedStatement ps = con.prepareStatement("delete from t1_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{ //删除失败
//history.go(-1)跳到上一页即doDel
out.print("<script>alert('删除失败');history.go(-1)</script>");
}
%>