旧功能升级&阅读&删除和修改
主页(升级版):
index.jsp:主页(新闻是从你的数据库拿来的,而不是定死的)
<%@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>主页</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?userId=<%=request.getParameter("userId") %>" 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?userId=<%=request.getParameter("userId") %>">新闻发布</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("userId") %></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 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">
<%
//导入驱动(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", "tiger");
//获得预编译对象(执行对象)
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}/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>
<%
}
//关闭资源
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>
新闻增加:(升级版)
add.jsp:增加新闻的界面(样子没什么改变,内在变了一点)
<%@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>增加新闻</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="${pageContext.request.contextPath}/news/index.jsp?userId=<%=request.getParameter("userId") %>" 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("userId") %></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>
<%--表单,action是提交的地址,需要给input和select标签加上name属性(不然doAdd拿不到数据) --%>
<form action="doAdd.jsp" class="container">
<input type="hidden" name="userId" value="<%=request.getParameter("userId") %>"></input>
<div class="panel panel-info">
<div class="panel-heading">新闻标题</div>
<input class="form-control" maxlength="50" name="title" required placeholder="标题控制在30个字之内哦~~~">
<div class="panel-heading">新闻类别</div>
<select name="topic" class=" form-control">
<%
//导入驱动(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", "tiger");
//获得预编译对象(执行对象)
PreparedStatement ps=con.prepareStatement("SELECT * FROM T_TOPIC");
//获得结果集
ResultSet rs=ps.executeQuery();
while(rs.next()){
%>
<option value="<%=rs.getInt(1)%>"><%=rs.getString(2)%></option>
<%
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
</select>
<div class="panel-heading">新闻作者</div>
<input class="form-control" maxlength="10" name="author" required placeholder="名字控制在10个字之内哦~~~">
<div class="panel-heading">发布时间</div>
<input type="date" class="form-control" name="publisher" required>
<div class="panel-heading">新闻内容</div>
<textarea class="form-control" rows="10" name="content" required placeholder="🙅达咩~~~~这是必填的"></textarea>
<div class="panel-footer">
<button class="btn btn-primary">增加</button>
<button class="btn btn-danger">取消</button>
</div>
</div>
</form>
</body>
</html>
doAdd.jsp:处理增加新闻的请求(老朋友)
<%@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"%>
<!-- 处理提交新闻请求 -->
<%
//修改请求的字符编码
request.setCharacterEncoding("UTF-8");
//拿到所有的数据
String title=request.getParameter("title");
String topic=request.getParameter("topic");
String author=request.getParameter("author");
String publisher=request.getParameter("publisher");
String content=request.getParameter("content");
//导入驱动(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", "tiger");
//获得预编译对象(执行对象)
PreparedStatement ps=con.prepareStatement("SELECT NVL(MAX(NEWS_ID),0) FROM T_NEWS");
//获得结果集
ResultSet rs=ps.executeQuery();
int id=0;
if(rs.next()){
id=rs.getInt(1);
}
id++;//避免主键重复
//编写插入数据库的语句
String sql="INSERT INTO T_NEWS(NEWS_ID, NEWS_TITLE, NEWS_TOPIC, NEWS_AUTHOR, NEWS_PUBLISHER, NEWS_CONTENT) VALUES(?,?,?,?,?,?)";
ps=con.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, title);
ps.setInt(3, Integer.parseInt(topic));
ps.setString(4, author);
ps.setString(5, publisher);
ps.setString(6, content);
int n=ps.executeUpdate();
//判断是否增加成功
if(n>0){
out.print("<script>alert('增加成功');location.href='index.jsp?userId="+request.getParameter("userId")+"'</script>");
}else{
out.print("<script>alert('增加失败');location.href='index.jsp?userId="+request.getParameter("userId")+"'</script>");
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
阅读新闻:
read.jsp:阅读主界面
<%@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="${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="${pageContext.request.contextPath}/news/index.jsp?userId=<%=request.getParameter("userId") %>" 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("userId") %></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>
<%
String newsId=request.getParameter("newsId");
//导入驱动(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", "tiger");
//获得预编译对象(执行对象)
PreparedStatement ps=con.prepareStatement("SELECT * FROM T_NEWS WHERE NEWS_ID=?");
ps.setInt(1,Integer.parseInt(newsId));
//获得结果集
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);
}
%>
<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?newsId=<%=newsId%>&userId=<%=request.getParameter("userId") %>" class="btn btn-info">删除</a>
</div>
<div class="btn-group">
<a href="${pageContext.request.contextPath}/news/upd.jsp?newsId=<%=newsId%>&userId=<%=request.getParameter("userId") %>" class="btn btn-info">修改</a>
</div>
</div>
</div>
<%
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
<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>
效果如下:
新闻删除:
doDel.jsp:处理删除新闻的请求
<%@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"%>
<!-- 处理删除新闻请求 -->
<%
String newsId=request.getParameter("newsId");
//导入驱动(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", "tiger");
//获得预编译对象(执行对象)
PreparedStatement ps=con.prepareStatement("DELETE FROM T_NEWS WHERE NEWS_ID=?");
ps.setInt(1,Integer.parseInt(newsId));
//获得结果集
int i = ps.executeUpdate();
if(i>0){ //删除成功
out.print("<script>alert('删除成功');location.href='index.jsp?userId="+request.getParameter("userId")+"'</script>");
}else{ //删除失败
out.print("<script>alert('删除失败');history.go(-1)</script>");
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
%>
新闻修改:(新朋友,老面孔)
upd.jsp:修改新闻的界面
<%@page import="oracle.jdbc.driver.OracleDriver"%>
<%@ 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?userId=<%=request.getParameter("userId") %>"
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("userId") %></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 newsId = request.getParameter("newsId");
//加载驱动
//OracleDriver
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con = DriverManager.getConnection(url, "scott", "tiger");
//查询所有的新闻数据
PreparedStatement ps = con.prepareStatement("SELECT * FROM T_NEWS WHERE NEWS_ID=?");
//占位符的设置
ps.setInt(1,Integer.parseInt(newsId));
//得到结果集
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=rs.getInt(3);
}
%>
<form action="doUpd.jsp" class="container" method="post">
<div class="panel panel-info">
<input type="hidden" value="<%=newsId%>" name="newsId">
<input type="hidden" value="<%=request.getParameter("userId")%>" name="userId">
<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=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>
<%
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
if(rs!=null){
rs.close();
}
%>
</body>
</html>
效果如下:
doUpd.jsp:处理修改新闻的请求
<%@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"%>
<!-- 处理修改新闻请求 -->
<%
request.setCharacterEncoding("UTF-8");
//获取到新闻的所有信息
String newsId = request.getParameter("newsId");
String author = request.getParameter("author");
String publisher = request.getParameter("publisher");
String content = request.getParameter("content");
String topic = request.getParameter("topic");
String title = request.getParameter("title");
//根据id去数据库做修改
//加载驱动
//OracleDriver
Class.forName("oracle.jdbc.driver.OracleDriver");
//定义连接字符串
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//获得连接
Connection con = DriverManager.getConnection(url, "scott", "tiger");
//查询所有的新闻数据
PreparedStatement ps = con.prepareStatement("UPDATE T_NEWS SET NEWS_TITLE=?,NEWS_AUTHOR=?,NEWS_TOPIC=?,NEWS_CONTENT=?,NEWS_PUBLISHER=? WHERE NEWS_ID=?");
//占位符的设置
ps.setString(1,title);
ps.setString(2,author);
ps.setInt(3,Integer.parseInt(topic));
ps.setString(4,content);
ps.setString(5,publisher);
ps.setInt(6,Integer.parseInt(newsId));
//执行并获得结果 【收到影响的行数】
int i = ps.executeUpdate();
if(i>0){ //修改成功
out.print("<script>alert('修改成功');location.href='index.jsp?userId="+request.getParameter("userId")+"'</script>");
}else{ //修改失败
out.print("<script>alert('修改失败');history.go(-1)</script>");
}
//关闭资源
if(con!=null&&!con.isClosed()){
con.close();
}
if(ps!=null){
ps.close();
}
%>
第二弹源码:
链接:百度网盘
提取码:zygx