<?xml version="1.0" encoding="GBK"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="ext.eclipse.ide.auth.role.impl.UserImpl" table="Users">
        <id name="id">
            <column name="UID" length="15" />
        </id>
        <property name="name">
            <column name="NAME" length="20" />
        </property>
        <property name="password">
            <column name="PASSWORD" length="64" />
        </property>
        <set name="roles" table="User_Role" cascade="all-delete-orphan" fetch="join">
            <key column="USER_ID"></key>
            <many-to-many class="ext.eclipse.auth.role.impl.RoleImpl"
                column="ROLE_ID"></many-to-many>
        </set>
    </class>
</hibernate-mapping>

    public List<?> query(String hql) {
        Session session = getSessionFactory().getCurrentSession();

        session.beginTransaction();
        Query query = null;
        try {
            query = session.createQuery(hql);
        } catch (Exception e) {
            e.printStackTrace();
        }
        List<?> result = query == null ? new ArrayList<Object>() : query.list();
        session.getTransaction().commit();

        return result;
    }