1.评论管理
(1).显示评论和添加评论
<%@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"%>
<!-- 获取 当前传递的参数用户以及新闻编号 -->
<%
//设置编码
request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");//用户名
%>
<!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">
<link rel="stylesheet" type="text/css" href="admin/css/read.css" />
<script type="text/javascript">
function check() {
var cauthor = document.getElementById("cauthor");
var content = document.getElementById("ccontent");
if (cauthor.value == "") {
alert("用户名不能为空!!");
return false;
} else if (content.value == "") {
alert("评论内容不能为空!!");
return false;
}
return true;
}
</script>
</head>
<body>
<div id="header">
</div>
<div id="container">
<div class="sidebar">
<h1> <img src="admin/images/title_1.gif" alt="国内新闻" /> </h1>
<div class="side_list">
</div>
<h1> <img src="admin/images/title_2.gif" alt="国际新闻" /> </h1>
<div class="side_list">
</div>
<h1> <img src="admin/images/title_3.gif" alt="娱乐新闻" /> </h1>
<div class="side_list">
</div>
</div>
<div class="main">
<div class="class_type"> <img src="admin/images/class_type.gif" alt="新闻中心" /> </div>
<div class="content">
<!-- 该区域实现新闻详情显示 start -->
<%
//定义所谓变量(新闻标题,发布时间,点击量,新闻内容等等)
String ntitle = "";//标题
String ndate = "";//发布时间
String nauthor = "";//作者
String ncontent = "";//内容
int ncount = 0;//点击量
//2.获取id
String id = request.getParameter("nid");
//转换
int nid = 0;
if(null!=id){
nid = Integer.valueOf(id);
}
//3.获取数据
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott","123");
//sql语句
String sql = "select * from tb_news where nid = ?";
//将sql语句传入方法返回执行对象
PreparedStatement ps = conn.prepareStatement(sql);
ps.setInt(1, nid);
//返回结果集对象
ResultSet rs = ps.executeQuery();
//if改造
if(rs.next()){
ntitle = rs.getString(3);
ndate = rs.getString(8);
nauthor = rs.getString(4);
ncontent = rs.getString(6);
ncount = rs.getInt(9);
}
%>
<ul class="classlist">
<table width="80%" align="center">
<tr width="100%">
<td colspan="2" align="center"><%=ntitle %>
点击量 <%=ncount %></td>
</tr>
<tr>
<td colspan="2">
<hr />
</td>
</tr>
<tr>
<td align="center"><%=ndate %></td>
<td align="left"><%=nauthor %> </td>
</tr&g