1.总的struts.xml文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts PUBLIC
    "-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
    "http://struts.apache.org/dtds/struts-2.0.dtd">
<struts>
<constant name="struts.i18n.encoding" value="UTF-8" />
<constant na

select * from acl_team start with team_id = 2
connect by prior team_id = parent_id

显示team_id为2并且其他team_id等于parent_id的记录
就是迭代team_id为2下面所有的儿子及孙子

业务未填收费编号：141
select count(*) from business a inner join busi_fee b on a.id = b.id left join contract c on a.contract = c.id where b.sys_type = 2 and a.state =2 and (b.fee_no is null or length(b.fee_no) <=6) and a.contract is not null and c.state = 1 and c.del_flag='N' and c.curr

乱码是开发Web应用程序一个比较老套又常见问题，由于不同Web应用服务器的默认编码是不一样的，为了方便Web应用在不同的Web应用服务器上移植，最好的做法是Web程序自身来处理编码转换的工作。经典的作法是在web.xml中配置一个编码转换过滤器，Spring就提供了一个编码过滤器类CharacterEncodingFilter，下面，我们为应用配置上这个过滤器：

1. ＜web-app＞
2. …
3. ＜filter＞
4. ＜filter-name＞encodingFilter＜/filter-name＞
5. ＜filter-class＞org.springframework.web.filter.CharacterEncodingFil

package com.powerdemystified.outweb.web.tag;

import com.powerdemystified.outweb.entity.ContentCategory;
import com.powerdemystified.outweb.entity.OutWebIntroduce;
import com.powerdemystified.outweb.framework.spring.context.ApplicationContextUtil;
import com.powerdemystified.outweb.service.common.tag.TagManager;
import com.powerdemystified.outweb.service.news.NewsCenterManger;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.jsp.JspExce