[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.GeneratedMethodAccessor18.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.GeneratedMethodAccessor18.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)
以图集形式查看>>
还在家和美容院之间耗着大把时间,来来回回折腾吗?还在苦恼是用洁面泡还是洗面奶对着镜子一顿猛搓吗?还在为自己被肤色暗沉而每天刷墙似的拼了命抹粉底吗?还在为洗完脸后鼻子上的点点黑头饱受煎熬吗?
NO NO NO!普通用手的洁面方法已经out,一支专业的“洁面神手”已经诞生,代替你的手,为你解决脸部肌肤深层清洁的难题。它,就是Olay Pro-X微晶亮肤洁面仪。不用费钱费力费时间耗在美容院,在家就能轻松为脸部肌肤做一场深层清洁啦~
以图集形式查看>>
Pro-X微晶亮肤洁面仪拥有三大专业设计特点:
1、可替换微晶亮肤按摩棉头:采用特殊进口高韧性高密度Latex材质,小小棉头上遍布了数百万微米级气孔,转动起来后就像活性炭的吸附作用,深入疏通堵塞毛孔和黑头。棉头表面的密度设计保证微晶啫喱不会被吸入刷头,完全作用于肌肤。而棉头的边缘设计韧性十足,保证鼻翼等部位也可以360°无死角按摩。
2、Pro-X微晶热能按摩啫喱:遇水发热配方,先快速软化堆积角质,并帮助堵塞毛孔的油污角栓等浮出皮肤表面。再配合莫氏硬度2.5的弹性圆形微晶颗粒去除老废角质和黑头白头。先软化再按摩,温和的水溶性弹性圆形微晶颗粒能够温柔而有力的还原肌肤通透亮泽。
3、防水流线设计的双频电动主机手柄,不仅方便手持,利于清洁,更可在沐浴等多种潮湿环境中安全使用,同时提供高低两种速率,可针对不同肌肤问题。还采用了STAYSPEED?恒速科技,即使在低电量的状况下也能保证转速恒定。
以图集形式查看>>
Pro-X微晶亮肤洁面仪拥有三大专业设计特点:
1、可替换微晶亮肤按摩棉头:采用特殊进口高韧性高密度Latex材质,小小棉头上遍布了数百万微米级气孔,转动起来后就像活性炭的吸附作用,深入疏通堵塞毛孔和黑头。棉头表面的密度设计保证微晶啫喱不会被吸入刷头,完全作用于肌肤。而棉头的边缘设计韧性十足,保证鼻翼等部位也可以360°无死角按摩。
2、Pro-X微晶热能按摩啫喱:遇水发热配方,先快速软化堆积角质,并帮助堵塞毛孔的油污角栓等浮出皮肤表面。再配合莫氏硬度2.5的弹性圆形微晶颗粒去除老废角质和黑头白头。先软化再按摩,温和的水溶性弹性圆形微晶颗粒能够温柔而有力的还原肌肤通透亮泽。
3、防水流线设计的双频电动主机手柄,不仅方便手持,利于清洁,更可在沐浴等多种潮湿环境中安全使用,同时提供高低两种速率,可针对不同肌肤问题。还采用了STAYSPEED?恒速科技,即使在低电量的状况下也能保证转速恒定。
以图集形式查看>>
来晒一晒我的Olay Pro-X微晶亮肤洁面仪套装,一共五样东东,双频电动主机手柄 柔肤按摩棉头 净头焕肤纤维刷头 微晶热能按摩按摩啫喱 去暗哑亮泽洁面乳,这样一套是不是很丰富很专业~
以图集形式查看>>
首先观察下仪器。手柄可以两用,先使用净头焕肤纤维刷头装上清洁,之后换下刷头换上柔肤按摩棉头进行去角质按摩护理。洁面仪体型轻巧,手握起来顺手,同时装拆刷头也非常简单方便。
以图集形式查看>>
1st Step:洁面
将Olay去暗哑亮泽洁面乳挤出适量于手心,涂抹在脸部,并用手均匀涂抹。同时,装上净头焕肤纤维刷头,用清水打湿刷头,启动洁面仪开关,进行全脸清洁,此时,产生的泡沫会随按摩的同时变得多而密集起来。刷头转动的同时,会温柔地携带走毛孔中残留的顽固脏东西。平时可使用低档转速,一周可进行1~2次高档转速。这里特别要注意的使用洁面仪的手法,从下巴慢慢打圈着向上提拉,直至耳朵下,清洁同时按摩脸部,去除脸部浮肿。
以图集形式查看>>
2nd Step:去除老化角质
一分钟的深层清洁后,则到了使用微晶热能按摩啫喱去角质的时间了。挤出适量啫喱在手心,用打湿的柔肤按摩棉头蘸取,由T区开始按摩开来。当水一碰到微晶热能按摩啫喱,啫喱中的遇水发热配方立即启动,热能帮助毛孔油脂迅速浮出肌肤表面。
这里的按摩手法:重点在角质层堆积最厚的额头开始,再清洁鼻子鼻翼等易寸黑头部位,整个T区约按摩40秒;最后按摩角质层较薄的U区20秒,由嘴角开始向上提拉,打圈按摩,最后再返回下巴打圈按摩。短短一分钟,细毛孔、去角质、亮肤色。
以图集形式查看>>
看一看使用后的真人效果吧,毛孔真的变细哦,特别是鼻子上的黑头,明显缩小。而且洗完脸没涂抹任何水和霜,肌肤就很细滑有光泽,并有种通透舒服的畅快感。我的脸部肌肤苦于一直有肤色不均的困扰,现在有了微晶亮肤洁面仪,一周使用1~2次去角质护理,很有信心能大大改善肤色暗沉不均的现状。
之后涂抹护肤品,明显觉得吸收加快不少,毕竟毛孔的“管道”疏通了,则营养自然就补充的进来啦!
[show] java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).