⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 excle.jsp

📁 一个java程序!!!数据库很特别!!请大家看看!!很有学习和使用的价值
💻 JSP
字号:
<%@page contentType="text/html; charset=UTF-8"%>
<%@ include file="/WEB-INF/include/taglib.jsp"%>
<html:html locale="true">
<head>
<TITLE></TITLE>
<LINK href="../css/iplan.css" rel=stylesheet type="text/css">
<script language="javascript" src="../scripts/Calendar.js"></script>
<SCRIPT language=javascript>
	function refresh(){ 
		document.form1.action = "excleAction.do?method=list";
	 	document.form1.target = "_self"; 	   
		document.form1.submit();   
	}
	
	function back(){ 
	 	document.form1.action = "excleAction.do?method=select&sign=excle";
	 	document.form1.target = "_self"; 
		document.form1.submit();   
	}

	function search() {
    	document.form1.action = "excleAction.do?method=search";
    	document.form1.target = "_self"; 
		document.form1.submit();
    } 

	function excle() {
		if(confirm("确定需要Excle操作?可能需要花费较长时间,请稍后...")) {
		    window.open("","excleWindow","left=300,top=200,toolbar=no,width=400,height=245,directories=no,status=yes,scrollbars=yes,resize=no,menubar=no");
	       	form1.action = "excleAction.do?method=excle" ;
	       	form1.target = "excleWindow";
	       	form1.submit();  
		}
    } 

	function customerList()
	{
    	window.open("","customerListWindow","left=600,top=50,toolbar=no,width=400,height=450,directories=no,status=yes,scrollbars=yes,resize=no,menubar=no");
       	form1.action = "selectCustomerAction.do?method=list" ;
       	form1.target = "customerListWindow";
       	form1.submit(); 
	}
	          
	function changeMonth() {
    	var month = document.form1.month.value;
		if (month!=null || !"".equals(month)) {
  			document.form1.month.value = month.substring(0,7);		
		}
    }     
</SCRIPT>
</head>

<body onclick="changeMonth();">
<html:form styleId="form1" focus="orderInfo.orderNo" action="/excleAction.do?method=list">
	<TABLE align="center" cellSpacing=0 border="0" cellPadding="0" width="100%" class="tablebgGREY">
		<TR>
			<TD width="45%" class="TableTxtBold">
				<bean:message key="menu.orderManage.excle" />		
			&nbsp;&nbsp;(<FONT color="red"><bean:write name="areaName"/></FONT>)</TD>
		</TR>
	</TABLE>
	<br>
	<Font color="red">说明:订单号、客户名称可以模糊查询</Font>
	<hr>
	<table border="0" cellspacing="0" cellpadding="1" class="cellBgSEARCHBOX" width="660pt">
		<tr>
			<td class="TableTxtBold" width="10%" style="vertical-align:middle;"><bean:message key="prompt.order.month" /></td>
			<td class="TableTxtNorm">
				<html:text property="orderInfo.month" styleId="month" size="12" maxlength="7" styleClass="formFill1line" onclick="setDay(this);" readonly="true"></html:text>
			</td>
			<td class="TableTxtBold" width="16%" style="vertical-align:middle;"><bean:message key="prompt.order.result" /></td>
			<td class="TableTxtNorm"> 
				<html:select property="orderInfo.ok" styleId="ok" styleClass="formFill1line" >				
					<html:options name="okIdList" labelName="okNameList"></html:options>
				</html:select>
			</td>										
		</tr>		
		<tr>
			<td colspan="5">
				<FONT color="blue">-------------------------------------------------------------------------------------------------------------------------------------------------------------------</FONT>	
			</td>				
		<tr/>
		<tr>
			<td class="TableTxtBold" width="10%" style="vertical-align:middle;"><bean:message key="prompt.order.orderNo" /></td>
			<td class="TableTxtNorm"><html:text property="orderInfo.orderNo" size="18"  styleId="orderNo" styleClass="formFill1line"  onchange="this.value = this.value.toUpperCase()"/></td>
			<td class="TableTxtBold" width="16%" style="vertical-align:middle;"><bean:message key="prompt.order.orderDate" /></td>
			<td class="TableTxtNorm">
				<html:text property="orderInfo.orderDateStr" size="12"  styleId="orderDate" styleClass="formFill1line" onclick="setDay(this);" readonly="true" />&nbsp;&nbsp;~
				<html:text property="orderInfo.orderDateStr2" size="12"  styleId="orderDate2" styleClass="formFill1line" onclick="setDay(this);" readonly="true" />
			</td>			
		</tr>
		<tr>
			<td class="TableTxtBold" width="10%" style="vertical-align:middle;"><bean:message key="prompt.order.customerName" /></td>
			<td class="TableTxtNorm">
				<html:text property="orderInfo.customerName" size="18"  styleId="customerNameStr" styleClass="formFill1line" ondblclick="customerList();" />
			</td>
			<td class="TableTxtBold" width="16%" style="vertical-align:middle;"><bean:message key="prompt.order.printingDate" /></td>
			<td class="TableTxtNorm">
				<html:text property="orderInfo.printingDateStr" size="12"  styleId="printingDate" styleClass="formFill1line" onclick="setDay(this);" readonly="true" />&nbsp;&nbsp;~
				<html:text property="orderInfo.printingDateStr2" size="12"  styleId="printingDate2" styleClass="formFill1line" onclick="setDay(this);" readonly="true" />
			</td>
			<td>
				<button class="button" onclick="search();"><bean:message key="button.search" /></button>			
			</td>					
		</tr>	
	</table>		
	<hr>
		<logic:equal value="true" name="result">
			<table width="500pt" border="0" align="left" class="cellBg" cellspacing="1" cellpadding="0">
				<tr>
					<td colspan="2" class="TableTxtBold"><FONT color="red">检索条件及结果如下:</FONT></td>
				</tr>	
				<tr>
					<td colspan="2" class="TableTxtBold"><FONT color="blue">检索结果</FONT></td>
				</tr>						
				<tr>
					<td class="TableTxtBold" width="35%"><bean:message key="prompt.excle.areaName" /></td>
					<td class="TableTxtNorm"><bean:write name="areaName"/></td>
				</tr>
				<tr>
					<td class="TableTxtBold" width="35%">记录条数</td>
					<td class="TableTxtNorm"><bean:write name="count"/></td>
				</tr>	
				<tr>
					<td colspan="2" class="TableTxtBold"><FONT color="blue">检索条件</FONT></td>
				</tr>	
				<tr>
					<td class="TableTxtBold" width="35%"><bean:message key="prompt.excle.month" /></td>
					<td class="TableTxtNorm"><bean:write name="month"/></td>
				</tr>	
				<tr>
					<td class="TableTxtBold" width="35%">订单处理结果</td>
					<td class="TableTxtNorm"><bean:write name="ok"/></td>
				</tr>					
				<tr>
					<td class="TableTxtBold" width="35%">订单号</td>
					<td class="TableTxtNorm"><bean:write name="orderNo"/></td>
				</tr>													
				<tr>
					<td class="TableTxtBold" width="35%">客户名称</td>
					<td class="TableTxtNorm"><bean:write name="customerName"/></td>
				</tr>						
				<tr>
					<td class="TableTxtBold" width="35%">订单日期</td>
					<td class="TableTxtNorm"><bean:write name="orderDateStr"/>&nbsp;&nbsp;~<bean:write name="orderDateStr2"/></td>
				</tr>	
				<tr>
					<td class="TableTxtBold" width="35%">打印装箱单时间</td>
					<td class="TableTxtNorm"><bean:write name="printingDateStr"/>&nbsp;&nbsp;~<bean:write name="printingDateStr2"/></td>
				</tr>
				<tr>
					<td colspan="2" class="TableTxtBold"><FONT color="blue">Excle</FONT></td>
				</tr>				
				<tr>	
					<td class="TableTxtBold" width="35%">生成Excle</td>
					<td class="TableTxtBold">
						<button class="button" onclick="excle();"><bean:message key="button.excle" /></button>			
					</td>
				</tr>																
			</table>			
		</logic:equal>
	<hr>
	
	<table border="0" cellspacing="0" cellpadding="0" height="35">
		<tr>
			<td>
				<button class="button" onclick="back();"><bean:message key="button.back" /></button>
			<td/>
		</tr>
 	</table>
 	<html:hidden property="orderInfo.areaid"/>
 	<html:hidden property="orderInfo.address" styleId="addressStr"/>
</html:form>
</body>
</html:html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -