[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)
最近天气多变,我的心情也跟着变化起来,心思自然就木有特别多放在呵护肌肤方面。于是乎,悲催哒“失恋肌”粗现。话说这个词儿是我自创哒,形容我现在面如菜色,蹦痘,换季爆皮,肌肤松弛,肤色不匀等等诸多问题哒大脸肌肤。换季了,就算心情再多变再懒也还是要有一套适合自己肌肤状况哒护肤装备哒,不能总一直持续木有精神哒“失恋肌”吧。咪儿在举国同庆哒日子给自己哒敏感肌准备哒这个简单换季水润护肤小routine。
以图集形式查看>>
妹子们都知道哒就是清洁是美肌养成哒第一步,重中之重!所以哇,只有改善好了我才能继续马上到来哒完美购物假啦。咪儿先来分享水润小routine第一步,那就是洁面!有过敏感史哒问题肌,不要怕,咪儿哒丝塔芙洁面乳来啦!
以图集形式查看>>
加拿大进口,适合所有肤质哒百搭不挑食洁面乳一枚。净含量118ml,搜了搜加上国外当地那种含量哒大概五种规格,小规格适合旅行或者外出携带,最大规格适合全家一起使用,无论咋滴都可以任由MM随心所欲选择咯。木有外盒木有塑封,十足哒简约药妆风。正面品牌logo让我曾经在屈臣氏一下子就看到了她。背面有详细哒中文标贴,全是有关洁面乳产地,成分,生产日期等等。这个号称世界上最温和的洁面乳,能做到卸妆与清洁完美结合,不管神马脸部颈部亦或者是娇嫩哒眼部肌肤,都很OK啦。她不但温和,最神奇哒就是木有泡沫哒情况下,可以洗的灰常干净。话说,一般我们都会感觉泡沫丰富哒洁面清洁力强,往往碱性成分相对较高,会有一定刺激性,破坏了肌肤哒屏障功能。但是无泡沫哒并不意味着清洁力不OK吖,这二者其实木有必然联系。尤其当肌肤出现敏感状况的时候,就必须选用丝塔芙这样既温和又能洗干净哒洁面乳啦。
以图集形式查看>>
丝塔芙是法国高德美公司研发生产,目前为止全球排名第一的皮肤科领域专业药厂,丝塔芙在全球都已经拥有四十多年哒品牌历史了呢。虽然咪儿之前有在屈臣氏给我麻麻买过丝塔芙洁面,但是自己一直用的都是泡沫洁面。直到朋友看到我肌肤会偶尔敏感,我才痛定思痛,护肤实在要根据实际情况,而不能由着自己喜欢不喜欢哒性子来。
以图集形式查看>>
因为清洁是呵护美肌或者美肌养成哒第一步,清洁重要,温和清洁加滋养更重要咯。看看沾取了洁面乳哒PH试纸还是呈现黄色哒弱酸性,如此接近人体健康肌肤酸碱度,就知道非常柔和,安全适用于包括敏感肌肤在内哒各种肌肤。真的是最爱这样完全不含皂基,无任何刺激性清洁成分,不含香料,也不含色素的洁面啦。我的菜我的菜。
以图集形式查看>>
打开盖子,轻松挤出来哒一小坨半透明乳白色哒液体,粘稠质地,木有任何流动性,直接在手背上面揉搓或者加水打湿手背再揉搓都可以。真真的是我见过的唯一一款啥味道都没有的洁面。不管你是爱香味,还是讨厌臭味,人家丝塔芙洁面啥你想要的不想要的味道都没有。这么有范儿,正是我喜欢哒。
以图集形式查看>>
揉搓多久都实在是真的一点儿泡沫都没有,我就相信她真的是超级无泡洁面啦。但是清水冲洗起来也蛮轻易就搞定,丝毫不会有洁面乳哒任何残留。看着我这个手背肌肤就能感受的到清爽与滋润了。测试下水分值居然飙升到82.6%,真正做到清洁彻底,补水高效,却是咪儿第一次遇到,爽歪歪了我。
以图集形式查看>>
最赞的是不论你想水洗还是不方便的时候选择干洗,都OK。丝塔芙洁面不过我不太喜欢干洗,所以平时依然选择哒是水洗更多一些,除非是特殊情况。不过分享的时候我是用哒自创哒干洗水洗结合喔。我先用干洗哒方法,挤出来适量洁面乳在手心,揉搓一下即可于面部打圈按摩。有一种用清洁凝胶或者冻膜给肌肤做清洁哒感觉呢。搭配简单的手法脸部肌肤会更舒服呢,也会让出现敏感状况的肌肤得到很好哒舒缓啦。然后再稍微沾湿一下手部肌肤,继续打圈按摩。
以图集形式查看>>
其实清洗干净的时候,是会有一种特别清爽透气哒感觉的。接下来直接用水冲干净就噢啦,摸起来干净还水润,而且还会感觉脸上有一层薄薄保护膜。不过放心啦,这个保护膜只会给肌肤更好哒即刻柔润哒保护。完全不会堵塞毛孔,更不会引起粉刺,还不会让那些脏脏哒东西残留于肌肤深层。
[show] java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).