?? 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="#39867B">
<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="#E1F4EE">
<td width="46" align="center" height="20"><STRONG>ID</STRONG></td>
<td width="400" align="center"><STRONG>軟 件 名</STRONG></td>
<td width="68" align="center">
<input type='submit' class=buttonface value='刪 除'>
</td>
</tr>
<tr bgcolor="#E1F4EE">
<td colspan="3" align="center" height="20">
<% 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="#E1F4EE">
<p align="center"><%=rs.getString("id")%>
</td>
<td width="400" bgcolor="#E1F4EE">
<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="#E1F4EE">
<p align="center"> <a href="delall.jsp?did=<%=rs.getString("id")%>">刪 除</a>
</td>
</tr>
<%
i++;//通過I循環設置每頁的頁數
}
}
%>
<tr bgcolor="#E1F4EE" align="center">
<td height="11" colspan="3">
<DIV align="center">
<CENTER>
</CENTER>
</DIV>
</td>
</tr>
</table>
</form>
</table>
</body>
</html>
<%}
}%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -