如何在Hibernate中创建INSERT IGNORE查询? [英] How to create an INSERT IGNORE query in Hibernate?

问题描述

Hibernate必须在具有唯一字段的表中插入.我想忽略重复的条目，以便我的程序继续运行.在MySQL中，我只说INSERT IGNORE，但是我不知道如何在Hibernate中做到这一点.有什么建议?谢谢！

Hibernate has to make inserts in a table which has an unique field. I want to ignore duplicate entries so that my program keeps running. In MySQL I would simply say INSERT IGNORE, but I can't figure out how to do that in Hibernate. Any suggestions? Thanks!

推荐答案

如果您使用的是简单的SQL查询， 使用以下代码.

if you are using a simple SQL query, use following code.

               Query query = session.createSQLQuery("INSERT IGNORE INTO user (name,username) VALUES (:name,:username)");
               query.setParameter("name", name);
               query.setParameter("username", username);
               int i= query.executeUpdate();

这篇关于如何在Hibernate中创建INSERT IGNORE查询?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！