Hibernate hql插入失败!
Session session = HibernateSessionFactory.getSession();
Transaction tx = session.beginTransaction();
String hqlInsert = "INSERT INTO " + table + colItemString
+ " VALUES " + whereString;
int deletedEntities = session.createQuery(hqlInsert)
.executeUpdate();
tx.commit();
// hqlInsert = INSERT INTO admin(Id,userName,userPwd,nowdate) VALUES (11,'111','111','2008-02-12')
在mysql 里面运行正常,可以在程序中报错。
错误如下:
unexpected token: VALUES near line 1, column 48 [INSERT INTO admin(Id,userName,userPwd,nowdate) VALUES ('11','111','111','2008-02-12')]
其他的select,delete,update语句没有问题。帮忙看看什么原因?