c.t.t.handler.GlobalExceptionHandler : 捕获异常：org.springframework.jdbc.BadSqlGrammarException:

2024-03-06 11:35:50.497 ERROR 9578 --- [nio-9603-exec-5] c.t.t.handler.GlobalExceptionHandler     : 捕获异常：

org.springframework.jdbc.BadSqlGrammarException:

### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Unknown column 'login_account' in 'field list'

### The error may exist in com/tengyuan/takeOut/mapper/ShopMapper.java (best guess)

### The error may involve defaultParameterMap

### The error occurred while setting parameters

### SQL: SELECT  id,name,mobile,principal_name,start_hours,end_hours,address,image,login_account,password,audit_status,description,business_license,industry_license,turnover,remaining_sum,invoke_flag,create_time,update_time,update_user_id  FROM ty_shop     WHERE (invoke_flag = ?)

### Cause: java.sql.SQLSyntaxErrorException: Unknown column 'login_account' in 'field list'

; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column 'login_account' in 'field list'

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239) ~[spring-jdbc-5.3.23.jar:5.3.23]

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70) ~[spring-jdbc-5.3.23.jar:5.3.23]

at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:88) ~[mybatis-spring-2.0.5.jar:2.0.5]

at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440) ~[mybatis-spring-2.0.5.jar:2.0.5]

at com.sun.proxy.$Proxy97.selectList(Unknown Source) ~[na:na]

at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223) ~[mybatis-spring-2.0.5.jar:2.0.5]

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:173) ~[mybatis-plus-core-3.4.2.jar:3.4.2]

at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:78) ~[mybatis-plus-core-3.4.2.jar:3.4.2]

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148) ~[mybatis-plus-core-3.4.2.jar:3.4.2]

at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89) ~[mybatis-plus-core-3.4.2.jar:3.4.2]

at com.sun.proxy.$Proxy120.selectList(Unknown Source) ~[na:na]

at com.tengyuan.takeOut.service.impl.ShopServiceImpl.pageSearch(ShopServiceImpl.java:47) ~[classes/:na]

at com.tengyuan.takeOut.service.impl.ShopServiceImpl$$

FastClassBySpringCGLIB

$$4fcc66bf.invoke(<generated>) ~[classes/:na]

at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.3.23.jar:5.3.23]

at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386) ~[spring-aop-5.3.23.jar:5.3.23]

at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85) ~[spring-aop-5.3.23.jar:5.3.23]

at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704) ~[spring-aop-5.3.23.jar:5.3.23]

经过排查，是实体类和mysql的表结构对不上，多了两个字段。

注释掉就好了。