?? edit.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="../conn.jsp"%>
<%
request.setCharacterEncoding("gb2312");
if ((session.getAttribute("admin")==null)){
response.sendRedirect("admin.jsp");
}else{
String str=(String)session.getAttribute("rights");
int flag=Integer.parseInt(str.trim());
if(flag<1){
out.print("<br><p align=center>您沒有權限操作!</p>");
}else{
int intPageSize,intRowCount,intPageCount,intPage;
String strPage;
int i,j;
intPageSize=10;
strPage=request.getParameter("page");
if(strPage==null){
intPage=1;
}else{
intPage=Integer.parseInt(strPage);
if (intPage<1) intPage=1;
}
String sql="select count(*) from download";
ResultSet rt=stmt.executeQuery(sql);
rt.next();
intRowCount=rt.getInt(1);
intPageCount=(intRowCount+intPageSize-1)/intPageSize;
if(intPage>intPageCount)
intPage=intPageCount;
sql="select * from download order by addtime DESC";
String actions="查 詢";
if(actions.equals(request.getParameter("search")))
{
sql="select * from download where softname like '%"+request.getParameter("keywords").trim()+"%' order by addtime DESC";
}
//out.print(sql);
ResultSet rs=stmt.executeQuery(sql);
i=(intPage-1)*intPageSize;
for(j=0;j<i;j++)
rs.next();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>無標題文檔</title>
<style type=text/css>
<!--
BODY{
margin:0px;
FONT-SIZE: 12px;
FONT-FAMILY: "宋體", "Verdana", "Arial", "Helvetica", "sans-serif";
scrollbar-face-color: #DEE3E7;
scrollbar-highlight-color: #FFFFFF;
scrollbar-shadow-color: #DEE3E7;
scrollbar-3dlight-color: #D1D7DC;
scrollbar-arrow-color: #006699;
scrollbar-track-color: #EFEFEF;
scrollbar-darkshadow-color: #98AAB1;
background-color: #D4DEF9;
}
table { border:0px; }
td { font:normal 12px 宋體; }
img { vertical-align:bottom; border:0px; }
a { font:normal 12px 宋體; color:#000000; text-decoration:none; }
a:hover { color:#428EFF;text-decoration:underline; }
.sec_menu { border-left:1px solid white; border-right:1px solid white; border-bottom:1px solid white; overflow:hidden; background:#D6DFF7; }
.menu_title { }
.menu_title span { position:relative; top:2px; left:8px; color:#215DC6; font-weight:bold; }
.menu_title2 { }
.menu_title2 span { position:relative; top:2px; left:8px; color:#428EFF; font-weight:bold; }
input,select,Textarea{
font-family:宋體,Verdana, Arial, Helvetica, sans-serif; font-size: 12px;}
}
.style1 {
color: #3D6DD3;
font-weight: bold;
}
-->
</style>
<style type="text/css">
<!--
.style1 {color: #666666}
.style2 {color: #000000}
.style3 {color: #660000}
-->
</style>
</head>
<script language="javascript">
function CheckOthers(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
// if (e.name != 'chkall')
if (e.checked==false)
{
e.checked = true;// form.chkall.checked;
}
else
{
e.checked = false;
}
}
}
function CheckAll(form)
{
for (var i=0;i<form.elements.length;i++)
{
var e = form.elements[i];
// if (e.name != 'chkall')
e.checked = true;// form.chkall.checked;
}
}
</script>
<body>
<table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" bgcolor="#3D6DD3"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<form name="form1" method="post" action="del.jsp?action=post"><tr bgcolor="#3D6DD3">
<td height="54" colspan="5"><div align="center" class="style1">
<p class="style3">點擊相關軟件察看及修改軟件資料,刪除軟件請選中相關軟件然后點擊刪除</p>
<p class="style2">查找軟件:<input name="keywords" type="text" id="keywords">
<input name="search" type="submit" id="search" value="查 詢">
</p>
</div></td>
</tr>
<tr>
<td width="6%" height="26" bgcolor="#D4DEF9"><div align="center"><strong>選擇</strong></div></td>
<td width="8%" bgcolor="#D4DEF9"><div align="center"><strong>ID</strong></div></td>
<td width="59%" bgcolor="#D4DEF9"><div align="center"><strong>軟件名</strong></div></td>
<td width="21%" bgcolor="#D4DEF9"><div align="center"><strong>添加時間</strong></div></td>
<td width="6%" bgcolor="#D4DEF9"><div align="center"><strong>操作</strong></div></td>
</tr>
<tr valign="middle">
<td colspan="5" align="center" bgcolor="#D4DEF9">
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td width="76%" height="29" valign="middle" align="center">
第 <font color="#FF0000"><%=intPage%></font> 頁 共 <font color="#FF0000"><%=intPageCount%></font> 頁
<select name="page" onChange="javascript:location.href=edit.jsp?page=this.options[selectedIndex].value;">
<%int k;
for (k=1;k<=intPageCount;k++)
%>
<option value="<%=intPage%>" <%if(k==intPage) out.print("selected");%>>第<%=intPage%>頁</option>
</select>
<%
%>
</td>
</tr>
</table> </td>
</tr>
<%if(intRowCount==0){
out.print("對不起,還沒有數據!");
}else{
i=0;
while(i<intPageSize&&rs.next()){
%>
<tr>
<td height="29" bgcolor="#D4DEF9">
<div align="center">
<input type="checkbox" name="sel" value="<%=rs.getInt("id")%>" >
</div></td>
<td bgcolor="#D4DEF9">
<div align="center"> <%=rs.getInt("id")%></div></td>
<td bgcolor="#D4DEF9"> <a href="editsoft.jsp?softid=<%=rs.getInt("id")%>" target="_self"><%=rs.getString("softname")%></a></td>
<td bgcolor="#D4DEF9" align="center"> <%=rs.getDate("addtime")%></td>
<td bgcolor="#D4DEF9"><div align="center"><a href="del.jsp?softid=<%=rs.getInt("id")%>">刪除</a></div></td>
</tr>
<%
i++;
}
}
%>
<tr>
<td colspan="5" bgcolor="#D4DEF9"> </td>
</tr>
<tr>
<td colspan="5" bgcolor="#D4DEF9">
<div align="center">
<input type="button" name="chkall" value="全選" onClick="javascript:CheckAll(this.form)" title="選擇顯示的所有軟件">
<input name="chkOthers" type="button" id="chkOthers" title="反向選擇軟件" onClick="javascript:CheckOthers(this.form)" value="反選">
<input name="del" type="submit" id="del" value="刪除">
</div></td>
</tr></form>
</table></td>
</tr>
</table>
</body>
</html>
<%
}
}
%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -