HTTP500nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.exception.GenericJDBCException: could not prepare statement
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:948)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.zcwin.product.common.filter.ZcwinCSRFFilter.doFilter(ZcwinCSRFFilter.java:51)
	com.zcwin.product.common.filter.ZcwinXssFilter.doFilter(ZcwinXssFilter.java:56)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:149)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

在网上查询有的说是数据库字段映射问题，但我的映射没改是正确的。
 后边分析我的报错原因是sql语句写错，导致数据库执行时报错。这类报错应该都是数据库的问题

由于多写一个and导致执行sql语句时报错，删除and即可。