📄 detail.jsp
字号:
<%@ page language="java"%>
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,common.*"%>
<%
String id = request.getParameter("fileid");
int fileid = Integer.parseInt(id);
//点击量+1
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
conn = DAO.getConnection();
conn.setAutoCommit(false);
stmt = conn.createStatement();
String sql = null;
sql = "update t_file set c_hits=c_hits+1 where c_id="
+ fileid;
stmt.executeUpdate(sql);
%>
<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>
<%@include file="top.htm"%>
<%
sql = "select c_id,c_name,c_describe,c_typeid,c_hits,c_lasttime,c_jointime from t_file where c_id="
+ fileid;
rs = stmt.executeQuery(sql);
if (rs.next()) {
%>
<table width="388" height="152" border="1" align="center">
<tr>
<td width="145" height="30">
软件名称
</td>
<td width="227">
<%=rs.getString("c_name")%>
</td>
</tr>
<tr>
<td height="25">
点击次数
</td>
<td>
<%=rs.getString("c_hits")%>
</td>
</tr>
<tr>
<td height="25">
收录时间
</td>
<td>
<%=rs.getString("c_jointime")%>
</td>
</tr>
<tr>
<td height="25">
最后一次下载时间
</td>
<td>
<%=rs.getString("c_lasttime")%>
</td>
</tr>
<tr>
<td>
软件描述
</td>
<td>
<textarea name="" cols="30" rows="6" disabled="disabled">
<%=rs.getString("c_describe")%>
</textarea>
</td>
</tr>
<%
//构建网络路径
String path = GetUrl.geturl(rs.getInt("c_typeid"));
int x = path.indexOf("soft");
path = path.substring(x);
String ip = request.getLocalAddr();
%>
<tr>
<td>
<a href="\\<%=ip%>/<%=path%>">打开软件所在目录</a>
</td>
<td>
<a href="\\<%=ip%>/<%=path%><%=rs.getString("c_name")%>">打开软件或者下载软件</a>
</td>
</tr>
</table>
<%
}
conn.commit();
} catch (Exception ex) {
System.out.println("-----------" + ex.getMessage());
ex.printStackTrace();
} finally {
DAO.closeResource(rs);
DAO.closeResource(stmt);
DAO.closeResource(conn);
}
%>
<%@include file="footer.jsp"%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -