control201 / hrm Goto Github PK

以及下拉选择部门的时候，列表只有“请选择部门”。自己加了选项以后还是会提示“此项不能为空”。
测试环境的数据库是MySql 8.0。

2022-03-23 16:18:37,258 -[DEBUG] method:[org.springframework.web.servlet.DispatcherServlet (495433ms)] - DispatcherServlet with name 'dispatcherServlet' processing GET request for [/employee/queryAllEmp.html]
2022-03-23 16:18:37,258 -[DEBUG] method:[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping (495433ms)] - Looking up handler method for path /employee/queryAllEmp.html
2022-03-23 16:18:37,258 -[DEBUG] method:[org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerMapping (495433ms)] - Returning handler method [public org.springframework.http.ResponseEntity<com.hrm.util.Layui> com.hrm.controller.main.EmployeeController.showAllEmp(com.hrm.bean.MyPage)]
2022-03-23 16:18:37,259 -[DEBUG] method:[org.springframework.beans.factory.support.DefaultListableBeanFactory (495434ms)] - Returning cached instance of singleton bean 'employeeController'
2022-03-23 16:18:37,259 -[DEBUG] method:[org.springframework.web.servlet.DispatcherServlet (495434ms)] - Last-Modified value for [/employee/queryAllEmp.html] is: -1
2022-03-23 16:18:37,260 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495435ms)] - Creating new transaction with name [com.hrm.service.impl.EmployeeServiceImpl.queryAllEmpInfo]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT
2022-03-23 16:18:37,260 -[DEBUG] method:[com.mchange.v2.resourcepool.BasicResourcePool (495435ms)] - trace com.mchange.v2.resourcepool.BasicResourcePool@45aeb100 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@453eebcd)
2022-03-23 16:18:37,260 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495435ms)] - Acquired Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@24fd8864] for JDBC transaction
2022-03-23 16:18:37,260 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495435ms)] - Switching JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@24fd8864] to manual commit
2022-03-23 16:18:37,261 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495436ms)] - Creating a new SqlSession
2022-03-23 16:18:37,262 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495437ms)] - Registering transaction synchronization for SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c150b37]
2022-03-23 16:18:37,262 -[DEBUG] method:[SQL_CACHE (495437ms)] - Cache Hit Ratio [SQL_CACHE]: 0.8333333333333334
2022-03-23 16:18:37,264 -[DEBUG] method:[org.mybatis.spring.transaction.SpringManagedTransaction (495439ms)] - JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@24fd8864] will be managed by Spring
2022-03-23 16:18:37,264 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll_COUNT (495439ms)] - ==> Preparing: SELECT count(0) FROM emp e LEFT JOIN dep d ON e.depId = d.depId
2022-03-23 16:18:37,264 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll_COUNT (495439ms)] - ==> Parameters:
2022-03-23 16:18:37,266 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll_COUNT (495441ms)] - <== Total: 1
2022-03-23 16:18:37,266 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll (495441ms)] - ==> Preparing: SELECT e.empId,e.empName,e.empEmail,e.gender,e.depId,e.phone,e.hiredate,e.notes, d.depLeader,d.depName FROM emp e LEFT JOIN dep d ON e.depId = d.depId LIMIT ?
2022-03-23 16:18:37,266 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll (495441ms)] - ==> Parameters: 10(Integer)
2022-03-23 16:18:37,268 -[DEBUG] method:[com.hrm.dao.EmployeeMapper.queryAll (495443ms)] - <== Total: 1
2022-03-23 16:18:37,268 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495443ms)] - Releasing transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c150b37]
2022-03-23 16:18:37,268 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495443ms)] - Transaction synchronization committing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c150b37]
2022-03-23 16:18:37,269 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495444ms)] - Transaction synchronization deregistering SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c150b37]
2022-03-23 16:18:37,269 -[DEBUG] method:[org.mybatis.spring.SqlSessionUtils (495444ms)] - Transaction synchronization closing SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6c150b37]
2022-03-23 16:18:37,269 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495444ms)] - Initiating transaction commit
2022-03-23 16:18:37,269 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495444ms)] - Committing JDBC transaction on Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@24fd8864]
2022-03-23 16:18:37,270 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceTransactionManager (495445ms)] - Releasing JDBC Connection [com.mchange.v2.c3p0.impl.NewProxyConnection@24fd8864] after transaction
2022-03-23 16:18:37,270 -[DEBUG] method:[org.springframework.jdbc.datasource.DataSourceUtils (495445ms)] - Returning JDBC Connection to DataSource
2022-03-23 16:18:37,270 -[DEBUG] method:[com.mchange.v2.resourcepool.BasicResourcePool (495445ms)] - trace com.mchange.v2.resourcepool.BasicResourcePool@45aeb100 [managed: 3, unused: 2, excluded: 0] (e.g. com.mchange.v2.c3p0.impl.NewPooledConnection@453eebcd)
2022-03-23 16:18:37,272 -[DEBUG] method:[org.springframework.web.servlet.mvc.method.annotation.HttpEntityMethodProcessor (495447ms)] - Written [{msg=, code=0, data=Page{count=true, pageNum=1, pageSize=10, startRow=0, endRow=10, total=1, pages=1, reasonable=true, pageSizeZero=false}, count=1}] as "application/json;charset=UTF-8" using [org.springframework.http.converter.json.MappingJackson2HttpMessageConverter@381e220d]
2022-03-23 16:18:37,272 -[DEBUG] method:[org.springframework.web.servlet.DispatcherServlet (495447ms)] - Null ModelAndView returned to DispatcherServlet with name 'dispatcherServlet': assuming HandlerAdapter completed request handling
2022-03-23 16:18:37,272 -[DEBUG] method:[org.springframework.web.servlet.DispatcherServlet (495447ms)] - Successfully completed request