📄 hql.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-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'/>">
<web:js src="flexgrid.js"/>
<web:js src="calendar.js"/>
<link rel="stylesheet" type="text/css" href="<%=SkinUtils.getCSS(request,"date.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">
<%
    //获取数据集合
    List list=new ArrayList();
    for(int i=0;i<15;i++){
        Address address = new Address();
		address.setId(i);
		address.setCity(String.valueOf(i));
		address.setCountry("20041212");
		address.setState("11");
		address.setStreet1("大连("+i+")");
		address.setStreet2("hhhfhf");
		address.setZipcode("0");		
		list.add(address);
	}
	//枚举值测试
	HashMap map = new HashMap();
	map.put("00","女");
	map.put("01","男");	
	request.setAttribute("enum",map.entrySet());
	//下拉框值测试
	List select = new ArrayList();
	HashMap map1;
	for (int i=0;i<10;i++){
	    map1 = new HashMap();
	    map1.put("id",String.valueOf(i));
	    select.add(map1);
	}
	request.setAttribute("addressId",select);
		
	Page ourPage = new Page(list,87);    
    QueryTool tool = new QueryTool(request);
    out.print("生成hql为:"+tool.getHqlObject());   
	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="hql.jsp">

<table>
<flex:search>
    <tr>    
	<td>第一列<flex:searchText name="name1" searchName="User.column1" dataType="java.lang.String" operSymbol=">" isNull="true" 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="lixy" action="hql.jsp" image="search.gif" imgClick="myclick()">
	</flex:searchImg></td>
	</tr>
</flex:search>
</table>

<flex:flexgrid name="grid2" height="200" isSubmit="true">
        <flex:checkboxCol caption="选择" name="aa" width="50" property="id" sortName="User.column2"></flex:checkboxCol>
		<flex:flexCol caption="文本列" name="bb" sortName="User.column3" width="100" property="street1"></flex:flexCol>
		<flex:flexCol caption="货币列" width="100" name="cc" property="city" type="currency" sortName="User.column4" isSum="true"></flex:flexCol>
		<flex:flexCol caption="日期列" width="100" name="dd" property="country" type="date" format="yyyyMMdd#yyyy年MM月dd日" sortName="User.column5" isSum="true"></flex:flexCol>
		<flex:flexCol caption="数值列" width="100" name="ee" property="$city*city+1" type="double" format="6#;" sortName="User.column6" isSum="true"></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="hql.jsp" pageSize="15" turnPageClick="myclick()">
</flex:pagePolit>
</html:form>
</BODY>
</HTML>
<script language="javascript">
grid2.show();
function myclick(){
}
</script>
⌨️ 快捷键说明

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