| | |
| | | ORDER BY dept.sort |
| | | </select> |
| | | |
| | | <!--查询所有的部门信息--> |
| | | <select id="selDeptList" resultType="org.springblade.common.vo.DeptVo"> |
| | | select id ,dept_name deptName from blade_dept where is_deleted=0 |
| | | </select> |
| | | |
| | | <select id="trees" resultMap="treeNodeResultMap"> |
| | | select id, parent_id, dept_name as title, id as "value", id as "key" from blade_dept where is_deleted = 0 |
| | | ORDER BY sort |
| | |
| | | # commandTimeout: 5000 |
| | | datasource: |
| | | # MySql |
| | | url: jdbc:mysql://192.168.0.105:3306/jfptpublic?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | url: jdbc:mysql://36.134.81.48:3306/jfptpublic?useSSL=false&useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&allowPublicKeyRetrieval=true |
| | | username: root |
| | | password: 123456 |
| | | password: jfpt123 |
| | | # PostgreSQL |
| | | #url: jdbc:postgresql://127.0.0.1:5432/bladex_boot |
| | | #username: postgres |