?? guestbook_005fmanage_jsp.java
字號(hào):
out.print("<a href='GuestBook_Manage.jsp'>返回</a><br />");
}
}
if(action.equals( "updateIsPassed" )){
int id=Integer.parseInt(request.getParameter("id"));
int GuestIsPassed=Integer.parseInt(request.getParameter("GuestIsPassed") );
GuestBook gb_update=new GuestBook();
gb_update.setGuestIsPassed(GuestIsPassed);
int update_success=gb_update.update(id);
if (update_success>0){
if (GuestIsPassed==1){
out.print("審閱修改成功！！！此信息將顯示在前臺(tái)<br />");
}else{
out.print("審閱修改成功！！！此信息將不會(huì)顯示在前臺(tái)<br />");
}
out.print("<a href='GuestBook_Manage.jsp'>返回</a><br />");
}
}else{
//------------留言內(nèi)容顯示 開始-----------------
out.write("\r\n");
out.write("\t\t<table cellspacing=\"1\" cellpadding=\"0\" width=\"95%\" align=\"center\" border=\"0\" class=\"table_td_guest\">\r\n");
out.write("\t\t\t<tr>\r\n");
out.write("\t\t\t\t<td colspan=\"2\"><div align=\"right\"><a href=\"?action=add&GuestType=0\"><img src=\"../images/GuestBook_message.gif\" alt=\"留言\" width=\"83\" height=\"23\" /></a> </div>\r\n");
out.write("\t\t\t\t</td>\r\n");
out.write("\t\t\t</tr>\t\t\r\n");
out.write("\t\t");
GuestBook gb=new GuestBook();
gb.setGuestType(0); //select留言
//gb.setGuestIsPassed(1); //審核留言 0:不顯示 1:顯示 注釋掉:顯示所有
gb.setUser_id(GuestBook_user_id);//GuestBook_user_id網(wǎng)站變量定義留言板用戶 默認(rèn)0
ArrayList al_gb=gb.query();
//分頁 內(nèi)容有3處 變量定義,for,form標(biāo)單
//----分頁變量 定義 start------------
int rowsCount=al_gb.size(); //總記錄數(shù)
int pageSize=15; //每頁記錄數(shù)
int countPage=(int)Math.ceil(al_gb.size()/(double)pageSize);//總頁數(shù)
int curPage=1; //當(dāng)前頁
if(request.getParameter("curPage")==null || request.getParameter("curPage").equals("") ) {
curPage=1;
}else {
try{
curPage=Integer.parseInt( request.getParameter("curPage") );
}catch(Exception e){}
if(curPage<1 || curPage>countPage) curPage=1;
}
int lastPage=(curPage==1?1:curPage-1); //上一頁
int nextPage=(curPage==countPage?countPage:curPage+1); //下一頁
int rowsStart=pageSize*(curPage-1); //開始記錄
int rowsEnd=( (curPage*pageSize<=rowsCount) ? curPage*pageSize:rowsCount);//結(jié)束記錄
//----分頁變量 定義 end------------
//實(shí)現(xiàn)分頁這里 修改 for
//for(int i=0;i<al_gb.size();i++){
for(int i=rowsStart;i<rowsEnd;i++){
GuestBook a_gb=(GuestBook)al_gb.get(i);
out.write(" \r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t <td align=\"center\" width=\"20%\" rowspan=\"3\" class=");
if (i % 2 ==0) {
out.write("\"bgcolor1\" ");
}else{
out.write("\"bgcolor2\" ");
}
out.write(" >\r\n");
out.write("\t\t\t\t \t<div align=\"center\">\r\n");
out.write("\t\t\t\t\t\t");
out.print(a_gb.getGuestName().trim());
out.write("<br />\r\n");
out.write("\t\t\t\t\t\t<img src=\"../images/");
out.print(a_gb.getGuestFace().trim());
out.write("\" width=\"32\" height=\"32\" border=\"0\" /><br />\r\n");
out.write("\t\t\t\t\t\t<hr />來自：");
out.print(a_gb.getGuestFrom().trim());
out.write("\r\n");
out.write("\t\t\t\t\t</div>\t\t\t\t \r\n");
out.write("\t\t\t\t </td>\r\n");
out.write("\t\t\t\t <td width=\"80%\" height=\"24\" class=");
if (i % 2 ==0) {
out.write("\"bgcolor1\" ");
}else{
out.write("\"bgcolor2\" ");
}
out.write(" >\r\n");
out.write("\t\t\t\t\t <strong>留言于：</strong> ");
out.print(gb.formatDate( a_gb.getGuestDatetime() ));
out.write("\r\n");
out.write("\t\t\t\t\t \r\n");
out.write("\t\t\t\t\t <a href=\"");
out.print(a_gb.getGuestEmail().trim());
out.write("\"><img src=\"../images/GuestBook_email.gif\" alt=\"發(fā)封郵件\" width=\"15\" height=\"15\" border=\"0\" align=\"absmiddle\" /></a>\r\n");
out.write("\t\t\t\t\t <img src=\"../images/GuestBook_homePage.gif\" alt=\"電話：");
out.print(a_gb.getGuestTel().trim());
out.write("\" width=\"15\" height=\"14\" border=\"0\" align=\"absmiddle\" />\r\n");
out.write("\t\t\t\t\t <img src=\"../images/GuestBook_icq.gif\" alt=\"QQ:");
out.print(a_gb.getGuestQQ().trim());
out.write("\" width=\"15\" height=\"16\" border=\"0\" align=\"absmiddle\" />\r\n");
out.write("\t\t\t\t </td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t <td valign=\"top\" height=\"67\" class=");
if (i % 2 ==0) {
out.write("\"bgcolor1\" ");
}else{
out.write("\"bgcolor2\" ");
}
out.write(">\r\n");
out.write("\t\t\t\t \t<strong>內(nèi)容是：</strong>");
out.print(a_gb.getGuestContent().trim());
out.write(" \r\n");
out.write("\t\t\t");
//--------回復(fù) 開始---------
GuestBook gb_reply=new GuestBook();
//gb_reply.setGuestIsPassed(1); //審核留言 0:不顯示 1:顯示 注釋掉:顯示所有
gb_reply.setGuestType( a_gb.getGuest_id() );
ArrayList al_gb_reply=gb_reply.query();
for(int ii=0;ii<al_gb_reply.size();ii++){
GuestBook a_gb_reply=(GuestBook)al_gb_reply.get(ii);
out.write("\r\n");
out.write("\t\t\t\t<hr />\r\n");
out.write("\t\t\t\t<strong>回復(fù)于：</strong> ");
out.print(gb.formatDate(a_gb_reply.getGuestDatetime()));
out.write(" 回復(fù)人：");
out.print(a_gb_reply.getGuestName().trim());
out.write("\r\n");
out.write("\t\t\t\t\t <a href=\"?action=del&id=");
out.print(a_gb_reply.getGuest_id());
out.write("\" onClick=\"return confirm('刪除后回復(fù)將不能恢復(fù)，你確定刪除么？')\"><img src=\"../images/GuestBook_recycle.gif\" alt=\"刪除該回復(fù)\" width=\"13\" height=\"13\" border=\"0\" align=\"absmiddle\" /></a>\t\t\t \r\n");
out.write("\t\t\t\t\t");
//---留言審閱----------
if (a_gb_reply.getGuestIsPassed()!=1) {
out.println(" <font color='#FF0000'>回復(fù)未審閱</font>");
out.println(" <a href='?action=updateIsPassed&GuestIsPassed=1&id="+ a_gb_reply.getGuest_id() +"'>審閱</a>");
}else{
out.println(" <a href='?action=updateIsPassed&GuestIsPassed=0&id="+ a_gb_reply.getGuest_id() +"' title='點(diǎn)擊改為未審閱'>審閱</a>");
}
out.write("\r\n");
out.write("\t\t\t\t\r\n");
out.write("\t\t\t\t<br />\r\n");
out.write("\t\t\t\t<strong>");
out.print(a_gb_reply.getGuestName().trim());
out.write("回復(fù)：</strong>");
out.print(a_gb_reply.getGuestContent().trim());
out.write("\t<br />\r\n");
out.write("\t\t\t");
}
//---------回復(fù) 結(jié)束---------
out.write("\t\t\t \r\n");
out.write("\t\t\t\t </td>\r\n");
out.write("\t\t\t\t</tr>\r\n");
out.write("\t\t\t\t<tr>\r\n");
out.write("\t\t\t\t <td height=\"24\" class=");
if (i % 2 ==0) {
out.write("\"bgcolor1\" ");
}else{
out.write("\"bgcolor2\" ");
}
out.write(">\r\n");
out.write("\t\t\t\t \t <a href=\"?action=add&GuestType=");
out.print(a_gb.getGuest_id());
out.write("\"><img src=\"../images/GuestBook_reply.gif\" alt=\"回復(fù)該留言\" width=\"16\" height=\"15\" border=\"0\" align=\"absmiddle\" /></a>\r\n");
out.write("\t\t\t \r\n");
out.write("\t\t\t\t \t <a href=\"?action=del&id=");
out.print(a_gb.getGuest_id());
out.write("\" onClick=\"return confirm('刪除后留言及關(guān)聯(lián)回復(fù)將不能恢復(fù)，你確定刪除么？')\"><img src=\"../images/GuestBook_recycle.gif\" alt=\"刪除該留言\" width=\"13\" height=\"13\" border=\"0\" align=\"absmiddle\" /></a>\t\t\t \r\n");
out.write("\t\t\t\t\t");
//---留言審閱----------
if (a_gb.getGuestIsPassed()!=1) {
out.println(" <font color='#FF0000'>留言未審閱</font>");
out.println(" <a href='?action=updateIsPassed&GuestIsPassed=1&id="+ a_gb.getGuest_id() +"'>審閱</a>");
}else{
out.println(" <a href='?action=updateIsPassed&GuestIsPassed=0&id="+ a_gb.getGuest_id() +"' title='點(diǎn)擊改為未審閱'>審閱</a>");
}
out.write("\r\n");
out.write("\r\n");
out.write("\t\t\t\t </td>\r\n");
out.write("\t\t\t\t</tr>\t\t\t\r\n");
out.write("\t\t\t");
}
out.write("\t\r\n");
out.write("\t\t\t\t\r\n");
out.write("\t\t\t</table>\r\n");
out.write(" <div align=\"center\">\r\n");
out.write("\t <form method=\"get\" action=\"\">\r\n");
out.write("\t\t [<a href=\"?curPage=1\">首頁</a>] \r\n");
out.write("\t\t [<a href=\"?curPage=");
out.print(lastPage);
out.write("\">上一頁</a>] \r\n");
out.write("\t\t [<a href=\"?curPage=");
out.print(nextPage );
out.write("\">下一頁</a>] \r\n");
out.write("\t\t [<a href=\"?curPage=");
out.print(countPage);
out.write("\">尾頁</a>]\r\n");
out.write("\t\t [頁次:<font color=red>1</font>/");
out.print(countPage);
out.write("] \r\n");
out.write("\t\t [共");
out.print(rowsCount);
out.write("條 <font color=red>");
out.print(pageSize);
out.write("</font>條/頁] \r\n");
out.write("\t\t 轉(zhuǎn)到<input name=\"curPage\" size=\"4\" value=\"1\" />頁<input type=\"submit\" value=\"go\" />\r\n");
out.write("\t </form>\r\n");
out.write(" </div>\r\n");
out.write("\r\n");
//------------留言內(nèi)容顯示 結(jié)束-----------------
}
out.write("\r\n");
out.write("<!-------留言板 結(jié)束-------------->\r\n");
out.write("\t <br />\r\n");
out.write(" <br />\r\n");
out.write(" <br />\r\n");
out.write("\r\n");
out.write(" <hr width=\"90%\"/>\r\n");
out.write(" <div align=\"center\">\r\n");
out.write("\t ");
out.print(siteCopyRight);
out.write("<br />\r\n");
out.write("\t 程序開發(fā)：<a href=\"http://www.deepteach.com\" target=\"_blank\" title=\"深度空間深度學(xué)習(xí)\">呂海鵬</a>\r\n");
out.write(" </div>\r\n");
out.write("\r\n");
out.write("\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
try { out.clearBuffer(); } catch (java.io.IOException e) {}
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
_jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -