📄 excel.jsp

📁 Web开发的基本框架
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ taglib uri="/tags/web-flex" prefix="flex"%>
<%@ taglib uri="/tags/web-html" prefix="html"%>
<%@ taglib uri="/tags/web-loushang" prefix="loushang"%>
<%@ taglib uri="/tags/web-widgets" prefix="widgets"%>
<%@ taglib uri="/tags/web-i18n" prefix="web"%>
<%@ page import="java.util.*"%>
<%@ page import="bean.Address"%>
<%@ page import="org.loushang.web.taglib.grid.flex.*"%>
<%@ page import="org.loushang.web.taglib.util.*"%>
<%@ page import="org.loushang.util.Page"%>
<%@ page import="org.loushang.web.taglib.util.skin.SkinUtils"%>
<link rel="stylesheet" type="text/css" href="<loushang:ui css='css-xp4.css'/>">
<HTML>
<HEAD>
<TITLE>GRID组件1 </TITLE>
</HEAD>
<table width="100%">
<tr>
<td><label class="title">flexgrid 组件</label></td>
<% String file=request.getServletPath().substring(1);
   String app=request.getContextPath();
%>
<td><label class="title">url：<%=file%></label></td>
<td align="right" valign="bottom" nowrap>&nbsp;[<a href="<%=app%>/src.jsp?target=<%=file %>" target="source">源代码</a>]&nbsp;</td>
</tr>
</table>
<hr>
<BODY topmargin="20px" scroll=no>
<web:js src="flexgrid.js"/>
<web:js src="calendar.js"/>
<link rel="stylesheet" type="text/css" href="<%=SkinUtils.getCSS(request,"date.css")%>">
<%
request.setAttribute(Global.getString("flexgrid.unique"),"excel.jsp");
    //获取数据集合
    List list=new ArrayList();
    for(int i=0;i<15;i++){
        Address address = new Address();
		address.setId(i+100);
		address.setCity(String.valueOf(i));
		address.setCountry("20041212");
		address.setState("11");
		//address.setStreet1("大连("+i+")");
		address.setStreet1("0101");
		address.setStreet2("hhhfhf");
		address.setZipcode("0");		
		list.add(address);
	}
	//枚举值测试
	HashMap map = new HashMap();
	map.put("00","女");
	map.put("01","男");	
	request.setAttribute("enum",map.entrySet());
		
	Page ourPage = new Page(list,87);    
    QueryTool tool = new QueryTool(request);
    out.print("生成sql为:"+tool.getSqlObject());   
	tool.process(ourPage,null);
%>
<%
String str1=(String)request.getParameter("name1");
String str2=(String)request.getParameter("name2");
if (str1==null){
  str1="";
}
if (str2==null){
  str2="";
}
%>
<html:form name="form1" action="excel.jsp">
<table>
<flex:search>
    <tr>    
    <flex:searchJoin joinL="User.column1" joinR="Role.role">
	</flex:searchJoin>
    <flex:searchJoin joinL="User.column1" joinR="Func.func">
	</flex:searchJoin>
	<td>第一列<flex:searchText name="name1" searchName="User.column1" dataType="java.lang.String" operSymbol=" like " value="<%=str1%>">
	</flex:searchText></td>
	<td>第二列<flex:searchText name="name2" searchName="User.column2" dataType="java.lang.String" operSymbol=">" value="<%=str2%>">
	</flex:searchText></td>	
	<td><flex:searchImg name="img" action="excel.jsp" image="search.gif">
	</flex:searchImg></td>
	</tr>
</flex:search>
</table>

<flex:flexgrid name="grid2" height="200" isSubmit="true" export="true">
        <flex:checkboxCol caption="选择" width="50" name="aa" property="id" sortName="User.column2" onclick="select()"></flex:checkboxCol>
		<flex:flexCol caption="文本列" width="100" name="bb" property="street1" sortName="User.column3" onclick="clicktext()"></flex:flexCol>
		<flex:flexCol caption="货币列" width="100" name="cc" property="city" type="currency" sortName="User.column4" isSum="true" onclick="clickcurrency()"></flex:flexCol>
		<flex:flexCol caption="日期列" width="100" name="dd" property="country" type="date" format="yyyyMMdd#yyyy年MM月dd日" sortName="User.column5" media="html"></flex:flexCol>
		<flex:flexCol caption="数值列" width="100" name="ee" property="$city*city+1" type="double" format="6#;" sortName="User.column6" isSum="true"  media="excel"></flex:flexCol>				
		<flex:flexCol caption="枚举列" width="100" name="ff" property="$zipcode+zipcode" type="enum" enumCollection="enum" enumKey="key" enumValue="value" sortName="User.column7"></flex:flexCol>
</flex:flexgrid>

<flex:pagePolit action="excel.jsp" pageSize="15">
</flex:pagePolit>
</html:form>
</BODY>
</HTML>
<script language="javascript">
grid2.show();
function select(){
  alert(grid2.getCellValue(grid2.getCurrentLine(),1));
}

function clicktext(){
    alert(grid2.getCellValue(grid2.getCurrentLine(),2));
}

function clickcurrency(){
    alert(grid2.getCellValue(grid2.getCurrentLine(),3));
}
</script>
⌨️ 快捷键说明

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