📄 adminindex.jsp
字号:
<%@ page language="java"%>
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,common.*,java.util.*"%>
<html>
<head>
<title>软件下载索引管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
-->
</style>
</head>
<body>
<%
if (session.getAttribute("bumen") != null) {
session.removeAttribute("bumen");
%>
<script type="text/javascript">
alert("添加部门成功");
</script>
<%
}
%>
<%
if (session.getAttribute("ok") != null) {
session.removeAttribute("ok");
%>
<script type="text/javascript">
alert("添加类别成功");
</script>
<%
}
%>
<%
//接值并判断
//没有值，id=0
int id = 0;
String typeid = request.getParameter("typeid");
if (typeid != null) {
id = Integer.parseInt(typeid);
} else {
id = 0;
}
Connection conn =null;
Statement stmt =null;
ResultSet rs = null;
%>
<%@include file="top.jsp"%>
<table width="100%" height="380" border="1">
<tr>
<td height="24" colspan="2" align="left" valign="top">
<table width="100%" height="20" border="0">
<tr>
<td width="70%">
当前路径：
<%
//输出当前的路径
out.print(GetUrl.geturl(id));
%>
</td>
<td width="30%">
<a href="adminindex.jsp">管理首页</a> |
<a href="add_depart.jsp">添加部门</a> |
<a href="add_type.jsp?typeid=<%=id%>">加分类</a>
<%if(id!=0) {%>
| <a href="add_file.jsp?typeid=<%=id%>">加软件</a>
<%} %>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="40%" align="left" valign="top">
<%
//根据得到的id把这个id下的子类显示出来
String sql = "select c_type_name,c_id,c_fid,c_describe from t_type where c_isdel=1 and c_fid="
+ id;
try{
conn = DAO.getConnection();
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
%>
<table width="100%" height="" border="1">
<tr>
<td height="25" colspan="2" align="center">
<strong> 分类（文件夹） </strong>
</td>
</tr>
<%
while (rs.next()) {
%>
<tr>
<td width="30%" height="25">
<a href="adminindex.jsp?typeid=<%=rs.getInt("c_id")%>"
target="_self"><%=rs.getString("c_type_name")%> </a>
</td>
<td width="70%" height="25">
<a href="add_type.jsp?typeid=<%=rs.getInt("c_id")%>">添加子类</a> |
<a href="add_file.jsp?typeid=<%=rs.getInt("c_id")%>">添加软件</a> |
<a href="#" onClick="show(<%=rs.getInt("c_id")%>)">修改</a> |
<input id=<%=rs.getInt("c_id")%> type="hidden"
value=<%=rs.getString("c_type_name")%>>
<a href="delete.jsp?typeid=<%=rs.getInt("c_id")%>"
onClick="{if(confirm('此操作慎用！将会将删除此类和此类下的子类,您确定吗?')){this.document.form1.submit();return true;}return false;}">删除此类</a>
</td>
</tr>
<tr>
<script type="text/javascript">
function show(id){
var odiv = document.getElementById('aa'+id);
odiv.style.display ="";
}
function hidden(id){
var odiv = document.getElementById('aa'+id);
odiv.style.display ="none";
}
</script>
<td height="25" colspan="2" align="center"
id="aa<%=rs.getInt("c_id")%>" style="display:none">
<div
style="width:100%;height:161px;z-index:1;background-color: #0066FF;font-size: 12px;">
<form action="../../ChangerTypeName" method="post">
<table width="372" height="162" border="1">
<tr>
<td width="49" height="25">
类别名称
</td>
<td width="307">
<input type="text" name="typename"
value="<%=rs.getString("c_type_name")%>">
<input type="hidden" name="typeid"
value="<%=rs.getInt("c_id")%>">
</td>
</tr>
<tr>
<td height="100">
类别描述
</td>
<td>
<textarea name="c_describe" cols="40" rows="7">
<%=rs.getString("c_describe")%>
</textarea>
</td>
</tr>
<tr>
<td>
</td>
<td>
<input type="submit" name="Submit" value="提交">
<input type="button" value="取消"
onClick="hidden(<%=rs.getInt("c_id")%>)" />
</td>
</tr>
</table>
</form>
</div>
</td>
</tr>
<%
}
%>
</table>
</td>
<td width="60%" align="left" valign="top">
<%List list=new ArrayList();
sql = "select c_id,c_departname from t_depart";
rs = stmt.executeQuery(sql);
while (rs.next()){
Department dm = new Department();
dm.setDepartid(rs.getInt(1));
dm.setDepartname(rs.getString(2));
list.add(dm);
}
%>
<%
//根据这个id 把这个类下面的软件文件显示出来
sql = "select c_id,c_name,c_describe,c_typeid,c_hits,c_lasttime,c_jointime,c_departid from t_file where c_isdel=1 and c_typeid="
+ id;
rs = stmt.executeQuery(sql);
%>
<table width="100%" height="" border="1">
<tr>
<td height="25" colspan="2" align="center">
<strong> 此分类下的软件（文件） </strong>
</td>
</tr>
<%
//构建网络路径
while (rs.next()) {
String path = GetUrl.geturl(rs.getInt("c_typeid"));
int cid = rs.getInt("c_id");
int bumen = rs.getInt("c_departid");
int x = path.indexOf("soft");
path = path.substring(x);
String ip = request.getLocalAddr();
%>
<tr>
<td width="70%" height="25">
<a href="\\<%=ip%>/<%=path%><%=rs.getString("c_name")%>"><%=rs.getString("c_name")%>
</a>[
<%=rs.getInt("c_hits")%>
次]-[
<%=rs.getString("c_jointime").substring(0, 10)%>
]
</td>
<td width="30%" height="25">
<a href="#" onClick="showchangefile(<%=rs.getInt("c_id")%>)">修改</a>
|
<a href="\\<%=ip%>/<%=path%>">打开目录</a> |
<a href="delete.jsp?fileid=<%=rs.getInt("c_id")%>"
onClick="{if(confirm('此操作将删除此文件,您确定吗?')){this.document.form1.submit();return true;}return false;}">删除</a>
</td>
</tr>
<tr>
<td height="25" colspan="2">
描述：
<span style="font-size:11px; color:#999999"><%=rs.getString("c_describe")%>
</span>
</td>
</tr>
<tr>
<script type="text/javascript">
function showchangefile(id){
var odiv = document.getElementById('bb'+id);
odiv.style.display ="";
}
function hiddenchangefile(id){
var odiv = document.getElementById('bb'+id);
odiv.style.display ="none";
}
</script>
<td height="140" colspan="2" align="center"
id="bb<%=rs.getInt("c_id")%>" style="display:none">
<div
style="width:100%;height:140px;z-index:1;background-color: #0066FF;font-size: 12px;">
<form action="../../ChangeFileName" method="post">
<table width="66%" height="140" border="1">
<tr>
<td width="48" height="20">
类别名称 </td>
<td width="297">
<input type="text" name="filename"
value="<%=rs.getString("c_name")%>">
<input type="hidden" name="fileid"
value="<%=rs.getInt("c_id")%>">
<input type="hidden" name="typeid"
value="<%=rs.getInt("c_typeid")%>">
</td>
</tr>
<tr>
<td height="80">
类别描述 </td>
<td>
<textarea name="describe" cols="40" rows="7">
<%=rs.getString("c_describe")%>
</textarea>
</td>
</tr>
<tr>
<td width="48" height="20">
所属部门 </td>
<td width="297">
<select name="bumenid">
<%
for(int y=0;y<list.size();y++){
Department d=(Department)list.get(y);
if(d.getDepartid()==bumen){%>
<option value="<%=d.getDepartid()%>" selected>
<%=d.getDepartname()%> </option>
<%}else{ %>
<option value="<%=d.getDepartid()%>">
<%=d.getDepartname()%> </option>
<%}
}
%>
</select>
</td>
</tr>
<tr>
<td height="20"> </td>
<td height="20">
<input type="submit" name="Submit" value="提交">
<input type="button" value="取消"
onClick="hiddenchangefile(<%=cid%>)" />
</td>
</tr>
</table>
</form>
</div>
</td>
</tr>
<%}
} catch (java.sql.SQLException ex) {
out.println(ex.getMessage());
}finally{
rs.close();
stmt.close();
conn.close();
}
%>
</table>
</td>
</tr>
</table>
<%@include file="footer.jsp"%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -