📄 index.jsp

📁 用JAVA写的5款不错的新闻发布系统。希望对大家有所帮助
💻 JSP
字号:
<%@ page language = "java" contentType = "text/html;charset=gb2312" errorPage="error.jsp"%>
<%@ page import = "java.sql.*" %>
<jsp:useBean id = "sts" scope = "page" class = "sts.JdbcOdbc_Con" />
<%
	//您可以任意更改本程序
	//不过作者只有一点请求
	//就是您的传播的过程中
	//请保留有关顺天科技
	//的相关文件
	//谢谢您
	//祝您好运
	//顺天科技作品
	int  intPage;
	int currentPage = 1;
	int PageNumbers = 10;
	if(request.getParameter("page")!=null && request.getParameter("page")!="")
		intPage = Integer.parseInt(request.getParameter("page"));
	else
		intPage = 1;
	int totalRecord = 0;
	ResultSet counters = sts.executeQuery("select count(*) as cnt from stsNews");
	if(counters.next())
	{
		totalRecord = counters.getInt("cnt");
	}
%>
<html>
<head><title>顺天科技新闻发布系统1.0版</title>
<LINK href="css/sts.css" rel=stylesheet type=text/css>
</head>
<body>
<div align="center" style="width: 901; height: 21">
<%@ include file="inc/top.jsp" %>
<br>
<table border = 0 width="505" cellspacing="0" cellpadding="2" style="border-collapse: collapse" bordercolor="#111111">
<tr bgcolor="#00ff00"><td width="505" colspan=2><img src="pic\qq.gif">新闻标题</td></tr>
<%
	if(session.getValue("name")==null || session.getValue("name")=="")
	{
		%>
<%

	String strSQL = "select id,title from stsNews order by id desc";
	ResultSet rs = sts.executeQuery(strSQL);
	int i=0;
	while(rs.next())
	{
		
		if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
		{
			String id = rs.getString("id");
			String title = rs.getString("title");
			out.print("<tr bgcolor = \"#00dc45\"><td width=300  valign=\"top\"><img src=\"pic\\gb.gif\"><a href=\"view.jsp?id="+id+"\">"+ title +"</a></td><td></td></tr>");
		}
		i++;
	}	
%>
</table>
</div>
<%
	
rs.close();
}
   else
   {
%>
<%
	String strSQL = "select id,title from stsNews order by id desc";
	ResultSet rs = sts.executeQuery(strSQL);
	int i=0;
	while(rs.next())
	{
		
		if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
		{
			String id = rs.getString("id");
			String title = rs.getString("title");
			out.print("<tr bgcolor = \"#00dc45\"><td valign=\"top\" width=\"90%\"><img src=\"pic\\gb.gif\"><a href=\"view.jsp?id="+id+"\">"+ title +"</a></td><td width=\"10%\"><a href=\"delete.jsp?id="+id+"\">删除</a></td></tr>");
		}
		i++;
	}
%>
</table>

<%
rs.close();
	}	
%>
<br>
<div align="center" >新闻总数：<%= totalRecord %> 当前页数：<%=currentPage%> 每页显示<%=PageNumbers%>条 共<%=(totalRecord+PageNumbers)/PageNumbers%>页 <a href="index.jsp?page=1">首页</a>


<%
	if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
	{
		out.print("<a href='index.jsp?page=" + (intPage-1) + "'>上一页&nbsp;&nbsp;</a>");
		out.print("<a href='index.jsp?page=" + (intPage+1) +"'>下一页&nbsp;&nbsp;</a>");
		out.print("<a href='index.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>最后一页</a>");
	}
	if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
		out.print("<a href='index.jsp?page=" + (intPage-1) + "'>上一页&nbsp;&nbsp;</a>");
	if(intPage == 1)
	{
		out.print("<a href='index.jsp?page=" + (intPage+1) +"'>下一页&nbsp;&nbsp;</a>");
		out.print("<a href='index.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>最后一页</a>");
	}
%>
</div>
<%
	counters.close();	
%>
<div align="center"><a href="manager.jsp" >进入管理</a>&nbsp;<a href="manager.jsp">发布文章</a>&nbsp;<a href="admin.jsp">登录</a><br>
<%@ include file="inc/bottom.jsp" %></div>
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -