Create Hibernate Project in Netbeans

Hibernate CRUD Project in Netbeans IDE

In this article I explained about How to create Hibernate project in Netbeans and here I showed simple hibernate project in detailed code.

Here I have created a registration form and servlet to insert data into database, and same as I done operations retrieve, update, and delete.

Read also: 

Develop Hibernate CRUD project in Eclipse IDE

Steps to create hibernate project in netbeans with screenshots

index.jsp

<form action="Register" method="post">

        <table>

            <tr><td>Employee Id :</td>

                <td><input type="text" name="eid" value=""/></td></tr>

            <tr><td>Employee Name :</td>

                <td><input type="text" name="ename" value="" /></td></tr>

            <tr><td>Employee Salary :</td>

                <td><input type="text" name="esal" value=""/></td></tr>

            <tr><td>Employee Address :</td>

                <td><textarea name="eadd">

                    </textarea></td></tr>

            <tr><td></td><td><input type="submit" value="Register" /></td></tr>

        </table>

        </form>

Register.java

 try {

         String empid,empname,empsal,empadd;

         empid=request.getParameter("eid");

         empname=request.getParameter("ename");      

         empsal=request.getParameter("esal");

         double sal=Double.parseDouble(empsal);

         empadd=request.getParameter("eadd");

        

         org.hibernate.SessionFactory sf=new org.hibernate.cfg.Configuration().configure().

         buildSessionFactory();

         org.hibernate.Session se=sf.openSession();

         org.hibernate.Transaction tr=se.beginTransaction();

         packcompany.Employee pe=new packcompany.Employee();        

         pe.setEmpid(empid);

         pe.setEmpname(empname);

         pe.setEmpsal(sal);

         pe.setEmpadd(empadd);

         se.save(pe);

         tr.commit();        

         RequestDispatcher rd=request.getRequestDispatcher("details.jsp");

         rd.forward(request, response);         

        } finally {           

            out.close();

        }

display.jsp

 <h1><a href="index.jsp">Click Here to Register</a></h1><br>       

        <%

        org.hibernate.SessionFactory sf=new org.hibernate.cfg.Configuration().configure().

        buildSessionFactory();

        org.hibernate.Session se=sf.openSession();

        org.hibernate.Transaction tr=se.beginTransaction();

        org.hibernate.Query q=se.createQuery("from Employee");

        java.util.ArrayList al=new java.util.ArrayList();

        al=(java.util.ArrayList)q.list();

        Iterator i=q.iterate();

        packcompany.Employee pe=new packcompany.Employee();

       

        %>

       

        <table border="1">

            <thead>   <tr>

                    <th>Employee Id</th>

                    <th>Employee Name</th>

                    <th>Employee Salary</th>

                    <th>Employee Address</th>

                    <th>Edit</th>

                    <th>Delete</th>         </tr>

            </thead>   <tbody>

                <%

                while(i.hasNext()){

                    pe=(packcompany.Employee)i.next();                 

                %>

                <tr><td><%=pe.getEmpid()%></td>

                    <td><%=pe.getEmpname()%></td>

                    <td><%=pe.getEmpsal()%></td>

                    <td><%=pe.getEmpadd()%></td>

                    <td><a href="edit.jsp?empid=<%=pe.getEmpid()%>">Edit</a></td>

                    <td><a href="delete.jsp?empid=<%=pe.getEmpid()%>">Delete</td>

                </tr>      </tbody>

             <%      }       %>       </table>

 edit.jsp

<%

        String empid=request.getParameter("empid");

org.hibernate.SessionFactory sf=new org.hibernate.cfg.Configuration().configure().

buildSessionFactory();

org.hibernate.Session se=sf.openSession();

org.hibernate.Transaction tr=se.beginTransaction();

org.hibernate.Query q=se.createQuery("from Employee where empid=:empid");

q.setParameter("empid",empid);

java.util.ArrayList al=new java.util.ArrayList();

al=(java.util.ArrayList)q.list();

Iterator i=al.iterator();

packcompany.Employee pe=new packcompany.Employee(); 

while(i.hasNext())

{

    pe=(packcompany.Employee)i.next();

    pe.getEmpid();

    pe.getEmpname();

    pe.getEmpsal();

    pe.getEmpadd();

}    %>

        <form action="Update" method="post"> 

        <table>     <tbody>

                <tr>

                    <td>Employee Id : </td><td><input type="text" name="empid" value="

                                                                          <%=pe.getEmpid()%>" readonly=""/></td>

                </tr>

                <tr>

                    <td>Employee Name :</td><td> <input type="text" name="empname" value="

                                                                                <%=pe.getEmpname()%>" /></td>

                </tr>          <tr>

                    <td>Employee Salary :</td><td> <input type="text" name="empsal" value="

                                                                                     <%=pe.getEmpsal()%>" /></td>

                </tr>          <tr>

                    <td>Employee Address :</td><td> <input type="text" name="empadd" value="

                                                                                      <%=pe.getEmpadd()%>" /></td> 

                </tr>

                <tr>              <td></td><td><input type="submit" value="update" /></td>

                </tr>    </tbody>        </table> 

</form>

   Update.java

  try {                  

        String empid,empname,empsal,empadd;

        empid=request.getParameter("empid");

        empname=request.getParameter("empname");

        empsal=request.getParameter("empsal");

        empadd=request.getParameter("empadd");       

        org.hibernate.SessionFactory sf=new org.hibernate.cfg.Configuration().configure().

        buildSessionFactory();

        org.hibernate.Session se=sf.openSession();

        org.hibernate.Transaction tr=se.beginTransaction();

        org.hibernate.Query q=se.createQuery("update Employee set empname=:empname,

        empsal=:empsal,empadd=:empadd where empid=:empid");       

        q.setParameter("empid", empid);

        q.setParameter("empname", empname);

        double sal=Double.parseDouble(empsal);

        q.setParameter("empsal",sal);

        q.setParameter("empadd", empadd);

        int i=q.executeUpdate();       

        tr.commit();

        if(i>0){

      response.sendRedirect("details.jsp?msg=updated");

  }

   else{

      response.sendRedirect("details.jsp?msg=try again");

   } 

        }

        catch(Exception e){

    out.println(e);

}

        finally {           

            out.close();

        }

delete.jsp

        <%

        String empid=request.getParameter("empid");

org.hibernate.SessionFactory sf=new org.hibernate.cfg.Configuration().configure().buildSessionFactory();

org.hibernate.Session se=sf.openSession();

org.hibernate.Transaction tr=se.beginTransaction(); 

org.hibernate.Query q=se.createQuery("delete Employee where empid=:empid"); 

q.setParameter("empid",empid);

int i=q.executeUpdate();

tr.commit();

if(i>0){

    response.sendRedirect("details.jsp?msg=successfuly deleted");

}

else{

   response.sendRedirect("details.jsp?msg=try again"); 

}

%>