首先简单介绍一些JavaWeb:
Java Web,是用Java技术来解决相关web互联网领域的技术栈。web包括:web服务端和web客户端两部分。Java在客户端的应用有Java Applet,不过使用得很少,Java在服务器端的应用非常的丰富,比如Servlet,JSP、第三方框架等等。Java技术对Web领域的发展注入了强大的动力。
//其实评论与回复是差不多的(都需要一个表来存数据)所以我以评论为例(供参考)
//这是一个doaddpl.sql代码,
//防止乱码
request.setCharacterEncoding("utf-8");
//接收评论人的编号
Object id = session.getAttribute("uuid");
int uuid = (Integer)id;//强转
//评论人的IP
String pip = request.getParameter("cip");
int nid = Integer.valueOf(request.getParameter("nid"));
//评论内容
String pnr = request.getParameter("ccontent");
//评论主键编号:连接数据库查询到最大编号 然后加1
int nextPid = 1;
//连接数据库
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//连接数据库
Connection con = DriverManager.getConnection(url, "scott", "tiger");
PreparedStatement ps = con.prepareStatement("select max(ppid) from ptextt");
//执行sql语句
ResultSet rs = ps.executeQuery();
if(rs.next()){
nextPid = rs.getInt(1)+1;
}
//连接数据库,添加评论
ps = con.prepareStatement("insert into ptextt values(?,?,?,?,sysdate,?)");
ps.setInt(1, nextPid);
ps.setInt(2, uuid);
ps.setInt(3, nid);
ps.setString(4, pnr);
ps.setString(5, pip);
int i = ps.executeUpdate();
//处理结果集
if(i>0){
out.print("<script>alert('评论成功');location.href='read_news.jsp?nid="+nid+"'</script>");
}else{
out.print("<script>alert('评论失败');location.href='read_news.jsp?nid="+nid+"'</script>");
}
//以下是查询新闻评论的主界面代码的一部分
<%
//查询新闻的评论
ps = con.prepareStatement("select * from ptextt where nid="+nid+" order by ppid");
rs = ps.executeQuery();
while(rs.next()){
%>
<li>
<%=rs.getString("ppnr") %>
<a href="dodelepl.jsp?ppid=<%=rs.getInt(1)%>">删除</a>
<a href="#">回复</a>
</li>
<hr>
<%} %>
//效果图如下
//最重要的分页(得理清是如何到第几条数据就开始进行分页)
//这是分页效果的主要代码
//首先注册驱动类
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
//连接数据库
Connection con = DriverManager.getConnection(url, "scott", "tiger");
//求出数据总条数
PreparedStatement ps = con.prepareStatement("select count(*) from newst");
ResultSet rs = ps.executeQuery();
int count = 0;
if(rs.next()){
count = rs.getInt(1);
}
int pageIndex = 1;//页码
//接收页码
String index = request.getParameter("pageIndex");
if(index!=null){//如果接收到页面,就给页面pageIndex赋值
pageIndex = Integer.valueOf(index);
}
int pageSize = 5;//每页的数据条数,每页5条数据
int maxPage = count/pageSize;
//判断一个页面的数据是否满足当前的条数,不满足则增加一页
if(count%pageSize!=0){
maxPage++;
}
int start = (pageIndex-1)*pageSize+1;
int end = pageIndex*pageSize;
String sql = "select * from(select a.*,rownum mid from newst a)b where tid>=? and tid<=?";
ps = con.prepareStatement(sql);
ps.setInt(1,start);
ps.setInt(2, end);
rs = ps.executeQuery();
while(rs.next()){
%>
<li>
<a href="newspages/read_news.jsp?nid=<%=rs.getInt(1)%>">
<%=rs.getString("ntitle") %>
</a>
<span> 作者:
<%=rs.getString("nzz") %>
     <a href='newspages/update_news.jsp?nid=<%=rs.getInt(1)%>'>修改</a>     
<a href='dodelnews.jsp?nid=<%=rs.getInt(1) %>' onclick='return clickdel()'>删除</a> </span> </li>
<li class='space'></li>
<%} %>
<p align="right">
<a href="admin.jsp">首页</a> <a href="admin.jsp?pageIndex=<%=pageIndex>1?pageIndex-1:1%>">上一页</a>
当前页数:[<%=pageIndex %>/<%=maxPage %>]
<a href="admin.jsp?pageIndex=<%=pageIndex<maxPage?pageIndex+1:maxPage%>">下一页</a>
<a href="admin.jsp?pageIndex=<%=maxPage%>">末页</a>
</p>
</ul>
</div>
</div>
//其中的效果图如下: