【JSP开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了JSP开源代码-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;
//前8位编码
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);
str
上一篇:
filesearch.jsp
下一篇:
行走梵净山之(三)一世一遇,即是懂得