jsp留言板(给初学者)

jsp留言板源代码一:给jsp初学者.|Tjsp留言板源代码一:给jsp初学者.作者:precom(皮蛋)oracle数据表创建.createtableguestbook(lw_titlevarchar2(100)notnull,--留言主题lw_authorvarchar2(20)notnull,--网上大名pkauthor_httpvarchar2(40),--主页地址author_emailvarchar2(40)notnull,--电子信箱pkexpressionvarchar2(2)notnull,--表情lw_timevarchar2(14)notnull,--发表回应时间answer_numnumber(3)notnull,--回应数click_numnumber(4)notnull,--点击数author_ipvarchar2(16),--来源iplw_class1varchar2(10)notnull,--留言板大类pklw_class2varchar2(20)notnull,--论坛栏目pklw_typevarchar2(1)notnull,--留言类别,即是否为主贴zt_timevarchar2(14),--主贴时间zt_authorvarchar2(40),--主贴emaillw_contentvarchar2(4000),--内容constraintpk_guestbookprimarykey(lw_class1,lw_class2,lw_time,lw_author))storage(initial5Mnext5Mpctincrease1);本文来自:站长之家()详细出处参考：留言板源代码二:给jsp初学者.|T作者:precom(皮蛋)2000.12.10guestbook.jsp===========================htmlheadMETAcontent=text/html;charset=gb2312http-equiv=Content-Typetitle张家界电话黄页(网上114)/title/headstyletype=text/css!--BODY{FONT-FAMILY:宋体,ArialNarrow,TimesNewRoman;FONT-SIZE:9pt}.p1{FONT-FAMILY:宋体,ArialNarrow,TimesNewRoman;FONT-SIZE:12pt}A:link{COLOR:#00793d;TEXT-DECORATION:none}A:visited{TEXT-DECORATION:none}A:hover{TEXT-DECORATION:underline}TD{FONT-FAMILY:宋体,ArialNarrow,TimesNewRoman;FONT-SIZE:9pt}.p2{FONT-FAMILY:宋体,ArialNarrow,TimesNewRoman;FONT-SIZE:9pt;LINE-HEIGHT:150%}.p3{FONT-FAMILY:宋体,ArialNarrow,TimesNewRoman;FONT-SIZE:9pt;LINE-HEIGHT:120%}--/stylebody%@pagecontentType=text/html;charset=GB2312%%@pagelanguage=javaimport=java.sql.*%jsp:useBeanid=testInqscope=pageclass=ymbean.opDb/%intpages=1;intpagesize=10;intcount=0;inttotalpages=0;Stringcountsql=,inqsql=,lwhere=,insertsql=,st=;Stringlw_title=,lw_author=,pagetitle=,author_http=,author_email=,lw_ico=,lw_content=,lw_class1=;Stringauthor_ip=,lw_time=,lw_class2=,lw_type=,zt_time=,zt_author=;intanswer_num=0,click_num=0;intinquire_item=1;Stringinquire_itemt=,inquire_value=;Stringlurlt=ahref=guestbook.jsp?,llink=;lwhere=wherelw_type='z';//只显示主贴/*Enumeratione=request.getParameterNames();while(e.hasMoreElements()){Stringname=(String)e.nextElement();*/try{//取显示的页页序数pages=newInteger(request.getParameter(pages)).intValue();}catch(Exceptione){}try{//取查询参数inquire_item=newInteger(request.getParameter(range)).intValue();inquire_value=newString(request.getParameter(findstr).getBytes(ISO8859_1));if(inquire_item==0)inquire_itemt=lw_title;elseif(inquire_item==1)inquire_itemt=lw_content;elseif(inquire_item==2)inquire_itemt=lw_author;elseif(inquire_item==3)inquire_itemt=lw_time;elseif(inquire_item==4)inquire_itemt=lw_title;lwhere=lwhere+and+inquire_itemt+like'%+inquire_value+%';lurlt=lurlt+range=+inquire_item+&findstr=+inquire_value+&;}catch(Exceptione){}try{//取得参数留言内容lw_class1=newString(request.getParameter(gbname).getBytes(ISO8859_1));lw_title=newString(request.getParameter(lw_title).getBytes(ISO8859_1));lw_author=newString(request.getParameter(lw_author).getBytes(ISO8859_1));pagetitle=newString(request.getParameter(pagetitle).getBytes(ISO8859_1));author_http=newString(request.getParameter(author_http).getBytes(ISO8859_1));author_email=newString(request.getParameter(author_email).getBytes(ISO8859_1));lw_ico=request.getParameter(gifface);lw_content=newString(request.getParameter(lw_content).getBytes(ISO8859_1));StringrequestMethod=request.getMethod();requestMethod=requestMethod.toUpperCase();if(requestMethod.indexOf(POST)0){out.print(非法操作!);return;}//形成其他数据项author_ip=request.getRemoteAddr();lw_time=testInq.getCurrentDate(yyyyMMddHHmmss);lw_class2=2;lw_type=+z;//主贴zt_time=lw_time;zt_author=lw_author;answer_num=0;click_num=0;//================st=',';//保证留言所有数据项的长度在正常范围内if(lw_title.length()50)lw_title=lw_title.substring(0,50);if(lw_author.length()20)lw_author=lw_author.substring(0,20);if(author_http.length()40)author_http=author_http.substring(0,40);if(author_email.length()50)author_email=author_email.substring(0,40);if(lw_content.length()4000)lw_content=lw_content.substring(0,4000);insertsql=insertintoguestbookvalues('+lw_title+st+lw_author+st+author_http+st+author_email+st+lw_ico+st+lw_time+',+answer_num+,+click_num+,'+author_ip+st+lw_class1+st+lw_class2+st+lw_type+st+zt_time+st+zt_author+st+lw_content+');//out.print(insertsql);//插入留言try{Stringlmsg=testInq.executeUpdate(insertsql);if(lmsg.indexOf(executeUpdateok)0)out.print(lmsg=+lmsg);}catch(Exceptione){out.print(错误:+e);}}catch(Exceptione){}%%//验证留言输入项合法性的javascriptStringljs=SCRIPTlanguage=JavaScript\n+!--\n+functionValidInput()\n+{if(document.sign.lw_author.value==\\)\n+{alert(\请填写您的大名。\);\n+document.sign.lw_author.focus();\n+returnfalse;}\n+if(document.sign.lw_title.value==\\)\n+{alert(\请填写留言主题。\);\n+document.sign.lw_title.focus();\n+returnfalse;}\n+if(document.sign.author_email.value!=\\)\n+{if((document.sign.author_email.value.indexOf(\@\)0)//(document.sign.author_email.value.indexOf(\:\)!=-1))\n+{alert(\您填写的EMail无效，请填写一个有效的Email!\);\n+document.sign.author_