📄 adminedit.jsp
字号:
<%@ include file="../conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
if ((session.getValue("admin")==null)){
response.sendRedirect("login.jsp");
}else{
String aaa= (String) session.getValue("flag");
int ddd=Integer.parseInt(aaa);
if(ddd>2){
out.print("<br><p align=center>您没有操作的权限</p>");
}else{
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title></title>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<link rel="stylesheet" type="text/css" href="style.css">
</head>
<%String title=request.getParameter("txtitle");
//idlist=request("selAnnounce")
%>
<body bgcolor="#009458">
<table border="0" width="92%" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="100%" align="center">
<FONT color="#FF9933">点击相关影片察看及修改影片资料，删除影片请选中相关影片然后点击删除
</FONT>
<form name="searchsoft" method="POST" action="adminedit.jsp">
查找影片: <input class=smallInput type="text" name="txtitle" size="13"><input class=buttonface type="submit" value="查 询" name="title">
</form>
<form method=Post action="adminedit.jsp">
<table border="0" cellspacing="1" width="589" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellpadding="2">
<tr bgcolor="#145f74">
<td width="46" align="center" height="20"><STRONG><FONT color="#FFFFFF">ID</FONT></STRONG></td>
<td width="400" align="center"><STRONG><FONT color="#FFFFFF">软 件 名</FONT></STRONG></td>
<td width="68" align="center">
<input type='submit' class=buttonface value='删 除'>
</td>
</tr>
<tr bgcolor="#cce6ed">
<td colspan="3" align="center" height="20">
</td>
</tr>
<% int intPageSize;
int intRowCount;//记录总数
int intPageCount;//总页数
int intPage;//页面参数
String strPage;//定义变量用来传递page
int i,j;
intPageSize=10;//定义每页显示10条记录
strPage=request.getParameter("page");//取得当前的页码
if(strPage==null){//判断初始页面,如果没有显示记录,就置为第一页
intPage=1;
}else{
intPage=Integer.parseInt(strPage);//将strPage转化为整数
if(intPage<1) intPage=1;
}
String sqlname;
if(title==null){
sqlname="select count(id) from scott.download order by id desc";
}else{
sqlname="select count(id) from scott.download where showname like '%"+title+"%' order by id desc";
}
ResultSet rt=stmt.executeQuery(sqlname);
rt.next();
intRowCount=rt.getInt(1);//取得整数保存与intRowCount变量中
intPageCount=(intRowCount+intPageSize-1)/intPageSize;//计算出总页数(记录总数+每页显示的记录-1)/每页显示的记录)
if(intPage>intPageCount)
intPage=intPageCount;
if(title==null){
sqlname="select * from scott.download order by id desc";
}else{
sqlname="select * from scott.download where showname like '%"+title+"%' order by id desc";
}
ResultSet rs=stmt.executeQuery(sqlname);//执行sql，按照时间先后排序显示
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<%if(intRowCount==0){%>
<p align='center'> 还 没 有 任 何 软 件 </p>
<%}else{%>
<p align='center' vAlign='bottom'>
第<%=intPage%>页 共<%=intPageCount%>页
<%if(intPage<intPageCount){%>
<a href="adminedit.jsp?page=<%=intPage+1%>">下一页</a>
<%}%>
<%if(intPage>1){%>
<a href="adminedit.jsp?page=<%=intPage-1%>">上一页</a>
<%}%></p>
<% i=0;
while(i<intPageSize && rs.next()){%>
<tr>
<td height="11" width="46" bgcolor="#a5d0dc">
<p align="center"><%=rs.getString("id")%>
</td>
<td width="400" bgcolor="#cce6ed">
<p><a href="editsoft.jsp?id=<%=rs.getString("id")%>&classid=<%=rs.getString("classid")%>&Nclassid=<%=rs.getString("Nclassid")%>"><%=rs.getString("showname")%> </a>
</td>
<td width="68" bgcolor="#a5d0dc">
<p align="center">
<a href="delall.jsp?did=<%=rs.getString("id")%>">删 除</a>
</td>
</tr>
<%
i++;//通过I循环设置每页的页数
}
}
%>
<tr bgcolor="#cce6ed" align="center">
<td height="11" colspan="3">
<DIV align="center">
<CENTER>
</CENTER>
</DIV>
</td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
<%}
}%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -