hibernate的增删改查

hibernate.cfg.xml文件

<?xml version="1.0" encoding="utf-8"?> org.hibernate.dialect.MySQLDialect com.mysql.jdbc.Driver jdbc:mysql://localhost/test?serverTimezone=GMT%2B8 root 933032 **Empolyee.htm.xml文件***斜体样式***** <?xml version="1.0" encoding="utf-8"?> This class contains the employee detail.
  <property name="firstName" column="first_name" type="string"/>
  <property name="lastName" column="last_name" type="string"/>
  <property name="salary" column="salary" type="int"/>
**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;
}

public int getId() {
	return id;
}

public void setId(int id) {
	this.id = id;
}

public String getFirstName() {
	return firstName;
}

public void setFirstName(String first_name) {
	this.firstName = first_name;
}

public String getLastName() {
	return lastName;
}

public void setLastName(String last_name) {
	this.lastName = last_name;
}

public int getSalary() {
	return salary;
}

public void setSalary(int salary) {
	this.salary = salary;
}

}
增删改查
import java.io.File;
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;

public class ManageEmployee {
private static SessionFactory factory;
public static void main(String[] args) {
try {
// factory = new Configuration().configure(new
// File(HibernateDemo/src/hibernate.cfg.xml")).buildSessionFactory();"
factory = new Configuration().configure(new File(“hibernate.cfg.xml”)).buildSessionFactory();
} catch (Throwable ex) {
System.err.println(“Failed to create sessionFactory object.” + ex);
throw new ExceptionInInitializerError(ex);
}
ManageEmployee ME = new ManageEmployee();
/* Add few employee records in database */
Object empID1 = ME.addEmployee(“Zara”, “Ali”, 1000);
Object empID2 = ME.addEmployee(“Daisy”, “Das”, 5000);
Object empID3 = ME.addEmployee(“John”, “Paul”, 10000);

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

	/* Update employee's records */
	ME.updateEmployee(empID1, 5000);

	/* Delete an employee from the database */
	ME.deleteEmployee(empID2);

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

/* Method to CREATE an employee in the database */
public Object addEmployee(String fname, String lname, int salary) {
	Session session = factory.openSession();
	Transaction tx = null;
	Object employeeID = null;
	try {
		tx = session.beginTransaction();
		Employee employee = new Employee(fname, lname, salary);
		employeeID = 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(Object empID1, int salary) {
	Session session = factory.openSession();
	Transaction tx = null;
	try {
		tx = session.beginTransaction();
		Employee employee = (Employee) session.get(Employee.class, empID1);
		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(Object empID2) {
	Session session = factory.openSession();
	Transaction tx = null;
	try {
		tx = session.beginTransaction();
		Employee employee = (Employee) session.get(Employee.class, empID2);
		session.delete(employee);
		tx.commit();
	} catch (HibernateException e) {
		if (tx != null)
			tx.rollback();
		e.printStackTrace();
	} finally {
		session.close();
	}
}

}
数据库表的结构

在这里插入图片描述
导入大量的hibernate的jar包
在这里插入图片描述
eclispe输出的结果??

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值