Insert data into table using Hibernate

Question

I'm new to Hibernate. I want to insert data into this hibernate entity:

@Entity
public class Invitation implements Serializable
{
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(name = "invited_on")
    @Temporal(TemporalType.TIMESTAMP)
    private Date invitedOn;

    @Column(name = "invited_email")
    private String invitedEmail;

    @Column(name = "invitation_msg")
    private String invitationMessage;

    private Boolean status; //true:accepted || false:pending

    @ManyToOne
    @JoinColumn(name = "sent_by")
    private Person inviter;

// getters and setters
}

I tested this code:

public void insert()
{
    Query query = session.createQuery("insert into Invitation(invited_on, invited_email, invitation_msg, sent_by)");
    int result = query.executeUpdate();
}

What is the proper way to insert data? How I should create session Object?

hi Peter, I suggest you to read more documents from hibernate. You need more stuff, like gettting sessionFactory, define transactions, define database connection,.... get a basic example from internet. — duardito
– duardito, Commented Aug 4, 2016 at 14:04

Timetrax · Accepted Answer · 2020-01-12 05:03:15Z

2

use this in the main class it works to insert data into table:

    Users user = new Users();
    user.setUid(1);
    user.setUfname("firstname");
    user.setUlname("Lastname");

    Configuration config = new Configuration()
       .configure()
       .addAnnotatedClass(Users.class);

    ServiceRegistry reg = new ServiceRegistryBuilder()
       .applySettings(config.getProperties())
       .buildServiceRegistry();

    SessionFactory sf = config.buildSessionFactory(reg);
    Session session = sf.openSession();

    Transaction tx = session.beginTransaction();
    session.save(user);

    tx.commit();

edited Jan 12, 2020 at 5:03

Timetrax

1,56315 silver badges17 bronze badges

answered Jan 31, 2018 at 8:43

BOUZAR

1611 silver badge4 bronze badges

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

Comments

Snackoverflow · Accepted Answer · 2017-08-14 16:00:47Z

1

You have Hibernate and it's tools USE THEM!!!

DISCLAIMER:

Example took from HERE
code written on the fly!!
I didnt use status attribute because is not mapped!

// don't need if you already got a session
Session session = HibernateUtil.getSessionFactory().openSession();

// start transaction
session.beginTransaction();

// create invitation Object
Invitation inv = new Invitation();
inv.setId(1L);
inv.setInvitedOn(new java.util.Date());
inv.setInvitedEmail("[email protected]");
inv.setInvitationMessage("come on!!!");
inv.setInviter(new Person("inviter"));  // hey! this is not valid for sure! :)

// Save the invitation to database
session.save(inv);

// Commit the transaction
session.getTransaction().commit();

edited Aug 14, 2017 at 16:00

Snackoverflow

6,35110 gold badges45 silver badges76 bronze badges

answered Aug 4, 2016 at 14:07

Jordi Castilla

27.1k8 gold badges73 silver badges113 bronze badges

Collectives™ on Stack Overflow

Insert data into table using Hibernate

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related