新闻发布的分页和评论

读取新闻并评论

  <%
  String sid = request.getParameter("nid");
  int nid = Integer.valueOf(sid);
  Class.forName("oracle.jdbc.OracleDriver");
  String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
  Connection con = DriverManager.getConnection(url, "scott", "wearegood000");
  PreparedStatement ps = con.prepareStatement("select * from news where nid=?");
  ps.setInt(1, nid);
  ResultSet rs = ps.executeQuery();
  if(rs.next()){
  %>
    <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 colspan="2" align="center"><%=rs.getString("ntitle") %></td>
          </tr>
          <tr>
            <td colspan="2"><%=rs.getString("ncontent") %><hr />
            </td>
          </tr>
          <tr>
            <td align="center"><%=rs.getString("ndate") %></td>
            <td align="left"><%=rs.getString("nzz") %> </td>
          </tr>
          <tr>
            <td colspan="2" align="center"></td>
          </tr>
          <tr>
            <td colspan="2"> 　</td>
          </tr>
          <tr>
            <td colspan="2"><hr />
            </td>
          </tr>
        </table>
      </ul>
              <%} %>
      <ul class="classlist">
        <%
        ps = con.prepareStatement("select * from ptext where nid=?");
        ps.setInt(1, nid);
        rs = ps.executeQuery();
        while(rs.next()){
        %>
        <li><%=rs.getString("prn") %></li>
         <a href="删除评论.jsp?nid=<%=rs.getInt("nid")%>">删除</a>
         <a href="#">回复</a>
         <hr>
       <%} %>
      </ul>
      <ul class="classlist">
        <form action="发表评论连接数据库.jsp" method="post" onsubmit="return check()">
          <table width="80%" align="center">
            <tr>
              <td> 评 论 </td>
            </tr>
            <tr>
              <td> 用户名： </td>
              <td><input id="cauthor" name="cauthor" value="<%=session.getAttribute("uname")%>"/>
                IP：
                <input name="cip" value="127.0.0.1"
											readonly="readonly"/>
              </td>
            </tr>
            <tr>
              <td colspan="2"><textarea name="ccontent" cols="70" rows="10"></textarea>
              </td>
            </tr>
            <td><input name="submit" value="发  表" type="submit"/>
              <input type="hidden" value="<%=nid%>" name="nid"> 
              </td>
          </table>
        </form>
      </ul>
    </div>
  </div>
</div>
<div id="friend">
  <h1 class="friend_t"> <img src="../images/friend_ico.gif" alt="合作伙伴" /> </h1>
  <div class="friend_list">

发表评论连接数据库

<%@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"%>
<%
Object uid = session.getAttribute("uid");
int uuid = (Integer)uid;
String cauthor = request.getParameter("cauthor");
String cip = request.getParameter("cip");
String ccontent = request.getParameter("ccontent");
String nid = request.getParameter("nid");
int nnid = Integer.valueOf(nid);
int maxpid = 1;
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
Connection con = DriverManager.getConnection(url, "scott", "wearegood000");
PreparedStatement ps = con.prepareStatement("select max(pid) from ptext");
ResultSet rs = ps.executeQuery();
if(rs.next()){
	maxpid = rs.getInt(1)+1;
}

PreparedStatement ps1 = con.prepareStatement("insert into ptext values (?,?,?,?,sysdate,?)");
ps1.setInt(1, maxpid);
ps1.setInt(2, uuid);
ps1.setInt(3, nnid);
ps1.setString(4, ccontent);
ps1.setString(5, cip);
int i = ps1.executeUpdate();
if(i>0){
	out.print("<script>alert('评论成功');location.href='读取新闻并评论.jsp?nid="+nid+"'</script>");
}else{
	out.print("<script>alert('评论失败');location.href='读取新闻并评论.jsp?nid="+nid+"'</script>");
}

%>

删除评论

<%@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 nnid = request.getParameter("nid");
int nid = Integer.valueOf(nnid);
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:ORCL";
Connection con = DriverManager.getConnection(url, "scott", "wearegood000");
PreparedStatement ps = con.prepareStatement("delete ptext where pid=?");
ps.setInt(1, nid);
ResultSet rs = ps.executeQuery();
if(rs.next()){
	out.print("<script>alert('删除成功');location.href='读取新闻并评论.jsp?nid="+nid+"'</script>");
}else{
	out.print("<script>alert('删除失败');location.href='读取新闻并评论.jsp?nid="+nid+"'</script>");
}

%>

主页的新闻分页

	Class.forName("oracle.jdbc.driver.OracleDriver");
					String url = "jdbc:oracle:thin:@localhost:1521:orcl";
					Connection con = DriverManager.getConnection(url, "scott", "wearegood000");
					PreparedStatement ps = con.prepareStatement("select count(*) from news");
					ResultSet rs = ps.executeQuery();
					int count = 0;
					if (rs.next()) {
						count = rs.getInt(1);
					}
					int ym = 1;
					int mysj = 7;
					int ks = (ym - 1) * mysj + 1;
					int js = ym * mysj;

					int max = count / mysj;
					if (count % mysj != 0) {
						max++;
					}

					String index = request.getParameter("ym");
					if (index != null) {
						ym = Integer.valueOf(index);
					}

					String sql = "select * from (select a.* ,rownum mid from news a)b where mid>=? and mid<=?";
					PreparedStatement ps1 = con.prepareStatement(sql);
					ps1.setInt(1, ks);
					ps1.setInt(2, js);
					ResultSet rs1 = ps1.executeQuery();
					while (rs1.next()) {
				%>
				<li><a href="读取新闻并评论.jsp?nid=<%=rs1.getInt("nid")%>"> <%=rs1.getString("ntitle")%>
				</a> <span> 作者：<%=rs1.getString("nzz")%>&#160;&#160;&#160;&#160;
						<a href='修改新闻.jsp?nid=<%=rs1.getInt("nid")%>'>修改</a>
						&#160;&#160;&#160;&#160; <a
						href='删除.jsp?nid=<%=rs1.getInt("nid")%>'
						onclick='return clickdel()'>删除</a>
				</span></li>
				<li class='space'></li>
				<%
					}
				%>
				<p align="right">
					<a href="admin.jsp">首页</a>
					<a href="admin.jsp?pageIndex=<%=ym>1?ym-1:1%>">上一页</a>
					 &nbsp;当前页数:[<%=ym%>/<%=max%>]&nbsp; 
					 <a href="admin.jsp?ym=<%=ym < max ? mysj + 1 : max%>">下一页</a> <a href="admin.jsp?ym=<%=max%>">末页</a>
				</p>
			</ul>
		</div>
	</div>