[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$$c3fbb5dc.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$$c3fbb5dc.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)
说起洁面可真的是太多的话要说了,不知道怎么的,一打开洁面的问题,我就滔滔不绝了,其实对于洁面的第一次觉醒是在高中的时候,那时候刚刚上高中,无意间看见了一款洁面膏,就觉得一定要拥有不可,这也是我第一次真正的自己选择护肤品,从那开始对于洁面的爱好就止不住了,用过洁面泡沫、磨砂洁面、洁面膏、洁面啫喱、洁面乳几乎涵盖了洁面的所有种类,不管是超市开架还是专柜货我一直都在寻找的途中,不过据说好马也是吃回头草的!这不就回到了旁氏身上了
以图集形式查看>>
第一次遇到旁氏纯粹是电视广告的吸引,当时的海藻泥补水和清洁效果真的是以我学生的消费水平来说性价比最高的产品了,8年之后的我,又回到了旁氏的身边,不能不说是一种缘分,旁氏的炭洁面真的是名胜在外了,不过当时我正沉迷于洗颜专科那绵密的泡沫中,so忘记了旁氏的好了
以图集形式查看>>
这款洁面的套装是限量的产品,虽然只有50ml 40g,已经足以让我爱上这个平价的品牌了
以图集形式查看>>
对于化妆的妹纸来说卸妆是一定必要的,不管你是卸妆油还是卸妆啫喱,卸的干净才是王道,这款卸妆摩丝用起来超级的方便,一按就有绵密的泡沫出来,而且针对油性污垢有很好的效果哦,洁面的话,我个人还是习惯用洗面奶,不知道为什么,觉得洁面啫喱的泡泡不够丰富,洁面泡的泡泡又不够紧致,还是享受自己打出泡泡来的感觉
以图集形式查看>>
对于纷繁复杂的成分,我只能呵呵了,因为个人不是敏感肌肤,也对成分没什么研究,只要好用,我就心满意足了
以图集形式查看>>
其实我一直没搞懂旁氏这支花到底是神马,貌似郁金香的感觉,就是这一只郁金香伴随我从青涩到成熟
以图集形式查看>>
包装总是要打开才行的,虽然是中样,但是丝毫不马虎的设计,底部的凹槽的设计能牢牢固定住卸妆泡沫和洁面乳,严丝合缝
以图集形式查看>>
首先我们来研究卸妆泡沫好了,正好手里的卸妆不适合,正愁着用啥能卸妆呢,这不yoka就给我送来了,木哈哈,感谢的话就不多说了,肉麻吧啦吧啦
以图集形式查看>>
按压式的设计很是符合我个人的审美,下面的一字形能固定压嘴不会乱动
以图集形式查看>>
按压一下就可以了,妆容就慢慢的融掉了哦
以图集形式查看>>
泡沫相对来说还算细致,不过不够绵密,能看出来泡沫打的不是特别的均匀,大小不一,不过香味还是比较能接受的,没有很刺鼻化工的香料添加
以图集形式查看>>
泡沫的性质很温和,各种肌肤都能很轻松的使用起来没有任何负担
以图集形式查看>>
脸上的彩妆无非也就是BB、眼线、睫毛膏还有口红,眉笔么对于我来说可有可无,最近有点懒,不太会画眉也是原因之一,细腻的泡沫覆盖了我的彩妆,看看能给我带来什么惊喜吧
以图集形式查看>>
慢慢的揉,可以看到最快投降的是眼线和眉笔,BB和口红睫毛膏比较顽固,需要多按摩一会才行
以图集形式查看>>
虽然我对他卸睫毛膏和口红的能力有点怀疑,但是只要耐心在,一切都不是问题,洗完之后皮肤还是很干净的
以图集形式查看>>
卸妆之后总觉得皮肤呼吸不好,因为卸妆总是有点残留的,如果不用洗面奶洗一遍我的心里是有障碍的,清透的洁面乳就是我的最爱了
以图集形式查看>>
话说40g的洁面对于我来说应该是一个月的用量,洁面的用量是有讲究的,不要以为随便打出泡泡来就是清洁了,泡泡绵密与否完全决定了你的清洁程度
以图集形式查看>>
500 Servlet Exception