两个.hibernate 和 flex的小问题-优快云博客

本文链接：https://blog.youkuaiyun.com/deeplyloving/article/details/83647990

本文探讨了使用Hibernate框架执行SQL查询时出现的“OPERATOR_ID column not found”错误，并提供了修正后的SQL语句及调用方法。同时介绍了如何在Flex中限制TextInput组件的输入。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

hibernate

用回调函数执行此语句报 OPERATOR_ID column not found 但是打出来的sql放数据库是可以执行的

                sql = "SELECT so.id AS id FROM system_operator AS so LEFT JOIN system_operator_permission AS sop ON so.id = sop.operator_id LEFT JOIN system_permission AS sp ON sp.id = sop.PERMISSION_ID " +
                        "LEFT JOIN system_permission_resources AS spr ON spr.PERMISSION_ID = sp.id " +
                        "LEFT JOIN system_resources AS sr ON sr.id = spr.RESOURCES_ID " +
                        "WHERE sr.code = '"+method+"' AND sr.path = '"+path+"'

public <T> List<T> getListBySQL(final String sql) {
        return (List<T>) this.getHibernateTemplate().execute(
                new HibernateCallback() {
                    public Object doInHibernate(Session session)
                            throws HibernateException, SQLException {
                        SQLQuery q = session.createSQLQuery(sql);
                        List<T> list = q.list();
                        return list;
                    }
                });
    }

删除红色as id 正确 hibernate说如果用别名 SQLQuery 等指定

sql = "SELECT so.id FROM system_operator AS so LEFT JOIN system_operator_permission AS sop ON so.id = sop.operator_id LEFT JOIN system_permission AS sp ON sp.id = sop.PERMISSION_ID " +
                        "LEFT JOIN system_permission_resources AS spr ON spr.PERMISSION_ID = sp.id " +
                        "LEFT JOIN system_resources AS sr ON sr.id = spr.RESOURCES_ID " +
                        "WHERE sr.code = '"+method+"' AND sr.path = '"+path+"'

二.flex textinput 限制双引号输入

方法将双引号转成unicode码

<mx:TextInput restrict="^\＂\""/>