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) //加在类上面，下面方法默认都按这个，不使用可以再在方法上填写覆盖 //事务传播属性为嵌套：如果没有，就...