(1)<select name="usres.userDegree" id="textfield9" value="<s:property value="usres.userDegree"/>" style="width:137px;">
<option value="请选择">请选择</option>
<option value="初中及以下">初中及以下</option>
<option value="高中/中专">高中/中专</option>
<option value="职高">职高</option>
<option value="大专">大专</option>
<option value="大学本科">大学本科</option>
<option value="硕士以上">硕士以上</option></select> (2) <input type="radio" name="sex" id="radio" value="男" />男
<input type="radio" name="sex" id="radio2" value="女" />女(3)<select name="nian" id="textfield8" style="width:60px;">
<option value="1900">1900</option>
</select>
年
<select name="yue" id="textfield8" style="width:50px;" >
<option value="1">1</option>
</select>
月
<select name="ri" id="textfield8" style="width:50px;">
<option value="1">1</option>
</select>
用的是strust2、spring、hibernate。我已经把数据提交到数据库中啦。是value的值。这是保存修改页面。点完保存修改后返回本页面。我怎么从数据库中读取出来,让它初始化选中我读取出来的值啊!
<option value="请选择">请选择</option>
<option value="初中及以下">初中及以下</option>
<option value="高中/中专">高中/中专</option>
<option value="职高">职高</option>
<option value="大专">大专</option>
<option value="大学本科">大学本科</option>
<option value="硕士以上">硕士以上</option></select> (2) <input type="radio" name="sex" id="radio" value="男" />男
<input type="radio" name="sex" id="radio2" value="女" />女(3)<select name="nian" id="textfield8" style="width:60px;">
<option value="1900">1900</option>
</select>
年
<select name="yue" id="textfield8" style="width:50px;" >
<option value="1">1</option>
</select>
月
<select name="ri" id="textfield8" style="width:50px;">
<option value="1">1</option>
</select>
用的是strust2、spring、hibernate。我已经把数据提交到数据库中啦。是value的值。这是保存修改页面。点完保存修改后返回本页面。我怎么从数据库中读取出来,让它初始化选中我读取出来的值啊!
比如:
<select name="qIplug" value="#request.qIplug">
<option value="">--请选择--</option>
<s:iterator id="c" value="iplugLst">
<s:if test='#request.qIplug==#c.value'>
<option selected value="${c.value}">${c.label}</option>
</s:if>
<s:else>
<option value="${c.value}">${c.label}</option>
</s:else>
</s:iterator>
</select>
<s:select theme="simple" name="yue" list="#{'1':'1'}" cssStyle="width:50px;"/>
<s:select theme="simple" name="ri" list="#{'1':'1'}" cssStyle="width:50px;"/>
<select name="usres.userPosition" id="textfield12" style="width:137px;">
<option value="<s:property value="usres.userPosition"/>"><s:property value="usres.userPosition"/></option>
<option value="请选择">请选择</option>
<option value="信息/公关">信息/公关</option>
<option value="市场营销/广告">市场营销/广告</option>
<option value="销售 咨询顾问">销售 咨询顾问</option>
<option value="代理人">代理人</option>
<option value="工程类">工程类</option>
<option value="金融业">金融业</option>
<option value="私人投资者">私人投资者</option>
<option value="高层管理">高层管理</option>
<option value="人力资源/培训">人力资源/培训</option>
<option value="产品管理/开发">产品管理/开发</option>
<option value="程序设计">程序设计</option>
<option value="研究人员">研究人员</option>
<option value="退休人士">退休人士</option>
<option value="战略/商业发展">战略/商业发展</option>
<option value="学生">学生</option>
<option value="教师">教师</option>
<option value="自由职业者">自由职业者</option>
<option value="其他">其他</option></select>
这是页面内容我现在用的这种方法。不能显示出默认的请选择,因为一开始没有值所以显示为空。我怎么把请选择一开始显示出来啊、我设定他的select=select那个的话,它永远是选中的只显示请选择。
其他2个问题也一样都是页面已经写死了的。
怎么在更改保存之后让它显示出用户所显示的值。也就是说我初始化的时候让用户的信息选中。以前是用c#做的那个里面有方法,不过我忘了汗我现在这种方法只是显示出来。并不是选中。
比如性别,
actionForm.setSex("男");
直接做显示。哈哈还是不会让他判断选中。如果是数据都从数据库中的读取出来那种会。这种不会。除非用js。o(︶︿︶)o 唉
.getCurrentSession()
.createSQLQuery(
"update Userlogin as user set user.userPw=:repassword where user.userPw=:password and user.id=:id");// 根据用户名密码查询更改
query.setString("password", password);// 参数
query.setString("repassword", repassword);// 参数
query.setInteger("id", id);// 参数
我用的是struts2、spring、hibernate3.0
报错如下
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:412)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1364)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.myledu.dao.impl.UserberDaoImpl.getUserByPwdAndRePwd(UserberDaoImpl.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy8.getUserByPwdAndRePwd(Unknown Source)
at org.myledu.web.action.UserberAction.updatePassWord(UserberAction.java:33)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:440)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:279)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:242)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:163)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:249)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:93)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:104)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:148)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:128)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:236)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:468)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:76)
at org.myledu.filter.StrutsFilter.doFilter(StrutsFilter.java:17)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)
如何执行更新的时候把sql语句做为参数传递进去
.getCurrentSession()
.createSQLQuery(
"update Userlogin as user set user.userPw=:repassword where user.userPw=:password and user.id=:id");;;;;;;------------------>>>>>>>>>>>>>>>>>update语句不要用别名试试看。Query query = sf
.getCurrentSession()
.createSQLQuery(
"update Userlogin set userPw=:repassword where userPw=:password and id=:id");
2010/05/13-14:04:25 DEBUG Loader:1747 - bindNamedParameters() 6 -> id [3]
2010/05/13-14:04:25 DEBUG IntegerType:133 - binding '6' to parameter: 3
2010/05/13-14:04:25 DEBUG Loader:1747 - bindNamedParameters() 71f396e4134a1160d90bb1439876df31 -> repassword [1]
2010/05/13-14:04:25 DEBUG StringType:133 - binding '71f396e4134a1160d90bb1439876df31' to parameter: 1
2010/05/13-14:04:25 DEBUG Loader:1747 - bindNamedParameters() eed8cdc400dfd4ec85dff70a170066b7 -> password [2]
2010/05/13-14:04:25 DEBUG StringType:133 - binding 'eed8cdc400dfd4ec85dff70a170066b7' to parameter: 2
2010/05/13-14:04:25 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2010/05/13-14:04:25 DEBUG AbstractBatcher:533 - closing statement
2010/05/13-14:04:25 DEBUG JDBCExceptionReporter:69 - could not execute query [update Userlogin as user set user.userPw=? where user.userPw=? and user.id=?]
有值啊是不是不该用createSQLQuery()这个方法
你的表名是 Userlogin 还是user啊?update后面用表名
int count = 0;// 返回条数
Query query = sf
.getCurrentSession()
.createSQLQuery(
"update Userlogin as user set user.userPw=:repassword where user.userPw=:password and user.id=:id");// 根据用户名密码查询更改
query.setString("password", password);// 参数
query.setString("repassword", repassword);// 参数
query.setInteger("id", id);// 参数
/*
* 如果大于0保存到条数
*/
if (query.list().size() > 0) {
count = query.list().size();
} return count;
}
我的DaoImpl里面的方法。我在main方法里面测试都过不去。是不是我方法createSQLQuery这个的错误啊我的值已经有啦能取到值。update语句用sql作为参数这样写对吗
谢谢啦啊费心了,呵呵 。
update后面用表名不要用实体类名啊。
我在数据库里运行了啊没有错误啊sql语句
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.myledu.entity">
<class name="Userlogin" table="userlogin">
<id name="id" column="ID">
<generator class="native" />
</id>
<property name="userPid" column="userPid" />
<property name="userName" column="userName" />
<property name="userEmail" column="userEmail" />
<property name="userPw" column="userPw" />
<property name="userType" column="userType" />
<property name="userLoinData" column="userLoginTime" />
<property name="userMobile" column="userMobile" />
<property name="userAddress" column="userAddress" />
<property name="userSex" column="userSex" />
<property name="userBirthday" column="userBirthday" />
<property name="userDegree" column="userDegree" />
<property name="userCompany" column="userCompany" />
<property name="userIndustry" column="userIndustry" />
<property name="userPosition" column="userPosition" />
<property name="userLoginName" column="userLoginName" />
<property name="userPost" column="userPost" />
<property name="userPostAddress" column="userPostAddress" />
</class>
</hibernate-mapping>
hibernate里面的配置
实体类是
private int id;//用户id
private String userPid;//用户pid
private String userName;//用户名
private String userEmail;//用户邮箱
private String userPw;//用户密码
private int userType;//用户类型
private String userLoinData;//日期
private String userMobile;//用户手机号码
private String userAddress;//用户地址
private String userSex;//用户性别
private String userPost;//用户邮编
private String userBirthday;//用户生日
private String userDegree;//用户教育程度
private String userCompany;//用户所在公司
private String userIndustry;//用户所在公司的行业
private String userPosition;//用户职位
private String userLoginName;//用户姓名
private String userPostAddress;//用户邮寄地址
看看有没有Update的相关方法。
这里调用的是executeQuery,需要的是executeUpdate。
2010/05/13-15:42:26 DEBUG SessionImpl:1685 - SQL query: update Userlogin as user set user.userPw=? where user.userPw=? and user.id=?
2010/05/13-15:42:26 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2010/05/13-15:42:26 DEBUG SQL:401 -
update
Userlogin as user
set
user.userPw=?
where
user.userPw=?
and user.id=?
Hibernate:
update
Userlogin as user
set
user.userPw=?
where
user.userPw=?
and user.id=?
2010/05/13-15:42:26 DEBUG AbstractBatcher:484 - preparing statement
2010/05/13-15:42:26 DEBUG Loader:1747 - bindNamedParameters() 6 -> id [3]
2010/05/13-15:42:26 DEBUG IntegerType:133 - binding '6' to parameter: 3
2010/05/13-15:42:26 DEBUG Loader:1747 - bindNamedParameters() 71f396e4134a1160d90bb1439876df31 -> repassword [1]
2010/05/13-15:42:26 DEBUG StringType:133 - binding '71f396e4134a1160d90bb1439876df31' to parameter: 1
2010/05/13-15:42:26 DEBUG Loader:1747 - bindNamedParameters() eed8cdc400dfd4ec85dff70a170066b7 -> password [2]
2010/05/13-15:42:26 DEBUG StringType:133 - binding 'eed8cdc400dfd4ec85dff70a170066b7' to parameter: 2
2010/05/13-15:42:26 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
2010/05/13-15:42:26 DEBUG AbstractBatcher:533 - closing statement
2010/05/13-15:42:26 DEBUG JDBCExceptionReporter:69 - could not execute query [update Userlogin as user set user.userPw=? where user.userPw=? and user.id=?]
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:412)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1364)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.myledu.dao.impl.UserberDaoImpl.getUserByPwdAndRePwd(UserberDaoImpl.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy4.getUserByPwdAndRePwd(Unknown Source)
at org.myledu.dao.impl.UserberDaoImpl.main(UserberDaoImpl.java:57)
2010/05/13-15:42:26 WARN JDBCExceptionReporter:77 - SQL Error: 0, SQLState: S1009
2010/05/13-15:42:26 ERROR JDBCExceptionReporter:78 - Can not issue data manipulation statements with executeQuery().
2010/05/13-15:42:26 DEBUG JDBCTransaction:152 - rollback
2010/05/13-15:42:26 DEBUG JDBCTransaction:163 - rolled back JDBC Connection
2010/05/13-15:42:26 DEBUG JDBCContext:219 - after transaction completion
2010/05/13-15:42:26 DEBUG ConnectionManager:302 - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2010/05/13-15:42:26 DEBUG SessionImpl:422 - after transaction completion
2010/05/13-15:42:26 DEBUG SessionImpl:273 - closing session
2010/05/13-15:42:26 DEBUG ConnectionManager:380 - performing cleanup
2010/05/13-15:42:26 DEBUG ConnectionManager:441 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
2010/05/13-15:42:26 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
2010/05/13-15:42:26 DEBUG JDBCContext:219 - after transaction completion
2010/05/13-15:42:26 DEBUG ConnectionManager:302 - transaction completed on session with on_close connection release mode; be sure to close the session to release JDBC resources!
2010/05/13-15:42:26 DEBUG SessionImpl:422 - after transaction completion
Exception in thread "main" org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.myledu.dao.impl.UserberDaoImpl.getUserByPwdAndRePwd(UserberDaoImpl.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy4.getUserByPwdAndRePwd(Unknown Source)
at org.myledu.dao.impl.UserberDaoImpl.main(UserberDaoImpl.java:57)
Caused by: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:412)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1364)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
... 21 more
报的错误用的是mysql数据库
.getCurrentSession()
.createQuery(
"update Userlogin as user set user.userPw=:repassword where user.userPw=:password and user.id=:id");// 根据用户名密码查询更改
用不了。我一开始用的就是这个createQuery后来改的createSqlQuery();
int count = 0;// 返回条数
Query query = sf
.getCurrentSession()
.createSQLQuery(
"update Userlogin as user set user.userPw=:repassword where user.userPw=:password and user.id=:id");// 根据用户名密码查询更改
query.setString("password", password);// 参数
query.setString("repassword", repassword);// 参数
query.setInteger("id", id);// 参数
/*
* 如果大于0保存到条数
*/
if (query.list().size() > 0) {
count = query.list().size();
} return count;
}
这个方法在main方法里测试都过不去
报错如下
java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:412)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1364)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.myledu.dao.impl.UserberDaoImpl.getUserByPwdAndRePwd(UserberDaoImpl.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy4.getUserByPwdAndRePwd(Unknown Source)
at org.myledu.dao.impl.UserberDaoImpl.main(UserberDaoImpl.java:57)
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2216)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289)
at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695)
at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142)
at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152)
at org.myledu.dao.impl.UserberDaoImpl.getUserByPwdAndRePwd(UserberDaoImpl.java:48)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy4.getUserByPwdAndRePwd(Unknown Source)
at org.myledu.dao.impl.UserberDaoImpl.main(UserberDaoImpl.java:57)
Caused by: java.sql.SQLException: Can not issue data manipulation statements with executeQuery().
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkForDml(Statement.java:412)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1364)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
at org.hibernate.loader.Loader.doQuery(Loader.java:674)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
at org.hibernate.loader.Loader.doList(Loader.java:2213)
... 21 more