SQL state [99999]; error code [17059]; 无法转换为内部表示

16:47:57.594 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5fc8b88e]
16:47:57.594 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.594 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.594 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5913506f] was not registered for synchronization because synchronization is not active
16:47:57.594 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.594 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.594 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.594 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.595 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 84(Integer)
16:47:57.595 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5913506f]
16:47:57.595 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.595 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.595 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73e95ddb] was not registered for synchronization because synchronization is not active
16:47:57.596 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.596 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.596 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.596 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.596 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 87(Integer)
16:47:57.596 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73e95ddb]
16:47:57.596 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.597 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.597 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3246246f] was not registered for synchronization because synchronization is not active
16:47:57.597 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.597 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.597 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.597 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.597 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 80(Integer)
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3246246f]
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@23b05b78] was not registered for synchronization because synchronization is not active
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.598 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.598 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.598 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.598 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 81(Integer)
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@23b05b78]
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@8c112af] was not registered for synchronization because synchronization is not active
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.599 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.599 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.599 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.600 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 88(Integer)
16:47:57.602 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@8c112af]
16:47:57.602 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.602 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.602 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b6f05e8] was not registered for synchronization because synchronization is not active
16:47:57.602 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.603 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.603 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.603 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.603 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 91(Integer)
16:47:57.603 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@b6f05e8]
16:47:57.603 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.603 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.604 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5c4c2306] was not registered for synchronization because synchronization is not active
16:47:57.604 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.604 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.604 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.604 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.604 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 92(Integer)
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5c4c2306]
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@56c452d1] was not registered for synchronization because synchronization is not active
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.605 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.605 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.605 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.605 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 182(Integer)
16:47:57.606 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@56c452d1]
16:47:57.606 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.606 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.606 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fb51349] was not registered for synchronization because synchronization is not active
16:47:57.606 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.607 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.607 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.607 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.607 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 183(Integer)
16:47:57.608 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fb51349]
16:47:57.608 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.609 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.609 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fa811ac] was not registered for synchronization because synchronization is not active
16:47:57.609 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.609 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.609 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.609 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.609 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 184(Integer)
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fa811ac]
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@57cc44e7] was not registered for synchronization because synchronization is not active
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.610 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.610 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.610 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.610 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 185(Integer)
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@57cc44e7]
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@38fae05] was not registered for synchronization because synchronization is not active
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.611 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.611 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.611 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.611 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 186(Integer)
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@38fae05]
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3055e050] was not registered for synchronization because synchronization is not active
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.612 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.612 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.613 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.613 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 187(Integer)
16:47:57.613 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3055e050]
16:47:57.613 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.613 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:57.613 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ee5ed2e] was not registered for synchronization because synchronization is not active
16:47:57.614 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:57.614 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:57.614 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:57.614 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==>  Preparing: select a.ID AS "id", a.PID AS "pid", a.TITLE AS "title", a.TITLE AS "name", a.ICON AS "icon", a.HREF AS "href", a.SPREAD AS "spread", a.MENU_SORT AS "sort", a.IS_TOP AS "isTop", a.del_flag AS "delFlag", a.MENU_LEVEL AS "level", a.MENU_TYPE AS "type", a.MENU_PERMISSON AS "permission" from SYS_MENU_NEW a WHERE a.del_flag = '0' AND (select count(1) from SYS_ROLE_MENU_NEW where role_id=? and menu_id = a.id) > 0 AND a.pid = ? order by MENU_SORT asc 
16:47:57.614 [http-bio-8080-exec-5] DEBUG MenuMapper.getByPidM - ==> Parameters: 1(String), 188(Integer)
16:47:57.615 [http-bio-8080-exec-5] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ee5ed2e]
16:47:57.615 [http-bio-8080-exec-5] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:57.615 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter - Written [[com.fh.entity.system.MenuNew@4355d4cb, com.fh.entity.system.MenuNew@38057df6, com.fh.entity.system.MenuNew@7090be35, com.fh.entity.system.MenuNew@2eb7c34f, com.fh.entity.system.MenuNew@22778f7f, com.fh.entity.system.MenuNew@576dec86]] as "application/json" using [org.springframework.http.converter.json.MappingJacksonHttpMessageConverter@d79e9a9]
16:47:57.616 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:57.616 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:57.616 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:57.616 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:57.761 [http-bio-8080-exec-2] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:57.761 [http-bio-8080-exec-2] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:57.762 [http-bio-8080-exec-2] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:57.762 [http-bio-8080-exec-2] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.516 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/layui_menu/css/modules/layer/default/loading-2.gif]
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/layui_menu/css/modules/layer/default/loading-2.gif] are [/static/**]
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/layui_menu/css/modules/layer/default/loading-2.gif] are {}
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/layui_menu/css/modules/layer/default/loading-2.gif] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/layui_menu/css/modules/layer/default/loading-2.gif] is: -1
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui_menu/css/modules/layer/default/loading-2.gif] against base location: ServletContext resource [/]
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui_menu/css/modules/layer/default/loading-2.gif] against base location: ServletContext resource [/static/]
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/layui_menu/css/modules/layer/default/loading-2.gif]
16:47:59.520 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [image/gif] for ServletContext resource [/static/res/layui_menu/css/modules/layer/default/loading-2.gif]
16:47:59.521 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.521 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.521 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/role/listRole.do]
16:47:59.521 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.521 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.523 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Matching patterns for request [/role/listRole.do] are [/role/listRole.*]
16:47:59.523 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - URI Template variables for request [/role/listRole.do] are {}
16:47:59.523 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Mapping [/role/listRole.do] to HandlerExecutionChain with handler [com.fh.controller.system.role.RoleController@454d72b0] and 2 interceptors
16:47:59.524 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/role/listRole.do] is: -1
16:47:59.524 [http-bio-8080-exec-5] DEBUG org.springframework.web.bind.annotation.support.HandlerMethodInvoker - Invoking request handler method: public org.springframework.web.servlet.ModelAndView com.fh.controller.system.role.RoleController.listRole(com.fh.entity.Page,javax.servlet.http.HttpServletRequest) throws java.lang.Exception
16:47:59.525 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.JstlView: name 'views/sys/roleList'; URL [/WEB-INF/jsp/views/sys/roleList.jsp]] in DispatcherServlet with name 'springMvc'
16:47:59.525 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.view.JstlView - Added model object 'page' of type [com.fh.entity.Page] to request in view with name 'views/sys/roleList'
16:47:59.525 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.view.JstlView - Added model object 'org.springframework.validation.BindingResult.page' of type [org.springframework.validation.BeanPropertyBindingResult] to request in view with name 'views/sys/roleList'
16:47:59.525 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.view.JstlView - Forwarding to resource [/WEB-INF/jsp/views/sys/roleList.jsp] in InternalResourceView 'views/sys/roleList'
16:47:59.526 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.526 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.526 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.545 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/zTree/js/jquery-1.4.4.min.js]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/zTree/js/jquery-1.4.4.min.js] are [/static/**]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/zTree/js/jquery-1.4.4.min.js] are {}
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/zTree/js/jquery-1.4.4.min.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/zTree/js/jquery-1.4.4.min.js] is: -1
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery-1.4.4.min.js] against base location: ServletContext resource [/]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery-1.4.4.min.js] against base location: ServletContext resource [/static/]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/zTree/js/jquery-1.4.4.min.js]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/zTree/js/jquery-1.4.4.min.js]
16:47:59.548 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/zTree/js/jquery.ztree.all.js]
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.548 [http-bio-8080-exec-5] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.549 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/zTree/js/jquery.ztree.excheck.js]
16:47:59.549 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/zTree/js/jquery.ztree.core.js]
16:47:59.554 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/zTree/js/jquery.ztree.all.js] are [/static/**]
16:47:59.554 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/zTree/js/jquery.ztree.all.js] are {}
16:47:59.554 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/zTree/js/jquery.ztree.all.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.554 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/zTree/js/jquery.ztree.all.js] is: -1
16:47:59.554 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.all.js] against base location: ServletContext resource [/]
16:47:59.555 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/zTree/js/jquery.ztree.excheck.js] are [/static/**]
16:47:59.556 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/zTree/js/jquery.ztree.core.js] are [/static/**]
16:47:59.557 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/zTree/css/zTreeStyle/zTreeStyle.css]
16:47:59.558 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/js/one-js/role.js]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/zTree/js/jquery.ztree.excheck.js] are {}
16:47:59.559 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.all.js] against base location: ServletContext resource [/static/]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/zTree/js/jquery.ztree.excheck.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.559 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/zTree/js/jquery.ztree.all.js]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/zTree/js/jquery.ztree.excheck.js] is: -1
16:47:59.559 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/zTree/js/jquery.ztree.all.js]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.excheck.js] against base location: ServletContext resource [/]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.excheck.js] against base location: ServletContext resource [/static/]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/zTree/js/jquery.ztree.excheck.js]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/zTree/js/jquery.ztree.excheck.js]
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.559 [http-bio-8080-exec-9] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.560 [http-bio-8080-exec-9] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.560 [http-bio-8080-exec-9] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.560 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.560 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.560 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/zTree/css/zTreeStyle/zTreeStyle.css] are [/static/**]
16:47:59.559 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/zTree/js/jquery.ztree.core.js] are {}
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/js/one-js/role.js] are [/static/**]
16:47:59.562 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/zTree/js/jquery.ztree.core.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/js/one-js/role.js] are {}
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/zTree/css/zTreeStyle/zTreeStyle.css] are {}
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/zTree/js/jquery.ztree.core.js] is: -1
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/js/one-js/role.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/zTree/css/zTreeStyle/zTreeStyle.css] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.core.js] against base location: ServletContext resource [/]
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/js/one-js/role.js] is: -1
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/zTree/css/zTreeStyle/zTreeStyle.css] is: -1
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/js/one-js/role.js] against base location: ServletContext resource [/]
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/css/zTreeStyle/zTreeStyle.css] against base location: ServletContext resource [/]
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/js/jquery.ztree.core.js] against base location: ServletContext resource [/static/]
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/zTree/css/zTreeStyle/zTreeStyle.css] against base location: ServletContext resource [/static/]
16:47:59.562 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/js/one-js/role.js] against base location: ServletContext resource [/static/]
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/zTree/js/jquery.ztree.core.js]
16:47:59.562 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/zTree/css/zTreeStyle/zTreeStyle.css]
16:47:59.562 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/zTree/js/jquery.ztree.core.js]
16:47:59.563 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [text/css] for ServletContext resource [/static/res/zTree/css/zTreeStyle/zTreeStyle.css]
16:47:59.563 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.563 [http-bio-8080-exec-10] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.563 [http-bio-8080-exec-10] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.563 [http-bio-8080-exec-10] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.563 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.563 [http-bio-8080-exec-1] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.563 [http-bio-8080-exec-1] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.563 [http-bio-8080-exec-1] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/js/one-js/role.js]
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/js/one-js/role.js]
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.564 [http-bio-8080-exec-4] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.690 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/layui/lay/modules/table.js]
16:47:59.694 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/layui/lay/modules/table.js] are [/static/**]
16:47:59.694 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/layui/lay/modules/table.js] are {}
16:47:59.694 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/layui/lay/modules/table.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.694 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/layui/lay/modules/table.js] is: -1
16:47:59.694 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/table.js] against base location: ServletContext resource [/]
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/table.js] against base location: ServletContext resource [/static/]
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/layui/lay/modules/table.js]
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/layui/lay/modules/table.js]
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.695 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.704 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/layui/lay/modules/laytpl.js]
16:47:59.708 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/layui/lay/modules/laytpl.js] are [/static/**]
16:47:59.708 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/layui/lay/modules/laytpl.js] are {}
16:47:59.708 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/layui/lay/modules/laytpl.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.708 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/layui/lay/modules/laytpl.js] is: -1
16:47:59.708 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/laytpl.js] against base location: ServletContext resource [/]
16:47:59.709 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/laytpl.js] against base location: ServletContext resource [/static/]
16:47:59.709 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/layui/lay/modules/laytpl.js]
16:47:59.709 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/layui/lay/modules/laytpl.js]
16:47:59.710 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.710 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.710 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.710 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.723 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/static/res/layui/lay/modules/laypage.js]
16:47:59.726 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Matching patterns for request [/static/res/layui/lay/modules/laypage.js] are [/static/**]
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - URI Template variables for request [/static/res/layui/lay/modules/laypage.js] are {}
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.handler.SimpleUrlHandlerMapping - Mapping [/static/res/layui/lay/modules/laypage.js] to HandlerExecutionChain with handler [org.springframework.web.servlet.resource.ResourceHttpRequestHandler@6f7be0c0] and 2 interceptors
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/static/res/layui/lay/modules/laypage.js] is: -1
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/laypage.js] against base location: ServletContext resource [/]
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Trying relative path [res/layui/lay/modules/laypage.js] against base location: ServletContext resource [/static/]
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Found matching resource: ServletContext resource [/static/res/layui/lay/modules/laypage.js]
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.resource.ResourceHttpRequestHandler - Determined media type [application/javascript] for ServletContext resource [/static/res/layui/lay/modules/laypage.js]
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.727 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:47:59.876 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing GET request for [/hfwzh3/role/roleData.do]
16:47:59.879 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Matching patterns for request [/role/roleData.do] are [/role/roleData.*]
16:47:59.879 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - URI Template variables for request [/role/roleData.do] are {}
16:47:59.879 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Mapping [/role/roleData.do] to HandlerExecutionChain with handler [com.fh.controller.system.role.RoleController@454d72b0] and 2 interceptors
16:47:59.879 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Last-Modified value for [/hfwzh3/role/roleData.do] is: -1
16:47:59.880 [http-bio-8080-exec-7] DEBUG org.springframework.web.bind.annotation.support.HandlerMethodInvoker - Invoking request handler method: public java.util.Map com.fh.controller.system.role.RoleController.roleData(com.fh.entity.Page,javax.servlet.http.HttpServletRequest) throws java.lang.Exception
16:47:59.880 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:59.881 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3df68ee8] was not registered for synchronization because synchronization is not active
16:47:59.881 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:59.881 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:59.881 [http-bio-8080-exec-7] DEBUG RoleMapper.findAllPage - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:59.881 [http-bio-8080-exec-7] DEBUG RoleMapper.findAllPage - ==>  Preparing: select ROLE_ID,ROLE_NAME from (select row_number() over(order by ROLE_ID) idx,e.* from SYS_ROLE e) s where idx between ? and ? 
16:47:59.882 [http-bio-8080-exec-7] DEBUG RoleMapper.findAllPage - ==> Parameters: 1(Integer), 20(Integer)
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@3df68ee8]
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f939f04] was not registered for synchronization because synchronization is not active
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:47:59.886 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:47:59.886 [http-bio-8080-exec-7] DEBUG RoleMapper.getCount - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:47:59.886 [http-bio-8080-exec-7] DEBUG RoleMapper.getCount - ==>  Preparing: select count(ROLE_ID) from SYS_ROLE 
16:47:59.887 [http-bio-8080-exec-7] DEBUG RoleMapper.getCount - ==> Parameters: 
16:47:59.887 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@2f939f04]
16:47:59.887 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:47:59.888 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter - Written [{count=31, data=[{ROLE_NAME=副主任医师, ROLE_ID=017f1e4e2faa4e45887a7bd8566de8cd}, {ROLE_NAME=编码员, ROLE_ID=055bf55389a54486bb404511f57e6811}, {ROLE_NAME=助理会计师, ROLE_ID=0f1b25754f754e00a4333d4a6f3c2378}, {ROLE_NAME=超级管理员, ROLE_ID=1}, {ROLE_NAME=科室主任, ROLE_ID=115b386ff04f4352b060dffcd2b5d1da}, {ROLE_NAME=角色组, ROLE_ID=15}, {ROLE_NAME=初级会员, ROLE_ID=1b67fc82ce89457a8347ae53e43a347e}, {ROLE_NAME=职位组, ROLE_ID=2}, {ROLE_NAME=卫生技术(护理), ROLE_ID=21b9b78a8e934d078a88778c793ebdb4}, {ROLE_NAME=药士, ROLE_ID=23ea81770bec4a9db2b2e84336cb468f}, {ROLE_NAME=护士, ROLE_ID=2783ba81afcc47729fbf9e934a732758}, {ROLE_NAME=主管技师, ROLE_ID=302b7b2aaecc49449229ea7a2607b1ec}, {ROLE_NAME=系统管理员, ROLE_ID=3264c8e83d0248bb9e3ea6195b4c0216}, {ROLE_NAME=副主任护师, ROLE_ID=35167fd8524a49bba6384c8d0a936054}, {ROLE_NAME=护师, ROLE_ID=4247e1980c49411ead228a0599bf1114}, {ROLE_NAME=主任医师, ROLE_ID=4e9b5db4f1f849659673615578fef1cc}, {ROLE_NAME=主任护师, ROLE_ID=75f2b01e734c48b78aca2c3b96b6142e}, {ROLE_NAME=副主任技师, ROLE_ID=89270a81e3ff421fa0dbd25c85112ad5}, {ROLE_NAME=医士, ROLE_ID=93b2a4ec0afa42babebfa8f21c38173c}, {ROLE_NAME=药师, ROLE_ID=95a51ea5e40e4db8b5639e248d194fa3}], code=0, msg=}] as "application/json" using [org.springframework.http.converter.json.MappingJacksonHttpMessageConverter@d79e9a9]
16:47:59.888 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Null ModelAndView returned to DispatcherServlet with name 'springMvc': assuming HandlerAdapter completed request handling
16:47:59.888 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:47:59.888 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:47:59.888 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'
16:48:01.299 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - DispatcherServlet with name 'springMvc' processing POST request for [/hfwzh3/menu/dataCheckJson.do]
16:48:01.303 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Matching patterns for request [/menu/dataCheckJson.do] are [/menu/dataCheckJson.*]
16:48:01.303 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - URI Template variables for request [/menu/dataCheckJson.do] are {}
16:48:01.303 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping - Mapping [/menu/dataCheckJson.do] to HandlerExecutionChain with handler [com.fh.controller.system.menu.MenuController@7b7fccd4] and 2 interceptors
16:48:01.303 [http-bio-8080-exec-7] DEBUG org.springframework.web.bind.annotation.support.HandlerMethodInvoker - Invoking request handler method: public java.util.List com.fh.controller.system.menu.MenuController.dataCheckJson(javax.servlet.http.HttpServletRequest,org.springframework.ui.Model) throws java.lang.Exception
16:48:01.304 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
16:48:01.304 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f99af5a] was not registered for synchronization because synchronization is not active
16:48:01.304 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
16:48:01.304 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52] will not be managed by Spring
16:48:01.304 [http-bio-8080-exec-7] DEBUG MenuMapper.getByPidTreeCheck - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@4cef3a52]
16:48:01.305 [http-bio-8080-exec-7] DEBUG MenuMapper.getByPidTreeCheck - ==>  Preparing: select a.id AS "id", a.pid AS "pid", a.title AS "name", a.spread AS "open", a.menu_sort AS "sort", a.is_top AS "isTop", a.del_flag AS "delFlag", (CASE WHEN (select count(1) from sys_role_menu_new where role_id = ? and menu_id= a.id) > 0 THEN 'true' ELSE 'false' END) AS "checked" from sys_menu_new a WHERE a.del_flag = '0' AND a.pid ='75' order by a.menu_sort asc 
16:48:01.305 [http-bio-8080-exec-7] DEBUG MenuMapper.getByPidTreeCheck - ==> Parameters: 1(String)
16:48:01.306 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator - Unable to translate SQLException with Error code '17059', will now try the fallback translator
16:48:01.306 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.support.SQLStateSQLExceptionTranslator - Extracted SQL state class '99' from value '99999'
16:48:01.306 [http-bio-8080-exec-7] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6f99af5a]
16:48:01.306 [http-bio-8080-exec-7] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
16:48:01.307 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Handler execution resulted in exception - forwarding to resolved error view: ModelAndView: reference to view with name 'error'; model is {exception=org.springframework.jdbc.UncategorizedSQLException: 
<br/>### Error querying database.  Cause: java.sql.SQLException: 无法转换为内部表示
<br/>### The error may exist in file [E:\tools\apache-tomcat-8080\webapps\hfwzh3\WEB-INF\classes\mybatis1\system\MenuMapper.xml]
<br/>### The error may involve defaultParameterMap
<br/>### The error occurred while setting parameters
<br/>### SQL: select       a.id AS "id",    a.pid AS "pid",    a.title AS "name",    a.spread AS "open",    a.menu_sort AS "sort",    a.is_top AS "isTop",    a.del_flag AS "delFlag",    (CASE WHEN (select count(1) from sys_role_menu_new where role_id = ? and menu_id= a.id) > 0  THEN 'true' ELSE 'false' END) AS "checked"      from sys_menu_new a       WHERE a.del_flag = '0'    AND a.pid ='75'       order by a.menu_sort asc
<br/>### Cause: java.sql.SQLException: 无法转换为内部表示<br/>; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; 无法转换为内部表示; nested exception is java.sql.SQLException: 无法转换为内部表示}
org.springframework.jdbc.UncategorizedSQLException: 
### Error querying database.  Cause: java.sql.SQLException: 无法转换为内部表示
### The error may exist in file [E:\tools\apache-tomcat-8080\webapps\hfwzh3\WEB-INF\classes\mybatis1\system\MenuMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select       a.id AS "id",    a.pid AS "pid",    a.title AS "name",    a.spread AS "open",    a.menu_sort AS "sort",    a.is_top AS "isTop",    a.del_flag AS "delFlag",    (CASE WHEN (select count(1) from sys_role_menu_new where role_id = ? and menu_id= a.id) > 0  THEN 'true' ELSE 'false' END) AS "checked"      from sys_menu_new a       WHERE a.del_flag = '0'    AND a.pid ='75'       order by a.menu_sort asc
### Cause: java.sql.SQLException: 无法转换为内部表示
; uncategorized SQLException for SQL []; SQL state [99999]; error code [17059]; 无法转换为内部表示; nested exception is java.sql.SQLException: 无法转换为内部表示
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)
	at com.sun.proxy.$Proxy10.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:194)
	at com.fh.dao.DaoSupport.findForList(DaoSupport.java:124)
	at com.fh.service.system.menu.impl.MenuService.getAllListCheckJson(MenuService.java:223)
	at com.fh.service.system.menu.impl.MenuService$$FastClassByCGLIB$$a493d270.invoke(<generated>)
	at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
	at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621)
	at com.fh.service.system.menu.impl.MenuService$$EnhancerByCGLIB$$931507a3.getAllListCheckJson(<generated>)
	at com.fh.controller.system.menu.MenuController.dataCheckJson(MenuController.java:613)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
	at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
	at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
	at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
	at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
	at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
	at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
	at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
	at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
	at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: 无法转换为内部表示
	at oracle.jdbc.driver.CharCommonAccessor.getBoolean(CharCommonAccessor.java:185)
	at oracle.jdbc.driver.T4CVarcharAccessor.getBoolean(T4CVarcharAccessor.java:781)
	at oracle.jdbc.driver.OracleResultSetImpl.getBoolean(OracleResultSetImpl.java:594)
	at oracle.jdbc.driver.OracleResultSet.getBoolean(OracleResultSet.java:386)
	at com.alibaba.druid.filter.FilterChainImpl.resultSet_getBoolean(FilterChainImpl.java:819)
	at com.alibaba.druid.filter.FilterAdapter.resultSet_getBoolean(FilterAdapter.java:1501)
	at com.alibaba.druid.filter.FilterChainImpl.resultSet_getBoolean(FilterChainImpl.java:817)
	at com.alibaba.druid.proxy.jdbc.ResultSetProxyImpl.getBoolean(ResultSetProxyImpl.java:309)
	at com.alibaba.druid.pool.DruidPooledResultSet.getBoolean(DruidPooledResultSet.java:266)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.logging.jdbc.ResultSetLogger.invoke(ResultSetLogger.java:59)
	at com.sun.proxy.$Proxy22.getBoolean(Unknown Source)
	at org.apache.ibatis.type.BooleanTypeHandler.getNullableResult(BooleanTypeHandler.java:34)
	at org.apache.ibatis.type.BooleanTypeHandler.getNullableResult(BooleanTypeHandler.java:23)
	at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:51)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyAutomaticMappings(FastResultSetHandler.java:348)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:272)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:221)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:193)
	at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:159)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:57)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:70)
	at sun.reflect.GeneratedMethodAccessor49.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:59)
	at com.sun.proxy.$Proxy19.query(Unknown Source)
	at org.apache.ibatis.executor.ReuseExecutor.doQuery(ReuseExecutor.java:54)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
	at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:354)
	... 69 common frames omitted
16:48:01.308 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Rendering view [org.springframework.web.servlet.view.JstlView: name 'error'; URL [/WEB-INF/jsp/error.jsp]] in DispatcherServlet with name 'springMvc'
16:48:01.308 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.view.JstlView - Added model object 'exception' of type [java.lang.String] to request in view with name 'error'
16:48:01.308 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.view.JstlView - Forwarding to resource [/WEB-INF/jsp/error.jsp] in InternalResourceView 'error'
16:48:01.309 [http-bio-8080-exec-7] DEBUG org.springframework.web.servlet.DispatcherServlet - Successfully completed request
16:48:01.309 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory'
16:48:01.309 [http-bio-8080-exec-7] DEBUG org.springframework.beans.factory.support.DefaultListableBeanFactory - Returning cached instance of singleton bean 'sqlSessionFactory2'

出现这个问题网上各种搜索结论是数据库列类型和实体类类型不匹配,排查了2天问题解决了,这次出现问题是权限分配需要ztree,后台数据没匹配到格式,问题解决了,记录一下,以防后面走弯路。

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值