20/07/2019, 10:12
Ví dụ Hibernate 3 Annotation Mapping – SQLServer 2017
Java This example apply following technologies: Eclipse Oxygen 4.7 SQLServer 2017 Express JDK 1.8 Hibernate 3.6.3 Nội dung chính: Hibernate 3 Annotation Mapping Project Structure Create Hibernate 3 Annotation Mapping – SQLServer 2017 Example ...
Java
This example apply following technologies:
- Eclipse Oxygen 4.7
- SQLServer 2017 Express
- JDK 1.8
- Hibernate 3.6.3
Nội dung chính:
- Hibernate 3 Annotation Mapping Project Structure
- Create Hibernate 3 Annotation Mapping – SQLServer 2017 Example
- 1. Create project “hibernate3-annotation-example2”
- 2. Create table testdb.Employee
- 3. Create hibernate annotation mapping class
- 4. Create hibernate configuration file
- 5. Create application class
Hibernate 3 Annotation Mapping Project Structure
Create Hibernate 3 Annotation Mapping – SQLServer 2017 Example
1. Create project “hibernate3-annotation-example2”
You can refer to tutorial how to create maven project in Eclipse?.
Update pom.xml file:
<dependencies>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>3.6.3.Final</version>
</dependency>
<dependency>
<groupId>javassist</groupId>
<artifactId>javassist</artifactId>
<version>3.12.1.GA</version>
</dependency>
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>6.1.0.jre8</version>
</dependency>
</dependencies>
2. Create table testdb.Employee
Use testdb; create table EMPLOYEE ( id INT NOT NULL IDENTITY(1,1), first_name VARCHAR(20) default NULL, last_name VARCHAR(20) default NULL, salary INT default NULL, PRIMARY KEY (id) );
3. Create hibernate annotation mapping class
Create Employee.java as a annotation mapping class.
File: Employee.java
package com.realtut.entity;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;
/**
* Employee generated by hbm2java
*/
@Entity
@Table(name = "employee")
public class Employee implements java.io.Serializable {
private Integer id;
private String firstName;
private String lastName;
private Integer salary;
public Employee() {
}
public Employee(String firstName, String lastName, Integer salary) {
this.firstName = firstName;
this.lastName = lastName;
this.salary = salary;
}
@Id
@GeneratedValue(strategy = IDENTITY)
@Column(name = "id", unique = true, nullable = false)
public Integer getId() {
return this.id;
}
public void setId(Integer id) {
this.id = id;
}
@Column(name = "first_name", length = 20)
public String getFirstName() {
return this.firstName;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
@Column(name = "last_name", length = 20)
public String getLastName() {
return this.lastName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
@Column(name = "salary")
public Integer getSalary() {
return this.salary;
}
public void setSalary(Integer salary) {
this.salary = salary;
}
}
4. Create hibernate configuration file
File: hibernate.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">
com.microsoft.sqlserver.jdbc.SQLServerDriver
</property>
<property name="hibernate.connection.url">
jdbc:sqlserver://localhost:1433;databaseName=testdb;
</property>
<property name="hibernate.connection.username">
sa
</property>
<property name="hibernate.connection.password">
1234567890
</property>
<property name="connection.pool_size">1</property>
<property name="hibernate.dialect">
org.hibernate.dialect.SQLServerDialect
</property>
<property name="show_sql">true</property>
<mapping class="com.realtut.entity.Employee" />
</session-factory>
</hibernate-configuration>
5. Create application class
Finally, we will create the application class to run by the main() method. There are some methods to perform CRUD operations (create, retrive, update, delete).
File: ManageEmployee.java
package com.realtut;
import java.util.Iterator;
import java.util.List;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import com.realtut.entity.Employee;
public class ManageEmployee {
private static SessionFactory factory;
public static void main(String[] args) {
// crate SessionFactory object
try {
factory = new Configuration().configure().buildSessionFactory();
} catch (Throwable ex) {
ex.printStackTrace();
}
// create manageEmployee object
ManageEmployee manageEmployee = new ManageEmployee();
// Add few employee records in database
Integer empID1 = manageEmployee.addEmployee("David", "Bishop", 1000);
Integer empID2 = manageEmployee.addEmployee("Chris", "Ali", 5000);
Integer empID3 = manageEmployee.addEmployee("John", "Vector", 10000);
// List down all the employees
System.out.println("List down all the employees:");
manageEmployee.listEmployees();
// Update employee's records
manageEmployee.updateEmployee(empID1, 5000);
// Delete an employee from the database
manageEmployee.deleteEmployee(empID2);
// List down new list of the employees
System.out.println("List down new list of the employees:");
manageEmployee.listEmployees();
}
// 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 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();
}
}
}
Output:
List down all the employees: First Name: David Last Name: Bishop Salary: 1000 First Name: Chris Last Name: Ali Salary: 5000 First Name: John Last Name: Vector Salary: 10000 List down new list of the employees: First Name: David Last Name: Bishop Salary: 5000 First Name: John Last Name: Vector Salary: 10000
Dowload Source Code
Download Now!
Java
