include指令
1.include指令属于jsp的三大指令之一
2.三大指令:page/include/taglib
3.include指令作用:引入页面
<%@ include file = "指定页面名称"%>
评论模块
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>
<%@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"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%
//1.设置编码格式
request.setCharacterEncoding("utf-8");
//获取用户名
String username =request.getParameter("cauthor");
//根据用户名获取编号
int cid=0;
//加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//建立连接
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "123");
//调用方法返回执行对象
String sql = "select * from tb_t281_news_users where username=?";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, username);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
cid = rs.getInt(1);
}
//获取新闻编号
String id=request.getParameter("nid");
int nid =0;
if(id!=null){
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 (cuserid,cnid,cip,ccontent,cdate) values(?,?,?,?,to_date(?,'yyyy-mm-dd hh24:mi:ss'))";
ps = conn.prepareStatement(sql);
ps.setInt(1,cid);
ps.setInt(2,nid);
ps.setString(3,cip);
ps.setString(4,ccontent);
ps.setString(5,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>");
}
%>
删除评论
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%@page import="java.sql.Connection"%>
<%@ 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>新闻首页</title>
<link rel="stylesheet" type="text/css" href="admin/css/main.css" />
</head>
<body>
<div id="header">
<div id="top_login">
<span style = "font-size:14px;cursor:pointer;font-weight:bold;">卓京教育新闻网首页</span>
【<a href = "">请注册</a>】
<%
//获取用户名
request.setCharacterEncoding("utf-8");
String username = request.getParameter("username");
if(null == username){
out.println("【<a href = 'login.jsp'>登录</a>】");
}else{
out.println("<span>当前用户:"+username+"</span><a href='login.jsp'>退出登录</a>");
}
%>
<img src="admin/images/friend_logo.gif" alt="Google" id="friend_logo" /> </div>
<div id="nav">
<div id="logo"> <img src="admin/images/logo.jpg" alt="新闻中国" /> </div>
<div id="a_b01"> <img src="admin/images/a_b01.gif" alt="" /> </div>
<!--mainnav end-->
</div>
</div>
<div id="container">
<div class="sidebar">
<h1> <img src="admin/images/title_1.gif" alt="国内新闻" /> </h1>
<div class="side_list">
<ul>
<li> <a href='#'><b> 重庆涉黑富豪黎强夫妇庭审答辩言辞相互矛盾 </b></a> </li>
<li> <a href='#'><b> 发改委:4万亿投资计划不会挤占民间投资空间 </b></a> </li>
<li> <a href='#'><b> 河南2个乡镇政绩报告内容完全一致引关注 </b></a> </li>
</ul>
</div>
<h1> <img src="admin/images/title_2.gif" alt="国际新闻" /> </h1>
<div class="side_list">
<ul>
<li> <a href='#'><b> 日本首相鸠山首次全面阐述新政府外交政策 </b></a> </li>
<li> <a href='#'><b> 黎巴嫩以色列再次交火互射炮弹 </b></a> </li>
<li> <a href='#'><b> 伊朗将于30日前就核燃料供应方案作出答复 </b></a> </li>
<li> <a href='#'><b> 与基地有关组织宣称对巴格达连环爆炸负责 </b></a> </li>
</ul>
</div>
<h1> <img src="admin/images/title_3.gif" alt="娱乐新闻" /> </h1>
<div class="side_list">
<ul>
<li> <a href='#'><b> 施瓦辛格启动影视业回迁计划 推进加州经济复苏 </b></a> </li>
<li> <a href='#'><b> 《沧海》导演回应观众质疑 自信能超越《亮剑》 </b></a> </li>
<li> <a href='#'><b> 《海角七号》导演新片开机 吴宇森等出席 </b></a> </li>
<li> <a href='#'><b> 《四大名捕》敦煌热拍 八主演飙戏火花四溅 </b></a> </li>
</ul>
</div>
</div>
<div class="main">
<div class="class_type"> <img src="admin/images/class_type.gif" alt="新闻中心" /> </div>
<div class="content">
<ul class="class_date">
<li id='class_month'>
<%
Connection conn=null;
PreparedStatement ps=null;
String sql="";
ResultSet rs=null;
//1.加载驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//2.连接数据库
conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","123");
//3.编写sql语句
sql="select * from tb_t281_news_themes ";
//4.传入执行对象
ps=conn.prepareStatement(sql);
//返回结果集
rs=ps.executeQuery();
//遍历结果集
while(rs.next()){
%>
<a href='index.jsp?tid=<%=rs.getInt(1)%>'><b> <%=rs.getString(2) %> </b></a>
<%
}
%>
</li>
</ul>
<div style="background: blue;height:35px;width:947x;text-align: center;line-height: 35px">
<form action="index.jsp" method="post">
<input type="text" name="ss" >
<input type="submit" value="搜索">
</form>
<%
String ss=request.getParameter("ss");
if(ss!=null){
}
%>
</div>
<ul class="classlist">
<li><a href='admin/news_add.html'> 深足教练组:说我们买球是侮辱 朱广沪常暗中支招 </a><span> 2009-10-28 01:03:51.0 </span></li>
<%
sql="select * from tb_t281_news ";
if(ss!=null){
sql+="where ntitle like '%"+ss+"%'";
}
//获取分类栏中选中的数据
String tid=request.getParameter("tid");
//如果不为空则修改sql语句
if(tid!=null){
sql+="where ntid="+Integer.valueOf(tid);
}
//4.传入执行对象
ps=conn.prepareStatement(sql);
//返回结果集
rs=ps.executeQuery();
//遍历结果集
while(rs.next()){
%>
<li><a href='news_read.jsp?nid=<%=rs.getInt(1)%>&username=<%=username%>'><%=rs.getString(3) %></a><span><%=rs.getString(8) %></span></li>
<%
}
%>
<p align="right"> 当前页数:[1/2] <a href="#">下一页</a> <a href="#">末页</a> </p>
</ul>
</div>
<div class="picnews">
<ul>
<li> <a href="#"><img src="admin/images/Picture1.jpg" width="249" alt="" /> </a><a href="#">幻想中穿越时空</a> </li>
<li> <a href="#"><img src="admin/images/Picture2.jpg" width="249" alt="" /> </a><a href="#">国庆多变的发型</a> </li>
<li> <a href="#"><img src="admin/images/Picture3.jpg" width="249" alt="" /> </a><a href="#">新技术照亮都市</a> </li>
<li> <a href="#"><img src="admin/images/Picture4.jpg" width="249" alt="" /> </a><a href="#">群星闪耀红地毯</a> </li>
</ul>
</div>
</div>
</div>
<div id="friend">
<h1 class="friend_t"> <img src="admin/images/friend_ico.gif" alt="合作伙伴" /> </h1>
<div class="friend_list">
<ul>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
<li> <a href="#">中国政府网</a> </li>
</ul>
</div>
</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>