用户登录不能为空
<%
//判断用户是不是为空
Object obj = session.getAttribute("a");
if (obj == null) {
out.print("<script>alert('老铁你没登录,请登录');location.href='login.jsp'</script>");
}
%>
计算最大页面公式:maxPage = count(总条数) / pageSize(每页数据条数)
// pageIndex(页码)
start = (pageIndex - 1) * pageSize + 1;
end = pageIndex * pageSize;
<body>
<%
//判断用户是不是为空
Object obj = session.getAttribute("a");
if (obj == null) {
out.print("<script>alert('老铁你妹登录,请登录');location.href='login.jsp'</script>");
}
%>
<div id="header">
<div id="welcome">欢迎使用新闻管理系统!</div>
<div id="nav">
<div id="logo">
<img src="images/logo.jpg" alt="新闻中国" />
</div>
<div id="a_b01">
<img src="images/a_b01.gif" alt="" />
</div>
</div>
</div>
<div id="admin_bar">
<div id="status">
管理员:<%=session.getAttribute("a")%>
     <a href="login.jsp">登录</a>
</div>
<div id="channel"></div>
</div>
<div id="main">
<div id="opt_list">
<ul>
<li><a href="newspages/add_news.jsp">添加新闻</a></li>
<li><a href="admin.jsp">编辑新闻</a></li>
<li><a href="admin.jsp">查找新闻</a></li>
<li><a href="newspages/add_sub.jsp">添加主题</a></li>
<li><a href="newspages/update_sub.jsp">编辑主题</a></li>
<li><a href="dodele.jsp">删除主题</a></li>
</ul>
</div>
<div id="opt_area">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<script language="javascript">
function clickdel() {
return confirm("删除请点击确认");
}
</script>
<form action="cx.jsp" align="center">
<input type="text" name="str"> <input type="submit"
value="查询">
</form>
<ul class="classlist">
<%
//连接数据库,查询新闻新
Class.forName("oracle.jdbc.OracleDriver");
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
Connection con = DriverManager.getConnection(url, "scott", "tiger");
//求出数据总条数
PreparedStatement ps = con.prepareStatement("select count(*) from news");
ResultSet rs = ps.executeQuery();
int count = 0;
if (r