SSH物流开发系统设计：区域和分区的增删改查

一、区域数据操作

批量导入功能

1、前端页面逻辑
首先ajax不能做文件上传。需要用到jquery插件。
第一步：在jsp页面中引入插件的js文件

<script type="text/javascript" src="${pageContext.request.contextPath }/js/jquery.ocupload-1.1.2.js"></script>

第二步：在页面中提供一个元素以供标示。

{
        id : 'button-import',
        text : '导入',
        iconCls : 'icon-redo'
    }

第三步：调用插件提供的upload方法，动态修改页面html代码

        //调用OCupload插件的方法
        $("#button-import").upload({
                action: '${pageContext.request.contextPath}/regionAction_importXls.action',  
                name: 'myFile',
                onComplete: function(data) {
                    if(data == '1'){
                        //上传成功
                        $.messager.alert("提示信息","区域数据导入成功！","info");
                    }else{
                        //失败
                        $.messager.alert("提示信息","区域数据导入失败！","warning");
                    }
                }
            });

2、后台系统逻辑
pojo基础类：Region

package com.crm.bos.domain;

import java.util.HashSet;
import java.util.Set;
/**
 * 区域实体
 *
 */

public class Region implements java.io.Serializable {

    // Fields

    private String id;
    private String province;
    private String city;
    private String district;
    private String postcode;
    private String shortcode;
    private String citycode;

    public String getName(){
        return province+city + district;
    }

    private Set subareas = new HashSet(0);

    // Constructors

    /** default constructor */
    public Region() {
    }

    /** minimal constructor */
    public Region(String id) {
        this.id = id;
    }

    /** full constructor */
    public Region(String id, String province, String city, String district,
            String postcode, String shortcode, String citycode, Set subareas) {
        this.id = id;
        this.province = province;
        this.city = city;
        this.district = district;
        this.postcode = postcode;
        this.shortcode = shortcode;
        this.citycode = citycode;
        this.subareas = subareas;
    }

    // Property accessors

    public String getId() {
        return this.id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getProvince() {
        return this.province;
    }

    public void setProvince(String province) {
        this.province = province;
    }

    public String getCity() {
        return this.city;
    }

    public void setCity(String city) {
        this.city = city;
    }

    public String getDistrict() {
        return this.district;
    }

    public void setDistrict(String district) {
        this.district = district;
    }

    public String getPostcode() {
        return this.postcode;
    }

    public void setPostcode(String postcode) {
        this.postcode = postcode;
    }

    public String getShortcode() {
        return this.shortcode;
    }

    public void setShortcode(String shortcode) {
        this.shortcode = shortcode;
    }

    public String getCitycode() {
        return this.citycode;
    }

    public void setCitycode(String citycode) {
        this.citycode = citycode;
    }

    public Set getSubareas() {
        return this.subareas;
    }

    public void setSubareas(Set subareas) {
        this.subareas = subareas;
    }

}

相应的Hibernate映射文件

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.crm.bos.domain.Region" table="bc_region" catalog="bos19">
        <id name="id" type="java.lang.String">
            <column name="id" length="32" />
            <generator class="assigned" />
        </id>
        <property name="province" type="java.lang.String">
            <column name="province" length="50" />
        </property>
        <property name="city" type="java.lang.String">
            <column name="city" length="50" />
        </property>
        <property name="district" type="java.lang.String">
            <column name="district" length="50" />
        </property>
        <property name="postcode" type="java.lang.String">
            <column name="postcode" length="50" />
        </property>
        <property name="shortcode" type="java.lang.String">
            <column name="shortcode" length="30" />
        </property>
        <property name="citycode" type="java.lang.String">
            <column name="citycode" length="30" />
        </property>
        <set name="subareas" inverse="true">
            <key>
                <column name="region_id" length="32" />
            </key>
            <one-to-many class="com.crm.bos.domain.Subarea" />
        </set>
    </class>
</hibernate-mapping>

action处理类：

@Controller
@Scope("prototype")
public class RegionAction extends BaseAction<Region> {
    // 接收上传的文件
    private File myFile;

    public void setMyFile(File myFile) {
        this.myFile = myFile;
    }

    /**
     * 批量导入
     * 
     * @throws IOException
     * @throws FileNotFoundException
     */
    public String importXls() throws Exception {
        String flag = "1";
        // 使用ＰＯＩ解析Ｅｘｃｅｌ文件
        try {
            HSSFWorkbook workbook = new HSSFWorkbook(
                    new FileInputStream(myFile));
            // 获得第一个sheet页
            HSSFSheet sheet = workbook.getSheetAt(0);
            List<Region> list = new ArrayList<Region>();
            for (Row row : sheet) {
                int rowNum = row.getRowNum();
                if (rowNum == 0) {
                    // 第一行，标题行，忽略
                    continue;
                }
                String id = row.getCell(0).getStringCellValue();
                String province = row.getCell(1).getStringCellValue();
                String city = row.getCell(2).getStringCellValue();
                String district = row.getCell(3).getStringCellValue();
                String postcode = String.valueOf((long) row.getCell(4)
                        .getNumericCellValue());
                Region region = new Region(id, province, city, district,
                        postcode, null, null, null);
                city = city.substring(0, city.length() - 1);
                String[] stringToPinyin = PinYin4jUtils.stringToPinyin(city);
                String citycode = StringUtils.join(stringToPinyin, "");

                // 简码---->>HBSJZCA
                province = province.substring(0, province.length() - 1);
                district = district.substring(0, district.length() - 1);
                String info = province + city + district;// 河北石家庄长安
                String[] headByString = PinYin4jUtils.getHeadByString(info);
                String shortcode = StringUtils.join(headByString, "");

                region.setCitycode(citycode);
                region.setShortcode(shortcode);
                list.add(region);
            }
            regionService.saveBatch(list);
        } catch (Exception e) {
            e.printStackTrace();
            flag = "0";
        }
        ServletActionContext.getResponse().setContentType(
                "text/html;charset=UTF-8");
        ServletActionContext.getResponse().getWriter().print(flag);
        return NONE;
    }

这里使用Pinyin4J生成简码和城市编码

public class PinYin4jUtils {
    /**
     * 将字符串转换成拼音数组
     * 
     * @param src
     * @return
     */
    public static String[] stringToPinyin(String src) {
        return stringToPinyin(src, false, null);
    }

    /**
     * 将字符串转换成拼音数组
     * 
     * @param src
     * @return
     */
    public static String[] stringToPinyin(String src, String separator) {

        return stringToPinyin(src, true, separator);
    }

    /**
     * 将字符串转换成拼音数组
     * 
     * @param src
     * @param isPolyphone
     *            是否查出多音字的所有拼音
     * @param separator
     *            多音字拼音之间的分隔符
     * @return
     */
    public static String[] stringToPinyin(String src, boolean isPolyphone,
            String separator) {
        // 判断字符串是否为空
        if ("".equals(src) || null == src) {
            return null;
        }
        char[] srcChar = src.toCharArray();
        int srcCount = srcChar.length;
        String[] srcStr = new String[srcCount];

        for (int i = 0; i < srcCount; i++) {
            srcStr[i] = charToPinyin(srcChar[i], isPolyphone, separator);
        }
        return srcStr;
    }

    /**
     * 将单个字符转换成拼音
     * 
     * @param src
     * @return
     */
    public static String charToPinyin(char src, boolean isPolyphone,
            String separator) {
        // 创建汉语拼音处理类
        HanyuPinyinOutputFormat defaultFormat = new HanyuPinyinOutputFormat();
        // 输出设置，大小写，音标方式
        defaultFormat.setCaseType(HanyuPinyinCaseType.LOWERCASE);
        defaultFormat.setToneType(HanyuPinyinToneType.WITHOUT_TONE);

        StringBuffer tempPinying = new StringBuffer();

        // 如果是中文
        if (src > 128) {
            try {
                // 转换得出结果
                String[] strs = PinyinHelper.toHanyuPinyinStringArray(src,
                        defaultFormat);

                // 是否查出多音字，默认是查出多音字的第一个字符
                if (isPolyphone && null != separator) {
                    for (int i = 0; i < strs.length; i++) {
                        tempPinying.append(strs[i]);
                        if (strs.length != (i + 1)) {
                            // 多音字之间用特殊符号间隔起来
                            tempPinying.append(separator);
                        }
                    }
                } else {
                    tempPinying.append(strs[0]);
                }

            } catch (BadHanyuPinyinOutputFormatCombination e) {
                e.printStackTrace();
            }
        } else {
            tempPinying.append(src);
        }

        return tempPinying.toString();

    }

    public static String hanziToPinyin(String hanzi) {
        return hanziToPinyin(hanzi, " ");
    }

    /**
     * 将汉字转换成拼音
     * 
     * @param hanzi
     * @param separator
     * @return
     */
    public static String hanziToPinyin(String hanzi, String separator) {

        // 创建汉语拼音处理类
        HanyuPinyinOutputFormat defaultFormat = new HanyuPinyinOutputFormat();
        // 输出设置，大小写，音标方式
        defaultFormat.setCaseType(HanyuPinyinCaseType.LOWERCASE);
        defaultFormat.setToneType(HanyuPinyinToneType.WITHOUT_TONE);

        String pinyingStr = "";
        try {
            pinyingStr = PinyinHelper.toHanyuPinyinString(hanzi, defaultFormat,
                    separator);
        } catch (BadHanyuPinyinOutputFormatCombination e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return pinyingStr;
    }

    /**
     * 将字符串数组转换成字符串
     * 
     * @param str
     * @param separator
     *            各个字符串之间的分隔符
     * @return
     */
    public static String stringArrayToString(String[] str, String separator) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < str.length; i++) {
            sb.append(str[i]);
            if (str.length != (i + 1)) {
                sb.append(separator);
            }
        }
        return sb.toString();
    }

    /**
     * 简单的将各个字符数组之间连接起来
     * 
     * @param str
     * @return
     */
    public static String stringArrayToString(String[] str) {
        return stringArrayToString(str, "");
    }

    /**
     * 将字符数组转换成字符串
     * 
     * @param str
     * @param separator
     *            各个字符串之间的分隔符
     * @return
     */
    public static String charArrayToString(char[] ch, String separator) {
        StringBuffer sb = new StringBuffer();
        for (int i = 0; i < ch.length; i++) {
            sb.append(ch[i]);
            if (ch.length != (i + 1)) {
                sb.append(separator);
            }
        }
        return sb.toString();
    }

    /**
     * 将字符数组转换成字符串
     * 
     * @param str
     * @return
     */
    public static String charArrayToString(char[] ch) {
        return charArrayToString(ch, " ");
    }

    /**
     * 取汉字的首字母
     * 
     * @param src
     * @param isCapital
     *            是否是大写
     * @return
     */
    public static char[] getHeadByChar(char src, boolean isCapital) {
        // 如果不是汉字直接返回
        if (src <= 128) {
            return new char[] { src };
        }
        // 获取所有的拼音
        String[] pinyingStr = PinyinHelper.toHanyuPinyinStringArray(src);

        // 创建返回对象
        int polyphoneSize = pinyingStr.length;
        char[] headChars = new char[polyphoneSize];
        int i = 0;
        // 截取首字符
        for (String s : pinyingStr) {
            char headChar = s.charAt(0);
            // 首字母是否大写，默认是小写
            if (isCapital) {
                headChars[i] = Character.toUpperCase(headChar);
            } else {
                headChars[i] = headChar;
            }
            i++;
        }

        return headChars;
    }

    /**
     * 取汉字的首字母(默认是大写)
     * 
     * @param src
     * @return
     */
    public static char[] getHeadByChar(char src) {
        return getHeadByChar(src, true);
    }

    /**
     * 查找字符串首字母
     * 
     * @param src
     * @return
     */
    public static String[] getHeadByString(String src) {
        return getHeadByString(src, true);
    }

    /**
     * 查找字符串首字母
     * 
     * @param src
     * @param isCapital
     *            是否大写
     * @return
     */
    public static String[] getHeadByString(String src, boolean isCapital) {
        return getHeadByString(src, isCapital, null);
    }

    /**
     * 查找字符串首字母
     * 
     * @param src
     * @param isCapital
     *            是否大写
     * @param separator
     *            分隔符
     * @return
     */
    public static String[] getHeadByString(String src, boolean isCapital,
            String separator) {
        char[] chars = src.toCharArray();
        String[] headString = new String[chars.length];
        int i = 0;
        for (char ch : chars) {

            char[] chs = getHeadByChar(ch, isCapital);
            StringBuffer sb = new StringBuffer();
            if (null != separator) {
                int j = 1;

                for (char ch1 : chs) {
                    sb.append(ch1);
                    if (j != chs.length) {
                        sb.append(separator);
                    }
                    j++;
                }
            } else {
                sb.append(chs[0]);
            }
            headString[i] = sb.toString();
            i++;
        }
        return headString;
    }

    public static void main(String[] args) {
        // pin4j 简码 和 城市编码 
        String s1 = "中华人民共和国"; 
        String[] headArray = getHeadByString(s1); // 获得每个汉字拼音首字母
        System.out.println(Arrays.toString(headArray));

        String s2 ="长城" ; 
        System.out.println(Arrays.toString(stringToPinyin(s2,true,",")));

        String s3 ="长";
        System.out.println(Arrays.toString(stringToPinyin(s3,true,",")));
    }
}

service层代码如下：

@Service
@Transactional
public class RegionServiceImpl implements IRegionService{
    @Resource
    private IRegionDao regionDao;

    public void saveBatch(List<Region> list) {
        for (Region region : list) {
            regionDao.saveOrUpdate(region);
        }
    }

双击编辑

1、前端逻辑

function doDblClickRow(rowIndex, rowData){
        //rowIndex是选中的行号索引（从0开始），rowData是当前行的数据，json格式
        //弹出修改窗口
        $('#addRegionWindow').window("open");
        $("#addRegionForm").form("load",rowData);//载入原有的表单数据
    }

2、后台逻辑
action类：

//添加和修改功能
    public String add(){
        regionService.save(model);
        return "list";
    }

service层：

public void save(Region model) {
        regionDao.saveOrUpdate(model);
    }

批量删除

1、前端逻辑

function doDelete(){
        //判断是否选择了内容
        var rows = $("#grid").datagrid("getSelections");
        if(rows.length==0){
            //未选中内容
            $.messager.alert("提示信息","请选择需要删除的数据","warning");
        }else{
            //获得选中的区域id,拼接字符串
            var array = new Array();
            for(var i=0;i<rows.length;i++){
                var id=rows[i].id;
                array.push(id);
            }
            var ids = array.join(",");//将数组中的数据分割
            //发送请求
            window.location.href="${pageContext.request.contextPath }/regionAction_delete.action?ids="+ids;
        }
    }

2、后台逻辑
action类：

// 批量作废
    private String ids;

    public String delete() {
        regionService.deleteBatch(ids);
        System.out.println();
        return "list";
    }

    public void setIds(String ids) {
        this.ids = ids;
    }

service层：

public void deleteBatch(String ids) {
        String[] sids = ids.split(",");
        Region region=null;
        for (String id : sids) {
            region=new Region(id);
            regionDao.delete(region);
        }
    }

二、重构分页查询代码

1、在BaseAction中抽取PageBean对象和条件查询对象

    protected PageBean pageBean = new PageBean();
    DetachedCriteria detachedCriteria = null;//条件查询对象
    protected int page;// 分页参数
    protected int rows;

2、在BaseAction中提供setPage和setRows方法

    public void setPage(int page) {
        pageBean.setCurrentPage(page);
    }

    public void setRows(int rows) {
        pageBean.setPageSize(rows);
    }

3、在BaseAction的构造方法中创建条件查询对象，并注入给PageBean对象

public BaseAction() {
        ParameterizedType genericSuperclass = null;
        Type genericSuperclass2 = this.getClass().getGenericSuperclass();
        if(genericSuperclass2 instanceof ParameterizedType){
            genericSuperclass=(ParameterizedType) genericSuperclass2;
        }else {//此时this为shiro的代理对象
            genericSuperclass=(ParameterizedType) this.getClass().getSuperclass().getGenericSuperclass();
        }
        Type[] actualTypeArguments = genericSuperclass.getActualTypeArguments();
        Class<T> entityClass = (Class<T>) actualTypeArguments[0];
        detachedCriteria = DetachedCriteria.forClass(entityClass);
        pageBean.setDetachedCriteria(detachedCriteria);
        try {
            model = entityClass.newInstance();
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        }
    }

4、在BaseAction中抽取将PageBean对象转为json的方法

// 将pageBean对象转为json
    public void writePageBean2Json(PageBean pageBean, String[] excludes) {
        JsonConfig jsonConfig = new JsonConfig();
        jsonConfig.setExcludes(excludes);
        JSONObject jsonObject = JSONObject.fromObject(pageBean, jsonConfig);
        String json = jsonObject.toString();
        ServletActionContext.getResponse().setContentType(
                "text/json;charset=UTF-8");
        try {
            ServletActionContext.getResponse().getWriter().print(json);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }

三、添加分区

1、前端页面逻辑

<!-- 添加 修改分区 -->
    <div class="easyui-window" title="分区添加修改" id="addSubareaWindow" collapsible="false" minimizable="false" maximizable="false" style="top:20px;left:200px">
        <div style="height:31px;overflow:hidden;" split="false" border="false" >
            <div class="datagrid-toolbar">
                <a id="save" icon="icon-save" href="#" class="easyui-linkbutton" plain="true" >保存</a>
                <script type="text/javascript">
                    $(function(){
                        $("#save").click(function(){
                            var v = $("#addSubareaForm").form("validate");
                            if(v){
                                $("#addSubareaForm").submit();
                            }
                        });
                    });
                </script>
            </div>
        </div>

        <div style="overflow:auto;padding:5px;" border="false">
            <form id="addSubareaForm" action="${pageContext.request.contextPath }/subareaAction_add.action" method="post">
                <table class="table-edit" width="80%" align="center">
                    <tr class="title">
                        <td colspan="2">分区信息</td>
                    </tr>
                    <tr>
                        <td>选择区域</td>
                        <td>
                            <input class="easyui-combobox" name="region.id"  
                                data-options="mode:'remote',valueField:'id',textField:'name',url:'${pageContext.request.contextPath }/regionAction_listajax.action'" />  
                        </td>
                    </tr>
                    <tr>
                        <td>关键字</td>
                        <td><input type="text" name="addresskey" class="easyui-validatebox" required="true"/></td>
                    </tr>
                    <tr>
                        <td>起始号</td>
                        <td><input type="text" name="startnum" class="easyui-validatebox" required="true"/></td>
                    </tr>
                    <tr>
                        <td>终止号</td>
                        <td><input type="text" name="endnum" class="easyui-validatebox" required="true"/></td>
                    </tr>
                    <tr>
                        <td>单双号</td>
                        <td>
                            <select class="easyui-combobox" name="single" style="width:150px;">  
                                <option value="0">单双号</option>  
                                <option value="1">单号</option>  
                                <option value="2">双号</option>  
                            </select> 
                        </td>
                    </tr>
                    <tr>
                        <td>位置信息</td>
                        <td><input type="text" name="position" class="easyui-validatebox" required="true" style="width:250px;"/></td>
                    </tr>
                </table>
            </form>
        </div>
    </div>

2、在RegionAction中提供listajax方法，查询所有的区域数据，返回json数据。
基础pojo类如下：

package com.crm.bos.domain;
/**
 * 分区实体
 *
 */
public class Subarea implements java.io.Serializable {

    // Fields

    private String id;
    private Decidedzone decidedzone;
    private Region region;
    private String addresskey;
    private String startnum;
    private String endnum;
    private String single;
    private String position;

    public String getSubareaid(){
        return id;
    }
    // Constructors

    /** default constructor */
    public Subarea() {
    }

    /** minimal constructor */
    public Subarea(String id) {
        this.id = id;
    }

    /** full constructor */
    public Subarea(String id, Decidedzone decidedzone, Region region,
            String addresskey, String startnum, String endnum, String single,
            String position) {
        this.id = id;
        this.decidedzone = decidedzone;
        this.region = region;
        this.addresskey = addresskey;
        this.startnum = startnum;
        this.endnum = endnum;
        this.single = single;
        this.position = position;
    }

    // Property accessors

    public String getId() {
        return this.id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public Decidedzone getDecidedzone() {
        return this.decidedzone;
    }

    public void setDecidedzone(Decidedzone decidedzone) {
        this.decidedzone = decidedzone;
    }

    public Region getRegion() {
        return this.region;
    }

    public void setRegion(Region region) {
        this.region = region;
    }

    public String getAddresskey() {
        return this.addresskey;
    }

    public void setAddresskey(String addresskey) {
        this.addresskey = addresskey;
    }

    public String getStartnum() {
        return this.startnum;
    }

    public void setStartnum(String startnum) {
        this.startnum = startnum;
    }

    public String getEndnum() {
        return this.endnum;
    }

    public void setEndnum(String endnum) {
        this.endnum = endnum;
    }

    public String getSingle() {
        return this.single;
    }

    public void setSingle(String single) {
        this.single = single;
    }

    public String getPosition() {
        return this.position;
    }

    public void setPosition(String position) {
        this.position = position;
    }

}

对应的Hibernate映射文件如下：

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.crm.bos.domain.Subarea" table="bc_subarea" catalog="bos19">
        <id name="id" type="java.lang.String">
            <column name="id" length="32" />
            <generator class="uuid" />
        </id>
        <many-to-one name="decidedzone" class="com.crm.bos.domain.Decidedzone" fetch="select">
            <column name="decidedzone_id" length="32" />
        </many-to-one>
        <many-to-one lazy="false" name="region" class="com.crm.bos.domain.Region" fetch="select">
            <column name="region_id" length="32" />
        </many-to-one>
        <property name="addresskey" type="java.lang.String">
            <column name="addresskey" length="100" />
        </property>
        <property name="startnum" type="java.lang.String">
            <column name="startnum" length="30" />
        </property>
        <property name="endnum" type="java.lang.String">
            <column name="endnum" length="30" />
        </property>
        <property name="single" type="java.lang.String">
            <column name="single" length="1" />
        </property>
        <property name="position" type="java.lang.String">
            <column name="position" />
        </property>
    </class>
</hibernate-mapping>

action类：

    // 查询所有区域数据，返回json,支持模糊查询
    public String listajax() throws IOException{
        List<Region> list = null;//regionService.findAll();
        if(StringUtils.isNotBlank(q)){
            list = regionService.findByQ(q.trim());
        }else{
            list = regionService.findAll();
        }
        String[] excludes = new String[]{"subareas","province","city","district","postcode","shortcode","citycode"};
        this.writeList2Json(list, excludes);
        return NONE;
    }

为了使返回的json中含有name字段，需要在Region类中提供getName方法

四、分区组合条件分页查询

1、为查询按钮绑定事件，调用datagrid的load方法，重新发起ajax请求，并且输入框提交参数

$("#btn").click(function(){
            //工具方法，可以将指定的表单中的输入项目序列号为json数据
            $.fn.serializeJson=function(){  
                var serializeObj={};  
                var array=this.serializeArray();
                $(array).each(function(){  
                    if(serializeObj[this.name]){  
                        if($.isArray(serializeObj[this.name])){  
                            serializeObj[this.name].push(this.value);  
                        }else{  
                            serializeObj[this.name]=[serializeObj[this.name],this.value];  
                        }  
                    }else{  
                        serializeObj[this.name]=this.value;   
                    }  
                });  
                return serializeObj;  
            }; 
            var params = $("#searchForm").serializeJson();
            //重新发起一次ajax的请求
            $("#grid").datagrid("load",params);
            //关闭查询窗口
            $('#searchWindow').window("close");
        });

2、修改SubareaAction中的分页查询方法，封装分页查询的条件

public String pageQuery() throws Exception{
        //在查询之前，封装条件
        DetachedCriteria detachedCriteria2 = pageBean.getDetachedCriteria();
        String addresskey = model.getAddresskey();
        Region region = model.getRegion();
        if(StringUtils.isNotBlank(addresskey)){
            //按照地址关键字模糊查询
            detachedCriteria2.add(Restrictions.like("addressKey", addresskey));
        }
        if(region != null){
            //创建别名，用于多表关联查询
            detachedCriteria2.createAlias("region", "r");
            String province = region.getProvince();
            String city = region.getCity();
            String district = region.getDistrict();
            if(StringUtils.isNotBlank(province)){
                //按照省进行模糊查询
                detachedCriteria2.add(Restrictions.like("r.province", "%"+province+"%"));
            }
            if(StringUtils.isNotBlank(city)){
                //按照省进行模糊查询
                detachedCriteria2.add(Restrictions.like("r.city", "%"+city+"%"));
            }
            if(StringUtils.isNotBlank(district)){
                //按照省进行模糊查询
                detachedCriteria2.add(Restrictions.like("r.district", "%"+district+"%"));
            }
        }
        subareaService.pageQuery(pageBean);
        String[] excludes = new String[]{"detachedCriteria","currentPage","pageSize","decidedzone","subareas"};
        this.writePageBean2Json(pageBean, excludes);
        return NONE;
    }

五、分区数据导出功能

导出Excel文件提供客户下载。
1、为“导出”按钮绑定事件

    //导出分区数据到excel文件中并提供下载
    function doExport(){
        //发送请求
        window.location.href = "${pageContext.request.contextPath}/subareaAction_exportXls.action";
    }

第二步：在Action中提供导出方法

  /**
     * 使用POI写入Excel文件，提供下载
     * @throws IOException 
     */
    public String exportXls() throws IOException {
        List<Subarea> list = subareaService.findAll();
        // 在内存中创建一个Excel文件，通过输出流写到客户端提供下载
        HSSFWorkbook workbook = new HSSFWorkbook();
        // 创建一个sheet页
        HSSFSheet sheet = workbook.createSheet("分区数据");
        // 创建标题行
        HSSFRow headRow = sheet.createRow(0);
        headRow.createCell(0).setCellValue("分区编号");
        headRow.createCell(1).setCellValue("区域编号");
        headRow.createCell(2).setCellValue("地址关键字");
        headRow.createCell(3).setCellValue("省市区");

        for (Subarea subarea : list) {
            HSSFRow dataRow = sheet.createRow(sheet.getLastRowNum() + 1);
            dataRow.createCell(0).setCellValue(subarea.getId());
            dataRow.createCell(1).setCellValue(subarea.getRegion().getId());
            dataRow.createCell(2).setCellValue(subarea.getAddresskey());
            Region region = subarea.getRegion();
            dataRow.createCell(3).setCellValue(region.getProvince()+region.getCity()+region.getDistrict());
        }

        String filename = "分区数据.xls";
        String agent = ServletActionContext.getRequest().getHeader("User-Agent");
        filename = FileUtils.encodeDownloadFilename(filename, agent);
        //一个流两个头
        ServletOutputStream out = ServletActionContext.getResponse().getOutputStream();
        String contentType = ServletActionContext.getServletContext().getMimeType(filename);
        ServletActionContext.getResponse().setContentType(contentType);
        ServletActionContext.getResponse().setHeader("content-disposition", "attchment;filename="+filename);
        workbook.write(out);
        return NONE;
    }

六、源码点我