hibernate之基本操作(增，删，改，查)

[size=xx-small]1 编写配置文件 hibernate-cfg.xml[/size]
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- 方言 -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- 数据库连接 -->
<property name="connection.url">jdbc:mysql://localhost:3306/db_database14</property>
<!-- 数据库连接用户名 -->
<property name="connection.username">root</property>
<!-- 数据库连接密码 -->
<property name="connection.password">admin</property>
<!-- 数据库驱动 -->
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<!-- 打印SQL语句 -->
<property name="show_sql">true</property>

<property name="format_sql">true</property>

<!-- 映射文件 -->
<mapping resource="com/java0806/Medicine.hbm.xml" />
</session-factory>
</hibernate-configuration>


2 编写工具类 hibernateUtil.java

package com.java0806.util;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

/**
* Hibernate初始化类，用于获取Session、SessionFactory 及关闭Session
* @author Li Yong Qiang
*/
public class HibernateUtil {
// SessionFactory对象
private static SessionFactory factory = null;
// 静态块
static {
try {
// 加载Hibernate配置文件
Configuration cfg = new Configuration().configure();
// 实例化SessionFactory
factory = cfg.buildSessionFactory();
} catch (HibernateException e) {
e.printStackTrace();
}
}
/**
* 获取Session对象
* @return Session对象
*/
public static Session getSession() {
//如果SessionFacroty不为空，则开启Session
Session session = (factory != null) ? factory.openSession() : null;
return session;
}
/**
* 获取SessionFactory对象
* @return SessionFactory对象
*/
public static SessionFactory getSessionFactory() {
return factory;
}
/**
* 关闭Session
* @param session对象
*/
public static void closeSession(Session session) {
if (session != null) {
if (session.isOpen()) {
session.close(); // 关闭Session
}
}
}
}


3 编写实体类

package com.java0806;
/**
* 药品持久化类
* @author Li Yong Qiang
*/
public class Medicine {
private Integer id; //id号
private String name; //药品名称
private double price; //价格
private String factoryAdd; //出厂地址
private String Description; //描述
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public double getPrice() {
return price;
}
public void setPrice(double price) {
this.price = price;
}
public String getFactoryAdd() {
return factoryAdd;
}
public void setFactoryAdd(String factoryAdd) {
this.factoryAdd = factoryAdd;
}
public String getDescription() {
return Description;
}
public void setDescription(String description) {
Description = description;
}
}


4编写映射文件

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="com.lyq.model.Medicine" table="tb_medicine_select_get">
<id name="id">
<generator class="native"/>
</id>
<property name="name" not-null="true" length="200" />
<property name="price" not-null="true"/>
<property name="factoryAdd" length="200"/>
<property name="description" />
</class>
</hibernate-mapping>


5编写测试类


package com.lyq.util;

import org.hibernate.Session;

import com.lyq.model.Medicine;
/**
* 增，删，改，查
* @author Li Yong Qiang
*/
public class Update {
public static void main(String[] args) {
Session session = null; //声明Session对象
try {
//获取Session
session = HibernateUtil.getSession();
//开启事物
session.beginTransaction();
/*
// 删除
Medicine medicine=(Medicine) session.load(Medicine.class,new Integer(1));
session.delete(medicine);*/

/*//添加数据
//实例化药品对象，并对其属性赋值
Medicine medicine = new Medicine();
medicine.setId(2);
medicine.setName("xxx感冒药");
medicine.setPrice(102.00);
medicine.setFactoryAdd("制药一厂xxx");
medicine.setDescription("最新感冒药");
//保存药品对象
session.save(medicine);*/


/*
//两种查询方式
Medicine medicine = (Medicine)session.get(Medicine.class, new Integer(1));
Medicine medicine =(Medicine)session.load(Medicine.class,new Integer(1));
System.out.println("药品ID：" + medicine.getId());
System.out.println("药品名称：" + medicine.getName());*/

//自动修改
/*Medicine medicine = (Medicine)session.get(Medicine.class, new Integer(1));
medicine.setName("感冒胶囊"); //修改药品名称
medicine.setPrice(10.05);*/


//手动修改
/*Medicine medicine = new Medicine();
medicine.setId(1);
medicine.setName("感冒药xx");
medicine.setPrice(12.00);
medicine.setFactoryAdd("制药一厂");
medicine.setDescription("最新感冒药");
session.update(medicine);*/
//提交事物
session.getTransaction().commit();
} catch (Exception e) {
e.printStackTrace();
//出错将回滚事物
session.getTransaction().rollback();
}finally{
//关闭Session对象
HibernateUtil.closeSession(session);
}
}
}