[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$$d346c03c.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$$d346c03c.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)
深深懂得爱美是女人的天性,常听人说起,"美是一种艺术,是对别人最大的尊重!”对这点,我深信不疑,我觉得彩妆就是让女人最美的唯一武器,
每个女人的内心总是希冀自信、美丽、百变,愿望着演绎不一样的自己,唇部的妆容往往是整个妆面的亮眼之笔。形形色色,多姿多彩的唇膏、唇釉,将一个个平凡的我们打造成不一样的亮丽风景。
以图集形式查看>>
外包装
第三代升级版的韩熙贞 甜蜜之吻唇膏采用流线型精致防磨损外壳,高雅宝石蓝釉面,俩端加以金色混搭点缀,瓶身方中带圆,亲肤外壳,细腻手感,拿在手里充满时尚又质感十足。
以图集形式查看>>
主打功效
亲肤水凝配方,锁水补水;
独特持色配方,色彩轻薄透亮,持久锁色;
另双唇饱满、亮丽、柔滑、丰盈有弹性。
以图集形式查看>>
此次试用的是806号慕斯红,听着名字,已经让人陶醉其中,
她将演绎怎样不同的红,点缀出俏丽迷人的唇部呢?
以图集形式查看>>
轻轻的拔开帽盖,发现这款唇膏是内置式磁吸式设计,开合方便,
关闭时帽盖能与瓶身紧紧的吸住,一开一合,一只手就能轻松搞定。
放在包包里也不用担心盖帽脱落,弄的膏体到处都是。
以图集形式查看>>
以图集形式查看>>
以图集形式查看>>
膏体中间部分同样采用了金色,凸显唇膏的高贵奢华。
上面刻有"韩熙贞”的英文LOGO,膏体顶端带有倾斜度,
膏面圆润幼滑,能更好的贴合唇部,便于均匀涂抹整个唇部。
以图集形式查看>>
显色度
韩熙贞甜蜜之吻唇膏涂抹在肌肤上显色轻薄通透,806慕斯红,比起樱花粉较为偏紫红,
涂抹在白纸上和手背上均能很好的呈现出本来的颜色,鲜亮娇媚,十分抢眼。
以图集形式查看>>
着色力、持久度
用纸巾按压在涂抹了唇膏的手背肌肤上,纸巾上只有少量浮色,手背上的唇膏颜色依然亮丽如初,
没有明显掉色现象,说明这款唇膏的的着色力和持久度都是非常不错的,
能够长时间维持亮丽的唇色,呵护双唇。
以图集形式查看>>
防水防油
将水油混合物喷洒在涂抹了唇膏的手背肌肤上,膏体上的水珠独立成形,唇膏没有晕染迹象,
韩熙贞 甜蜜之吻唇膏的防水防油性能很好,不易晕染脱色。
以图集形式查看>>
唇部上妆
唇部涂抹前唇色暗沉,唇纹较深,涂抹806慕斯红唇膏后,唇部显得水嫩丰盈,整体气色得到提升,唇色提亮,唇纹得到良好的覆盖。
以图集形式查看>>
黏腻度
将唇部压在均匀散落的胶囊颗粒上后观察,黏附的颗粒并不多,韩熙贞 甜蜜之吻唇膏含有乳木果油、蜂王浆、维生素C、E等多种保湿成分,涂抹后令唇部滋润而饱满,同时持久不黏腻。这点也是我非常看重的。
以图集形式查看>>
以图集形式查看>>
淡化唇纹
用吸油纸按压在唇部,吸油纸上的唇纹自然,沟壑并不十分明显,说明此款唇膏淡化唇纹效果较好。
以图集形式查看>>
滋润度
水分测试仪测出,使用前,唇部肌肤水分值只有31.1%,而涂抹了韩熙贞甜蜜之吻唇膏后,
水分值上升到42.5%,说明这款唇膏滋润度非常好,上妆后双唇能够保持水润娇嫩。
以图集形式查看>>
以图集形式查看>>
易卸程度
在棉纱布上倒上适量眼唇卸妆液,按压在唇部数秒,唇膏能基本上被卸除干净,可见韩熙贞 甜蜜之吻唇膏能较为容易的卸除,不会因为卸妆难而伤害娇弱的唇部肌肤。
以图集形式查看>>
优点:持久锁色,涂抹后滋润不油腻,色彩轻薄透亮,能轻松画出娇嫩美好的唇妆。
缺点:无
性价比:88元/3.8克,价位适中,值得入手。