guest.jsp

flash+jsp+mysql 的一实例

<%@ page import="java.sql.*,java.net.*"%>
<jsp:useBean id="db" scope="page" class="guest.liupangzii"/>
<jsp:useBean id="server" scope="page" class="guest.page"/>
  <%
  String ac=request.getParameter("ac");
  if(ac!=null && ac.equals("add")){
   String re="&yn=",qq,homepage,title,body;
  qq=request.getParameter("qq");
  homepage=request.getParameter("homepage");
  title=request.getParameter("title");
  body=request.getParameter("body");

  if(title==null || body==null || title.length()<=0 || body.length()<=0){
  re+="留言标题和内容不能为空&up=nos";
  out.print(server.codestring(re));
  db.connclose();
  return;
  }
  if(qq==null)qq="";
  if(homepage==null)homepage="";
  if(db.executeUpdate("insert into dns_flash_guest(icq,home,title,body,times)values('"+qq+"','"+homepage+"','"+server.flash_htmlencode(title)+"','"+server.flash_htmlencode(body)+"','"+server.getTimeA()+"')")){
  re+="留言成功&up=nos";
  }else{
  re+="留言时数据库出现了意外的错误&up=nos";
  }
  out.print(server.codestring(re));
  db.connclose();
  return;
  }
  
  ResultSet rs=db.executeQuery("select count(*) as t from dns_flash_guest");
int row=0,pagesize=5,pagecount=1,intpage=1;
String ejb;
ejb=request.getParameter("ejb");
if(rs.next()){
row=rs.getInt("t");
}
pagecount=(row+pagesize-1)/pagesize;
rs.close(); rs=null;
ResultSet rs2=db.executeQuery("select * from dns_flash_guest order by id desc");
rs2.absolute(server.absolutepage(row,pagesize,ejb));
String book="",title="",counts="",body,hf,qq,homepage;
int count=0,i=0;
for(i=0;i<pagesize;i++){
title=rs2.getString("title");
body=rs2.getString("body");
hf=rs2.getString("hf");
qq=rs2.getString("icq");
homepage=rs2.getString("home");
book+="&title"+i+"="+URLEncoder.encode("标题:"+title);
book+="&body"+i+"="+URLEncoder.encode(body);
if(hf!=null && hf.length()>0){
book+="&hf"+i+"="+URLEncoder.encode("站长回复:"+hf);
}
book+="&qq"+i+"="+qq;
book+="&homepage"+i+"="+URLEncoder.encode(homepage);
counts+=count++;
  if(!rs2.next())break; 
  }
  out.print("&pagesize="+pagesize);
  out.print("&count="+count);
  out.print(book+"&");
  rs2.close(); rs2=null;
  db.connclose();
String pagename="guest.jsp?"; 
	//out.print(server.pages(pagecount,ejb,pagesize,pagename));
	//---------------------------------------------
int top,next,neo,countss;
//if(pagecount>0){
if(ejb!=null){
if((ejb.trim()).length()>0){
intpage=Integer.parseInt(ejb);
}else{
intpage=1;
}
}else{
if(intpage<1)intpage=1;
}
if(intpage>pagecount)intpage=pagecount;
if(pagecount>intpage){
next=intpage+1;
}else{ 
next=1;
}
if(intpage>1){
top=intpage-1;
}else{ 
top=1; 
}
if(pagecount>1){
countss=pagecount;
}else{ 
countss=1; 
}
if(pagecount>1){
neo=1;
}else{ 
neo=1; 
}

//}else{

//} //-------------------------------------
out.print("&next="+next);
out.print("&top="+top);
out.print("&ejb="+ejb);
out.print("&pagecount="+pagecount);
out.print("&load=1");
	%>