📄 data.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,dsp.utils.*" errorPage="" %>
<%@include file="getusersession.jsp"%>
<%
request.setCharacterEncoding("GB2312");
%>
<jsp:useBean id="news" scope="page" class="dsp.database.Operation"/>
<%
//总记录数
int totalRecord = 0;
//当前页
int currPage = 1;
//页面大小
int pageSize = 10;
//页数
int pageCount = 0;
//每页第一条记录号
int offset = 1;
String sql = "SELECT * FROM web_data WHERE class="+request.getParameter("id")+" ORDER BY id DESC";
ResultSet rs = news.query(sql);
totalRecord = news.totalRecord(rs);
pageCount = ((totalRecord % pageSize) == 0)?(totalRecord/pageSize) : (totalRecord/pageSize) + 1;
String p = request.getParameter("page");
if(p != null && p != ""){
currPage = Integer.parseInt(p);
offset = (currPage - 1) * pageSize + 1;
}
String ctrl = news.showPages(currPage, pageSize, pageCount, "data.jsp?id="+request.getParameter("id")+"&name="+request.getParameter("name")+"&");
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="inc/admin.css" rel="stylesheet" type="text/css">
<script language="javascript">
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
if (e.name != 'checkall')
e.checked = form.checkall.checked;
}
}
</script>
</head>
<body>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
<tr>
<td height="30" colspan="10" align="center" background="images/tablebg.gif"><b><%=request.getParameter("name")%></b></td>
</tr>
<tr>
<td height="25" colspan="5"><div align="center"><%=ctrl%></div></td>
</tr>
<form action="processdata.jsp?ps=<%=pageSize%>" name="from2" method="post">
<tr>
<td width="11%" height="25" align="center">ID</td>
<td width="7%" height="25" align="center">操作</td>
<td width="46%" height="25" align="center">文章标题</td>
<td width="10%" height="25" align="center">作者</td>
<td width="26%" height="25" align="center">发布时间</td>
</tr>
<%
int i = 1;
while((offset <= pageSize*currPage) && (offset <= totalRecord)){
rs.absolute(offset);
%>
<tr>
<td height="25" align="center"><%=rs.getInt("id")%></td>
<td height="25" align="center"><input name="newsid<%=i%>" type="checkbox" id="newsid" value="<%=rs.getInt("id")%>"></td>
<td height="25" align="center"><div align="left"><a href="<%if(rs.getInt("flag") == 1){%>modfile.jsp?id=<%=rs.getInt("id")%>" title="<%=Convert.ISOtoGB(rs.getString("information"))%>"<%}else{%>modedit.jsp?id=<%=rs.getInt("id")%>"<%}%>><%=rs.getString("title")%></a></div></td>
<td height="25" align="center"><%=rs.getString("author")%></td>
<td height="25" align="center"><%=rs.getString("date")%></td>
</tr>
<%
offset ++;
i++;
}
%>
<tr>
<td height="25" colspan="5" align="center"><div align="center">管理操作：
<input name="checkall" type="checkbox" id="checkall" value="checkbox" onClick="javascript:CheckAll(this.form)">
全部选择
<input name="del" type="submit" id="del" onClick="{if(confirm('确定删除选定的文章吗?')){ op.value = '1';submit();return true;}return false;}" value="删除">
<input name="mv" type="submit" id="mv" onClick="{if(confirm('确定转移选定的文章吗?')){ op.value = '2';submit();return true;}return false;}" value="将选定的资源转移到">
<%
sql = "SELECT * FROM web_class WHERE flag<>0 ORDER BY id ASC";
rs = news.query(sql);
%>
<select name="move" id="move" >
<option selected>这里...</option>
<%
while(rs.next()){
%>
<option value="<%=rs.getInt("id")%>"><%=rs.getString("classname")%></option>
<%}%>
</select>
<input name="op" type="hidden" id="op" value="0">
</div></td>
</tr>
</form>
<tr>
<td height="25" colspan="5" align="center"><%=ctrl%></td>
</tr>
</table>
<%@include file="copyright.jsp"%>
</body>
</html>
<%
news.closestmt();
news.closeconn();
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -