ibatIS中$与#的差别

ibatIS中$与#的区别

在ibatIS中经常会用到： $ 和 # 符号。

?

一、区别

$aaa$ 输出参数是以字符串方式直接输出 123

#aaa# 输出参数是以Parameter方式输出 @aaa

?

二、实际应用

1.sqlMap配置文件

<!-- 查询左树菜单 --><select id="queryMenu"  parameterresultname="code">public List<List<TEmployeePriv>> queryMenu(TEmployeePriv priv)throws SQLException {List<TEmployeePriv> allPrivList = new ArrayList<TEmployeePriv>();List<TEmployeePriv> firstList = new ArrayList<TEmployeePriv>();List<TEmployeePriv> secondList = new ArrayList<TEmployeePriv>();String orderType = Converter.getCfgValue("manage_menu_type");//配置表，菜单排序类型/*if("215".equals(orderType)){priv.setMenuRank1("t1.menu_rank_1");}else if("216".equals(orderType)){priv.setMenuRank1("t1.menu_rank_2");}else if("217".equals(orderType)){priv.setMenuRank1("t1.menu_rank_3");}else{priv.setMenuRank1("t1.menu_rank_1");}*/priv.setMenuRank1("t1.menu_rank_1");//直接设置字符串(死的参数)priv.setEmployeeId(this.getUserId());//设置参数方式(活的参数)allPrivList = empDAO.queryMenu(priv);//根据权限查询当前商户的菜单/*1.加载一级菜单*/if( allPrivList.size()>0 ){for( TEmployeePriv firstPriv : allPrivList ){if(null==firstPriv.getMenuId1()){firstList.add(firstPriv);//一级菜单}}}/*2.加载二级菜单*/for( TEmployeePriv firstPriv : firstList ){for(TEmployeePriv secondPriv : allPrivList){if(null!=secondPriv.getMenuId1()&&firstPriv.getPrivNum().equals(secondPriv.getMenuId1())){secondList.add(secondPriv);}}}List<List<TEmployeePriv>> result = new ArrayList<List<TEmployeePriv>>();result.add(firstList);result.add(secondList);return result;}