操_干_Hibernate
操_作_Hibernate
hibernate.cfg.xml --数据库配置文件
<?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.OracleDialect</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">scott</property>
<property name="connection.password">xbliuc</property>
<property name="hbm2ddl.auto">create</property>
<property name="show_sql">true</property>
<mapping resource="com/rt/xbliuc/test/UserInfo.hbm.xml" />
</session-factory>
</hibernate-configuration>
---------------------------------------------------
实体类映射文件 UserInfo.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.rt.xbliuc.test">
<class name="UserInfo" table="UserInfos">
<id name="id">
<generator class="native"/>
</id>
<property name="name" unique="true" not-null="true"/>
<property name="sex"/>
<property name="address"/>
</class>
</hibernate-mapping>
---------------------------------------------------
获取Session对象的工具类
public final class HibernateUtil {
private HibernateUtil(){}
private static SessionFactory sessionFactory;
static{
//创建配置管理对象
Configuration config = new Configuration();
//加载配置文件(hibernate.cfg.xml)
config.configure();//加载默认路径下的配置文件
//config.configure(uri)手动指定配置文件路径
//构建SessionFactory
sessionFactory = config.buildSessionFactory();
}
public static Session getSession(){
//获取Session对象
return sessionFactory.openSession();
}
}
---------------------------------------------------
实体类
public class UserInfo {
private int id;
private String name;
private String sex;
private String address;
public UserInfo(){}
public UserInfo(String name, String sex, String address) {
this.name = name;
this.sex = sex;
this.address = address;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
---------------------------------------------------
操作工具类
public class UserInfoDaoImpl {
/**
* 通过Id获取一个对象
*
* @param id
* @return
*/
public static UserInfo getUserInfoById(int id) {
Session session = null;
UserInfo userInfo = null;
try {
session = HibernateUtil.getSession();
userInfo = (UserInfo) session.get(UserInfo.class, id);
System.out.println(userInfo.getName());
} finally {
if (session != null) {
session.close();
}
}
return userInfo;
}
public static UserInfo queryUserInfoByName(String name) {
Session session = null;
UserInfo userInfo = null;
try {
session = HibernateUtil.getSession();
String hql = "from UserInfo as userinfo where userinfo.name = :u_name";
Query query = session.createQuery(hql);
query.setParameter("u_name", name);
userInfo = (UserInfo) query.uniqueResult();
System.out.println(userInfo.getName());
} finally {
if (session != null) {
session.close();
}
}
return userInfo;
}
/**
* 删除数据
*/
public static void removeUserInfo(UserInfo userInfo) {
Session session = null;
try {
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.delete(userInfo);
transaction.commit();
} finally {
if (session != null) {
session.close();
}
}
}
}
-----------------------------------------------
测试类
public class Test {
/**
* @param args
*/
public static void main(String[] args) {
saveData();
// queryData();
UserInfo user = UserInfoDaoImpl.getUserInfoById(1);// 根据ID查询对象
// UserInfoDaoImpl.queryUserInfoByName("xbliuc");// 根据Name查询对象
UserInfoDaoImpl.removeUserInfo(user);
}
// 从数据库中查询数据
public static void queryData() {
Session session = null;
try {
session = HibernateUtil.getSession();
// String hql = "from UserInfo"; --不带条件
String hql = "from UserInfo as userinfo where userinfo.name=:name and userinfo.sex=:sex";
Query query = session.createQuery(hql);
query.setString("sex", "男");// 设置hql语句中的参数
query.setString("name", "xbliuc");
// query.setFirstResult(11);//从11条数据开始查询--用于排序
// query.setMaxResults(10);//最大查询10条记录
// List list = query.list();//返回一个集合
UserInfo userInfo = (UserInfo) query.uniqueResult();// 有且只有一条数据时使用
System.out.println(userInfo.getName());
// 另一种查询方式-更趋向于面向对象设计
// Criteria criteria = session.createCriteria(UserInfo.class);
// criteria.add(Restrictions.eq("name", "xbliuc"));
// criteria.add(Restrictions.eq("sex", "男"));
// criteria.uniqueResult();
// criteria.list();
// criteria.setFirstResult(11);
// criteria.setMaxResults(10);
} finally {
if (session != null) {
session.close();
}
}
}
// 保存对象到数据库中
public static void saveData() {
// 获取Session对象
Session session = HibernateUtil.getSession();
// 开启事务
Transaction transaction = session.beginTransaction();
UserInfo user = new UserInfo("xbliuc", "男", "深圳");
session.save(user);
// 提交事务
transaction.commit();
session.close();
System.out.println("-------------------------------\t");
}
}
--------------------------------------------
/**
* 通过Id获取UserInfo对象
* @param a
* @return UserInfo
*/
public static UserInfo getUserInfoById(int id){
session = HibernateUtil.getSession();
String hql = "from UserInfo as u where u.id = 1";
//Query query = session.createQuery(hql);//
UserInfo obj = (UserInfo)session.get(UserInfo.class, 1);
//UserInfo obj = (UserInfo)query.uniqueResult();
System.out.println(obj);
if(session != null){
session.close();
}
return userInfo;
}
/**
* 添加数据
* @param userInfos
*/
public static void addUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.save(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}
/**
* 修改数据
* @param userInfos
*/
public static void updateUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.update(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}
/**
* 删除数据
* @param userInfos
*/
public static void deleteUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.delete(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}
hibernate.cfg.xml --数据库配置文件
<?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.OracleDialect</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:orcl</property>
<property name="connection.username">scott</property>
<property name="connection.password">xbliuc</property>
<property name="hbm2ddl.auto">create</property>
<property name="show_sql">true</property>
<mapping resource="com/rt/xbliuc/test/UserInfo.hbm.xml" />
</session-factory>
</hibernate-configuration>
---------------------------------------------------
实体类映射文件 UserInfo.hbm.xml
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.rt.xbliuc.test">
<class name="UserInfo" table="UserInfos">
<id name="id">
<generator class="native"/>
</id>
<property name="name" unique="true" not-null="true"/>
<property name="sex"/>
<property name="address"/>
</class>
</hibernate-mapping>
---------------------------------------------------
获取Session对象的工具类
public final class HibernateUtil {
private HibernateUtil(){}
private static SessionFactory sessionFactory;
static{
//创建配置管理对象
Configuration config = new Configuration();
//加载配置文件(hibernate.cfg.xml)
config.configure();//加载默认路径下的配置文件
//config.configure(uri)手动指定配置文件路径
//构建SessionFactory
sessionFactory = config.buildSessionFactory();
}
public static Session getSession(){
//获取Session对象
return sessionFactory.openSession();
}
}
---------------------------------------------------
实体类
public class UserInfo {
private int id;
private String name;
private String sex;
private String address;
public UserInfo(){}
public UserInfo(String name, String sex, String address) {
this.name = name;
this.sex = sex;
this.address = address;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
}
---------------------------------------------------
操作工具类
public class UserInfoDaoImpl {
/**
* 通过Id获取一个对象
*
* @param id
* @return
*/
public static UserInfo getUserInfoById(int id) {
Session session = null;
UserInfo userInfo = null;
try {
session = HibernateUtil.getSession();
userInfo = (UserInfo) session.get(UserInfo.class, id);
System.out.println(userInfo.getName());
} finally {
if (session != null) {
session.close();
}
}
return userInfo;
}
public static UserInfo queryUserInfoByName(String name) {
Session session = null;
UserInfo userInfo = null;
try {
session = HibernateUtil.getSession();
String hql = "from UserInfo as userinfo where userinfo.name = :u_name";
Query query = session.createQuery(hql);
query.setParameter("u_name", name);
userInfo = (UserInfo) query.uniqueResult();
System.out.println(userInfo.getName());
} finally {
if (session != null) {
session.close();
}
}
return userInfo;
}
/**
* 删除数据
*/
public static void removeUserInfo(UserInfo userInfo) {
Session session = null;
try {
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.delete(userInfo);
transaction.commit();
} finally {
if (session != null) {
session.close();
}
}
}
}
-----------------------------------------------
测试类
public class Test {
/**
* @param args
*/
public static void main(String[] args) {
saveData();
// queryData();
UserInfo user = UserInfoDaoImpl.getUserInfoById(1);// 根据ID查询对象
// UserInfoDaoImpl.queryUserInfoByName("xbliuc");// 根据Name查询对象
UserInfoDaoImpl.removeUserInfo(user);
}
// 从数据库中查询数据
public static void queryData() {
Session session = null;
try {
session = HibernateUtil.getSession();
// String hql = "from UserInfo"; --不带条件
String hql = "from UserInfo as userinfo where userinfo.name=:name and userinfo.sex=:sex";
Query query = session.createQuery(hql);
query.setString("sex", "男");// 设置hql语句中的参数
query.setString("name", "xbliuc");
// query.setFirstResult(11);//从11条数据开始查询--用于排序
// query.setMaxResults(10);//最大查询10条记录
// List list = query.list();//返回一个集合
UserInfo userInfo = (UserInfo) query.uniqueResult();// 有且只有一条数据时使用
System.out.println(userInfo.getName());
// 另一种查询方式-更趋向于面向对象设计
// Criteria criteria = session.createCriteria(UserInfo.class);
// criteria.add(Restrictions.eq("name", "xbliuc"));
// criteria.add(Restrictions.eq("sex", "男"));
// criteria.uniqueResult();
// criteria.list();
// criteria.setFirstResult(11);
// criteria.setMaxResults(10);
} finally {
if (session != null) {
session.close();
}
}
}
// 保存对象到数据库中
public static void saveData() {
// 获取Session对象
Session session = HibernateUtil.getSession();
// 开启事务
Transaction transaction = session.beginTransaction();
UserInfo user = new UserInfo("xbliuc", "男", "深圳");
session.save(user);
// 提交事务
transaction.commit();
session.close();
System.out.println("-------------------------------\t");
}
}
--------------------------------------------
/**
* 通过Id获取UserInfo对象
* @param a
* @return UserInfo
*/
public static UserInfo getUserInfoById(int id){
session = HibernateUtil.getSession();
String hql = "from UserInfo as u where u.id = 1";
//Query query = session.createQuery(hql);//
UserInfo obj = (UserInfo)session.get(UserInfo.class, 1);
//UserInfo obj = (UserInfo)query.uniqueResult();
System.out.println(obj);
if(session != null){
session.close();
}
return userInfo;
}
/**
* 添加数据
* @param userInfos
*/
public static void addUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.save(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}
/**
* 修改数据
* @param userInfos
*/
public static void updateUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.update(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}
/**
* 删除数据
* @param userInfos
*/
public static void deleteUserInfo(UserInfo userInfos){
session = HibernateUtil.getSession();
Transaction transaction = session.beginTransaction();
session.delete(userInfos);
transaction.commit();
if(session != null){
session.close();
}
}