tyjlearning的博客

insert into TS_SYS_STAFFCERTMANAGER            (            ID,            ORANAME,            STAFFNAME,            CERTTYPE,            CERTNAME,            CERTCODE,            CERT

1.controller层HashMap map = new HashMap();map.put("v_orgid", subjectorg.getOrgid());map.put("v_year", subjectorg.getCreaty());map.put("v_month",subjectorg.getCreatm() );map.put("v_subid", sub

1.sqlserver:获取本级及下级部门 WITH cte as( select deptId,deptName,superdeptid from ts_cttsp_dept where deptid=(select groups from ts_cttsp_staffInfo where staffNum=#{assignee,jdbcType=VARCHAR}) ...

service实现类@Service@Transactional(propagation=Propagation.NESTED,isolation=Isolation.DEFAULT,readOnly = false,rollbackFor=RestException.class)//加在类上面，下面方法默认都按这个，不使用可以再在方法上填写覆盖//事务传播属性为嵌套：如果没有，就...