defaultcenter.jsp

一个小的图书管理系统供大家参考。有什么意见大家一起讨论一下

<%@ page pageEncoding="gbk" %>
<%@ include file="bytes.jsp"%>
<%@ include file="format.jsp"%>
<%
String name;
name= (String) session.getValue("name");
if(name!=null)
{
out.print("<div align=center>管理员"+session.getValue("name"));
out.print("已经登陆&nbsp;&nbsp;&nbsp;&nbsp;<a href=default.jsp?loginout=true>退出登陆</a></div>");
String loginout=request.getParameter("loginout");//退出登陆
	if(loginout!=null)
	{
		if(loginout.compareTo("true")==0)
		{
			session.removeAttribute("name");
			response.sendRedirect("default.jsp");
		}
	}
String dell=request.getParameter("dell");//删除
	if(dell!=null)
	{
		if(dell.compareTo("true")==0)
			{
			String str_num;
			int num;
			Integer int_num;
			str_num=request.getParameter("id");
			//int_num=Integer.valueOf(str_num);
			int_num=new Integer(0);
			num=int_num.parseInt(str_num);
			Statement stmtdell=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
			String sql1="delete * from eshow_content where ID="+num+"";
			stmtdell.executeUpdate(sql1);
			stmtdell.close();
			response.sendRedirect("default.jsp");
			}
		}//删除完
String rep=request.getParameter("rep");//回复
		if(rep!=null)
		{
			if(rep.compareTo("true")==0)
			{
				String rep_text,rep_str_num;
				int rep_num;
				Integer rep_intnum;
				rep_text=request.getParameter("reptext");
				rep_str_num=request.getParameter("repid");
				rep_intnum=new Integer(0);
				rep_num=rep_intnum.parseInt(rep_str_num);
				Statement stmtrep=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
				String sql2="update eshow_content set eshow_rep='"+rep_text+"' where ID="+rep_num+"";
				sql2=Bytes(sql2);
				sql2=format(sql2);
				stmtrep.executeUpdate(sql2);
				stmtrep.close();
				response.sendRedirect("default.jsp");
			}
		}//回复完
}//判断session
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from eshow_content order by eshow_times desc"; 
ResultSet rs=stmt.executeQuery(sql); //操作数据库
 //参照了杰诺分页
  int intPageSize; //一页显示的记录数
  int intRowCount; //记录总数 
  int intPageCount; //总页数 
  int intPage; //待显示页码 
  String  strPage; 
  int i; 
  
//设置一页显示的记录数 
 intPageSize =6; 

//取得待显示页码 
strPage = request.getParameter("page"); 
if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
  intPage = 1; 
  } else{//将字符串转换成整型 
intPage = java.lang.Integer.parseInt(strPage); 
}
if(intPage< 1){
intPage = 1; 
} 
//获取记录总数 
rs.last(); 
intRowCount = rs.getRow(); 
//记算总页数 
intPageCount = (intRowCount+intPageSize-1) / intPageSize; 
//调整待显示的页码 
if(intPage >intPageCount) intPage = intPageCount; 
if(intPageCount >0){ 
//将记录指针定位到待显示页的第一条记录上 
rs.absolute((intPage-1) * intPageSize+1); 
//显示数据 
}
i = 0; 
while(i< intPageSize && !rs.isAfterLast()){
out.print("<TABLE cellSpacing=1 cellPadding=0 width=771 align=center bgColor=#000000 border=0>");
    out.print("<TR bgColor=#ffffff>");
      out.print("<TD vAlign=top align=middle width=180>");
	  out.print("<IMG src="+rs.getString("eshow_image")+">");//数据库内容，头像
          out.print("<TABLE cellSpacing=0 cellPadding=5 width='100%' border=0>");
              out.print("<TR>");
                out.print("<TD align=middle>"+rs.getString("eshow_name")+"["+rs.getString("eshow_sex")+"]</TD>");//数据库内容，名称，性别
             out.print("</TR>");
              out.print("<TR>");
               out.print("<TD align=middle><SPAN class=time>"+rs.getString("eshow_times")+"</SPAN></TD>");//数据库内容，时间
             out.print("</TR>");
        out.print("</TABLE></TD>");
      out.print("<TD vAlign=top width=588><TABLE cellSpacing=0 cellPadding=5 width='100%' border=0>");
           out.print("<TR>");
             out.print("<TD><TABLE cellSpacing=1 cellPadding=2 width='100%' bgColor=#cccccc border=0><TR><TD bgColor=#ffffff><TABLE cellSpacing=0 cellPadding=0 width='100%' border=0><TR align=middle><TD width='30%'>");
			out.print("<A  href='"+rs.getString("eshow_index")+"'><IMG alt='"+rs.getString("eshow_index")+"'  src='image/homepage.gif' border=0></A>");//数据库内容，主页
			out.print("</TD><TD width='30%'>");
			 out.print("<A href='mailto:"+rs.getString("eshow_email")+"'><IMG alt='电子邮箱:"+rs.getString("eshow_email")+"'  src='image/email.gif' border=0></A>");//数据库内容，电子邮箱
			 out.print("</TD><TD width='30%'>");
			 out.print("<IMG src='image/QQ.gif' alt='oicq号:"+rs.getString("eshow_oicq")+"'>");//数据库内容，回复
			 out.print("</TD></TR></TABLE></TD></TR></TABLE></TD></TR>");
           out.print("<TR>");
              out.print("<TD><B>留言</B>:");
			  out.print(rs.getString("eshow_content"));//数据库内容，留言内容
			  out.print("</TD></TR><TR><TD><TABLE cellSpacing=1 cellPadding=2 width='100%' bgColor=#cccccc border=0><TR>");
              out.print("<TD bgColor=#ffffff><B>回复</B>:");
			out.print(rs.getString("eshow_rep"));//数据库内容，回复
			out.print("</TD></TR></TABLE></TD></TR>");
			if(name!=null)
			{
			out.print("<script src='image/openwin.js'></script>");
			//out.print("<TABLE cellSpacing=1 cellPadding=2 width='100%' bgColor=#cccccc border=0><TR><td bgColor=#ffffff><a href=default.jsp?id="+rs.getString("ID")+"&dell=true>删除</a></td><td bgColor=#ffffff><a href=javascript:turnit('a"+rs.getString("ID")+"')>回复</a></td></tr>");
			//out.print("<tr id=a"+rs.getString("eshow_index")+"><td bgColor=#ffffff><form name='form1' method='post' action='default.asp?rep=true><textarea name='text'>"+rs.getString("eshow_index")+"</textarea><input type='submit' name='Submit' value='回复'><input type='button' name='Submit' value='返回' onclick=javascript:turnit('a')><input name='id' type='hidden' id='id' value=></form></td><td>1</td></tr>");
			//out.print("</table>");
			  out.print("<table width='100%'  border='0'><tr><td>");
  out.print("<form name='form1' method='post' action='default.jsp?rep=true'>");
  out.print("<textarea name='reptext' cols='60' rows='3'>"+rs.getString("eshow_rep")+"</textarea><input name='repid' type='hidden' value='"+rs.getString("ID")+"'><input type='submit' name='Submit' value='回复'>&nbsp;&nbsp;&nbsp;&nbsp;<a href=default.jsp?id="+rs.getString("ID")+"&dell=true>删除</a>");
  out.print("</form></td></tr></table>");
			}
			out.print("</TABLE></TD></TR></TABLE>");
  rs.next(); 
   i++; 
}
			rs.close();
			stmt.close();						
			out.print("<br><TABLE cellSpacing=1 cellPadding=0 width=776 align=center bgColor=#000000 border=0>");
out.print("<tr align=middle bgColor=#ffffff height=22><td>");
//out.print(rscount+"个记录：");
//out.print("本页第:&nbsp;"+pgcount+"&nbsp;页&nbsp;&nbsp;");
//for(int j=1;j<=pgcount;j++){out.print("&nbsp;<a href=default.jsp?pages="+j+">"+j+"</a>&nbsp;&nbsp;");}
out.print(intRowCount+"个记录,");
out.print("分"+intPageCount+"页,");
out.print("本页是:"+intPageCount+"页,");
for(int j=1;j<=intPageCount;j++)
{out.print("&nbsp;&nbsp;<a href='default.jsp?page="+j+"'>"+j+"</a>");
}
out.print("</td></TR></TABLE>");
			%>