代码如下
public boolean doRemove(Integer id) throws Exception { try { Statement statement = getHibernateTemplate().getSessionFactory().openStatelessSession().connection()
.createStatement();
String hql = " delete from messageelementlink where messageid='" + id + "' and pervMessageId='" + id + "'";
statement.execute(hql);
hql = " delete from Messageelement where messageid='" + id + "' ";
statement.execute(hql);
hql = " delete from messagegroup where messageid='" + id + "' ";
statement.execute(hql);
hql = " delete from Message where id='" + id + "' ";
statement.execute(hql); } catch (Exception e) {
System.out.print(e.getMessage());
} // super.getHibernateTemplate().delete(findById(id));
return true;
}
hql = " delete from Messageelement where messageid='" + id + "' ";
hql = " delete from Message where id='" + id + "' ";
这两条语句from后面跟的是类名hql = " delete from messagegroup where messageid='" + id + "' ";
这条from后面跟的应该是表名 ,
不是说hql的from后面跟类名么 到底是怎么回事?
public boolean doRemove(Integer id) throws Exception { try { Statement statement = getHibernateTemplate().getSessionFactory().openStatelessSession().connection()
.createStatement();
String hql = " delete from messageelementlink where messageid='" + id + "' and pervMessageId='" + id + "'";
statement.execute(hql);
hql = " delete from Messageelement where messageid='" + id + "' ";
statement.execute(hql);
hql = " delete from messagegroup where messageid='" + id + "' ";
statement.execute(hql);
hql = " delete from Message where id='" + id + "' ";
statement.execute(hql); } catch (Exception e) {
System.out.print(e.getMessage());
} // super.getHibernateTemplate().delete(findById(id));
return true;
}
hql = " delete from Messageelement where messageid='" + id + "' ";
hql = " delete from Message where id='" + id + "' ";
这两条语句from后面跟的是类名hql = " delete from messagegroup where messageid='" + id + "' ";
这条from后面跟的应该是表名 ,
不是说hql的from后面跟类名么 到底是怎么回事?
解决方案 »
- 建立mysql集群时,选择簇,还是heartbeat的方式?谁能帮忙介绍一下两种到底用在什么情况中吗?
- java 使用ipv6地址连接linux 下的mysql 连接字符串怎么写?
- MySQL动态创建临时表后,每次查询得到的都是前一次的字段!
- Mysql查询删除重复记录,保留最新记录
- 版本问题
- 哪里可以下载java连接mysql的驱动程序??
- linux下的MyODBC怎么用?
- mysql索引及临时表的问题.请大侠们帮忙.
- 同步的时候,mysql,information_schema等不被同步吧?
- 上海一氏软件科技有限公司,急切诚聘网络游戏服务器段设计程序员
- 求教MYSQL数据库SQL语句查询问题
- 相册图片数据库设计求助
应该是类名吧,虽然也可以写成sql,但是应该不会有混用的