<%@page pageEncoding="utf-8" contentType="text/html; charset=utf-8"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Insert title here</title>
<script src="../../js/jquery-1.11.2.js" type="text/javascript" charset="utf-8"></script>
<script type="text/javascript">
function GetQueryString(name)
{
     var reg = new RegExp("(^|&)"+ name +"=([^&]*)(&|$)");
     var r = window.location.search.substr(1).match(reg);
     if(r!=null)return  unescape(r[2]); return null;
}
	$(function(){
		var r = GetQueryString("uri");
		
		$("#fileName").val(r);
		
	});
	
</script>
</head>
<body>
	<form action="getFile.do" method="post">
		<div name="b">
			<span>文件名路径：<input type="text" name="fileName" id="fileName"/></span> <input
				type="submit" value="提交" />
		</div>
	</form>
	
	
	<form action="toCheck.do" method="post">
	<span>请选择sheet表：<select name="sheetName">	
		<c:forEach items="${sheetName}" var="sheetName">
			<option value="${sheetName}" >${sheetName}</option>
		</c:forEach>
		</select>	
		<input type="hidden" value="${fileName}" name="fileName" />
		</span>	
		<input type="submit" value="提交"/>
	</form>
	
	<form action="getword.do" method="post">
		<span>请选择数据库表：<select name="tableName">
			<c:forEach items="${tableName}" var="tableName">
				<option value="${tableName}">${tableName}</option>
			</c:forEach>
		</select></span>
		<input  type="submit" value="提交"/>
		<input type="hidden" value="${sheetName}" name="sheetName"/>
		<input type="hidden" value="${fileName}" name="fileName"/>
	</form>
	
	
	<form action="insertSql.do" method="post">
		<div>
			<span>导入的产品为：<select name="productId">
			<option value="0">沪深300指数 </option>
			<c:forEach items="${product}" var="product">
				<option value="${product.productId}">${product.productName}</option>
			</c:forEach>
			</select>
			</span>
		</div>
		<div>
			<ul>
			<li>单位净值：<select name="accumulativeValue">
							<option ></option>
							<c:forEach items="${list}" var="list">
								<option value="${list.index}">${list.value}</option>
							</c:forEach>
					</select>
				</li>
				<li>净值(劣后)：<select name="netValue">
							<option></option>
							<c:forEach items="${list}" var="list">
								<option value="${list.index}">${list.value}</option>
							</c:forEach>
					</select>
				</li>
				<li>日期：<select name="expiryDate">
							<option></option>
							<c:forEach items="${list}" var="list">
								<option value="${list.index}">${list.value}</option>
							</c:forEach>
					</select>
				</li>
			</ul>
		</div>
		<div>
			<input type="submit" value="导入到数据库" />
		</div>
		<input type="hidden" name="fileName" value="${fileName}" /> <input
			type="hidden" name="sheetName" value="${sheetName}" /> <input
			type="hidden" name="tableName" value="${tableName}" />
	</form>
	
</body>
</html>