我用SSH写的dao方法没有执行SQL语句,希望有大神帮帮忙

LOVEJA_VA 2017-11-26 10:29:47
dao方法


public User findByUser(User user) {

		// TODO Auto-generated method stub

		System.out.println("进入DAO111111111");

		Object result= sessionFactory.getCurrentSession().

		createQuery("from user where uname=? and pwd=?")

		.setString(0, user.getUname())

		.setString(1,user.getPwd())

		.uniqueResult();

		System.out.println(result);

		 return (User)result;

		

	}

bean.xml


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

		<property name="dataSource" ref="dataSource"></property>

		<property name="hibernateProperties">

			<props>

				 <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

				 <prop key="hibernate.show_sql">true</prop>

				 <prop key="hibernate.hbm2ddl.auto">update</prop>

			</props>

		</property>

		<property name="mappingLocations">

			<list>

				<value>classpath:com/register/entity/*.hbm.xml</value>

			</list>

		</property>

		

	</bean>

	<!-- 3. 事务相关配置 -->

	<!-- 3.1 事务管理器类 -->

	<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">

		<property name="sessionFactory" ref="sessionFactory"></property>

	</bean>

<tx:advice id="txAdvice" transaction-manager="txManager">

		<tx:attributes>

			<tx:method name="*" read-only="false"/>

		</tx:attributes>

	</tx:advice>

	<aop:config>

		<aop:pointcut expression="execution(* com.register.service.*.*(..))" id="pt"/>

		<aop:advisor advice-ref="txAdvice" pointcut-ref="pt"/>

	</aop:config>

</beans>

struts.xml


<package name="user" extends="struts-default">

	

		<!-- 全局异常 -->

		<global-exception-mappings>

			<!-- result 会取找全局视图的名称 -->

			<exception-mapping result="null" exception="java.lang.NullPointerException"></exception-mapping>

			<exception-mapping result="error" exception="java.lang.Exception"></exception-mapping>

		</global-exception-mappings>



	<action name="user_*" class="userAction" method="{1}">

		

			<!-- 登陆失败 -->

			<result name="loginfaild">/login.jsp</result>

			

			<!-- 登陆成功 -->

			<result name="index" >/register.jsp</result>

		

		</action>

	</package>


...全文
341 12 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
12 条回复
切换为时间正序
请发表友善的回复…
发表回复
xls丶 2017-11-28
  • 打赏
  • 举报
 回复
hql查的是对象,User大写
LOVEJA_VA 2017-11-28
  • 打赏
  • 举报
 回复
引用 11 楼 qq_38204653 的回复:
hql查的是对象,User大写
谢了，这些细节很重要
qq_19518637 2017-11-27
  • 打赏
  • 举报
 回复
楼主倒是把代码贴完呢。无语 .setString(0, user.getUname())  .setString(1,user.getPwd()) .uniqueResult();
ssy03092919 2017-11-27
  • 打赏
  • 举报
 回复
action的fandByUser()方法的返回值不在struts配置文件的result中
Sunyiban 2017-11-27
  • 打赏
  • 举报
 回复
你倒是把控制台的输出贴出来呀~
艺哥来了 2017-11-27
  • 打赏
  • 举报
 回复
你打断点跟踪看看，看看报的啥子错
LOVEJA_VA 2017-11-27
  • 打赏
  • 举报
 回复
引用 8 楼 ab1021586251 的回复:
action 配置文件看看，你的result 怎么配的
action的xml文件 

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
	xmlns:p="http://www.springframework.org/schema/p"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:aop="http://www.springframework.org/schema/aop"
	xmlns:tx="http://www.springframework.org/schema/tx"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
    	 http://www.springframework.org/schema/beans/spring-beans.xsd
     	 http://www.springframework.org/schema/context
         http://www.springframework.org/schema/context/spring-context.xsd
         http://www.springframework.org/schema/aop
         http://www.springframework.org/schema/aop/spring-aop.xsd
         http://www.springframework.org/schema/tx
     	 http://www.springframework.org/schema/tx/spring-tx.xsd">
<!-- 将action注入到service -->
	<bean id="userAction" class="com.register.action.UserAction">
		<property name="userService" ref="userService"></property>
		
	</bean>
	
</beans>
struts的xml文件 

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
	"-//Apache Software Foundation//DTD Struts Configuration 2.3//EN"
	"http://struts.apache.org/dtds/struts-2.3.dtd">

<struts>

<package name="user" extends="struts-default">
	
	
		
		<!-- 全局异常 -->
		<global-exception-mappings>
			<!-- result 会取找全局视图的名称 -->
			<exception-mapping result="null" exception="java.lang.NullPointerException"></exception-mapping>
			<exception-mapping result="error" exception="java.lang.Exception"></exception-mapping>
		</global-exception-mappings>
		

	
	<action name="user_*" class="userAction" method="{1}">
		
			<!-- 登陆失败 -->
			<result name="error">/login.jsp</result>
			
			<!-- 登陆成功 -->
			<result name="success" >/register.jsp</result>
		
		</action>
	</package>
 


</struts>
「已注销」 2017-11-27
  • 打赏
  • 举报
 回复
action 配置文件看看，你的result 怎么配的
墨笙弘一 2017-11-27
  • 打赏
  • 举报
 回复
Could not find action or result No result defined for action com.register.action.UserAction and result error SSH配置文件明显有问题啊
LOVEJA_VA 2017-11-27
  • 打赏
  • 举报
 回复
引用 1 楼 u014548833 的回复:
你打断点跟踪看看，看看报的啥子错
警告: Could not find action or result No result defined for action com.register.action.UserAction and result error at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:376) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:278) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511) at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 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:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:744)
LOVEJA_VA 2017-11-27
  • 打赏
  • 举报
 回复
引用 1 楼 u014548833 的回复:
你打断点跟踪看看，看看报的啥子错
警告: Could not find action or result No result defined for action com.register.action.UserAction and result error at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:376) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:278) at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54) at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511) at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77) at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 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:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:744) 这个是异常
LOVEJA_VA 2017-11-27
  • 打赏
  • 举报
 回复 

警告: Could not find action or result
No result defined for action com.register.action.UserAction and result error
	at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:376)
	at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:278)
	at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
	at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:511)
	at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
	at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	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:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:744)
这个是输出的异常错误
java基础002
试卷一2013年年底的时候，我看到了网上流传的一个叫做《Java面试题大全》的东西，认真的阅读了以后发现里面的很多题目是重复且没有价值的题目，还有不少的参考答案也是错误的，于是我花了半个月时间对这个所谓的...
java面试题大合集（开发者必看）
本文来自百度网络的一篇文章，由于没有答案，现在整理了一些比较好的回答和好的博客，可以自己扩展思路，如果大家有一下面试题的更好的答案，欢迎在评论区留言。以上全部来自网络！ 基本概念 1、操作系统中 heap 和 ...
webmagic采集CSDN的Java_WebDevelop页面
使用webmagic采集博客类的网站示例
阿里Java面经大全（整合版）
1.上来问我项目用的框架，然后问我springmvc里面有的参数的设定，问的是细节，然后问我如果传的多个值是一个对象的属性，问我如何处理，我说直接在后端接收为对象就行了，然后突然问我http怎么传对象，这里有点不...
java面试题总结（开发者必备）
本文来自百度网络的一篇文章，由于没有答案，现在整理了一些比较好的回答和好的博客，可以自己扩展思路，如果大家有一下面试题的更好的答案，欢迎在评论区留言。以上全部来自网络！此外，我的微信公众号将每日分享...
Java EE

67,549

社区成员

225,860

社区内容

发帖
与我相关
我的任务
社区描述
J2EE只是Java企业应用。我们需要一个跨J2SE/WEB/EJB的微容器，保护我们的业务核心组件（中间件），以延续它的生命力，而不是依赖J2SE/J2EE版本。
社区管理员
  • Java EE
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章