是在: if (userDAO.isValidUser(username,password)) 出错!
解决方案 »
- 关于struts文件上传的一个问题
- oracle里如何将一张表的数据导入另外一张表?
- java调c++程序中的函数怎么实现?
- Hibernate中多对多的问题
- 请教关于Struts Cannot find ActionMappings or ActionFormBeans collection的问题,检查一个礼拜都没有找到错误在哪里.
- 超链接到之前的页面时,如何清除密码框的数据
- 应用Hibernate,Spring,Struts做系统中延迟加载的问题
- myeclipse中JSP页面的代码提示没了
- 调查:大家用 hibernate 对于数据库主键用什么?
- 开发EntityBean连接oracle的基本配置问题(最后10分请大家谅解)
- Java集合中如何解决数据分类汇总的问题(需要高手解决)
- 电信增值业务服务一般是干什么的呀,java开发一般作什么?
显示层--》服务层--》持久层需要在spring中为服务层的服务对象配置事务代理工厂,同时配置事物规则等等,然后才能调用。
<bean name="/login" class="com.test.struts.action.LoginAction" singleton="false">
<property name="userDAO"><ref bean="UserDAO" /></property>
</bean>
另外,singleton="false"从LoginAction的代码看来,我认为是没有必要的,Spring管理prototype的bean效率并不是很高。
现在有出现了这个问题:
type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select user0_.ID as ID, user0_.USERNAME as USERNAME0_, user0_.PASSWORD as PASSWORD0_ from sampledb__user user0_ where user0_.USERNAME=?]; nested exception is java.sql.SQLException: Table 'sampledb.sampledb__user' doesn't exist
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:523)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select user0_.ID as ID, user0_.USERNAME as USERNAME0_, user0_.PASSWORD as PASSWORD0_ from sampledb__user user0_ where user0_.USERNAME=?]; nested exception is java.sql.SQLException: Table 'sampledb.sampledb__user' doesn't exist
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:223)
org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:411)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:370)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:817)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:813)
com.test.Hibernate.UserDAO.isValidUser(UserDAO.java:119)
com.test.struts.action.LoginAction.execute(LoginAction.java:58)
org.springframework.web.struts.DelegatingActionProxy.execute(DelegatingActionProxy.java:106)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)