?? index.jsp
字號(hào):
<html><body bgcolor="lightyellow">
<font color="red" size="5">留言內(nèi)容:</font>
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page import="java.lang.Math.*" %>
<%!
String id = "";
Connection conn=null;
ResultSet rsTmp = null;
Statement stmt=null;
ResultSet rs=null;
String sql = "";
int PageSize = 5;
int Page = 3;
int totalPage=1;
String str = "";
public String ShowOnePage(ResultSet rs, int Page, int PageSize)
{
str = "";
try {
rs.absolute( (Page-1) * PageSize + 1);
}catch(SQLException e) {
}
for(int i=0;i<=(Page-1) * PageSize;i++)
{
try
{
rs.next();
}
catch(Exception e)
{
}
}
for(int iPage=1; iPage<=PageSize; iPage++) {
str += RsToGbook(rs);
try {
if(!rs.next()) break;
}catch(Exception e) {}
}
return str;
}
public String RsToGbook(ResultSet rs)
{
String tt="";
String name="";
String memo="";
String gtime="";
String del="";
String ping="";
String id="";
String ip="";
String update="";
String news_id="";
try{
name=rs.getString("name");
memo=rs.getString("content");
gtime=rs.getString("gtime");
ip=rs.getString("ip");
id=rs.getString("id");
ping=rs.getString("ping");
news_id=rs.getString("news_id");
}
catch(Exception e)
{
System.out.println("出現(xiàn)錯(cuò)誤!") ;
System.out.println();}
if(ping.equals("0"))
ping="<a href=index.jsp?update="+id+"&&id="+news_id+">是</a>";
if(ping.equals("1"))
ping="已被屏蔽!!";
if(del.equals(""))
del="<a href=index.jsp?del="+id+"&&id="+news_id+">刪除</a>";
tt+="<table border='0' width='50%'>";
tt+="第"+news_id+"條新聞";
tt+="<tr><td><table border='0'><tr><td>";
tt+="<b>網(wǎng)名: </b>"+name+"</td><td>";
tt+="</td></tr>";
tt+="<tr><td></td></tr>";
tt+="<tr><td colspan='4'>"+"<b>留言: </b>"+memo+"</td></tr>";
tt+="<tr><td colspan='4'></td></tr>";
tt+="<hr border='1' width='100%'></table>";
tt+="<tr><td>是否屏蔽</td><td>";
tt+=ping+"</td></tr>";
tt+="<tr><td><b>ip地址:</b></td><td>"+ip+"</td></tr>";
tt+="<tr><td><b>是否刪除:</b></td><td>"+del+"</td></tr></table><hr></hr>";
return tt;
}
%>
<% String news_id="";
news_id=request.getParameter("id");
try{
String strurl="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:/Program Files/Apache Group/Tomcat 4.1/webapps/examples/jsp/db1.mdb";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection(strurl);
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from gbook where news_id="+news_id+" order by gtime desc");
if( !rs.next() ){
out.println("<center><font color='blue'>目前還沒有評(píng)論!</font><br><br><br>");
out.println("<center><a href=newsedit.jsp>返回</a><br><br><br>");
return;
}
}
catch(Exception e)
{
out.println("語句輸入錯(cuò)誤!");
}
if(request.getParameter("del")!=null)
stmt.executeUpdate("delete * from gbook where id=" + request.getParameter("del"));
if(request.getParameter("update")!=null )
stmt.executeUpdate("update gbook set ping=1 where id="+request.getParameter("update"));
rsTmp=stmt.executeQuery("select count(*) as mycount from gbook where news_id="+news_id);
rsTmp.next();
int totalrecord = rsTmp.getInt("mycount");
if(totalrecord % PageSize ==0)
{
totalPage = totalrecord / PageSize;
}
else
{
totalPage = (int) Math.floor( totalrecord / PageSize ) + 1;
}
if(totalPage == 0)
{
totalPage = 1;
}
rsTmp.close();
try
{
if(request.getParameter("Page")==null || request.getParameter("Page").equals(""))
{
Page = 1;
}
else
{
Page = Integer.parseInt(request.getParameter("Page"));
}
}
catch(java.lang.NumberFormatException e)
{
Page = 1;
}
if(Page < 1) Page = 1;
if(Page > totalPage) Page = totalPage;
rs=stmt.executeQuery("select * from gbook where news_id="+news_id+" order by gtime desc");
out.println(ShowOnePage(rs, Page, PageSize));
out.println("<br>");
out.println("<center>");
out.println("共"+totalrecord+"條評(píng)論");
out.println("</center>");
%>
<form Action="index.jsp" Method="GET">
<% if(Page!=1)
{
out.println("<a href=index.jsp?Page=1>第一頁</a>");
out.println("<a href=index.jsp?Page="+(Page-1)+">上一頁</a>");
}
if(Page!=totalPage){
out.println("<a href=index.jsp?Page="+(Page+1)+">下一頁</a>");
out.println("<a href=index.jsp?Page="+totalPage+">最后一頁</a>");
}
%>
<p>輸入頁面:<input type="text" name="Page" size="3">頁數(shù):<font color="red"><%=Page%>/<%=totalPage%></font></p>
</form>
</div>
</body>
<center><a href=newsedit.jsp><b>編輯新聞</b></a></center>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -