[show] java.sql.SQLException: Parameter index out of range (1 > number of parameters,
which is 0).
org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback;
SQL [select p.id from cs_product p where p.status>0 order by p.id desc
LIMIT 0,3]; Parameter index out of range (1 > number of parameters, which
is 0).; nested exception is java.sql.SQLException: Parameter index out
of range (1 > number of parameters, which is 0).
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
at org.springframework.jdbc.core.JdbcTemplate$$FastClassByCGLIB$$a4771cb8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
at org.gelivable.web.AopSqlMonitor.monitor(AopSqlMonitor.java:33)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
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 org.springframework.jdbc.core.JdbcTemplate$$EnhancerByCGLIB$$56d4f91f.query(<generated>)
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200)
at org.gelivable.dao.GeliDao.list(GeliDao.java:246)
at org.gelivable.dao.GeliDao.page(GeliDao.java:405)
at cn.com.pc.cosme.service.ProductService$3.fetchData(ProductService.java:483)
at cn.com.pc.cosme.service.CacheService.findWithCache(CacheService.java:153)
at cn.com.pc.cosme.service.ProductService.listCommentProduct(ProductService.java:479)
at _jsp._comment._detail__jsp._jspService(comment/detail.jsp:270)
at com.caucho.jsp.JavaPage.service(JavaPage.java:61)
at com.caucho.jsp.Page.pageservice(Page.java:578)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:195)
at org.gelivable.web.EnvFilter.doFilter(EnvFilter.java:60)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at org.gelivable.web.gzip.GZIPFilter.doFilter(GZIPFilter.java:86)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:730)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:649)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: Parameter index out of range (1 > number
of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3646)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3630)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3672)
at com.mysql.jdbc.PreparedStatement.setLong(PreparedStatement.java:3688)
at com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3893)
at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.setObject(PreparedStatementWrapper.java:500)
at com.caucho.sql.UserPreparedStatement.setObject(UserPreparedStatement.java:617)
at com.caucho.sql.UserPreparedStatement.setObject(UserPreparedStatement.java:617)
at org.springframework.jdbc.core.StatementCreatorUtils.setValue(StatementCreatorUtils.java:351)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValueInternal(StatementCreatorUtils.java:216)
at org.springframework.jdbc.core.StatementCreatorUtils.setParameterValue(StatementCreatorUtils.java:144)
at org.springframework.jdbc.core.ArgPreparedStatementSetter.doSetValue(ArgPreparedStatementSetter.java:65)
at org.springframework.jdbc.core.ArgPreparedStatementSetter.setValues(ArgPreparedStatementSetter.java:46)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:713)
at org.springframework.jdbc.core.JdbcTemplate$$FastClassByCGLIB$$a4771cb8.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)
at org.gelivable.web.AopSqlMonitor.monitor(AopSqlMonitor.java:33)
at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)
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 org.springframework.jdbc.core.JdbcTemplate$$EnhancerByCGLIB$$56d4f91f.query(<generated>)
at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200)
at org.gelivable.dao.GeliDao.list(GeliDao.java:246)
at org.gelivable.dao.GeliDao.page(GeliDao.java:405)
at cn.com.pc.cosme.service.ProductService$3.fetchData(ProductService.java:483)
at cn.com.pc.cosme.service.CacheService.findWithCache(CacheService.java:153)
at cn.com.pc.cosme.service.ProductService.listCommentProduct(ProductService.java:479)
at _jsp._comment._detail__jsp._jspService(comment/detail.jsp:270)
at com.caucho.jsp.JavaPage.service(JavaPage.java:61)
at com.caucho.jsp.Page.pageservice(Page.java:578)
at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.java:195)
at org.gelivable.web.EnvFilter.doFilter(EnvFilter.java:60)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at org.gelivable.web.gzip.GZIPFilter.doFilter(GZIPFilter.java:86)
at com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:87)
at com.caucho.server.cache.CacheFilterChain.doFilter(CacheFilterChain.java:192)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:187)
at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:265)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:730)
at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:649)
at java.lang.Thread.run(Thread.java:662)
隆冬时节,身体肌肤在干燥环境中如何保持滋润呢?每到冬季,身体的皮肤就变得非常干燥,甚至脱皮,干痒,涂很多的身体乳也觉得吸收不了,反而让情况恶化,虽然选择滋润的身体乳固然重要,那你的沐浴产品是否随着季节的变化而更换呢?
以图集形式查看>>
在干燥冬季,强效清洁油脂汗垢的沐浴液不再适用。为抵御干燥天气,选择强效补水滋润的沐浴液,来帮助缓解肌肤的干燥不适症状是非常关键的一步。
以图集形式查看>>
olay全新升级的美肌肤滋养沐浴乳由女神志玲姐姐代言的奥,女神的肌肤真是吹弹可破,想要有女神的肌肤,除了加倍保养,也要用一下女神推荐的olay美肌肤滋养沐浴乳。
以图集形式查看>>
全新升级的美肌肤滋养沐浴乳,采用更加滋润的护肤配方,含有一整瓶面部护肤精华,成分全新升级,含微米滋养因子、天然蜂蜜 乳液精华,能够迅速渗透肌肤,修复干燥,暗哑,让肌肤达到真正的由内而外的滋润。
以图集形式查看>>
选择沐浴乳当然要选择大包装,不仅经济实惠,全家用起来也方便,我这一瓶是400ml的大容量,瓶装加上粉色的搭配,给人一种可爱的感觉。翻盖使用的设计,方便取用。
以图集形式查看>>
质地:
打开按压式的瓶盖,轻轻挤压瓶身,就能看到白色的质地细腻温润,看上去有点像乳霜。它的味道清新好闻。质地也非常的水润。
以图集形式查看>>
Olay深润滋养沐浴乳独有的微米级滋润因子,能有效渗透超过8层皮肤。与一般滋润因子相比,Olay沐浴乳独有的微米级滋润因子能层层渗透皮肤而不会在沐浴时流失,从内而外深润肌肤,修护肌肤干燥损伤,持续使用不到一瓶,就可以看到肌肤的柔嫩改变。
以图集形式查看>>
泡沫:
沐浴产品能搓出丰富的泡沫才能彻底清洁身体,丰富的泡沫能将清洁成分和护肤成分带到肌肤的毛孔,泡沫越细腻,就越能渗透到毛孔。OlAY深润滋养沐浴乳的发泡力也非常棒。沐浴液与沐浴球遇水稍微揉搓,就能起非常多的泡沫,而且泡沫非常细腻、绵密。
以图集形式查看>>
而且也非常好清洗,有些沐浴产品非常难清洗,冲洗完一会依然觉得有不干净的感觉,而这款沐浴露,直接用水冲洗后非常的清爽。
清洁力:
当然作为一款沐浴露,其洁肤能力当然不能忽视,优秀的清洁力更能有效地、更深层地清洁肌肤。现在就让我们一起来看看这款沐浴露的清洁力如何吧。
以图集形式查看>>
在手背上涂抹上彩妆品,然后OlAY深润滋养沐浴乳的泡沫,清洗过的肌肤,只留下一点淡淡的笔迹。油性肌肤或者出汗油垢较多者,可以配合按摩揉搓来帮助洗净肌肤。清洁力度也是非常不错的。
以图集形式查看>>
保湿度:
我们再来测试下这款沐浴乳的保湿力度吧,一款好的沐浴露,不仅能为肌肤清洁,还能为肌肤快速补水,让肌肤持久顺润。
以图集形式查看>>
在使用前肌肤的水分值为22.7.5%,使用后,水分值马上上升到50.6%,上升了20多个百分点。肌肤保湿非常的好,能帮助keep住肌肤的水分,保持肌肤的水润。含一整罐OlAY面部滋润精华,微米级的深润滋养功效果然不容小觑
以图集形式查看>>
清爽度:
当然保湿不代表着粘腻,所以清爽度也是很关键的,在使用了沐浴乳的手背上,粘帖一把米粒,然后将手背翻转过来一会,看到手背只有几粒米粒粘住了,说明是一款非常清爽不油腻的沐浴乳,油皮也可以清爽无负担奥。
500 Servlet Exception