hibernate maven web servlet

/*********************************************************
Hibernate configuration  files:
hibernate-oracle.cfg.xml
/*********************************************************

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
       <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
                  <property name="hibernate.connection.url">jdbc:oracle:thin:@127.0.0.1:1521:xe</property>
                  <property name="hibernate.connection.username">system</property>
                  <property name="hibernate.connection.password">andrzej</property>
                  <property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>
                  <property name="hibernate.default_schema">SYSTEM</property>
                 <property name="show_sql">true</property>
        <!-- List of XML mapping files -->
        <mapping class="app2.Employee"/>
    </session-factory>
</hibernate-configuration>


/*********************************************************
Hibernate configuration  files:
hibernate-mysql.cfg.xml

/*********************************************************

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-configuration SYSTEM
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.dialect"> org.hibernate.dialect.MySQLDialect </property>
        <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
        <!-- Assume test is the database name -->
        <property name="hibernate.connection.url"> jdbc:mysql://localhost:3306/test </property>
        <property name="hibernate.connection.username"> root </property>
        <property name="hibernate.connection.password"> andrzej </property>
        <!-- List of XML mapping files -->
        <mapping resource="Employee.hbm.xml"/>
    </session-factory>
</hibernate-configuration>


/*********************************************************
Reading hibernate configuration files from Java source code:

/*********************************************************

package app2;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import java.util.List;
import java.util.Date;
import java.util.Iterator;

import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.SQLQuery;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;

import java.util.*;
import java.util.logging.Level;

public class apps2 {
                private static SessionFactory factory;

                public static void main(String[] args)
                {

                               try{
                                               //factory = new Configuration().configure().buildSessionFactory();
                                               Configuration cfg1 = new AnnotationConfiguration();
                                               //cfg1.configure("/hibernate-mysql.cfg.xml");
                                               cfg1.configure("/hibernate-oracle.cfg.xml");
                                               factory = cfg1.buildSessionFactory();

                               }catch (Throwable ex)
                               {
                                               System.err.println("Failed to create sessionFactory object." + ex);
                                               throw new ExceptionInInitializerError(ex);
                               }
                               apps2 ME = new apps2();

                               /* Add few employee records in database */
                               Integer empID1 = ME.addEmployee("andrzej", "haslo", 100000);

                               //ME.listEmployeesScalar();
                               /* List down all the employees */
                               //ME.listEmployees();

                               /* Update employee's records */
                               //ME.updateEmployee(2, 20000);

                               /* Delete an employee from the database */

                               /*for (int i = 12; i <= 19; i++)
                                               ME.deleteEmployee(i);*/

                               /* List down new list of the employees */
                               //ME.listEmployees();

                               //System.out.println("Witaj");
                               /*Logger logger = LoggerFactory.getLogger(apps2.class);
                    logger.info("Logger Andrzej");*/

                }
                /* Method to CREATE an employee in the database */
                public Integer addEmployee(String fname, String lname, int        salary)
                {
                               Session session = factory.openSession();
                               Transaction tx = null;
                               Integer employeeID = null;
                               try{
                                               tx = session.beginTransaction();
                                               Employee employee = new Employee(fname, lname, salary);
                                               employeeID = (Integer) session.save(employee);
                                               tx.commit();
                               }catch (HibernateException e)
                               {
                                               if (tx!=null)
                                                               tx.rollback();
                                               e.printStackTrace();
                               }finally
                               {
                                               session.close();
                               }
                               return employeeID;
                }
                /* Method to READ all the employees */
                public void listEmployees( )
                {
                               Session session = factory.openSession();
                               Transaction tx = null;
                               try{
                                               tx = session.beginTransaction();
                                               List employees = session.createQuery("FROM Employee").list();
                                               for (Iterator iterator = employees.iterator(); iterator.hasNext();)
                                               {
                                                               Employee employee = (Employee) iterator.next();
                                                               //System.out.print("First Name: " + employee.getFirstName());
                                                               System.out.print(" Last Name: " + employee.getLastName());
                                                               //System.out.println(" Salary: " + employee.getSalary());
                                                               }
                                               tx.commit();
                                               }catch (HibernateException e)
                                               {
                                                               if (tx!=null) tx.rollback();
                                                               e.printStackTrace();
                                               }finally
                                               {
                                                               session.close();
                                               }
                               }

                /* Method to READ all the employees using Scalar Query */
                public void listEmployeesScalar( )
                {
                               Session session = factory.openSession();
                               Transaction tx = null;
                               try{
                                               tx = session.beginTransaction();
                                               String sql = "SELECT first_name, salary FROM EMPLOYEE";
                                               SQLQuery query = session.createSQLQuery(sql);
                                               query.setResultTransformer(Criteria.ALIAS_TO_ENTITY_MAP);
                                               List data = query.list();
                                               for(Object object : data)
                                               {
                                                               Map row = (Map)object;
                                                               System.out.print("First Name: " + row.get("first_name"));
                                                               System.out.println(", Salary: " + row.get("salary"));
                                               }
                                               tx.commit();
                               }catch (HibernateException e)
                               {
                                               if (tx!=null)
                                                               tx.rollback();
                                               e.printStackTrace();
                               }finally {
                                               session.close();
                               }
                }

                /* Method to UPDATE salary for an employee */
                public void updateEmployee(Integer EmployeeID, int salary )
                {
                               Session session = factory.openSession();
                               Transaction tx = null;
                               try{
                                               tx = session.beginTransaction();
                                               Employee employee = (Employee)session.get(Employee.class, EmployeeID);
                                               employee.setSalary( salary );
                                               session.update(employee);
                                               tx.commit();
                               }catch (HibernateException e)
                               {
                                               if (tx!=null) tx.rollback();
                                               e.printStackTrace();
                               }finally
                               {
                                               session.close();
                               }
                }
                /* Method to DELETE an employee from the records */
                public void deleteEmployee(Integer EmployeeID)
                {
                               Session session = factory.openSession();
                               Transaction tx = null;
                               try{
                                               tx = session.beginTransaction();
                                               Employee employee = (Employee)session.get(Employee.class, EmployeeID);
                                               session.delete(employee);
                                               tx.commit();
                               }catch (HibernateException e)
                               {
                                               if (tx!=null)
                                                               tx.rollback();
                                               e.printStackTrace();
                               }finally
                               {
                                               session.close();
                                               }
                               }

}


/*********************************************************
Hibernate Mapping POJO class:

/*********************************************************

package app2;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.GenericGenerator;


@Entity
@Table(name = "Employee")
public class Employee {
                private int id;
                private String firstName;
                private String lastName;
                private int salary;


                public Employee() {}
                public Employee(String fname, String lname, int salary)
                {
                               this.firstName = fname;
                               this.lastName = lname;
                               this.salary = salary;
                }
                @Id
                @GenericGenerator(name="kaugen" , strategy="increment")
                @GeneratedValue(generator="kaugen")
                public int getId()
                {
                               return id;
                }
                public void setId( int id )
                {
                               this.id = id;
                }
                @Column(name = "first_name")
                public String getFirstName()
                {
                               return firstName;
                }
                public void setFirstName( String first_name )
                {
                               this.firstName = first_name;
                }
                @Column(name = "last_name")
                public String getLastName()
                {
                               return lastName;
                }
                public void setLastName( String last_name )
                {
                               this.lastName = last_name;
                }
                @Column(name = "salary")
                public int getSalary()
                {
                               return salary;
                }
                public void setSalary( int salary )
                {
                               this.salary = salary;
                }

}

/********************************************
POM.xml
/********************************************
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.mycompany.app</groupId>
  <artifactId>my-app</artifactId>
  <packaging>jar</packaging>
  <version>1.0-SNAPSHOT</version>
  <name>my-app</name>
  <url>http://maven.apache.org</url>
  <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>3.8.1</version>
      <scope>test</scope>
    </dependency>
               <dependency>
                               <groupId>org.hibernate</groupId>
                               <artifactId>hibernate-core</artifactId>
                               <version>5.0.1.Final</version>
                </dependency>
                <dependency>
                               <groupId>org.hibernate</groupId>
                               <artifactId>hibernate-annotations</artifactId>
                               <version>3.5.6-Final</version>
                </dependency>

  </dependencies>
</project>


/********************************************
FirstServlet.java
/********************************************

package webservlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/WitajSwiecie1")
public class FirstServlet extends HttpServlet{


                protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
                               PrintWriter out = response.getWriter();
        out.println("Welcome !!");
        RequestDispatcher RequetsDispatcherObj =request.getRequestDispatcher("/index.html");
        RequetsDispatcherObj.forward(request, response);

                }
}



/********************************************
Index.html
/********************************************
<html>
    <head>
                               <link rel="stylesheet" type="text/css" href="style.css">
                </head>

    <body>
    <h1>Welcome</h1>
    <br/>
    <form action="odpowiedz.jsp" method="GET">
         <b>Imie: </b><input type="text" name="first_name">
    <br />
         <b>Nazwisko: </b><input type="text" name="last_name" />
    <br />
    <input type="submit" value="Submit" />
    <input type="checkbox" name="a" checked="checked" /> A
    <input type="checkbox" name="b"  /> B
    <input type="checkbox" name="c" checked="checked" /> C
    </form>
    </body>
</html>


/********************************************
Pom.xml (for Maven)
/********************************************
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>co.uk.tedo</groupId>
  <artifactId>firstwebservlet</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
    <dependencies>
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.0</version>
      <type>jar</type>
      <scope>test</scope>
      <optional>true</optional>
    </dependency>
    <dependency>
                               <groupId>javax.servlet</groupId>
                               <artifactId>javax.servlet-api</artifactId>
                               <version>3.1.0</version>
                </dependency>

  </dependencies>
</project>

/********************************************
Style.css file
/********************************************

b {
    font-weight: bold;
    color: #7F462C;
}

body {
    font-family: Verdana, Arial, sans-serif;
    font-size: smaller;
    padding: 50px;
    color: #555;
    background-color: #b0c4de;
}

h1 {
    text-align: left;
    letter-spacing: 6px;
    font-size: 1.4em;
    color: #be7429;
    font-weight: normal;
    width: 450px;
}

table {
    width: 580px;
    padding: 10px;
    background-color: #c5e7e0;
}

th {
    text-align: left;
    border-bottom: 1px solid;
}

td {
    padding: 10px;
}

a:link {
   color: #be7429;
   font-weight: normal;
   text-decoration: none;
}

a:link:hover {
   color: #be7429;
   font-weight: normal;
   text-decoration: underline;
}

/********************************************
Web.xml file
/********************************************

<?xml version="1.0" encoding="ISO-8859-1" ?>

<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
    version="2.4">

    <display-name>webservlet1</display-name>
</web-app>


/********************************************