defaultcenter.jsp

网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询

<%@ 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 =4; 

//取得待显示页码 
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()){%>

<TABLE cellSpacing=1 cellPadding=0 width=771 align=center bgColor=#000000 border=0>
 <TR bgColor=#ffffff>
 <TD vAlign=top align=middle width=195>
	<IMG src=<%=rs.getString("eshow_image")%>>
<TABLE width='100%' height="60" border=0 cellPadding=5 cellSpacing=0 >
	<TR>
    <%out.print("<TD align=middle>"+rs.getString("eshow_name")+"["+rs.getString("eshow_sex")+"]</TD>");%>
</TR>
<TR>
    <TD align=middle><span class=time><%=rs.getString("eshow_times")%></span></TD>
</TR>
<TR>
  <TD align=middle><SPAN class=time><a  href='"+rs.getString("eshow_index")+"'><img alt='"+rs.getString("eshow_index")+"'  src='image/homepage.gif' border=0></a><a href='mailto:"+rs.getString("eshow_email")+"'><img alt='电子邮箱:"+rs.getString("eshow_email")+"'  src='image/email.gif' border=0></a><img src='image/QQ.gif' alt='oicq号:"+rs.getString("eshow_oicq")+"'></SPAN></TD>
</TR>
</TABLE></TD>
   <TD vAlign=top width=573><TABLE width='100%' height="148" border=0 cellPadding=5 cellSpacing=0>
<TR>
   <TD></TD>
   </TR>
<TR>
  <TD><B>留言</B>:
    <%out.print(rs.getString("eshow_content"));//数据库内容，留言内容%></TD>
</TR>
  <TR><TD><TABLE cellSpacing=1 cellPadding=2 width='100%' bgColor=#cccccc border=0><TR>
              <TD bgColor=#ffffff><B>回复</B>
			<%out.print(rs.getString("eshow_rep"));//数据库内容，回复%>
			</TD></TR></TABLE></TD></TR>
			<%if(name!=null)
			{%>
			<script src='image/openwin.js'></script>
			<table width='100%'  border='0'><tr><td>
 <form name='form1' method='post' action='default.jsp?rep=true'>
 <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>
</form></td></tr></table>
			<%}%>
</TABLE></TD></TR></TABLE>
  <%rs.next(); 
   i++; 
}
			rs.close();
			stmt.close();%>			
			<br><TABLE cellSpacing=1 cellPadding=0 width=776 align=center bgColor=#000000 border=0>
<tr align=middle bgColor=#ffffff height=22><td>
共<%=intRowCount%>个记录,分<%=intPageCount%>页显示,您所在本页是:第<%=intPageCount%>页
<%for(int j=1;j<=intPageCount;j++)
{out.print("&nbsp;&nbsp;<a href='default.jsp?page="+j+"'>"+j+"</a>");
}%>
</td></TR></TABLE>