public void queryBeanByNullRowHandler(NullRowHandler rowhandler, String sqlname, Object bean) throws SQLException { queryBeanWithDBNameByNullRowHandler( rowhandler,null, sqlname, bean); } /**
public Map<String, String> getUserDeskMapMenus(DeskTopMenuBean bean) throws Exception { // String sql = "SELECT menupath,subsystem,userid FROM TD_SM_DESKMENU // WHERE userid=#[userid] and subsystem=#[subsystem]"; final Map<String, String> datas = new HashMap<String, String>(); executor.queryBeanWithDBNameByNullRowHandler(new NullRowHandler() { @Override public void handleRow(Record origine) throws Exception { datas.put(origine.getString("menupath"), origine .getString("subsystem")); } }, dbname, "getUserDeskMapMenus", bean); return datas; }
public Map<String,DeskTopMenuBean> queryMenuCustom(DeskTopMenuBean bean)throws Exception{ String sql = "getDeskMenuCustom"; final Map<String,DeskTopMenuBean> listMap = new HashMap<String,DeskTopMenuBean>(); executor.queryBeanWithDBNameByNullRowHandler(new NullRowHandler(){ public void handleRow(Record arg) throws Exception { DeskTopMenuBean dtmb = new DeskTopMenuBean(); dtmb.setWidth(arg.getString("width")); dtmb.setHeight(arg.getString("height")); listMap.put(arg.getString("menupath"),dtmb); } },dbname, sql, bean); return listMap; }
esjdbc.getExecutor().queryBeanWithDBNameByNullRowHandler(resultSetHandler, esjdbc.getDbConfig().getDbName(), esjdbc.getSqlName(),(Map)null); esjdbc.getExecutor().queryBeanWithDBNameByNullRowHandler(resultSetHandler, esjdbc.getDbConfig().getDbName(), esjdbc.getSqlName(), getParamValue());
esjdbc.getExecutor().queryBeanWithDBNameByNullRowHandler(resultSetHandler, esjdbc.getDbConfig().getDbName(), esjdbc.getSqlName(),(Map)null); esjdbc.getExecutor().queryBeanWithDBNameByNullRowHandler(resultSetHandler, esjdbc.getDbConfig().getDbName(), esjdbc.getSqlName(), getParamValue());