[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$$d3aa8070.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$$d3aa8070.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)
以图集形式查看>>
每次工作很累,心里压力大的时候,各种烦恼接踵而至,真想做个SPA,为心灵找到出口,让身体彻底的放松。其实我们的面部肌肤也同样需要来个SPA,那种排毒焕肤,久违的轻松惬意感一定会让你拥有不一样的美丽。前段时间闺蜜就介绍了这瓶艾天然凝萃舒缓柔肤精华水,它不仅可以紧致,保湿还具有出色的美白功效,它还相当的舒缓温和,特别适合最近老爆痘,异常敏感的粉鱼的皮肤,嘿嘿
以图集形式查看>>
艾天然ATTENER这个牌子创立23年已经有几百万的爱用者,是珍稀植物护肤品牌,倍受青睐,它和FANCL还是一个公司的哦。今天介绍的这款SPA水水是采用尖端的科技和独家的原料配方,还素款高机能的水水,能让你真正的体验什么是焕颜,什么是活肤.
以图集形式查看>>
这款水水由发酵胶原蛋白,初生蜂皇原浆,棉籽糖,有机药蜀葵,有机米糠精华等成份构成。其中发酵胶原蛋白可以促进肌肤胶原蛋白合成,初生蜂皇原浆更是能为肌肤补充营养,抑制肌肤老化;棉籽糖则可以提升肌肤的保湿能力;有机米糠精华更能抑制黑色素,美白肌肤。
以图集形式查看>>
那么这款艾天然凝萃舒缓柔肤精华水与我们平时使用的水水有什么不同,又有什么出色的功效呢?请出粉鱼水水家族的另一位,来自法国的珂玛德柔性安抚舒缓爽肤水,要与我们的艾天然精华水来一次大PK,吼吼
以图集形式查看>>
一 外观
珂德玛:玻璃瓶身,比较沉重,瓶身无过多修饰,实在没啥美好的词来形容
艾天然:粉色的瓶身,看起来优雅可爱,亮粉的瓶盖与闪着珠光粉的瓶身相得益彰,符合各个年龄段女性的审美需求
二 气味
珂德玛:因为里边添加了精油的成份,会看到有一层黄色的油浮在上层,植物与精油气味相结合,比较猛烈浓郁
艾天然:特别美好的香气,很自然很纯粹的感觉,让人闻后便有一各安心的愉悦感,绝对没有人工添加香料的突兀感。
以图集形式查看>>
三 PH测试
珂德玛:基本上属温和款,巴特前段时间粉鱼用这款水水敷脸,有明显的刺感,第二次使用后脸颊两侧有明显的过敏泛红现象,一层细密的小疙瘩,SO粉鱼现在的皮肤一直处于敏感期
艾天然:从PH试纸可以看出它比珂德玛那款更加温和,这种温和不仅来自测试,更多的来自肌肤的感受,柔软温和,让你有前所未有的安心感,就算敏感期的肌肤也完全不会有一丝的不适
以图集形式查看>>
四 质地
珂德玛:质地水润,流动性强,吸收比较快,留在肌肤表面一层浓郁的植物精油气味
艾天然:质地稍感浓稠,但却不会有粘腻感
五 水份值
珂德玛:补水效果也不错,但是锁水时间不够长
艾天然:因为内含弹性柔润胶体,不仅可以减少对肌肤的刺激,更能慢慢的释放出水份,令按摩更瞬间,渗透力更强
以图集形式查看>>
在家里就可以轻松享受脸部的SPF护理,我有我高招。下面来分享一下艾天然精华水螺旋式按摩法
1)以下颏部作为开始点,在脸部用食指由下至上划圈按摩
2)眼睛周围不要用力,用中指和无名指的指腹轻柔接触打圈。
3)额头部位一边划圈一边向上提拉
4)从太阳穴经过耳朵前部,然后一直到颈部,整个手掌与颈部帖合,由上至下贴服按摩令化妆水吸收。
5)重复以上步骤3~5次,最后用手掌帖合整个脸部,向上提升,同时促使余留化妆水被肌肤完全吸收。
以图集形式查看>>
综上所述,无论从外观,质地,气味,温和度,补水效果,艾天然凝萃舒缓精华水都更胜一筹,它让肌肤体验了前所未有的水润,亮泽,饱满,嫩滑,同时我们还可以采取螺旋式按摩手法,不仅可以提拉紧致肌肤,更能焕发肌肤新生的力量,它的SPA活肤效果堪称完美,值得一直用下去的宝贝。