|
<%@ page contentType="text/html; charset=gb2312" import="java.util.*,java.io.*,java.net.*,java.util.regex.*"%>
<%@ page import="com.evsoft.file.*" %>
<%@ page import="com.evsoft.db.*" %>
<%@ page import="com.evsoft.util.*" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>數(shù)據(jù)導(dǎo)入</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../css/style.css" type=text/css rel=stylesheet>
<SCRIPT language=javascript src="../../js/checkbox.js" CHARSET="gb2312"></SCRIPT>
<script>
function submitinport()
{
if ( document.forms[0].filename1.value == "" )
{
alert("請(qǐng)輸入數(shù)據(jù)來(lái)源文件！");
return false;
}
document.getElementById("pwait").style.display = ‘‘;
return false;
}
</script>
</head>
<body>
<table align=‘center‘ border=0 width=‘100%‘ height=‘100%‘ cellPadding=4 cellspacing=1 bgColor=#99ccff>
<tr>
<td valign=‘top‘ bgColor=#f0f4f9>
<%!
String Upload(HttpServletRequest request) throws Exception
{
String path = request.getRealPath("/excel_card");
System.out.println("import path = " + path);
String msg = "文件上傳失敗";
UploadFile fileBean = new UploadFile();
fileBean.setObjectPath(path);
fileBean.setSize(10000*1024);
fileBean.setSuffix(".txt.gif.jpg.png.jpge.html.htm.gz.xls.zip.csv");
fileBean.setNamingType(fileBean.OLD_NAME);
fileBean.setSourceFile(request);
String [] saSourceFile = fileBean.getSourceFile();
String [] saObjectFile = fileBean.getObjectFileName();
String [] saDescription = fileBean.getDescription();
String FileName = "";
int iCount = fileBean.getCount();
String fileName2 = saObjectFile[0];
String sObjectPath = fileBean.getObjectPath();
//Action = fileBean.getFieldValue("Action");
FileName = fileName2;
System.out.println("sam_____path_"+path +"/"+FileName);
return path +"/"+FileName;
}
%>
<%
String errHtml = "";
if ( request.getParameter("ss") == null )
{
String path = Upload(request);
System.out.println("path_sam==="+path);
String templateContent="";
FileInputStream fileinputstream = new FileInputStream(path);//讀取模塊文件
int lenght = fileinputstream.available();
byte bytes[] = new byte[lenght];
fileinputstream.read(bytes);
fileinputstream.close();
templateContent = new String(bytes);
//out.println("=================="+templateContent);
String fileame = "outport_sa.xls";
fileame = request.getRealPath("/")+"/new_report/"+fileame;//生成的outport文件保存路徑
FileOutputStream fileoutputstream = new FileOutputStream(fileame);//建立文件輸出流
byte tag_bytes[] = templateContent.getBytes();
fileoutputstream.write(tag_bytes);
fileoutputstream.close();
}
if ( errHtml.equals("") )
{
%>
<form name="form1" method="POST" enctype="MULTIPART/FORM-DATA" action="aa.jsp">
<br>
<input type=file size=30 class=input name=filename1><br>
<input type=submit name=inportIT value=" 確 定 " class=button3 onclick="submitinport()">
<br><br><br>
<div id="pwait" style="display:none">
正在導(dǎo)入，請(qǐng)稍候...
</div>
</form>
<%
}
%>
</td>
</tr>
</table>
</body>
</html>
|
