后台管理框架,登陆,退出,分页
顶头上常用几句
<%@ page language="java" contentType="text/html; charset=GB2312" import="java.sql.*"%>
<jsp:useBean id="db" class="com.pp.db.DBOperation"></jsp:useBean>
<link rel="stylesheet" type="text/css" href="../css/style.css">
Admin_Main.jsp
<%@ page contentType="text/html; charset=GBK" language="java" buffer="32kb"%>
<%@ include file="Session.jsp"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>网站联盟后台管理系统</title>
</head>
<frameset rows="*" cols="180,*" framespacing="0" frameborder="no" border="0">
<frame src="Admin_Left.jsp" name="leftFrame" scrolling="YES" noresize>
<frame src="Index_Face.html" name="rightFrame">
</frameset>
<noframes><body>
您的浏览器不支持框架网页!
</body></noframes>
</html>
Admin_left.jsp
<A
href="../advertiser/news.jsp" title="广告主新闻" target="rightFrame">广告主新闻</A>
logout.jsp
<%@ page contentType="text/html; charset=GBK" language="java" buffer="32kb"%>
<%
session.setAttribute("Login","");
session.setAttribute("Username","");
out.println("<SCRIPT LANGUAGE='JavaScript'>alert('成功退出系统!');location.href='../advertiser/login.jsp';</SCRIPT>");
//response.sendRedirect("index.jsp");
%>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
login.jsp
登陆成功后
session.setAttirbue("Login",yes);
session.jsp 判断是否登陆了.
<%@ page import="dreamtime.dreamnews.*"%>
<%
Function Function1 = new Function();
boolean isLogin = Function1.StringToBoolean((String)session.getAttribute("Login"));
if(!isLogin)
{
response.sendRedirect("../advertiser/login.jsp");
return;
}
%>
分页
<%!
//每页显示的记录数
int pageSize = 10;
//总页数
int pageCount = 0;
//总记录数
int rowCount=0;
//当前页
int showPage=1;
%>
<html>
<head>
<head><link rel="stylesheet" type="text/css" href="../css/style.css">
<script language="javascript">
function docheck()
{
if(say.title.value=="")
{
alert("请填写标题");
return false;
}
else if(say.content.value.length<5)
{
alert("内容不得小于5个字");
return false;
}
else
{
return true;
}
}
</script>
</head>
<body>
用户留言<br><br>
<FIELDSET
style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 10px"><LEGEND><SPAN
class=f1>在线留言</SPAN></LEGEND>
<TABLE id=middle1 cellSpacing=0 cellPadding=0 width="100%"
align=left border=0>
<TBODY>
<TR>
<TH width="10%">发件人</TH>
<TH width="65%"> 主题</TH>
<TH width="15%">时间</TH>
<TH width="10%">操作</TH></TR>
<%
db.creatConnection();
String sql="select * from saysomething order by id desc";
ResultSet rs=db.executeQuery(sql);
//让游标到表中的最后一行
rs.last();
//获取记录总数.
rowCount = rs.getRow();
//总页数的计算公式
pageCount = (rowCount % pageSize == 0) ? (rowCount / pageSize ) : (rowCount / pageSize +1);
//取得用户所指定要显示的页
String goToPage = request.getParameter("showPage");
if (goToPage == null)
{
goToPage = "1";
}
//将当前要显示的页码转换成整型
try
{
showPage = Integer.parseInt(goToPage);
}
catch (NumberFormatException ex)
{
showPage = 1;
}
//当前页小于等于第一页,则按第一页算;如果当前页大于等于总页数,则为最后页
if(showPage <= 1)
{
showPage = 1;
}
else if(showPage >= pageCount)
{
showPage = pageCount;
}
//游标的位置 (当前页 - 1) * 页面大小 + 1
int posion = (showPage -1 ) * pageSize + 1;
//设置游标的位置
rs.absolute(posion);
int i =0;
//循环显示表中的数据 pageSize(每页所显示的记录)
//rs.isAfterLast() 游标是否在最后一行之后 说明后面已经没记录
while(i<pageSize && !rs.isAfterLast())
{ int id=rs.getInt("id");
String title=rs.getString("title");
String content=rs.getString("content");
String curtime=rs.getDate("curtime").toString();
String Username=rs.getString("Username");
%>
<TR>
<TD>
<DIV align=center><%=Username %></DIV></TD>
<TD>
<a href="../advertiser/message_show.jsp?id=<%=id%>"> <%=title %></A></TD>
<TD>
<DIV align=center><%=curtime %></DIV></TD>
<TD>
<DIV align=center>〖<a href="../advertiser/message_show.jsp?id=<%=id%>"> 查</A>〗</DIV></TD></TR>
<%
rs.next();
i++;
}
%>
//上面是分页的数据显示,以面是上一页下一页的显示
<TD class=nav colSpan=4><form action="message.jsp" method="post" target="_self">
共<font color=red><%=rowCount%></font>条
<font color=red><%=pageSize%></font>条/页
第<font color=red><%=showPage%></font>页/共<font color=red><%=pageCount%></font>页
<a href="message.jsp?showPage=1" target="_self">[首页]</a>
<%
//判断“上一页”链接是否要显示
if(showPage > 1)
{
%>
<a href="message.jsp?showPage=<%=showPage-1%>" target="_self">[上一页]</a>
<%
}
else
{
%>
[上一页]
<%
}
//判断"下一页"链接是否要显示
if(showPage < pageCount)
{
%>
<a href="message.jsp?showPage=<%=showPage+1%>" target="_self">[下一页]</a>
<%
}
else
{
%>
[下一页]
<%
}
%>
<a href="message.jsp?showPage=<%=pageCount%>" target="_self">[尾页]</a>
转到
<select name="showPage">
<%
for(int x=1;x<=pageCount;x++)
{
%>
<option value="<%=x%>" <%if(showPage==x) out.println("selected");%> ><%=x%></option>
<%
}
%>
</select>
页
<input type="submit" name="go" value="提交"/>
</form></TD></TR></TBODY></TABLE></FIELDSET>
<%
db.closeConnection();
// rs.close(); %>
message.jsp为自已当前页