org.hibernate.exception.SQLGrammarException: could not execute query

Question

高手帮帮我吧！源文件
Hibernate 配置<hibernate-mapping>
    <class name="beans.Users" table="``users" catalog="springweb">
        <id name="id" type="java.lang.Integer">
            <column name="id" />
            <generator class="increment" />
        </id>
        <property name="username" type="java.lang.String">
            <column name="username" length="13" not-null="true" unique="true" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="password" length="13" not-null="true" />
        </property>
        <set name="userlogs" inverse="true">
            <key>
                <column name="userid" not-null="true" />
            </key>
            <one-to-many class="beans.Userlog" />
        </set>
        <set name="paies" inverse="true">
            <key>
                <column name="uid" not-null="true" />
            </key>
            <one-to-many class="beans.Pay" />
        </set>
    </class>代码
public class UsersDAO extends HibernateDaoSupport implements imp.IUserDAO
{    private static final Log log = LogFactory.getLog(UsersDAO.class);    private HibernateTemplate hibernateTemplate;
public static final String USERNAME = "username";
public static final String PASSWORD = "password"; protected void initDao() {
//do nothing
}
    public Users login(Users user)
    {
    
     try
     {
     Session session=this.getSessionFactory().openSession();
     Query query=session.createQuery("from Users where username=:username and password=:password");
     query.setString("username",user.getUsername());
     query.setString("password",user.getPassword());
     List list=query.list();
     if(list.size()>0)
     return (Users)list.get(0);
     return null;
     }
     catch(RuntimeException re)
     {
     throw re;
     }
    }数据库:
create table users
(
id int auto_increment not null,

username varchar(13) unique  not null,

password varchar(13) not null,

primary key(id)
);不知道怎么老出这个问题的   

Answer 1

from Users where username=:username and password=:password
寫錯了~~是form不是from