jsp留言板(給初學(xué)者)

1、往鏈點(diǎn)點(diǎn)通共享資源，了解更多請登錄jsp留言板源代碼一留言板源代碼一:給jsp初學(xué)者.2000121800:00T|Tjsp留言板源代碼一:給jsp初學(xué)者.作者:precom(皮蛋)acle數(shù)據(jù)表創(chuàng)建.createtableguestbook(lw_titlevar2(100)notnull留言主題lw_authvar2(20)notnull網(wǎng)上大名pkauth_var2(40)主頁地址auth_emailvar2(40)notnull

2、電子信箱pkexpressionvar2(2)notnull表情lw_timevar2(14)notnull發(fā)表回應(yīng)時間answer_numnumber(3)notnull回應(yīng)數(shù)click_numnumber(4)notnull點(diǎn)擊數(shù)auth_ipvar2(16)來源iplw_class1var2(10)notnull留言板大類pklw_class2var2(20)notnull論壇欄目pklw_typevar2(1)notnull留言

3、類別即是否為主貼zt_timevar2(14)主貼時間zt_authvar2(40)主貼emaillw_contentvar2(4000)內(nèi)容constraintpk_guestbookprimarykey(lw_class1lw_class2lw_timelw_auth))stage(initial5Mnext5Mpctincrease1)本文來自:站長之家()詳細(xì)出處參考：View30300104035553.htmljsp留言板源

4、代碼二:給jsp初學(xué)者.2000121800:00T|T作者:precom(皮蛋)2000.12.10guestbook.jsp===========================Stringlurlt=“ahref=guestbook.jsp“l(fā)link=““l(fā)where=“wherelw_type=z“只顯示主貼Enumeratione=request.getParameterNames()while(e.hasMeElement

5、s())Stringname=(String)e.nextElement()try取顯示的頁頁序數(shù)pages=newInteger(request.getParameter(“pages“)).intValue()catch(Exceptione)try取查詢參數(shù)inquire_item=newInteger(request.getParameter(“range“)).intValue()inquire_value=newString

6、(request.getParameter(“findstr“).getBytes(“ISO8859_1“))if(inquire_item==0)inquire_itemt=“l(fā)w_title“elseif(inquire_item==1)inquire_itemt=“l(fā)w_content“elseif(inquire_item==2)inquire_itemt=“l(fā)w_auth“elseif(inquire_item==3)inqu

7、ire_itemt=“l(fā)w_time“elseif(inquire_item==4)inquire_itemt=“l(fā)w_title“l(fā)where=lwhere““inquire_itemt“l(fā)ike%“inquire_value“%“l(fā)urlt=lurlt“range=“inquire_item“catch(Exceptione)try取得參數(shù)留言內(nèi)容lw_class1=newString(request.getParameter(“g

8、bname“).getBytes(“ISO8859_1“))lw_title=newString(request.getParameter(“l(fā)w_title“).getBytes(“ISO8859_1“))lw_auth=newString(request.getParameter(“l(fā)w_auth“).getBytes(“ISO8859_1“))pagetitle=newString(request.getParameter(“pa