📄 new.jsp
字号:
<script language=javascript>
<!--
var startTime,endTime;
var d=new Date();
startTime=d.getTime();
//-->
</script>
<html>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.util.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<head>
<title>企业内部管理信息平台∷全部更新信息</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link rel="stylesheet" href="newstyle.css" type="text/css">
</head>
<body leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<div align=center>
<jsp:include page="header.jsp"/>
<BR style="OVERFLOW: hidden; LINE-HEIGHT: 3px">
<SCRIPT>
var old_bg="";
function inStyle(obj)
{
old_bg=obj.style.background;
obj.style.background="#FFFF99";
}
function outStyle(obj)
{
obj.style.background=old_bg;
}
</SCRIPT>
<TABLE class=TableBorder cellSpacing=0 cellPadding=0 align=center border=0>
<TR class=Border2>
<TD><BR style="OVERFLOW: hidden; LINE-HEIGHT: 3px">
<TABLE width="99%" bgcolor="#CECECE" cellSpacing=1 cellPadding=0 align=center border=0>
<TR>
<Th width="90%" align="left"><img src="images/th_img.gif" align="absmiddle"> 标题
</Th>
<Th noWrap> 整理日期 </Th>
<Th noWrap> 出处 </Th>
<Th noWrap> 人气 </Th>
</TR>
<%String sql = "Select * FROM news order by id desc";
ResultSet RS = sqlbean.executeQuery(sql);
//java.util.Date xx=rs.getDate(1);
// java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy-MM-dd");
//String s = df.format(xx);
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount; //总页数
int intPage; //待显示页码
java.lang.String strPage;
//int i;
//设置一页显示的记录数
intPageSize = 15;
//取得待显示页码
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);
//显示数据
int i = 0;
while((i<intPageSize && !RS.isAfterLast())){%>
<TR onmouseover=inStyle(this) style="BACKGROUND: #F7F7F7" onmouseout=outStyle(this) class=Border2>
<TD height=23> [<a href=list.jsp?sortid=<%=RS.getString("class")%>&rootid=<%=RS.getString("parentclass")%>><%=RS.getString("class")%></a>] <a href=show.jsp?id=<%=RS.getString("id")%>>
<%=RS.getString("title")%></a></TD>
<TD noWrap align=center><%=RS.getDate("d")%></TD>
<TD noWrap align=center><%=RS.getString("author")%></TD>
<TD noWrap align=center><%=RS.getString("hit")%></TD>
</TR>
<%RS.next();
i++;}
}
RS.close();%>
<TR class=Border1>
<TD height=22 colSpan=3>第<%=intPage%>页/共<%=intPageCount%>页
<%if(intPage>1){%><a href="new.jsp?page=<%=intPage-1%>">上一页</a><%}%>
<%if(intPage<intPageCount){%><a href="new.jsp?page=<%=intPage+1%>">下一页</a><%}%>
</TD>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -