jsp留言板(给初学者).doc

jsp留言板源代码一: 给jsp初学者. 2000-12-18 00:00 T|Tjsp留言板源代码一: 给jsp初学者. 作 者: precom (皮蛋) oracle数据表创建. create table guestbook ( lw_title varchar2(100) not null, -留言主题 lw_author varchar2(20) not null, -网上大名 pk author_http varchar2(40) , -主页地址 author_email varchar2(40) not null,-电子信箱 pk expression varchar2(2) not null,-表情 lw_time varchar2(14) not null,-发表回应时间 answer_num number(3) not null,-回应数 click_num number(4) not null,-点击数 author_ip varchar2(16) ,-来源ip lw_class1 varchar2(10) not null,-留言板大类 pk lw_class2 varchar2(20) not null,-论坛栏目 pk lw_type varchar2(1) not null,-留言类别,即是否为主贴 zt_time varchar2(14) ,-主贴时间 zt_author varchar2(40) ,-主贴email lw_content varchar2(4000) ,-内容 constraint pk_guestbook primary key(lw_class1,lw_class2,lw _time,lw_author) ) storage (initial 5M next 5M pctincrease 1); 本文来自: 站长之家() 详细出处参考：/View/30/30010403/5553.htmljsp留言板源代码二: 给jsp初学者. 2000-12-18 00:00 T|T作 者: precom (皮蛋) 2000.12.10guestbook.jsp = 张家界电话黄页(网上114) % int pages=1; int pagesize=10; int count=0; int totalpages=0; String countsql=,inqsql=,lwhere=,insertsql=,st=; String lw_title=,lw_author=,pagetitle=,author_http=,author_e mail=,lw_ico=, lw_content=,lw_class1=; String author_ip=,lw_time=,lw_class2=,lw_type=,zt_time=,zt _author=; int answer_num=0,click_num=0; int inquire_item=1; String inquire_itemt=,inquire_value=; String lurlt=a href=guestbook.jsp?,llink=; lwhere= where lw_type=z ; /只显示主贴 /* Enumeration e = request.getParameterNames(); while (e.hasMoreElements() String name = (String) e.nextElement(); */ try /取显示的页页序数 pages = new Integer(request.getParameter(pages).intValue(); catch (Exception e) try /取查询参数 inquire_item=new Integer(request.getParameter(range).intValu e(); inquire_value=new String(request.getParameter(findstr).getByt es(ISO8859_1); if(inquire_item=0) inquire_itemt=lw_title; else if(inquire_item=1) inquire_itemt=lw_content; else if(inquire_item=2) inquire_itemt=lw_author; else if(inquire_item=3) inquire_itemt=lw_time; else if(inquire_item=4) inquire_itemt=lw_title; lwhere=lwhere+ and +inquire_itemt+ like %+inquire_value+% ; lurlt=lurlt+range=+inquire_item+&findstr=+inquire_value+& ; catch (Exception e) try /取得参数 留言内容 lw_class1=new String(request.getParameter(gbname).getBytes(ISO885 9_1); lw_title=new String(request.getParameter(lw_title).getBytes(ISO88 59_1); lw_author=new String(request.getParameter(lw_author).getBytes(ISO 8859_1); pagetitle=new String(request.getParameter(pagetitle).getBytes(ISO 8859_1); author_http=new String(request.getParameter(author_http).getBytes( ISO8859_1); author_email=new String(request.getParameter(author_email).getByte s(ISO8859_1); lw_ico=request.getParameter(gifface); lw_content=new String(request.getParameter(lw_content).getBytes(I SO8859_1); String requestMethod=request.getMethod(); requestMethod=requestMethod.toUpperCase(); if(requestMethod.indexOf(POST)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,4 0); if(lw_content.length()4000) lw_content=lw_content.substring(0,4000) ; insertsql=insert into guestbook values(+lw_title+st+lw_author+st+ author_http+st+ author_email+st+lw_ico+st+lw_time+,+answer_num+,+cli ck_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 String lmsg=testInq.executeUpdate(insertsql); if(lmsg.indexOf(executeUpdate ok) % /验证留言输入项合法性的javascript String ljs= n+ !- n+ function ValidInput() n+ if(document.sign.lw_author.value=) n+ alert(请填写您的大名。); n+ document.sign.lw_author.focus(); n+ return false; n+ if(document.sign.lw_title.value=) n+ alert(请填写留言主题。); n+ document.sign.lw_title.focus(); n+ return false; n+ if (document.sign.author_email.value!=) n+ if (document.sign.author_email.value.indexOf() n+ ; out.print(ljs); % % /留言板界面首部 String ltop= n+ n+ n+ n+ n+ n+ n+ n+ 欢迎远方的朋友来张家界旅游观光 n + n+ 主页: 张家界旅游 管理员: 一民 n+ 管理 申请 n+ n+ 按主题 按内 容 n+ 按作者 按日期 按主题&内容 n+ n+ n+ ; out.print(ltop); % 0) try try ResultSet rcount=testInq.executeQuery(countsql); if(rcount.next() count = rcount.getInt(1); rcount.close(); catch (Exception el1) out.println(count record error : +el1+ ); out.println(countsql); totalpages=(int)(count/pagesize); if(counttotalpages*pagesize) totalpages+; st=+ + + 共 +totalpages+ 页，+count+ 条. + 当前页: +pages+ ; out.print(st); /out.print( 共 +totalpages+ 页，+ count+ 条. + 当前页: +pages+); st= + + + + 留言主题 + 回应数 + 点击数 + 作者名 + 发表/回应时间 ; out.print(st); if(count 0 ) ResultSet rs = testInq.executeQuery(inqsql); ResultSetMetaData metaData = rs.getMetaData(); int i; / 跳过pages -1 页,使cursor指向pages并准备显示 for(i=1;i=(pages - 1)*pagesize;i+) rs.next(); /显示第pages页开始 String linestr=; for(i=1;i=pagesize;i+) if(rs.next() lw_title=rs.getString(lw_title); answer_num=rs.getInt(answer_num); click_num=rs.getInt(click_num); lw_author=rs.getString(lw_author); lw_time=rs.getString(lw_time); st=lw_time.substring(0,4)+-+lw_time.substring(4,6)+- +lw_time.substring(6,8)+:+ lw_time.substring(8,10)+:+lw_time.substring(10,12)+ :+lw_time.substring(12,14); lw_ico=rs.getString(expression); author_email=rs.getString(author_email); lw_class1=rs.getString(lw_class1); lw_class2=rs.getString(lw_class2); llink=reply.jsp?lw_class1=+lw_class1+&lw_class2=+lw_ class2+&zt_time=+lw_time+ &zt_author=+author_email; linestr= n + +lw_title+ + +answer_num+ +click_num+ +lw_author+ +st+; out.println(linestr); rs.close(); /显示第pages页结束 st=; out.print(st); int iFirst=1,iLast=totalpages,iPre,iNext; if(pages=totalpages) iNext=totalpages; else iNext=pages + 1; int n=(int)(count/pagesize); if(n*pagesize1) /for(i=1;i=n;i+) out.print(+i+ ); /out.print(); String lt1=返回主页,lt2=第一页,lt3=上一页,lt4=下一 页,lt5=最后一页,lt6=; lt6=+ lt1 + + lurlt + pages=+iFirst+lt2+&nbs p; + lurlt + pages=+iPre+lt3+ + lurlt + pages=+iNext+lt4+ ; + lurlt + pages=+iLast+lt5+ ; ; st=+ + + lt6+ ; out.print(st); catch (Exception e) out.println(error: +e); % % /留言板界面尾部 String lbottom=; lbottom=lbottom+ n+ n+ n+ n+ n+ n+ n+ 发 表 意 见 &nbs p; 加*的内容必须填写 n+ n+ n+ n+ n+ n+ n+ *留言主题： n+ n+ *网上大名： n+ n+ 主页标题： n+ n+ 主页地址： n+ n+ *电子邮件： n+ n+ n+ n+ n+ n+ 请在下面填写你的留言： n+ n+ n+ n+ 表情n+ n+ n+ n+ n+ n+ n+ n+ n+ n+ n+ ; out.print(lbottom); % 本文来自: 站长之家() 详细出处参考：/View/30/30010403/5552.htmljsp留言板源代码三: 给jsp初学者. 2000-12-18 00:00 T|T作 者: precom (皮蛋) 2000.12.10reply.jsp = 张家界电话黄页(网上114) % int pages=1; int pagesize=10; int count=0; int totalpages=0; String countsql=,inqsql=,updatesql=,lwhere=,insertsql=,st= ; String lw_title=,lw_author=,pagetitle=,author_http=,author_e mail=,lw_ico=0, lw_content=,lw_class1=; String author_ip=,lw_time=,lw_class2=,lw_type=,zt_time=,zt _author=; int answer_num=0,click_num=0; int inquire_item=1; String inquire_itemt=,inquire_value=; String lurlt=a href=reply.jsp?; lwhere= where ; /只显示主贴 /* Enumeration e = request.getParameterNames(); while (e.hasMoreElements() String name = (String) e.nextElement(); */ try /取显示的页页序数 pages = new Integer(request.getParameter(pages).intValue(); catch (Exception e) try /取查询参数 lw_class1=new String(request.getParameter(lw_class1).getBytes (ISO8859_1); lw_class2=new String(request.getParameter(lw_class2).getBytes (ISO8859_1); zt_time=new String(request.getParameter(zt_time).getBytes(IS O8859_1); zt_author=new String(request.getParameter(zt_author).getBytes (ISO8859_1); lwhere= where ( lw_class1=+lw_class1+ and lw_class2=+lw_ class2+ and (lw_time=+ zt_time+ or zt_time=+zt_time+ ) and (author_email=+zt_author+ or zt_author=+zt _author+) ) ; lurlt=lurlt+lw_class1=+lw_class1+&lw_class2=+lw_class2+&zt _time=+zt_time+ &zt_author=+zt_author+&; /out.print(lwhere); catch (Exception e) /out.print(error1: +e+); try /取得参数 留言内容 lw_class1=