org.hibernate.hql.internal.ast.QuerySyntaxException：Motor未映射[来自VNOPOL=:id的Motor]

Question

我在映射时遇到一个问题：

马达。Java

public void fullInfo() {
        MotorDao dao = new MotorDao();
        List<Motor> lc = dao.getMotorById(VNOPOL);
        System.out.println(lc.get(0).VNOPOL);
        this.VIDCUSTOMER = lc.get(0).VIDCUSTOMER;
        this.VFRAMENUM = lc.get(0).VFRAMENUM;
        this.VENGINENUM = lc.get(0).VENGINENUM;
        this.VTHNPROD = lc.get(0).VTHNPROD;
        this.NKMSERVICE = lc.get(0).NKMSERVICE;

    }

public List<Motor> getMotorById(String motid) {
        System.out.println(motid);
//        Customer cust = null;
        Transaction trns = null;
        Session session = HibernateUtil.getSessionFactory().openSession();
        try {
            trns = session.beginTransaction();
            String queryString = "from Motor where VNOPOL = :id";
            Query query = session.createQuery(queryString);
            query.setString("id", motid);
            //cust = (Customer) query.uniqueResult();
            List<Motor> list = query.list();
            if (list.size() > 0) {
                return list;
            }
        } catch (RuntimeException e) {
            e.printStackTrace();
        } finally {
            session.flush();
            session.close();
        }
        return null;
    }

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Jul 5, 2013 10:57:32 AM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="com.javaknowledge.entity.Motor" table="ahmdsmts_mstmotor" catalog="ahmids">
        <id name="VFRAMENUM" type="string">
            <column name="VVFRAMENUM" />

        </id>
        <property name="VENGINENUM" type="string">
            <column name="VENGINENUM" length="100"  />
        </property>
        <property name="VNOPOL" type="string">
            <column name="VNOPOL" length="100" />
        </property>
        <property name="VTYPECODE" type="string">
            <column name="VTYPECODE" length="15" />
        </property>
        <property name="VCLRCODE" type="string">
            <column name="VCLRCODE" length="4"/>
        </property>
        <property name="VTHNPROD" type="java.lang.Integer">
            <column name="VTHNPROD" length="100" />
        </property>
        <property name="NKMSERVICE" type="java.lang.Integer">
            <column name="NKMSERVICE" length="100" />
        </property>
        <property name="VIDCUSTOMER" type="string">
            <column name="VIDCUSTOMER" length="4"/>
        </property>
    </class>
</hibernate-mapping>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/ahmids?zeroDateTimeBehavior=convertToNull</property>
    <property name="hibernate.connection.username">root</property>
    <property name="hibernate.connection.password">ahmids</property>
    <mapping resource="com/javaknowledge/entity/Customer.hbm.xml"/>
    <mapping resource="com/javaknowledge/entity/TipeMotor.hbm.xml"/>
    <mapping resource="com/javaknowledge/entity/Service.hbm.xml"/>
    <mapping resource="com/javaknowledge/entity/Motor.hbm.xml"/>
  </session-factory>
</hibernate-configuration>

查询“from motor”是一个classname。但它仍然不起作用。如何按id vnopol查询？

Answer 1

尝试将查询更改为：

String queryString = "from ahmdsmts_mstmotor where VNOPOL = :id";