是在: if (userDAO.isValidUser(username,password)) 出错!
解决方案 »
- HTML 中插入Flash问题
- 批量处理数据 在线等大牛或小神 打酱油的勿近
- 请问Eclipse中有没有jseclipse插件可以支持自动提示jQuery的函数库的,谢谢
- 2*8问题
- jsp如何给.js文件 传输参数 高分相赠
- myeclipse的uml编辑器打开任何东东都报错 为什么啊 急急急!!!!!!!!!!!!!
- 两个double数值相加:3.32+2.88=6.199999999999999的问题,请高手赐教
- 初学jbuilder + weblogic8.1开发EJB,有个问题.
- 用JBuilder10找开struts-config.xml总是出错!
- 初学者的疑惑,希望各位大哥帮忙(在线等待)
- 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)