📄 filetransfer.jsp
字号:
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<%@page import="java.util.*" %>
<%@page import="javax.servlet.*" %>
<%@page import="javax.servlet.http.*" %>
<%@ page language="java" import="com.jspsmart.upload.*"%>
<%@ page contentType="text/html; charset=GBK" %>
<jsp:useBean id="myUpload" scope="page" class="com.jspsmart.upload.SmartUpload" />
<HTML>
<head>
<style type="text/css"><!--
.wwx{ font-family: 宋体; font-size: 9pt; line-height:140%}
.wwd{ font-family: 宋体; font-size: 14px; line-height:140%}
A:hover{COLOR: blue; FONT-FAMILY: 宋体; FONT-SIZE: 9pt; TEXT-DECORATION: underline}
A.wwl{COLOR: rgb(0,0,0); FONT-FAMILY: 宋体; FONT-SIZE: 9pt; TEXT-DECORATION: none}
--></style>
</head>
<BODY BGCOLOR="white">
<p> </p>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<hr width="50%" noshade size="1" color="#000080">
</td>
</tr>
</table>
<%!
final String URL = "jdbc:oracle:thin:@10.111.10.82:1521:lims";
//保存目录名称
String strBCDZ;
//转换后的文件名称
String strWXZHMC;
//新增加的后四位编码
String strLastNumber;
//所有的关键字组合
String strkey;
//文件名称
String strFileName;
String strNewRec;
String strFinal;
%>
<%
// 初始化
myUpload.initialize(pageContext);
String requestAddr=request.getRemoteAddr();
Calendar calendar = null;
calendar = Calendar.getInstance();
java.util.Date trialTime = new java.util.Date();
calendar.setTime(trialTime);
String tempYear=Integer.toString(calendar.get(Calendar.YEAR));
String tempMonth=Integer.toString(1+calendar.get(Calendar.MONTH));
String tempDay=Integer.toString(calendar.get(Calendar.DAY_OF_MONTH));
String tempHour=Integer.toString(1+calendar.get(Calendar.HOUR_OF_DAY));
String tempMinute=Integer.toString(1+calendar.get(Calendar.MINUTE));
String tempSecond=Integer.toString(1+calendar.get(Calendar.SECOND));
// 文件上传
myUpload.upload();
String strBigBM=myUpload.getRequest().getParameter("dwList").toString();
String strSmallBM=myUpload.getRequest().getParameter("cpList").toString();
String strAuthor=myUpload.getRequest().getParameter("Author").toString();
String strkey1=myUpload.getRequest().getParameter("key1").toString();
String strkey2=myUpload.getRequest().getParameter("key2").toString();
String strkey3=myUpload.getRequest().getParameter("key3").toString();
String strkey4=myUpload.getRequest().getParameter("key4").toString();
strkey=strkey1+" " +strkey2+" "+strkey3+" "+strkey4;
//前８位编码
String strBM=strBigBM+strSmallBM;
// 从大类表中取大类的目录名是否存在，否则建立路径名称;同时;取小类的名称，存详细文献表中，便于查询显示目录树
// String URL = "jdbc:oracle:thin:@10.111.4.20:1521:limsdb";
Connection con_1 = null;
Statement stmt_1 = null;
ResultSet rs_1 = null;
String strSelectBCDZ = "SELECT bcdz FROM lims_wx_dmb_big Where wxfldm_big="+strBigBM;
String strSelectXLMC = "SELECT wxflmc_min FROM lims_wx_dmb_min Where wxfldm_min="+strSmallBM;
String strSelectWXBM="SELECT wxbm FROM lims_wx_mlb where SUBSTR(wxbm,1,8)='" + strBM+"'"+" ORDER BY wxbm DESC";
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con_1 = DriverManager.getConnection(URL, "limsusr", "lims2000");
stmt_1 = con_1.createStatement();
// 辨别相同大类时文件名称是否有重复的
com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(0);
strFileName=myFile.getFileName();
String strCompare="SELECT wxbm FROM lims_wx_mlb where SUBSTR(wxbm,1,4)='" + strBigBM+"'"+" and wxmc='"+strFileName+"'";
rs_1=stmt_1.executeQuery(strCompare);
int recTempCount=0;
while (rs_1.next())
{
recTempCount++;
}
// 辨别相同大类时文件名称是否有重复的
if (recTempCount>=1)
{
strFinal="该大类中已经存在相同文件名的文件，请修改文件名后重新上传！";
}
else
{
// 取项目文献的保存目录
rs_1 = stmt_1.executeQuery(strSelectBCDZ);
rs_1.next();
strBCDZ=rs_1.getString("bcdz").trim();
// 转换文件名称
int intFileLen=strFileName.length();
String strFileLast=strFileName.substring(intFileLen-4,intFileLen);
strWXZHMC=strBCDZ+tempYear+tempMonth+tempDay+tempHour+tempMinute+tempSecond+requestAddr+strFileLast;
//取绝对路径
String fileName="jspsmartupload";
int intFile=fileName.length();
java.io.File file1 = new java.io.File(application.getRealPath("jspsmartupload"));
String tempPath=file1.getAbsolutePath();
int intPath=tempPath.length();
String strAbsPath = tempPath.substring(0,intPath-intFile-1);
String thePath=(strAbsPath+"/"+strBCDZ);
//建立目录
java.io.File testfile= new java.io.File(thePath);
java.io.File file=new java.io.File(thePath);
file.mkdir();
// 取小类名称
rs_1 = stmt_1.executeQuery(strSelectXLMC);
rs_1.next();
String strXLMC=rs_1.getString("wxflmc_min");
// 从项目文献的信息到记录表中得出最后的编码，如果前面八位为新的，则一条八位编码的记录，便于查询时小类下拉框的形成
rs_1 = stmt_1.executeQuery(strSelectWXBM);
int RecCount=0;
while(rs_1.next())
{
RecCount++;
String strTempBM;
strTempBM=rs_1.getString("wxbm");
String intNumber=strTempBM.substring(8,12);
int intTemp=Integer.valueOf(intNumber).intValue();
int intLast=intTemp+1;
if(intLast<=9) strLastNumber="000"+intLast;
if(intLast>=10&&intLast<=99) strLastNumber="00"+intLast;
if(intLast>=100&&intLast<=999) strLastNumber="0"+intLast;
break;
}
if (RecCount<1)
{
String strNewRec="INSERT INTO lims_wx_mlb(wxbm,wxmc,wxzhmc) VALUES('" +strBM+"0000"+ "','" +strXLMC+ "','" +strBCDZ+ "')";
stmt_1.executeUpdate(strNewRec);
strLastNumber="0001";
strNewRec="INSERT INTO lims_wx_mlb(wxbm,wxmc,wxzhmc,bcdz,bcsj,wxzz,keyword1) VALUES('" +strBM+strLastNumber+ "','" +strFileName+ "','" +strWXZHMC+ "','" +strBCDZ+ "',sysdate,'" +strAuthor+ "','" +strkey+ "')";
stmt_1.executeUpdate(strNewRec);
}
else
{
strNewRec="INSERT INTO lims_wx_mlb(wxbm,wxmc,wxzhmc,bcdz,bcsj,wxzz,keyword1) VALUES('" +strBM+strLastNumber+ "','" +strFileName+ "','" +strWXZHMC+ "','" +strBCDZ+ "',sysdate,'" +strAuthor+ "','" +strkey+ "')";
stmt_1.executeUpdate(strNewRec);
}
// 0--一个文件，多个文件的上传用别的方法,Sample5
// com.jspsmart.upload.File myFile = myUpload.getFiles().getFile(0);
// 文件存在保存
if (!myFile.isMissing())
{
// 取大类的目录名，都存入大类的名称
// strFileName=myFile.getFileName();
myFile.saveAs("/"+strBCDZ+"/" + strFileName);
// myFile.saveAs("/upload/" + myFile.getFileName(), myUpload.SAVE_VIRTUAL);
strFinal="恭喜您，文件已上传成功！";
}
//修改文件
java.io.File tempfile= new java.io.File(strAbsPath +"/"+strBCDZ+"/" + strFileName);
java.io.File tempfile1= new java.io.File(strAbsPath +"/"+strBCDZ+"/"+ strWXZHMC);
//out.print(tempfile);
//out.print(strAbsPath +"\\aaa.xls");
tempfile.renameTo(tempfile1);
}
%>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="279" >
<tr>
<td align="center" valign="top" height="286">
<table width="315" border="0" cellspacing="0" cellpadding="0" background="/images/bg.gif" height="226">
<tr>
<td align="center">
<table width="315" border="0" cellspacing="0" cellpadding="0" height="212" background="bgbak.gif">
<tr>
<td width="48" height="119"> </td>
<td width="217" height="119"> </td>
<td width="50" height="119"> </td>
</tr>
<tr>
<td width="48" height="55" valign="top">
</td>
<td width="217" height="55" align="center" class="wwx"><font color="#FFFFFF">
<%
out.print(strFinal);
%>
</font></td>
<td width="50" height="55"> </td>
</tr>
<tr>
<td width="48" height="38"> </td>
<td width="217" valign="top" align="center" height="38"> </td>
<td width="50" height="38"> </td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<a href="javascript:history.back(-1);"><img src="return.gif" width="65" height="21" border="0"><br>
</a>
</td>
</tr>
</table>
<table border="0" width="100%" height="1" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="11">
<hr width="50%" noshade size="1" color="#000080">
</td>
</tr>
<tr>
<td width="100%" height="8" class="wwx">
<p align="center"><img border="0" src="dot_little.gif" width="8" height="11">
<font color="#003366">版权所有：中石化巴陵分公司 敬请使用800*600分辨率、IE4.0以上版本浏览<br>
<img border="0" src="email.gif" width="14" height="10"> 欢迎来信：<a href="mailto:mailzsy@263.net" class="wwl">mailzsy@263.net </a> 联系电话：0730-8501120</font></td>
</tr>
</table>
<%
rs_1.close();
stmt_1.close();
con_1.close();
}
catch(SQLException e)
{
// System.err.print(e.getMessage());
String strFinal= e.getMessage();
// System.err.print(strFinal);
// rs_1.close();
// stmt_1.close();
// con_1.close();
// }
// %>
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="267" >
<tr>
<td align="center" valign="top" height="274">
<table width="315" border="0" cellspacing="0" cellpadding="0" background="/images/bg.gif" height="226">
<tr>
<td align="center">
<table width="315" border="0" cellspacing="0" cellpadding="0" height="212" background="bgbak.gif">
<tr>
<td width="48" height="119"> </td>
<td width="217" height="119"> </td>
<td width="50" height="119"> </td>
</tr>
<tr>
<td width="48" height="55" valign="middle" align="right">
<p align="center"><img border="0" src="caution.gif" align="right" width="17" height="17"></p>
</td>
<td width="217" height="55" align="center" class="wwx"><font color="#FFFFFF">
<%
out.print(strFinal);
%>
</font></td>
<td width="50" height="55"> </td>
</tr>
<tr>
<td width="48" height="38"> </td>
<td width="217" valign="top" align="center" height="38"> </td>
<td width="50" height="38"> </td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<a href="javascript:history.back(-1);"><img src="return.gif" width="65" height="21" border="0"></a>
<p> </p>
</td>
</tr>
</table>
<table border="0" width="100%" height="1" cellspacing="0" cellpadding="0">
<tr>
<td width="100%" height="11">
<hr width="50%" noshade size="1" color="#000080">
</td>
</tr>
<tr>
<td width="100%" height="8" class="wwx">
<p align="center"><img border="0" src="dot_little.gif" width="8" height="11">
<font color="#003366">版权所有：中石化巴陵分公司 敬请使用800*600分辨率、IE4.0以上版本浏览<br>
<img border="0" src="email.gif" width="14" height="10"> 欢迎来信：<a href="mailto:mailzsy@263.net" class="wwl">mailzsy@263.net </a> 联系电话：0730-8501120</font></td>
</tr>
</table>
<%
}
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -