📄 rz_brow.jsp
字号:
<%@page language="java"%>
<%@page contentType="text/html;charset=8859_1"%>
<%@page import="java.sql.*"%>
<%@page import="DBCon"%>
<%@page import="DateText"%>
<% DBCon DBConBean=new DBCon(); %>
<%@page import="IdSelect"%>
<% IdSelect IdSelectBean=new IdSelect();
String s_jb_id =(String)session.getValue("s_jb_id");
int pagesize=18;
String pages=request.getParameter("pages");
if ((pages==null)||(pages=="")){pages="1";}else{}
int pages_new = Integer.parseInt(pages);
IdSelectBean.setStrTableName("logs");
IdSelectBean.setStrId("logs_del='0' and s_jb_id='"+s_jb_id+"'");
Connection conn = DBConBean.getConnection();
IdSelectBean.setConn(conn);
int count = IdSelectBean.getCount();
int pageline=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1;
if (pages_new<=0){pages_new=1;}else{
if (pages_new>pageline){pages_new=pageline;}else{}}%>
<html>
<head>
<title>栏目资料</title>
<style type="text/css">
<!--
-->
</style>
<link rel="stylesheet" href="../css/style.css" type="text/css">
</head>
<script language="javascript">
function subb() {
if(document.form1.pages.value==""){alert("请输入你需要的页号");}else{
document.form1.action="rz_brow.jsp?pages="+document.form1.pages.value+""
form1.submit();
}}
</script>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="">
<%
IdSelectBean.setIdName("logs_del");
IdSelectBean.setStrTableName("logs");
IdSelectBean.setStrId("0 and s_jb_id="+s_jb_id+" order by logs_id desc");
try {
ResultSet result = IdSelectBean.getResultSet();
%>
<TABLE width="80%" border="1" cellspacing="0" cellpadding="0" align="left" bordercolorlight="#000000" bordercolordark="#ffffff" class="zw" bgcolor="#e1e1e1">
<TR>
<TD><b>时间</b></TD>
<TD><B>操作员名</B></TD>
<TD><b>操作IP</b></TD>
<TD><b>改变表名</b></TD>
<TD>改变方式</TD>
<TD> </TD>
</TR>
<% int i=1;
//利用while循环将数据表中的记录列出
while(result.next()) {i=i+1;
String logs_id= result.getString("logs_id");
String logs_people= result.getString("logs_people");
String logs_people_ip=result.getString("logs_people_ip");
String logs_data=DateText.getDateString(result.getString("logs_data"));
String logs_biao=result.getString("logs_biao");
String logs_do=result.getString("logs_do");
String logs_del=result.getString("logs_del");
if((i>((pages_new-1)*pagesize))&&(i<(pages_new*pagesize+1))){%>
<TR>
<TD><B> <%=logs_data%> </B></TD>
<TD><B><%=logs_people%></B></TD>
<TD>
<%=logs_people_ip%>
</TD>
<TD><%=logs_biao%></TD>
<TD><%=logs_do%></TD>
<TD><a href="rz_del.jsp?rz_id=<%=logs_id%>" onClick="return confirm('您确定删除吗？')">删除</a></TD>
</TR>
<%
}else{} }
}
catch(Exception e) {DBConBean.closeAll();
e.printStackTrace();
}
DBConBean.closeAll();
%><tr><%int j=pages_new-1;int h=pages_new+1;%><td colspan="8">共<%=(count%pagesize)==0?(count/pagesize):(count/pagesize)+1%>页 <a href="rz_brow.jsp?pages=<%=j%>">上一页</a> <a href="rz_brow.jsp?pages=<%=h%>">下一页</a> 本页是第<%=pages_new%>页
<input type="text" name="pages" style="width:20px">
<input type="button" name="Submit" value="GO" onclick="subb()"></td></tr>
</TABLE>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -