chasfz
jsp 留言板
源代码 chasfz
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); guestbook.jsp ===========================
1
chasfz
chasfz
<%@ page contentType="text/html; charset=GB2312" %> <%@ page language="java" import="java.sql.*" %>
xml:namespace prefix = jsp />
<% int pages=1; int pagesize=10; int count=0; int totalpages=0; String countsql="",inqsql="",lwhere="",insert
sql="",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="
查询参数 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_aut
hor"; 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
2
chasfz
chasfz
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")<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,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")<0) out.print("lmsg="+lmsg);
3
chasfz
chasfz
}catch (Exception e) { out.print("错误:"+e);} } catch (Exception e) {} %> <% //验证留言输入项合法性的 javascript String ljs=" "; out.print(ljs); %> <% //留言板界面首部 String ltop="