hibernate4使用本地sql查询和删除

    public List<MMSTable> listAll(Map<Object, String> map, int pn, int pageSize)  
            throws Exception  
        {  
            // 定义StringBuffer对象，拼装sql语句  
            StringBuffer sb = new StringBuffer();  
            sb.append("select m.* from MMSTable as m ");  
            if (!Global.isEmpty(map.get("mmsReceNo")))  
            {  
                sb.append(" inner join ReceiptNoInfo as r on m.msgId = r.msgId");  
            }  
            sb.append(" where 1=1 ");  
            if (!Global.isEmpty(map.get("mmsSubject")))  
            {  
                sb.append("and m.mmsSubject = '" + map.get("mmsSubject") + "'");  
            }  
            if (!Global.isEmpty(map.get("startMmsDate")))  
            {  
                sb.append("and m.mmsDate >= '" + map.get("startMmsDate") + "'");  
            }  
            if (!Global.isEmpty(map.get("endMmsDate")))  
            {  
                sb.append("and m.mmsDate <= '" + map.get("endMmsDate") + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsOrigNo")))  
            {  
                sb.append("and m.mmsOrigNo = '" + map.get("mmsOrigNo") + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsReceNo")))  
            {  
                sb.append(" and r.mmsReceNo like '" + map.get("mmsReceNo") + '%' + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsStatus")))  
            {  
                sb.append("and m.mmsStatus = '" + map.get("mmsStatus") + "'");  
            }  
            sb.append("order by m.mmsDate DESC");  
              
            // 获取本地sql语句对象  
            SQLQuery query = getSession().createSQLQuery(sb.toString());  
              
            // 设置将SQL表的别名和实体类联系起来  
            query.addEntity(MMSTable.class);  
              
            // 分页代码  
            if (pn > -1 && pageSize > -1)  
            {  
                query.setMaxResults(pageSize);  
                int start = pn;  
                if (start != 0)  
                {  
                    query.setFirstResult(start);  
                }  
            }  
              
            // 执行查询方法，返回结果  
            List<MMSTable> mmsList = query.list();  
              
            // 返回执行结果  
            return mmsList;  
        }  
          
        /** 
         * {@inheritDoc} 
         */  
        @Override  
        public int countAll(Map<Object, String> map)  
            throws Exception  
        {  
            // 定义StringBuffer对象，拼装sql语句  
            StringBuffer sb = new StringBuffer();  
            sb.append("select count(*) from MMSTable as m ");  
              
            // 如果接受电话号码存在则做内连接  
            if (!Global.isEmpty(map.get("mmsReceNo")))  
            {  
                sb.append(" inner join ReceiptNoInfo as r on m.msgId = r.msgId");  
            }  
            sb.append(" where 1=1 ");  
            if (!Global.isEmpty(map.get("mmsSubject")))  
            {  
                sb.append("and m.mmsSubject = '" + map.get("mmsSubject") + "'");  
            }  
            if (!Global.isEmpty(map.get("startMmsDate")))  
            {  
                sb.append("and m.mmsDate >= '" + map.get("startMmsDate") + "'");  
            }  
            if (!Global.isEmpty(map.get("endMmsDate")))  
            {  
                sb.append("and m.mmsDate <= '" + map.get("endMmsDate") + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsOrigNo")))  
            {  
                sb.append("and m.mmsOrigNo = '" + map.get("mmsOrigNo") + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsReceNo")))  
            {  
                sb.append(" and r.mmsReceNo like '" + map.get("mmsReceNo") + '%' + "'");  
            }  
            if (!Global.isEmpty(map.get("mmsStatus")))  
            {  
                sb.append("and m.mmsStatus = '" + map.get("mmsStatus") + "'");  
            }  
              
            // 获取本地sql语句对象  
            SQLQuery query = getSession().createSQLQuery(sb.toString());  
              
            // 执行查询方法，返回结果  
            Integer count = Integer.valueOf(query.uniqueResult().toString());  
            return count;  
        }      public List<MMSTable> listAll(Map<Object, S