删除新闻
<%@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 id = request.getParameter("nid");
int nid = 0;
if (id != null) {
nid = Integer.valueOf(id);
}
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "delete from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回所影响的行数
int n = ps.executeUpdate();
if (n > 0) {
out.println("<script>alert('删除成功');location.href = 'admin.jsp'</script>");
} else {
out.println("<script>alert('删除失败');location.href = 'admin.jsp'</script>");
}
%>
查看新闻详情
Java部分
<%@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"%>
<%
//定义变量
String ntitle = "";
String ndate = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
int ncount = 0;
//设置编码
request.setCharacterEncoding("utf-8");
//获取参数
String id = request.getParameter("nid");
int nid = 0;
if (id != null) {
nid = Integer.valueOf(id);
}
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "select * from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历
if (rs.next()) {
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
整体
<%@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"%>
<%
//定义变量
String ntitle = "";
String ndate = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
int ncount = 0;
//设置编码
request.setCharacterEncoding("utf-8");
//获取参数
String id = request.getParameter("nid");
int nid = 0;
if (id != null) {
nid = Integer.valueOf(id);
}
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "select * from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历
if (rs.next()) {
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>新闻详情-后台管理</title>
<link rel="stylesheet" type="text/css" href="css/read.css" />
</head>
<body>
<div id="header">
<div id="top_login">
<label> 登录名 </label> <input type="text" id="uname" value=""
class="login_input" /> <label> 密  码 </label> <input
type="password" id="upwd" value="" class="login_input" /> <input
type="button" class="login_sub" value="登录" onclick="login()" /> <label
id="error"> </label> <a href="index.html" class="login_link">返回首页</a>
<img src="images/friend_logo.gif" alt="Google" id="friend_logo" />
</div>
<div id="nav">
<div id="logo">
<img src="images/logo.jpg" alt="新闻中国" />
</div>
<div id="a_b01">
<img src="images/a_b01.gif" alt="" />
</div>
<!--mainnav end-->
</div>
</div>
<div id="container">
<div class="sidebar">
<h1>
<img src="images/title_1.gif" alt="国内新闻" />
</h1>
<div class="side_list">
<ul>
<li><a href='#'><b> 国内新闻1 </b></a></li>
<li><a href='#'><b> 国内新闻2 </b></a></li>
<li><a href='#'><b> 国内新闻3 </b></a></li>
</ul>
</div>
<h1>
<img src="images/title_2.gif" alt="国际新闻" />
</h1>
<div class="side_list">
<ul>
<li><a href='#'><b> 国际新闻1 </b></a></li>
<li><a href='#'><b> 国际新闻2 </b></a></li>
<li><a href='#'><b> 国际新闻3 </b></a></li>
<li><a href='#'><b> 国际新闻4 </b></a></li>
</ul>
</div>
<h1>
<img src="images/title_3.gif" alt="娱乐新闻" />
</h1>
<div class="side_list">
<ul>
<li><a href='#'><b> 娱乐新闻1 </b></a></li>
<li><a href='#'><b> 娱乐新闻2 </b></a></li>
<li><a href='#'><b> 娱乐新闻3 </b></a></li>
<li><a href='#'><b> 娱乐新闻4 </b></a></li>
</ul>
</div>
</div>
<div class="main">
<div class="class_type">
<img src="images/class_type.gif" alt="新闻中心" />
</div>
<div class="content">
<ul class="classlist">
<table width="80%" align="center">
<tr width="100%">
<td align="right"><%=ntitle%></td>
<td align="right">访问量:<%=ncount%></td>
</tr>
<tr>
<td colspan="2">
<hr />
</td>
</tr>
<tr>
<td align="center"><%=ndate%></td>
<td align="left">作者:<%=nauthor%>
</td>
</tr>
<tr>
<td colspan="2" align="center"></td>
</tr>
<tr>
<td colspan="2">
<h5>
新闻摘要:<%=nsummary%></h5>
</td>
</tr>
<tr>
<td colspan="2"><%=ncontent%></td>
</tr>
<tr>
<td colspan="2">
<hr />
</td>
</tr>
</table>
</ul>
<ul class="classlist">
<table width="80%" align="center">
<td colspan="6">暂无评论!</td>
<tr>
<td colspan="6">
<hr />
</td>
</tr>
</table>
</ul>
</div>
</div>
</div>
<!-- 通过include指令引入admin_foot.jsp -->
<%@ include file = "admin_foot.jsp" %>
</body>
</html>
修改新闻页面
Java部分
<%@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"%>
<%
//定义变量
int ntid = 0;
String ntitle = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
String nimage = "images\\1.jpg";
String ndate = "";
int ncount = 0;
//设置编码
request.setCharacterEncoding("utf-8");
//获取编号
String id = request.getParameter("nid");
int nid = 0;
if (id != null) {
nid = Integer.valueOf(id);
}
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "select * from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历
if (rs.next()) {
ntid = rs.getInt(2);
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
整体
<%@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"%>
<%
//定义变量
int ntid = 0;
String ntitle = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
String nimage = "images\\1.jpg";
String ndate = "";
int ncount = 0;
//设置编码
request.setCharacterEncoding("utf-8");
//获取编号
String id = request.getParameter("nid");
int nid = 0;
if (id != null) {
nid = Integer.valueOf(id);
}
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "select * from tb_t281_news where nid = " + nid;
PreparedStatement ps = conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历
if (rs.next()) {
ntid = rs.getInt(2);
ntitle = rs.getString(3);
nauthor = rs.getString(4);
nsummary = rs.getString(5);
ncontent = rs.getString(6);
ndate = rs.getString(8);
ncount = rs.getInt(9);
}
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>新闻维护--管理后台</title>
<link rel="stylesheet" type="text/css" href="css/admin.css" />
</head>
<body>
<div id="header">
<div id="welcome">欢迎使用新闻管理系统!</div>
<div id="nav">
<div id="logo">
<img src="images/logo.jpg" alt="新闻中国" />
</div>
<div id="a_b01">
<img src="images/a_b01.gif" alt="" />
</div>
</div>
</div>
<div id="admin_bar">
<div id="status">
管理员: 登录     <a href="#">退出</a>
</div>
<div id="channel"></div>
</div>
<div id="main">
<div id="opt_list">
<ul>
<li><a href="admin.html">管 理 首 页</a></li>
<li><a href="admin_addNews.html">新 闻 发 布</a></li>
<li><a href="admin_themeMaintain.html">主 题 维 护</a></li>
<li><a style="color: red;" href="#">系统账号管理</a></li>
<li><a style="color: red;" href="#">注册用户管理</a></li>
</ul>
</div>
<div id="opt_area">
<h1 id="opt_type">编辑新闻:</h1>
<form action="doAdminEditNews.jsp" method="post">
<p>
<label> 主题 </label> <select name="ntid">
<option value="1">选择</option>
<%
//绑定所有的主题
sql = "select * from tb_t281_news_themes";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
while (rs.next()) {
if (rs.getInt(1) == ntid) {
out.println("<option selected = 'selected' value='" + rs.getInt(1) + "'>" + rs.getString(2)
+ "</option>");
} else {
out.println("<option value='" + rs.getInt(1) + "'>" + rs.getString(2) + "</option>");
}
}
//根据编号进行对比
%>
<option value='1'>国内</option>
</select>
</p>
<p>
<label> 标题 </label> <input name="ntitle" type="text"
class="opt_input" value="<%=ntitle%>" />
</p>
<p>
<label> 作者 </label> <input name="nauthor" type="text"
class="opt_input" value="<%=nauthor%>" />
</p>
<p>
<label> 摘要 </label>
<textarea name="nsummary" cols="40" rows="3">
<%=nsummary%>
</textarea>
</p>
<p>
<label> 内容 </label>
<textarea name="ncontent" cols="70" rows="10"><%=ncontent%></textarea>
</p>
<p>
<label> 上传图片 </label> <input name="file" type="file"
class="opt_input" />
</p>
<input name="nid" type="hidden" value="<%=nid%>"> <input
type="submit" value="确认修改" class="opt_sub" /> <input type="reset"
value="重置" class="opt_sub" />
</form>
</div>
</div>
<!-- 通过include指令引入admin_foot.jsp -->
<%@ include file = "admin_foot2.jsp" %>
</body>
</html>
主题绑定
<%
//显示所有新闻
//数据库交互
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "triger");
//sql语句
String sql = "select * from tb_t281_news";
PreparedStatement ps = conn.prepareStatement(sql);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//遍历
while (rs.next()) {
%>
<li><a href="admin_newsDetail.jsp?nid=<%=rs.getInt(1)%>"><%=rs.getString(3)%></a>
<span> 作者: <%=rs.getString(4)%>      <a
href='admin_editNews.jsp?nid=<%=rs.getInt(1)%>'>修改</a>
     <a href='javascript:void(0)'
onclick='return clickdel("<%=rs.getInt(1)%>")'>删除</a>
</span></li>
<%
}
%>