public void insertMenuWinSize(ItemMenuCustom bean)throws Exception{ String sql = "insertDeskMenuWinSize"; executor.insertBean(dbname, sql, bean); } public ItemMenuCustom queryMenuWinSize(ItemMenuCustom bean)throws Exception{
public void cleardeskmenu(String userID, String currentSystemID) throws Exception { String sql = "cleardeskmenu"; executor.delete(sql, userID, currentSystemID); }
@SuppressWarnings("rawtypes") @Override public List<HashMap> getBrowserIPDayDistribute(int siteId, String vtime) throws SQLException { Map<String, Object> paramMap = new HashMap<String, Object>(); paramMap.put("siteId", siteId); paramMap.put("vtime", vtime); return executor.queryListBean(HashMap.class, "getBrowserIPDayDistributeByTime", paramMap); }
public void deleteSmOrganization(String orgId) throws SmOrganizationException { try { executor.update("moveUsertoDaigang", orgId); executor.delete("removeOrgManager", orgId); executor.delete("deleteByKey", orgId); } catch (Throwable e) { throw new SmOrganizationException("delete SmOrganization failed::orgId=" + orgId, e); } } public void deleteBatchSmOrganization(String... orgIds) throws SmOrganizationException {
public List<RoleType> queryListRoleTypes(RoleTypeCondition conditions) throws RoleTypeException { try { List<RoleType> beans =conditions == null? executor.queryList(RoleType.class, "queryAllListRoleType"): executor.queryListBean(RoleType.class, "queryListRoleType",conditions); return beans; } catch (Exception e) { throw new RoleTypeException("query RoleType failed:", e); } } }
@Override public ListInfo queryAreaList( int offset, int pagesize) throws Exception { Map<String, Object> paramMap = new HashMap<String, Object>(); ListInfo datas = executor.queryListInfoBean(Area.class, "queryAreaList", offset, pagesize, paramMap); return datas; } @Override
startUser = executor.queryObject(String.class, "getProcessStarter", processID); List<WfRunTask> tasks = getTodoList(processID,startUser,lastOp, this.activitiService.getUserInfoMap().getUserName(lastOper)); executor.delete("deleteWfRunTaskByKey", processID); executor.insertBeans("addWfRunTask", tasks);
@Override public String getOrgIdByUserId(String userId) throws Exception { String orgid = executor.queryObject(String.class, "getOrgIdByUserId", userId); return orgid; } @Override
/** * 更新单条背景信息 * @param bean * @throws Exception */ public void updateDesktopStyleCustom(DeskTopBackGround bean)throws Exception{ String sql = "updateDesktopStyleCustom"; executor.updateBean(dbname, sql, bean); } /**
public void saveClasses(List<DocClass> docClasses,String site_id) throws Exception { // TODO Auto-generated method stub TransactionManager tm = new TransactionManager(); try { tm.begin(); executor.delete("deleteClasses", site_id); executor.insertBeans("saveClasses", docClasses); tm.commit(); } catch(Exception e) { throw e; } finally { tm.release(); } } }
/** * Description:通过字典ID获取字典名称 * @author qingl2 * @version 2013-07-04 */ @Override public List<String> getDictTypeById(String did) throws Exception { List<String> datas = executor.queryList(String.class, "getDictTypeById", did); return datas; }
/** * 该用户删除自定义桌面背景 * @param bean * @throws Exception */ public void deleteDesktopStyleCustom(DeskTopBackGround bean)throws Exception{ String sql = "deleteDesktopStyleCustom"; executor.deleteBean(dbname, sql, bean); } /**
public void insertMenuSort(List<DeskTopMenuBean> beans) throws Exception { String sql = "insertUserDeskMapMenusSort"; executor.insertBeans(dbname, sql, beans); }
@Override public String saveNodeContralParam( List<NodeControlParam> nodeControlParamList, String business_id, String business_type, String process_key) { TransactionManager tm = new TransactionManager(); try { tm.begin(); Map<String, String> params = new HashMap<String, String>(); params.put("process_key", process_key); params.put("business_id", business_id); params.put("business_type", business_type); executor.deleteBean("deleteNodeContralParam", params); for (int i = 0; i < nodeControlParamList.size(); i++) { NodeControlParam nodeControlParam = nodeControlParamList.get(i); nodeControlParam.setID(UUID.randomUUID().toString()); nodeControlParam.setBUSINESS_ID(business_id); nodeControlParam.setBUSINESS_TYPE(business_type); nodeControlParam.setDURATION_NODE(nodeControlParam .getDURATION_NODE() * 60 * 60 * 1000); } executor.insertBeans("addNodeControlParam", nodeControlParamList); tm.commit(); return "success"; } catch (Exception e) { tm.release(); return "fail:" + e.getMessage(); } }
private void initSQLInfo(){ if(esjdbc.getSql() == null || esjdbc.getSql().equals("")){ try { ConfigSQLExecutor executor = new ConfigSQLExecutor(esjdbc.getSqlFilepath()); SQLInfo sqlInfo = executor.getSqlInfo(esjdbc.getSqlName()); esjdbc.setSql(sqlInfo.getSql()); esjdbc.setExecutor(executor); } catch (SQLException e){ throw new ESDataImportException(e); } } } public void setEsjdbc(ESJDBC esjdbc){
executor.insertBeans("insertNodeWorktime_wf", worktimeList); }else { executor.updateBeans("updateNodeWorktime_wf", worktimeList);
protected void initInstanceUpgrade() { if(instanceUpgrade == null) { instanceUpgrade = new InstanceUpgrade(); extendExecutor = new ConfigSQLExecutor("org/activiti/engine/impl/db/upgrade/upgradesql.xml"); instanceUpgrade.setExecutor(extendExecutor); } instanceUpgrade.setTaskService(this.taskService); instanceUpgrade.setRuntimeService(this.runtimeService); instanceUpgrade.init(); }
ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/sysmgrcore/manager/db/job.xml"); Map conditions = new HashMap(); conditions.put("jobname", jobname); conditions.put("jobnumber", jobnumber); datas = executor.queryListInfoBeanByRowHandler(new RowHandler<Job>(){
try ConfigSQLExecutor executor = new ConfigSQLExecutor("com/frameworkset/platform/cms/documentmanager/document.xml"); SQLParams params = new SQLParams(); final SimpleDateFormat dateformat = DataFormatUtil.getSimpleDateFormat(request,"yyyy-MM-dd"); listInfo = executor.queryListInfoBeanByNullRowHandler(new NullRowHandler(){
public ListInfo queryUsers(QueryUserCondition condition, long offset, int pagesize)throws SmUserException{ try { ListInfo _users = this.executor.queryListInfoBean(SmUser.class, "queryUsers", offset, pagesize, condition); // users = _users.getDatas(); return _users; } catch (SQLException e) { throw new SmUserException(e); } } /** (non-Javadoc)