删除新闻
<%@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