struts+spring+hibernate程序出错

错误提示
javax.servlet.ServletException: Hibernate operation: could not execute query; bad SQL grammar [select adminuser0_.id as id, adminuser0_.UserName as UserName0_, adminuser0_.Password as Password0_, adminuser0_.Card_Id as Card4_0_, adminuser0_.Subject as Subject0_ from mydata__adminuser adminuser0_ where adminuser0_.UserName=?]; nested exception is java.sql.SQLException: Table 'mydata.mydata__adminuser' 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:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: could not execute query; bad SQL grammar [select adminuser0_.id as id, adminuser0_.UserName as UserName0_, adminuser0_.Password as Password0_, adminuser0_.Card_Id as Card4_0_, adminuser0_.Subject as Subject0_ from mydata__adminuser adminuser0_ where adminuser0_.UserName=?]; nested exception is java.sql.SQLException: Table 'mydata.mydata__adminuser' doesn't exist
org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:224)
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:371)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
dao.AdminuserDAO.findByProperty(AdminuserDAO.java:84)
dao.AdminuserDAO.findByUserName(AdminuserDAO.java:92)
service.ServiceImp.isAdmin(ServiceImp.java:18)
service.ServiceImp$$FastClassByCGLIB$$b97a41d0.invoke(<generated>)
net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:685)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:623)
service.ServiceImp$$EnhancerByCGLIB$$c83ebea1.isAdmin(<generated>)
com.csu.struts.action.AdminloginAction.execute(AdminloginAction.java:54)
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:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
root cause java.sql.SQLException: Table 'mydata.mydata__adminuser' doesn't exist
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1231)
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
org.hibernate.loader.Loader.doQuery(Loader.java:391)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
org.hibernate.loader.Loader.doList(Loader.java:1593)
org.hibernate.loader.Loader.list(Loader.java:1577)
org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
org.springframework.orm.hibernate3.HibernateTemplate$31.doInHibernate(HibernateTemplate.java:853)
org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:366)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:844)
org.springframework.orm.hibernate3.HibernateTemplate.find(HibernateTemplate.java:840)
dao.AdminuserDAO.findByProperty(AdminuserDAO.java:84)
dao.AdminuserDAO.findByUserName(AdminuserDAO.java:92)
service.ServiceImp.isAdmin(ServiceImp.java:18)
service.ServiceImp$$FastClassByCGLIB$$b97a41d0.invoke(<generated>)
net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:685)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:623)
service.ServiceImp$$EnhancerByCGLIB$$c83ebea1.isAdmin(<generated>)
com.csu.struts.action.AdminloginAction.execute(AdminloginAction.java:54)
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:710)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.我的hbm文件是
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- 
    Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
    <class name="vo.Adminuser" table="adminuser" catalog="mydata">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="native" />
        </id>
        <property name="userName" type="java.lang.String">
            <column name="UserName" length="20" not-null="true" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="Password" length="20" />
        </property>
        <property name="cardId" type="java.lang.String">
            <column name="Card_Id" length="20" />
        </property>
        <property name="subject" type="java.lang.String">
            <column name="Subject" length="20" />
        </property>
    </class>

解决方案 »

  1.   

    另外　其他几个类是
    public class AdminloginAction extends Action {
    /*
     * Generated Methods
     */ /** 
     * Method execute
     * @param mapping
     * @param form
     * @param request
     * @param response
     * @return ActionForward
     */
     private ServiceImp serviceImp;
     
     public ServiceImp getServiceImp() {
      return serviceImp;
     }
     
     public void setServiceImp(ServiceImp serviceImp) {
      this.serviceImp = serviceImp; 
     } public ActionForward execute(ActionMapping mapping, ActionForm form,
    HttpServletRequest request, HttpServletResponse response) {
        DynaValidatorForm adminloginForm = (DynaValidatorForm) form;// TODO Auto-generated method stub
        Adminuser adminuser=new Adminuser();
        adminuser.setUserName(adminloginForm.getString("username"));
        adminuser.setPassword(adminloginForm.getString("password"));
         if (serviceImp.isAdmin(adminuser)) {
            return mapping.findForward("success");
          } else {
           return mapping.getInputForward();
          }
       }

    package service;
    import java.util.List;import vo.Adminuser;
    import dao.AdminuserDAO;public class ServiceImp implements IService {
    private AdminuserDAO adminuserDAO;
    public  AdminuserDAO getAdminuserDAO(){
    return adminuserDAO;
    }
    public void setAdminuserDAO(AdminuserDAO adminuserDAO){
    this.adminuserDAO=adminuserDAO;
    } public boolean isAdmin(Adminuser adminuser) {
    boolean flag=false;
    List result = adminuserDAO.findByUserName(adminuser.getUserName());
             if(result.size()>0&&result.get(0).equals(adminuser)) {
    flag=true;
    }
    return flag;
    }}package service;import vo.Adminuser;public interface IService {
    public boolean isAdmin(Adminuser adminuser );}
    这个我刚刚入门　请高人指点谢谢
      

  2.   

    另外的两个配置文件是
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN" "http://struts.apache.org/dtds/struts-config_1_2.dtd"><struts-config>
      <data-sources />
      <form-beans >
        <form-bean name="adminloginForm" type="org.apache.struts.validator.DynaValidatorForm">
          <form-property name="username" type="java.lang.String" />
          <form-property name="password" type="java.lang.String" />
        </form-bean>  </form-beans>  <global-exceptions />
      <global-forwards />
      <action-mappings >
        <action
          attribute="adminloginForm"
          input="/adminlogin.jsp"
          name="adminloginForm"
          path="/adminlogin"
          scope="request"
          validate="true"
          type="org.springframework.web.struts.DelegatingActionProxy">
          <forward name="fail" path="/adminlogin.jsp" />
          <forward name="success" path="/adminmain.jsp" />
        </action>  </action-mappings>
      
      <message-resources parameter="com.csu.struts.ApplicationResources" />
       <plug-in className="org.apache.struts.validator.ValidatorPlugIn">
        <set-property property="pathnames" value="/WEB-INF/validator-rules.xml,/WEB-INF/validation.xml" />
      </plug-in>
      <!--  <plug-in className="org.springframework.web.struts.ContextLoaderPlugIn">
    <set-property property="contextConfigLocation" value="/WEB-INF/applicationContext.xml" />
    </plug-in>  
       -->
    </struts-config>
    <?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>
    <bean id="dataSource"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName">
    <value>com.mysql.jdbc.Driver</value>
    </property>
    <property name="url">
    <value>jdbc:mysql://localhost:3306/mydata</value>
    </property>
    <property name="username">
    <value>root</value>
    </property>
    </bean>
    <bean id="sessionFactory"
    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
    <property name="dataSource">
    <ref bean="dataSource" />
    </property>
    <property name="hibernateProperties">
    <props>
    <prop key="hibernate.dialect">
    org.hibernate.dialect.MySQLDialect
    </prop>
    <prop key="hibernate.show_sql">true</prop>
    </props>
    </property>
    <property name="mappingResources">
    <list>
    <value>vo/Adminuser.hbm.xml</value></list>
    </property></bean>
    <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
             <property name="sessionFactory">
             <ref local="sessionFactory" />
             </property>
        </bean>

        <!-- <bean id="AdminuserDAOProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
              <property name="transactionManager">
               <ref bean="transactionManager" />
            </property>
               <property name="target">
                 <ref local="AdminuserDAO" />
            </property>
            <property name="proxyTargetClass" value="true"/>
            <property name="transactionAttributes">
            <props>
               <prop key="insert*">PROPAGATION_REQUIRED</prop>
               <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
               <prop key="is*">PROPAGATION_REQUIRED,readOnly</prop>
            </props>
            </property>
        </bean>  -->
        <bean id="AdminuserDAO" class="dao.AdminuserDAO">
    <property name="sessionFactory">
    <ref bean="sessionFactory" />
    </property>
    </bean>
    <bean id="ServiceImp" class="service.ServiceImp">
             <property name="adminuserDAO">
                      <ref local="AdminuserDAO"/>
              </property>
        </bean>
        <bean id="ServiceImpProxy" class="org.springframework.transaction.interceptor.TransactionProxyFactoryBean">
              <property name="transactionManager">
               <ref bean="transactionManager" />
            </property>
               <property name="target">
                 <ref local="ServiceImp" />
            </property>
            <property name="proxyTargetClass" value="true"/>
            <property name="transactionAttributes">
            <props>
               <prop key="insert*">PROPAGATION_REQUIRED</prop>
               <prop key="get*">PROPAGATION_REQUIRED,readOnly</prop>
               <prop key="is*">PROPAGATION_REQUIRED,readOnly</prop>
            </props>
            </property>
        </bean>
           <bean name="/adminlogin" class="com.csu.struts.action.AdminloginAction" singleton="false">
            <property name="serviceImp">
                  <ref bean="ServiceImpProxy" /> 
            </property>
          </bean>
        </beans>