📄 result_of_upload.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.io.*" %>
<%@ page import="com.jspsmart.upload.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.text.*" %>
<!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">
<!--
.style1 {color: #0000FF}
.style2 {color: #990066}
body {
background-color: #CCCCCC;
}
-->
</style>
</head>
<body>
<%! int fileSize;String myFileName=""; String trace=""; %>
<%! String title="";String keyword=""; String receipt="";%>
<%! String sender="";String origin=""; String kind=""; %>
<%! int id; String dir=""; %>
<%
com.jspsmart.upload.SmartUpload mySmartUpload=new com.jspsmart.upload.SmartUpload();
mySmartUpload.initialize(pageContext);
mySmartUpload.setMaxFileSize(500*1024*1024);
mySmartUpload.upload();
com.jspsmart.upload.File myFile = mySmartUpload.getFiles().getFile(0);
title=mySmartUpload.getRequest().getParameter("title");
keyword=mySmartUpload.getRequest().getParameter("keyword");
receipt=mySmartUpload.getRequest().getParameter("receipt");
sender=mySmartUpload.getRequest().getParameter("sender");
origin=mySmartUpload.getRequest().getParameter("origin");
kind=mySmartUpload.getRequest().getParameter("kind");
String ddate=new SimpleDateFormat("yyyy-MM-dd").format(Calendar.getInstance().getTime());
if (!myFile.isMissing())
{
myFileName=myFile.getFileName();
session.setAttribute("tmp_file_name",myFileName);
String suffix=myFileName.substring(0,myFileName.lastIndexOf('.'));
String ext= myFile.getFileExt();
fileSize=myFile.getSize();
String aa=(String)session.getAttribute("ftrace");
dir=aa;
trace=aa+myFileName;
myFile.saveAs(trace,mySmartUpload.SAVE_PHYSICAL);
}
Connection conn = null;
Statement stmt=null;
ResultSet rs=null;
try {
String dsn = "jdbc:odbc:my";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(dsn,"","");
}
catch (Exception ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
String sql="insert into file_upload_info(title,keyword,receipt,sender,origin,kind,fileSize,trace,myFileName,ddate,dir) values('"+title+"','"+keyword+"','"+receipt+"','"+sender+"','"+origin+"','"+kind+"','"+fileSize+"','"+trace+"','"+myFileName+"','"+ddate+"','"+dir+"')";
stmt.executeUpdate(sql);
String sql2="select id from file_upload_info order by id desc";
rs=stmt.executeQuery(sql2);
rs.next();
id=rs.getInt(1);
stmt.close();
conn.close();
%>
<table width="890" height="76" border="0">
<tr>
<th width="884" height="72" bgcolor="#3399FF" scope="col"><div align="left"><img src="image/105948-10.gif" width="350" height="65"></div></th>
</tr>
</table>
<table width="890" height="733" border="0">
<tr>
<td width="10" rowspan="6" bgcolor="#FFFFFF" scope="col"><p align="center"> </p>
<div align="center"></div></td>
<td width="870" height="93" scope="col"><div align="center">
<pre>当前-><span class="style1">上传结果</span> <a href="upload.jsp" class="style2">上传文件</a> <a href="query.jsp" class="style2"> 查询文件</a> <a href="modify.jsp" class="style2">修改路径</a></pre>
</div></td>
</tr>
<tr>
<th width="870" align="center" valign="top" scope="col"><form name="form1" method="post" action="">
<table width="556" height="300" border="0">
<tr>
<th colspan="2" scope="col"><div align="center">上传结果：</div></th>
</tr>
<tr>
<td width="135"><div align="center"><strong>文件编号：</strong></div></td>
<td width="564" align="center" valign="top"><div align="left">政<%=id%>号</div></td>
</tr>
<tr>
<td><div align="center">文件名称：</div></td>
<td><div align="left"><%=title%></div></td>
</tr>
<tr>
<td><div align="center">文件关键字：</div></td>
<td><div align="left"><%=keyword%></div></td>
</tr>
<tr>
<td><div align="center">接收人：</div></td>
<td><div align="left"><%=receipt%></div></td>
</tr>
<tr>
<td><div align="center">发送人：</div></td>
<td><div align="left"><%=sender%></div></td>
</tr>
<tr>
<td><div align="center">文件来源：</div></td>
<td><div align="left"><%=origin%></div></td>
</tr>
<tr>
<td><div align="center">文件类型：</div></td>
<td><div align="left"><%=kind%></div></td>
</tr>
<tr>
<td><div align="center">文件大小：</div></td>
<td><div align="left"><%=fileSize%> bytes</div></td>
</tr>
<tr>
<td colspan="2"><div align="center"></div></td>
</tr>
</table>
</form></th>
</tr>
<tr>
<td height="50"><div align="right">返回主界面<a href="upload.jsp"><img src="image/sales.gif" width="21" height="22" border="0"></a></div></td>
</tr>
<tr>
<td height="87"> </td>
</tr>
<tr>
<td height="87"> </td>
</tr>
<tr>
<td height="94"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -