【文章內(nèi)容簡介】 過 SQL 數(shù)據(jù)庫語句建立表，在設(shè)計(jì)表時(shí)，首先設(shè)計(jì)了 2個(gè)基本的表，分別記錄管理員信息和留言信息。 管理員息表： 圖 221 注冊(cè)用戶留言信息表： 圖 2 3 3． 第三章 詳細(xì)設(shè)計(jì) 首頁設(shè)計(jì) 本系統(tǒng)的首頁由圖片 用戶名，留言主題，用戶郵箱，地址，頭像， iqcq，我的主頁以及留言內(nèi)容組成 ，根據(jù)訪客的不同需求選擇不同的界面 ，并且加入了必須填寫所有信息的 JavaScript 特效。 代碼如下： %@ page language=java contentType=text/html。 charset=UTF8 pageEncoding=UTF8 import=.*,.*% % Boolean isLogin=(Boolean)(isLogin)。 Connection conn=null。 PreparedStatement pstmt=null。 ResultSet rs=null。 conn=()。 The genral stf(1mpoyidvc,uh)0jb。5wT pstmt=(conn,select * from t_msg)。 rs=()。 % !DOCTYPE html PUBLIC //W3C//DTD HTML Transitional//EN html head title周婷的留言板 /title meta equiv=ContentType content=text/html。 charset=gb2312 link href= rel=stylesheet type=text/css /head body bgcolor=FFFFFF leftmargin=0 topmargin=0 marginwidth=0 marginheight=0 center ! ImageReady Slices () table id=__01 width=990 height=793 border=0 cellpadding=0 cellspacing=0 tr td rowspan=7 img src=images/ width=12 height=631 alt=/td td height=27 colspan=2 class=tdfont background=images/ a href=[ 留言首頁 ]/a/td td rowspan=7 img src=images/ width=7 height=631 alt=/td /tr tr td colspan=2marquee class=tdfont vspace=5 scrollamount=3 height=15 width=500 align=middle onMouseOver=() onMouseOut=()a href=歡迎來到周婷的留言板！ /a/marquee/td /tr tr td colspan=2table width=762 bordercolor=FF6600 cellspacing=0 cellpadding=0 border=1 tr align=center class=tdfont td height=27 width=200 background=images/留言作者 /td The general staff (1 em ployees in additon to vice president, director, m anager, deputy m anager and special positons outside the contract period) to resign, to give 10 days notice, the project m anager or departm ent m anager, adm inistrative personnel departm ent or elevant responsible person for the relevant visa after departure procedures。 in additon to general staff personnel outside the contract period of turnover m ust ubm it he resignation report, a m onth ahead of schedule, the adm inistrative personnel departm ent, general m anager of visa before separation procedures。 probation em ployees shall pay in advance 5 resignation report, he project m anager or departm ent m anager and adm inistrative personnel departm ent visa before departure。 positve after special reasons did not sign a contract w ith reference to general em ployees Through the staff9 td height=27 background=images/留言信息/td /tr ! start % int floor=1。 while(()){ % tr tdtable width=200 cellspacing=0 cellpadding=0 border=0 tr td colspan=3 align=centerimg src=images/%=(photo) %.gif width=75 height=75/td /tr tr class=tdfont td align=rightNO:%=floor++ %/td td width=22 height=15 img src=images//td td align=left width=90%=(username) %/td /tr /table/td td valign=toptable width=562 cellspacing=0 cellpadding=0 border=0 tr td align=left class=tdfont width=200 標(biāo)題：%=(title) %/td td /td td align=left class=tdfont width=100 時(shí)間：%=(pdate) % % if(isLogin!=null amp。amp。 isLogin){ % a href=./?id=%=(id) % 刪除/a a href=./?state=2amp。id=%=(id) %審核通過/a a href=./?state=3amp。id=%=(id) %審核未通過 /a The genral stf(1mpoyidvc,uh)0jb。5wT %} % /td td /td td /td td width=19 height=16img src=images/ alt=住址 width=16 height=16/td td width=19 height=16img src=images/ alt=郵箱 width=16 height=16/td td width=19 height=16img src=images/ alt=IQCQ width=16 height=16/td td width=19 height=16img src=images/ alt=主頁 width=16 height=16/td td width=19 height=16img src=images/ alt=IP width=16 height=16/td /tr tr td colspan=10 height=75 background=images/ % int state = (state)。 if(state==1){ (管理員未審核 )。 }else if(state==2){ ((content))。 }else{ (審核未通過 )。 } if(isLogin!=null amp。amp。 isLogin){ (/br+(content))。 } % /td /tr /table/td /tr % } (conn,pstmt,rs)。 % ! end The general staff (1 em ployees in additon to vice president, director, m anager, deputy m anager and special positons outside the contract period) to resign, to give 10 days notice, the project m anager or departm ent m anager, adm inistrative personnel departm ent or elevant responsible person for the relevant visa after departure procedures。 in additon to general staff personnel outside the contract period of turnover m ust ubm it he resignation report, a m onth ahead of schedule, the adm inistrative personnel departm ent, general m anager of visa before separation procedures。 probation em ployees shall pay in advance 5 resignation report, he project m anager or departm ent m anager and adm inistrative personnel departm ent visa before departure。 positve after special reasons did not sign a contract w ith reference to general em ployees Through the staff11 /table /td /tr tr height=27 td valign=bottom colspan=2 width=762 height=27 background=images/ /td /tr tr td colspan=2 img src=images/ width=762 height=9 alt=/td /tr tr td colspan=2 width=762 height=380 ! START form action= name=note method=post onsubmit=return c