how can i delete records from database in hibernate with condition other than primary key [duplicate]

Question

Here is my code in dao layer..can anyone please help me to delete multiple records from database in the table mapped to SabbModelPrd using the condition equal to ("clientid", strClientId) which is not the primary key . Thanks in advance...

 public boolean deleteAllServices(String strClientId){
    boolean flag = false;
    try {
        Session session  = sessionFactory.getCurrentSession();
        SabbModelPrd sabbModelPrd = (SabbModelPrd) session.get(SabbModelPrd.class, strClientId);
        if (!StringUtils.isEmpty(sabbModelPrd)) {
            session.delete(sabbModelPrd);
            flag = true;
        }
    } catch (Exception e) {

    }
    return flag;
}

here its checking strClientId with the primary key product_id

Mohamed Nabli · Accepted Answer · 2015-11-29 17:26:43Z

0

 public boolean deleteAllServices(String strClientId){
    boolean flag = false;
    try {
        Session session  = sessionFactory.getCurrentSession();
        SabbModelPrd sabbModelPrd = (SabbModelPrd) session.createQuery("delete FROM SabbModelPrd where strClientId like'"+strClientId+"'");
flag= true;
    } catch (Exception e) {
return flag;
    }
    return flag;
}

I hope its gonna help you

answered Nov 29, 2015 at 17:26

Mohamed Nabli

1,6493 gold badges17 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tobias Liefke Over a year ago

While this code may answer the question, it would be better to explain how it solves the problem and why to use it. Code-only answers are not useful in the long run.

Mohamed Nabli Over a year ago

the get method gives you a list of the class you give as a param (SabbModelPrd.class in your case) and insteadof getting a list of object and remove from this list it better to use sql and remove directly from database

Tobias Liefke Over a year ago

Here on Stackoverflow you can always edit your posts to improve them. And punctuation matters.

Collectives™ on Stack Overflow

how can i delete records from database in hibernate with condition other than primary key [duplicate]

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related