mysql generator 的缺点_MyBatis Generator与MySQL遇见的坑

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.UncategorizedSQLException:

### Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : FROM, pos : 31 : insert into message

( from,

to,

content,

state )

values ( ?,

?,

?,

? )

### SQL: insert into message ( from, to, content, state ) values ( ?, ?, ?, ? )

### Cause: java.sql.SQLException: sql injection violation, syntax error: ERROR. token : FROM, pos : 31 : insert into message

( from,

to,

content,

state )

values ( ?,

?,

?,

? )

; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: ERROR. token : FROM, pos : 31 : insert into message

( from,

to,

content,

state )

values ( ?,

?,

?,

? ); nested exception is java.sql.SQLException: sql injection violation, syntax error: ERROR. token : FROM, pos : 31 : insert into message

( from,

to,

content,

state )

values ( ?,

?,

?,

? )

org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:979)

org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:858)

javax.servlet.http.HttpServlet.service(HttpServlet.java:621)

org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)

javax.servlet.http.HttpServlet.service(HttpServlet.java:728)

org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)

com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)

org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)

org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)

org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)

org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)

org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)

org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)

org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)

org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)

org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)

org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)

org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)

org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)