本文目录一览:
求使用Tomcat+Mysql+Myeclipse搭建的简单留言板的源代码
这个挺简单的啊,我给你点提示吧,自己写比较有感觉,而且印象深,而且就算给你源码,数据库什么的不配置好你也用不了
登陆界面:Login.java
验证:Logincl.java(到数据库验证),验证成功,到留言界面,失败返回登陆界面
留言界面:Message.java(一个文本框,加一个提交按钮,提交到Messagecl,java)
留言处理界面:Messagecl.java(将数据写入数据库)
返回结果界面:Responseview.java(提示成功或者失败)
开源里有没有留言板的源代码,JAVA的
绝对开源,绝对明了的留言板,便于学习的源码
用JAVA写的留言板原代码
/*
* guestbookServlet.java
*
* */
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Date;
/**
*
* */
public class guestbookServlet extends HttpServlet {
boolean debug=false;
String sDBDriver;
Connection conn=null;
ResultSet rs=null;
/** Initializes the servlet.
*/
public void init(ServletConfig config) throws ServletException {
super.init(config);
if(debug)
sDBDriver=new String("sun.jdbc.odbc.JdbcOdbcDriver");
else
sDBDriver=new String("org.gjt.mm.mysql.Driver");
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e){
System.err.println("Driver类初始化:"+e.getMessage());
}
}
/** Destroys the servlet.
*/
public void destroy() {
}
/** Processes requests for both HTTP codeGET/code and codePOST/code methods.
* @param request servlet request
* @param response servlet response
*/
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
response.setContentType("text/html;charset=gb2312");
java.io.PrintWriter out = response.getWriter();
boolean empty=true;
boolean noResult=true;
String sqlStr;
int currentPage=0;
int totalPage=0;
int reccount=0;
ResultSet myrs=null;
String username=request.getParameter("username");
String email=request.getParameter("email");
String ucontent=request.getParameter("ucontent");
String ipage=request.getParameter("ipage");
if(ipage==null||ipage.length()==0)
currentPage=1;
else
currentPage=Integer.parseInt(ipage);
if((username==null||username.length()==0)||(ucontent==null||ucontent.length()==0))empty=true;
else empty=false;
Date myDate=new Date();
//String intime=new String(String.valueOf(myDate.getYear()+1990)+String.valueOf(myDate.getMonth()));
String year=String.valueOf(myDate.getYear()+1900);
String month=String.valueOf(myDate.getMonth()+1);
if(month.length()==1)
month=new String("0"+month);
String days=String.valueOf(myDate.getDate());
if(days.length()==1)
days=new String("0"+days);
String hours=String.valueOf(myDate.getHours());
if(hours.length()==1)
hours=new String("0"+hours);
String minutes=String.valueOf(myDate.getMinutes());
if(minutes.length()==1)
minutes=new String("0"+minutes);
String intime=year+"-"+month+"-"+days+" "+hours+":"+minutes;
if(email==null||email.length()==0)
email=new String("");
if(!empty){
//username=convert(username);
//email=convert(email);
//ucontent=convert(ucontent);
sqlStr="insert into Mintegbook(Mname,Memail,Mcontent,Mtime,Mid) values("+username+","+email+","+ucontent+","+intime+",1)";
getDsnConn();
executeInsert(sqlStr);
}
sqlStr=new String("select Mname,Memail,Mcontent,Mtime from Mintegbook order by Mtime DESC");
getDsnConn();
reccount=getRecordCount("Mintegbook");
if(reccount==0)
noResult=true;
else
noResult=false;
if(!noResult){
int ipageSize=10;
totalPage=getTotalPage("Mintegbook",ipageSize);
if(currentPagetotalPage)
currentPage=totalPage;
int cursor=(currentPage-1)*ipageSize+1;
try{
myrs=executeScrollableQuery(sqlStr);
myrs.absolute(cursor);
}
catch(SQLException e){
noResult=true;
}
}
out.println("HTMLHEADTITLE我的Servlet留言板/TITLE");
out.println("META http-equiv="Content-Type" content="text/html; charset=gb2312"");
out.println("STYLE type="text/css"");
out.println("!--");
out.println(".mytext { font-family: "宋体"; font-size: 12px}");
out.println(" --");
out.println("/STYLE");
out.println("/HEAD");
out.println("BODY bgcolor="#FFFFFF" text="#000000"");
out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext"");
out.println("TRTD height="22" | a href=""我的主页/a | 我的Servlet留言板(A href="mailto:yf188@21cn.com"川石/A制作)/TD/TR");
out.println("TRTD height="1" bgcolor="#999933"/TD/TR");
out.println("/TABLE");
out.println("BR");
out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="0" align="CENTER" class="mytext"");
out.println("TRTD height="8"/TD/TR");
out.println("TRTD height="18" bgcolor="#f7f7f7"DIV align="right"");
out.println("共有 "+reccount + " 条留言 ");
out.println(" 当前第font color=#ff0000"+currentPage+"/font/共 "+totalPage+" 页 ");
if(currentPage1)
out.println(" a href=guestbookServlet?ipage=1首页/a a href=guestbookServlet?ipage="+(currentPage-1)+"上一页/a ");
else
out.println(" 首页 上一页 ");
if(currentPagetotalPage)
out.println(" a href=guestbookServlet?ipage="+(currentPage+1)+"下一页/a a href=guestbookServlet?ipage="+totalPage+"末页/a ");
else
out.println(" 下一页 末页 ");
out.println("/DIV/TD/TR");
out.println("/TABLE");
out.println("BR");
//这里是显示留言内容
if(!noResult){
String dname;
String demail;
String dcontent;
String dtime;
Date temptime;
try{
do{
dname=new String(myrs.getString("Mname"));
demail=new String(myrs.getString("Memail"));
dcontent=new String(myrs.getString("Mcontent"));
try{
dtime=new String(myrs.getObject("Mtime").toString());
}
catch(java.lang.NullPointerException e){
dtime=new String("2001-04-06 12:30");
}
if(dname==null)
dname=new String("川石");
if(demail==null)
demail=new String("yf188@21cn.com");
if(dcontent==null)
dcontent=new String("test");
if(dtime==null)
dtime=new String("2001-04-06 12:30");
dname=convert(dname);
dcontent=convert(dcontent);
//temptime=myrs.getDate("Mtime");
/*
String tempyear=String.valueOf(temptime.getYear()+1900);
String tempmonth=String.valueOf(temptime.getMonth()+1);
if(tempmonth.length()==1)
tempmonth=new String("0"+tempmonth);
String tempdays=String.valueOf(temptime.getDate());
if(tempdays.length()==1)
tempdays=new String("0"+tempdays);
String tempminute=String.valueOf(temptime.getMinutes());
if(tempminute.length()==1)
tempminute=new String("0"+tempminute);
String temphours=String.valueOf(temptime.getHours());
if(temphours.length()==1)
temphours=new String("0"+temphours);
String dtime=tempyear+" 年 "+ tempmonth +" 月 "+ tempdays +" 日 " + temphours+ " 时 "+ tempminute + " 分 ";
*/
out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");
out.println("TRTD姓名 A href="mailto:"+demail+"""+dname+"/A 留言时间:"+dtime+"/TD/TR");
out.println("TRTD height="10"/TD/TR");
out.println("TRTD height="10""+dcontent+"/TD/TR");
out.println("/TABLE");
out.println("HR width="600" size="1"");
}while(myrs.next());}
catch(SQLException e){
out.println("error found");
}
}
else{
out.println("还没有留言!");
}
//结束
out.println("FORM name="form1" method="post" action="guestbookServlet"");
out.println("TABLE width="600" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");
out.println("TRTD width="80"姓名:/TDTDINPUT type="text" name="username"*/TD/TR");
out.println("TRTDEmail:/TDTDINPUT type="text" name="email"*/TD/TR");
out.println("TRTD留言:/TDTDTEXTAREA name="ucontent" cols="65" rows="4"/TEXTAREA/TD/TR");
out.println("/TABLE");
out.println("TABLE width="400" border="0" cellspacing="0" cellpadding="6" align="CENTER" class="mytext"");
out.println("TRTD height="15" width="200" /TDTD /TD/TR");
out.println("TRTDDIV align="RIGHT"INPUT type="button" name="Button" value=" 提 交 " style="cursor:hand" onclick="javascript:check()"/DIV/TD");
out.println("TDINPUT type="reset" name="Submit2" value=" 重 置 "/TD/TR");
out.println("/TABLE");
out.println("/FORM");
out.println("TABLE width="400" border="0" cellspacing="0" cellpadding="4" align="CENTER" class="mytext"");
out.println("TRTD width="15" /TD/TR");
out.println("TRTDDIV align="LEFT"/DIV/TD/TR");
out.println("TRTD /TD/TR");
out.println("/TABLE");
out.println("/BODY");
out.println("/HTML");
out.println("SCRIPT language="javascript"");
out.println("function check(){");
out.println("if(form1.username.value.length1||form1.ucontent.value.length1)");
out.println("{alert(姓名和留言是必须有的!);}else{form1.submit();}}");
out.println("/SCRIPT");
out.close();
}
/** Handles the HTTP codeGET/code method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
/** Handles the HTTP codePOST/code method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, java.io.IOException {
processRequest(request, response);
}
protected void getDsnConn(){
String sqlUrl="jdbc:mysql://10.0.0.1/你申请用户名?user=你的名字password=你的帐号";
try{
if(debug)
conn=DriverManager.getConnection("jdbc:odbc:ODBC源","用户名","密码口令");
else
conn=DriverManager.getConnection(sqlUrl);
}
catch(SQLException es){
System.err.println("和库连接时出错:"+es.getMessage());
}
}
protected void executeInsert(String sqlStr){
try{
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
}
catch(SQLException es){
System.err.println("执行插入时:"+es.getMessage());
}
}
protected void executeUpdate(String sqlStr){
try{
Statement stmt=conn.createStatement();
stmt.executeUpdate(sqlStr);
}
catch(SQLException e){
System.err.println("error in query record");
}
}
//查寻
protected ResultSet executeQuery(String sqlStr){
rs=null;
try{
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sqlStr);
}
catch(SQLException ex){
System.err.println("执行查寻出错:"+ex.getMessage());
}
return rs;
}
protected ResultSet executeScrollableQuery(String sqlStr){
rs=null;
try{
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=stmt.executeQuery(sqlStr);
}
catch(SQLException e){
System.err.println("执行动态查寻出错");
}
return rs;
}
//得到表记录总数
protected int getRecordCount(String sTableName){
rs=null;
int CountResult=0;
String sqlStr="select count(*) from "+sTableName;
try{
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sqlStr);
if(rs.next())
CountResult=rs.getInt(1);
rs=null;
stmt.close();
}
catch(SQLException ex){
System.err.println(ex.getMessage());
}
return CountResult;
}
//得到记录总页数
protected int getTotalPage(String sTableName,int iPageSize){
int totalPage;
int totalRecNum=getRecordCount(sTableName);
if(totalRecNum%iPageSize==0)
totalPage=totalRecNum/iPageSize;
else
totalPage=totalRecNum/iPageSize+1;
return totalPage;
}
protected String convert(String InputStr){
String converted=new String();
byte[] bytes;
try{
bytes=InputStr.getBytes("ISO8859-1");
converted=new String(bytes,"GB2312");
}
catch(java.io.UnsupportedEncodingException e){
System.out.print("error");
}
return converted;
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
}
网页留言板代码
link href="../../css/user.css" rel="stylesheet" type="text/css"
script language="JavaScript" src="../../js/common.js"/script
script language="JavaScript" src="../../js/ubbcode.js"/script
script language="JavaScript"
function formCheck()
{
if (document.theform.nickname.value == "")
{
alert("请填写名字。");
document.theform.nickname.focus();
return false;
}
if (document.theform.content.value == "")
{
alert("请填写留言内容。");
document.theform.content.focus();
return false;
}
theform.Submit.disabled=true;
return true;
}
function showimage()
{
document.images.faceimg.src=face_image[parseInt(document.theform.face.options[document.theform.face.selectedIndex].value)];
}
body background=""
center
IFRAME marginHeight=0 marginWidth=0 noResize scrolling=no frameBorder=0 src=";bgcolor=ffffff" width=468 height=60
/IFRAME
/center
p /p
form name="theform" onsubmit="return formCheck();" method="post" action="get_post.asp"
TABLE width=550 border=0 align="center" cellPadding=0 cellSpacing=0
table width="550" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="#ebebeb"
tr
td class="pt9"
p*名字:
input name="nickname" type="text" size="15" maxlength="12" class="inputbox1"
br
Email:
input name="email" type="text" size="15" maxlength="45" class="inputbox1"
主页地址:
input name="hp_url" type="text" value="http://" size="22" maxlength="125" class="inputbox1"
/p
/td
tr
td width="409" class="pt9" !--因为图片连接的原因,本文件只适合include在script/dirname下的文件 --
img onClick=bold() src="../../images/icon_editor_bold.gif" width="23" height="22" alt="粗体" border="0"img onClick=italicize() src="../../images/icon_editor_italicize.gif" width="23" height="22" alt="斜体" border="0"img onClick=underline() src="../../images/icon_editor_underline.gif" width="23" height="22" alt="下划线" border="0"
img onClick=center() src="../../images/icon_editor_center.gif" width="23" height="22" alt="居中" border="0"img onClick=hyperlink() src="../../images/icon_editor_url.gif" width="23" height="22" alt="超级连接" border="0"img onClick=email() src="../../images/icon_editor_email.gif" width="23" height="22" alt="Email连接" border="0"img onClick=image() src="../../images/icon_editor_image.gif" width="23" height="22" alt="图片" border="0"img onClick=flash() src="../../images/icon_swf.gif" width="23" height="22" alt="Flash图片" border="0"img onClick=showcode() src="../../images/icon_editor_code.gif" width="23" height="22" alt="编号" border="0"img onClick=quote() src="../../images/icon_editor_quote.gif" width="23" height="22" alt="引用" border="0"img onClick=list() src="../../images/icon_editor_list.gif" width="23" height="22" alt="目录" border="0"
br
tr
td
table width="100%" border="0" cellpadding="0" cellspacing="0" class="pt9"
tr
td width="40" valign="top"*留言:/td
tdtextarea name="content" cols="50" rows="6" id="content"/textarea/td
/tr
/table
p align="center"
input name="replyer" type="hidden" value=""
input name="reply_content_id" type="hidden" value=""
input name="userid" type="hidden" value="79444"
input type="submit" name="Submit" value="确认留言" class="button1"
input type="reset" name="Reset" value="取消重写" class="button1"
/p/td
/tr
/table
p /p
/form
table width="550" border="0" align="center" cellpadding="2" cellspacing="1"
tr
td width="88" valign="top"
img src=""
/td
td width="417"TABLE width="100%" border=0 cellPadding=0 cellSpacing=0 class="pt9"
TBODY
TR
TD width=43 colSpan=2 height=29 rowSpan=2IMG height=29
src="../../images/1_r2_c2.gif" width=43 border=0/TD
TD background=../../images/1_r2_c4.gif height=10/TD
TD width=37 colSpan=2 height=29 rowSpan=2IMG height=29
src="../../images/1_r2_c6.gif" width=37 border=0/TD
/TR
TR
TD height=19 TABLE cellSpacing=0 cellPadding=0 width="100%" border=0
TBODY
TR
TD class="pt9" font class="filtertxt"dsfsd/font /TD
TD width="168" align=right class="pt9" /TD
/TR
/TBODY
/TABLE/TD
/TR
TR
TD width=10 background=../../images/1_r4_c2.gif/TD
TD width=27/TD
TD width="100%" height=50 img src="../../images/blank.gif" width="5" height="5"
br fdsfsdbdfssdfsdf/b br img src="../../images/blank.gif" width="5" height="5" /TD
TD width=22/TD
TD width=15 background=../../images/1_r4_c2.gif/TD
/TR
TR
TD background=../../images/1_r4_c2.gif/TD
TD/TD
TD height=1hr width="100%" size="1" noshade/TD
TD/TD
TD background=../../images/1_r4_c2.gif/TD
/TR
TR
TD width=43 colSpan=2 height=26 rowSpan=2 IMG height=26 src="../../images/1_r6_c2.gif" width=43 border=0/TD
TD align=right height=17
img src="../../images/no_home.gif" align="absmiddle" img src="../../images/no_email.gif" align="absmiddle" FONT color=#336600[2006-7-17 21:24:00]/FONT /TD
TD width=43 colSpan=2 height=26 rowSpan=2IMG height=26
src="../../images/1_r6_c6.gif" width=37 border=0/TD
/TR
TR
TD background=../../images/1_r2_c4.gif
height=9/TD
/TR
/TBODY
/TABLE/td
/tr
/table
BR
form
table width="516" border="0" cellspacing="0" cellpadding="0" align="center"
tr
td
table width=100% border=0 cellspacing=1 cellpadding=2 class=pt9trtd height=13img src=../../images/turnpage2_1.gif align=absmiddle border=0 img src=../../images/turnpage2_2.gif align=absmiddle border=0 b1/b | img src=../../images/turnpage2_3.gif align=absmiddle border=0 img src=../../images/turnpage2_4.gif align=absmiddle border=0/tdtd class=pt9 width=140 align=right共font color=red1/font页第input type=text name=JumpPage maxlength=3 size=3页input type=button value=转页 onClick="location.href='/script/user/list.asp?userid=79444page=' + this.form.JumpPage.value;"/td/tr/table
/td
/tr
/table
/form
网页留言板的代码
meta http-equiv="Content-Type" content="text/html;charset=gb2312"
%@ Language=VBScript %
!--#INCLUDE FILE="config.asp" --
!--#INCLUDE FILE="guest_lib.asp" --%
dim ASPBook
dim StrSQL
if not isempty(request("page")) then
Mypage=cint(Request("page"))
else
Mypage=1
end if
set ASPBook = Server.CreateObject("ADODB.Recordset")
StrSQL = "Select * from guest order by ID desc"
ASPBook.open StrSQL,conn,1,1
ASPBook.pagesize=Mypagesize
maxpages=cint(ASPBook.pagecount)
totalsize=cint(Mypagesize)
ASPBook.absolutepage=Mypage
GuestTotal=ASPBook.RecordCount
if cint(Mypage) 1 then
if cint(Mypage) maxpages then
MESSAGE("li没有你所想去的页数!/li")
Response.End
end if
end if
HEADER "显示留言"
MyMenu
%
html
head
title[ 客户留言系统 ]/title
meta http-equiv="Content-Type" content="text/html; charset=gb2312"
link rel="stylesheet" href="css/colorbird.css"
style
BODY {SCROLLBAR-FACE-COLOR: #D4D0C8; SCROLLBAR-HIGHLIGHT-COLOR: #999999; SCROLLBAR-SHADOW-COLOR: #999999; SCROLLBAR-3DLIGHT-COLOR: #FFFFFF; SCROLLBAR-ARROW-COLOR: #000000; SCROLLBAR-TRACK-COLOR: #E3E3E3; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
/style
/head
body bgcolor="#FFFFFF" topmargin="0" leftmargin="0"
p align="center"a href="gb_sign.asp"
img border="0" src="IMAGES/sign.gif" alt="签写留言"/a/p
tdp align="center"font color="#000000"bfont face="Arial" size="1"Total of
font color="#ff0000"%=GuestTotal%/font messages, /font/b/font
font face="Arial"font size="1" color="#ff0000"%=MyPageSize%/fontfont size="1"
messages per page, You are on page/font/font/fontfont color="#FF0000"font size="1" face="Arial"%=cint(Mypage)%/font
%=Greeting%... font color="#000000"%PageLink%/font/p
/font
div align="right"/div/td
div align="center"
center
table width="590" border="0" cellspacing="0" cellpadding="0"
tr
td height="50"a href="gb_sign.asp"img src="IMAGES/shop.gif" alt="签写留言" width="89" height="25" border="0"/a/td
/tr
/table
table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#6699CC" width="590" height="197"
tr
td align="center" height="197"
table width="590" border="0" cellspacing="0" cellpadding="4" style="border-collapse: collapse" height="35" bgcolor="#F7F7F7"
tr
/tr
tr
/tr
/table
table cellspacing="1" border="1" width="592" height="23" style="border-collapse: collapse" cellpadding="0" bgcolor="#C6C3C6" bordercolorlight="#FFFFFF" bordercolordark="#000000" background="table.gif"
tr
td align="right" width="130" height="23"
p align="left"b
font color="#FFFFFF"留言者 :/font/b/p
/td
td align="right" width="445" height="23"
p align="left"b
font color="#FFFFFF"留言内容 :/font/b/p
/td
/tr
/table
table width="590" border="0" cellspacing="0" cellpadding="0"
%
If ASPBook.Eof or ASPBook.Bof then
Response.Write "TR"
Response.Write "TD bgcolor=" Color1 " align=center colspan=6FONT STYLE=font-size:9pt对不起,目前还没有任何留言,如要留言,请按“我要留言”图片!/FONT/TD"
else
i = 0
total = 0
do until ASPBook.Eof or total = totalsize
if i = 0 then
CColor = Color1
else
CColor = Color2
end if
%
tr bgcolor="%=CColor%"
td
table width="590" border="1" cellspacing="8" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"
tr
/tr
/table
table width="590" border="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111" height="1"
tr
td width="137" rowspan="3" height="1" valign="top"
table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="99%" id="AutoNumber2" height="96"
tr
td width="100%" align="center" height="12"b%=ASPBook("名字")%/b/td
/tr
tr
td width="100%" align="center" height="54"%if ASPBook("性别") = "boy" then%
br
img src="images/boy.gif" alt="英俊潇洒的 %=ASPBook("名字")% 先生" align="middle" border="0"
%elseif ASPBook("性别") = "girl" then%
img src="images/girl.gif" alt="美丽又温柔的 %=ASPBook("名字")% 小姐" align="middle" border="0"
br
%end if%/td
/tr
tr
td width="100%" align="center" height="28"Form: %=ASPBook("来自")% /td
/tr
/table
/td
td width="234" height="1"font size="1"
font color="#000000" class="littel"
img src="./icons/em%=ASPBook("表情")%.gif" border="0" align="ABSCENTER"/fontfont color="#0000FF" class="littel"On:
%=ASPBook("留言日期")%/font/fontfont size="1" color="#0000FF"
/font/td
td width="212" height="1"%if ASPBook("邮件")"" then%
a href="mailto:%=ASPBook("邮件")%"
img src="images/email.gif" ALIGN="absmiddle" border="0" width="15" height="16"/a
%end if% %if ASPBook("主页")"" and ASPBook("主页")"http://" then%
a href="%=ASPBook("主页")%" Target="_blank"
img src="images/home.gif" ALIGN="absmiddle" border="0"/a
%end if% %if ASPBook("ICQ")"" then%
img src="images/icq.gif" alt="ICQ:%=ASPBook("ICQ")%" align="absmiddle" border="0" width="15" height="16"
%if ASPBook("OICQ")"" then% %end if%
a href=";%=ASPBook("OICQ")%" target="_blank"
img src="images/oicq.gif" alt="OICQ:%=ASPBook("OICQ")%" align="absmiddle" border="0" width="16" height="16"/a
%end if%
img src="images/ip.gif" alt="%=ASPBook("IP")%" align="absmiddle" border="0" width="13" height="16"
img src="images/system.gif" alt="%=ASPBook("系统")%" align="absmiddle" border="0" width="15" height="16"/td
/tr
tr
td width="450" height="14" colspan="2" valign="top"%=ASPBook("留言")% /td
/tr
tr
%if ASPBook("Reply")"" then%td width="450" height="17" colspan="2" valign="top"
font color="#FF0000"Reply :b /b/font
font color="#0000FF" class="littel" size="1"(%=ASPBook("Reply_Date")%)/fontbr
img src="./icons/em%=ASPBook("Reply_Icon")%.gif" border="0" align="ABSCENTER"%=ASPBook("Reply")%/font/td
%end if%/tr
/table
table width="590" border="0" cellspacing="0" cellpadding="0" style="border-collapse: collapse" bordercolor="#111111"
tr
td width="137" rowspan="2" /td
td width="450"/td
/tr
tr
td width="450" /td
/tr
/table
table width="590" height="24" border="0" cellpadding="0" cellspacing="1" bordercolor="#DCE8F3" bordercolorlight="#FFFFFF" bgcolor="#DCE8F3" style="border-collapse: collapse"
tr
td align="right" width="131" height="20"
p align="left" /p
/td
td align="right" width="448" height="20"
a href="gb_reply.asp?page=%=mypage%Number=%=ASPBook("ID")%"
img src="images/quote.gif" alt="回复该留言" align="absmiddle" border="0" width="16" height="16"/a
a href="gb_delete.asp?page=%=mypage%Number=%=ASPBook("ID")%"
img src="images/recycle.gif" alt="删除该留言" align="absmiddle" border="0" width="16" height="16"/a/td
/tr
/table
/td
/tr
%
ASPBook.MoveNext
i = i + 1
if i = 2 then i = 0
total = total + 1
loop
% %END IF%
/table
%COPYRIGHT%
table border="0" cellpadding="2" cellspacing="0" width="590" height="1" bgcolor="#F7F7F7" style="border-collapse: collapse" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF"
tr
td width="131" height="1"
p align="center"/p
/td
td align="right" width="448" height="1"font color="#000000"%PageLink%
/font /td
/tr
/table
/td
/tr
/table
/center
/div
div align="center"
center
table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="592" id="AutoNumber1"
tr
td width="100%"
p align="center"a href="gb_sign.asp" /abr
/p
/td
/tr
/table
/center
/div
/body
/html
%
function PageLink
PageShowSize = 10
Scriptname=Request.Servervariables("script_name")
PageNextSize=int((MyPage-1)/PageShowSize)+1
Pagetpage=int((GuestTotal-1)/MyPageSize)+1
if Maxpages 1 then
if PageNextSize 1 then
PagePrev=PageShowSize*(PageNextSize-1)
Response.write "a href='" Scriptname "?page=" PagePrev "'[]/a-"
end if
if Mypage-1 0 then
Prev_Page = MyPage - 1
Response.write "a href='" Scriptname "?page=" Prev_Page "'[]/a "
end if
if maxpages=PageNextSize*PageShowSize then
PageSizeShow = PageShowSize
else
PageSizeShow = Maxpages-PageShowSize*(PageNextSize-1)
end if
for PageCounterSize=1 to PageSizeShow
PageLink = (PageCounterSize+PageNextSize*10)-10
if PageLink cint(Mypage) then
Response.write "a href='" Scriptname "?page=" PageLink "'[" PageLink "]/a "
else
Response.Write PageLink " "
end if
next
if Mypage+1 =Pagetpage then
Next_Page = MyPage + 1
Response.write "a href='" Scriptname "?page=" Next_Page "'[]/a"
end if
if maxpages PageShowSize*PageNextSize then
PageNext = PageShowSize * PageNextSize + 1
Response.write "-a href='" Scriptname "?page=" PageNext "'[]/a"
end if
else
Response.write "[1]"
end if
END function
set ASPBook=nothing
conn.Close
set conn = nothing
%