In this post i explain how to insert data into MySQL database using Hibernate with the help of NetBeans IDE.
First you need to create a database and a table in the MySQL database. While creating the table keep in mind that, the table must contain a primary key field. I use the following query for create the table.
create table test_table (id int not null primary key auto_increment,name varchar(50), email varchar(50));
Ads by Google
Now you need to follow the steps given bellow.
Step 1 :
Open up the NetBeans IDE.
Step 2 :
Go to the services and expand the database.
Step 9 :
Create a form in your index.jsp as shown bellow.
Step 10:
Create a new servlet and add the following code segment in processRequest method as shown bellow.
Now run the index.jsp file and check data in your database table.
Now you need to follow the steps given bellow.
Step 1 :
Open up the NetBeans IDE.
Step 2 :
Go to the services and expand the database.
Step 3:
Now right click MySQL server and choose connect.
Step 4:
Now you need to enter your MySQL username and password and choose the database to which you want to insert data. Right click the database and choose connect.
Step 5:
Create a new Web Application and choose the hibernate framework and choose the database connection.
Step 6:
Right click the project name from the other option, choose Hibernate and from the hibernate folder choose the hibernate reverse engineering wizard.
Step 7:
Click next and choose the table / tables and click the add button and finally click finish.
Now you got your hibernate reverse engineering xml file.
Step 8:
Right click the project, choose other and from hibernate folder select the "Hibernate mapping files and POJOs" from database.
You need to provide a package name and click finish. Now you got your hibernate mapping xml file and the POJO class file as shown bellow.
Create a form in your index.jsp as shown bellow.
<form action="TestServlet">
Name :<input type="text" name="name"/>
Email :<input type="text" name="email" />
<input type="submit" value="SAVE" />
</form>
Step 10:
Create a new servlet and add the following code segment in processRequest method as shown bellow.
String name,email;
name = request.getParameter("name");
email = request.getParameter("email");
SessionFactory sf = new Configuration().configure().buildSessionFactory();
Session s = sf.openSession();
Transaction tr = s.beginTransaction();
TestTable t = new TestTable(name, email);
s.save(t);
tr.commit();
s.close();
Now run the index.jsp file and check data in your database table.
Watch Video Tutorial of this Topic