目录
评论管理
评论do界面
<%
//设置编码
request.setCharacterEncoding("utf-8");
//获取form表单提交的评论字段
//编号
int cid = 0;
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
//调用方法返回执行对象
String sql = "select nvl(max(cid),0) from tb_t281_news_comment";
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
cid = rs.getInt(1) + 1;
}
//用户编号
int cuserid = 0;
String username = request.getParameter("cauthor");
//交互 根据username获取该用户的编号
sql = "select * from tb_t281_news_users where username = ?";
ps = conn.prepareStatement(sql);
ps.setString(1,username);
rs = ps.executeQuery();
if(rs.next()){
cuserid = rs.getInt(1);
}
//新闻编号
int nid = 0;
String id = request.getParameter("nid");
if(null!=id){
nid = Integer.valueOf(id);
}
//ip地址
String cip = request.getParameter("cip");
//内容
String ccontent = request.getParameter("ccontent");
//时间
Date date = new Date();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String cdate = sdf.format(date);
//交互---插入评论
sql = "insert into tb_t281_news_comment values(?,?,?,?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'))";
ps = conn.prepareStatement(sql);
ps.setInt(1,cid);
ps.setInt(2,cuserid);
ps.setInt(3,nid);
ps.setString(4,cip);
ps.setString(5,ccontent);
ps.setString(6,cdate);
int n = ps.executeUpdate();
if(n>0){
out.println("<script>alert('评论成功');location.href='news_read.jsp?username="+username+"&nid="+nid+"'</script>");
}else{
out.println("<script>alert('评论失败');location.href='news_read.jsp?username="+username+"&nid="+nid+"'</script>");
}
%>
评论主界面
<%
//定义全局变量存储数据库查询的结果 将来可以通过jsp表达式可以在该页面的任意一个位置进行输出
String ntitle = "";
String ndate = "";
String nauthor = "";
String nsummary = "";
String ncontent = "";
int ncount = 0;
//获取新闻编号
//1.设置编码
request.setCharacterEncoding("utf-8");
//2.获取参数
String id = request.getParameter("nid");
int nid = 0;
if (null != id) {
nid = Integer.valueOf(id);//转成int类型 因为数据库number类型
}
String username = request.getParameter("username");//用户名 传递过来的
//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_t281_news where nid = "+nid;
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
//sql 1条记录 没有记录
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);
}
%>
include指令
1.include指令属于jsp的三大指令之一
2.三大指令:page/include/taglib
3.include指令作用:引入页面
<%@ include file = "指定页面名称"%>
include封装重复代码页面
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!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>Insert title here</title>
</head>
<body>
<div id="site_link"> <a href="#">关于我们</a><span>|</span> <a href="#">Aboue Us</a><span>|</span> <a href="#">联系我们</a><span>|</span>
<a href="#">广告服务</a><span>|</span> <a href="#">供稿服务</a><span>|</span> <a href="#">法律声明</a><span>|</span> <a href="#">招聘信息</a><span>|</span>
<a href="#">网站地图</a><span>|</span> <a href="#">留言反馈</a> </div>
<div id="footer">
<p class="">24小时客户服务热线:010-68988888      <a href="#">常见问题解答</a>     
新闻热线:010-627488888<br />
文明办网文明上网举报电话:010-627488888      举报邮箱:<a href="#">jubao@jb-aptech.com.cn</a></p>
<p class="copyright">Copyright © 1999-2009 News China gov, All Right Reserver<br />
新闻中国 版权所有</p>
</div>
</body>
</html>
在指定页面进行调用
<%@ include file = "指定页面名称"%>