Java框架之Hibernate实战篇2

1.cn.itcast.entity包里面：

（1）Customer.java

复制代码
package cn.itcast.entity;

import java.util.HashSet;
import java.util.Set;

public class Customer {
// 用户id
private Integer cid;

// 用户名称
private String custName;// 用户级别
private String custLevel;// 用户来源
private String custSource;// 联系电话
private String custPhone;// 手机
private String custMobile;// 在客户实体类里面表示多个联系人，一个客户有多个联系人
// hibernate要求使用集合表示多的数据，使用set集合:
// import java.util.HashSet;import java.util.Set;
private Set<LinkMan> setLinkMan = new HashSet<LinkMan>();public Set<LinkMan> getSetLinkMan() {return setLinkMan;
}public void setSetLinkMan(Set<LinkMan> setLinkMan) {this.setLinkMan = setLinkMan;
}public Integer getCid() {return cid;
}public void setCid(Integer cid) {this.cid = cid;
}public String getCustName() {return custName;
}public void setCustName(String custName) {this.custName = custName;
}public String getCustLevel() {return custLevel;
}public void setCustLevel(String custLevel) {this.custLevel = custLevel;
}public String getCustSource() {return custSource;
}public void setCustSource(String custSource) {this.custSource = custSource;
}public String getCustPhone() {return custPhone;
}public void setCustPhone(String custPhone) {this.custPhone = custPhone;
}public String getCustMobile() {return custMobile;
}public void setCustMobile(String custMobile) {this.custMobile = custMobile;
}

}
复制代码
Customer.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>复制代码（2）LinkMan.java

复制代码
package cn.itcast.entity;

public class LinkMan {
// 联系人编号（主键）
private Integer lkm_id;

// 联系人姓名
private String lkm_name;// 联系人性别
private String lmk_gender;// 联系人办公电话
private String lkm_phone;// 在联系人实体类里面表示所有客户，一个联系人只能属于一个客户
// Customer customer=new Customer();
private Customer customer;public Customer getCustomer() {return customer;
}public void setCustomer(Customer customer) {this.customer = customer;
}public Integer getLkm_id() {return lkm_id;
}public void setLkm_id(Integer lkm_id) {this.lkm_id = lkm_id;
}public String getLkm_name() {return lkm_name;
}public void setLkm_name(String lkm_name) {this.lkm_name = lkm_name;
}public String getLmk_gender() {return lmk_gender;
}public void setLmk_gender(String lmk_gender) {this.lmk_gender = lmk_gender;
}public String getLkm_phone() {return lkm_phone;
}public void setLkm_phone(String lkm_phone) {this.lkm_phone = lkm_phone;
}

}
复制代码
LinkMan.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>

<many-to-one name="customer" class="cn.itcast.entity.Customer" column="clid"></many-to-one>

复制代码 2.HibernateUtils包里面的HibernateUtils.java工具类，添加本地线程绑定的session的方法

复制代码
package cn.itcast.utils;

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

public class HibernateUtils {

// 加载核心配置文件，静态代码块实现
static Configuration cfg = null;static SessionFactory sessionFactory = null;
static {cfg = new Configuration();cfg.configure();sessionFactory = cfg.buildSessionFactory();
}// 提供返回与本地线程绑定的session的方法
public static Session getSessionObject() {return sessionFactory.getCurrentSession();
}// 提供方法返回sessionFactory
public static SessionFactory getSessionFactory() {return sessionFactory;
}public static void main(String[] args) {}

}
复制代码
3.Hibernate核心配置文件

复制代码

<?xml version="1.0" encoding="UTF-8"?> com.mysql.jdbc.Driver jdbc:mysql:///hibernate_test3 root root true true update org.hibernate.dialect.MySQLDialect thread 复制代码 4.Hibernatetest包

(1)HibernateOnetoMany.java

复制代码
package hibernatetest;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

import cn.itcast.entity.Customer;
import cn.itcast.entity.LinkMan;
import cn.itcast.utils.HibernateUtils;

public class HibernateOnetoMany {

// 演示:一对多级联保存
@Test
public void testUpdate() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 添加一个客户，为这个客户添加一个联系人// 1 创建客户和联系人对象Customer customer = new Customer();customer.setCustLevel("vip");customer.setCustMobile("8888");customer.setCustName("橡果国际");customer.setCustPhone("18345782345");customer.setCustSource("上海");LinkMan linkman = new LinkMan();linkman.setLkm_name("王小卓");linkman.setLkm_phone("173456379876");linkman.setLmk_gender("女");// 2 在客户表示所有联系人，在联系人表示客户// 建立客户对象和联系人对象关系// 2.1 把联系人对象 放到客户对象的set集合里面customer.getSetLinkMan().add(linkman);// 2.2 把客户对象放到联系人里面linkman.setCustomer(customer);// 3 保存到数据库session.save(customer);session.save(linkman);tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}// 演示:一对多级联保存
@Test
public void testAddDemo2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();Customer customer = new Customer();customer.setCustLevel("普通");customer.setCustName("奥克斯");customer.setCustPhone("18932222237");customer.setCustSource("北京");LinkMan linkman = new LinkMan();linkman.setLkm_name("陈小桥");linkman.setLkm_phone("15024324567");linkman.setLmk_gender("女");customer.getSetLinkMan().add(linkman);// 少了这句，linkman.setCustomer(customer);只执行t_customer表的insert语句// 添加它和session.save(linkman);，则t_linkman表中添加的新数据（陈小桥）才会加进去linkman.setCustomer(customer);// save() 保存要有哦！session.save(customer);session.save(linkman);tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {// sessionFactory.close();// session.close();}
}// 演示：一对多级联删除
@Test
public void testDeleteDemo() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.根据id查询客户对象Customer customer = session.get(Customer.class, 12);// 2.调用删除方法session.delete(customer);// 3.提交事务tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}
}// 演示：一对多修改
@Test
public void testUpdateDemo() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.根据id查询联系人，根据id查询客户Customer customer1 = session.get(Customer.class, 3);LinkMan linkman1 = session.get(LinkMan.class, 1);// 2.设置持久态对象值// i.把联系人放到客户里面customer1.getSetLinkMan().add(linkman1);// ii.把客户放到联系人里面linkman1.setCustomer(customer1);// 3.提交事务tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}}

}
复制代码
(2)HibernateManytoMany.java

复制代码
package hibernatetest;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

import cn.itcast.manytomany.Role;
import cn.itcast.manytomany.User;
import cn.itcast.utils.HibernateUtils;

public class HibernateManytoMany {
// 演示维护第三张表
@Test
public void testTable1() {
SessionFactory sessionFactory = null;
Session session = null;
Transaction tx = null;
try {
sessionFactory = HibernateUtils.getSessionFactory();
session = sessionFactory.openSession();
tx = session.beginTransaction();

        // 让某个用户拥有某个角色// 1.查询User user1 = session.get(User.class, 2);Role role1 = session.get(Role.class, 2);// 2.放user1.getSetRole().add(role1);tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}
}// 演示：维护第三张表
@Test
public void testTable2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 让某个用户没有某个角色User user2 = session.get(User.class, 2);Role role2 = session.get(Role.class, 3);// 从用户里面把角色去掉user2.getSetRole().remove(role2);// 提交事务tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}}// 演示：多对多级联删除
@Test
public void testSave() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 添加两个用户，为每个用户相加两个角色// 1.创建对象User user3 = new User();user3.setUser_name("春花");user3.setUser_password("8766899");User user4 = new User();user4.setUser_name("mary");user4.setUser_password("456");Role role3 = new Role();role3.setRole_name("pig");role3.setRole_memo("粉色的");Role role4 = new Role();role4.setRole_name("秘书");role4.setRole_memo("秘书");Role role5 = new Role();role5.setRole_name("保安");role5.setRole_memo("保安");// 2.建立关系，把角色放到用户里面user3.getSetRole().add(role3);user3.getSetRole().add(role4);user4.getSetRole().add(role4);user4.getSetRole().add(role5);// 3.保存session.save(user3);session.save(user4);// 4.提交事务tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}
}// 演示：多对多级联保存
@Test
public void testDelete() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();User user5 = session.get(User.class, 1);session.delete(user5);// 提交事务tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();// sessionFactory.close();}
}

}
复制代码
5.cn.itcast.manytomany包

(1)Role.java

复制代码
package cn.itcast.manytomany;

import java.util.HashSet;
import java.util.Set;

public class Role {

private Integer role_id;private String role_name;private String role_memo;// 一个角色有多个客户
private Set<User> setUser = new HashSet<User>();public Set<User> getSetUser() {return setUser;
}public void setSetUser(Set<User> setUser) {this.setUser = setUser;
}public Integer getRole_id() {return role_id;
}public void setRole_id(Integer role_id) {this.role_id = role_id;
}public String getRole_name() {return role_name;
}public void setRole_name(String role_name) {this.role_name = role_name;
}public String getRole_memo() {return role_memo;
}public void setRole_memo(String role_memo) {this.role_memo = role_memo;
}

}
复制代码
Role.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>复制代码（2）User.java

复制代码
package cn.itcast.manytomany;

import java.util.HashSet;
import java.util.Set;

public class User {

private Integer user_id;private String user_name;private String user_password;// 一个用户可以有多个角色
private Set<Role> setRole = new HashSet<Role>();public Set<Role> getSetRole() {return setRole;
}public void setSetRole(Set<Role> setRole) {this.setRole = setRole;
}public Integer getUser_id() {return user_id;
}public void setUser_id(Integer user_id) {this.user_id = user_id;
}public String getUser_name() {return user_name;
}public void setUser_name(String user_name) {this.user_name = user_name;
}public String getUser_password() {return user_password;
}public void setUser_password(String user_password) {this.user_password = user_password;
}

}
复制代码
User.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>复制代码第四篇：HQL、QBC 、查询、检索策略、批量抓取等相关练习篇

1.cn.itcast.entity包

(1)Cutomer.java

复制代码
package cn.itcast.entity;

import java.util.HashSet;
import java.util.Set;

public class Customer {
private Integer cid;

private String custName;private String custLevel;private String custSource;private String custPhone;private String custMobile;// 在客户实体类里面表示多个联系人，一个客户有多个联系人
private Set<LinkMan> setLinkMan = new HashSet<LinkMan>();public Set<LinkMan> getSetLinkMan() {return setLinkMan;
}public void setSetLinkMan(Set<LinkMan> setLinkMan) {this.setLinkMan = setLinkMan;
}public Integer getCid() {return cid;
}public void setCid(Integer cid) {this.cid = cid;
}public String getCustName() {return custName;
}public void setCustName(String custName) {this.custName = custName;
}public String getCustLevel() {return custLevel;
}public void setCustLevel(String custLevel) {this.custLevel = custLevel;
}public String getCustSource() {return custSource;
}public void setCustSource(String custSource) {this.custSource = custSource;
}public String getCustPhone() {return custPhone;
}public void setCustPhone(String custPhone) {this.custPhone = custPhone;
}public String getCustMobile() {return custMobile;
}public void setCustMobile(String custMobile) {this.custMobile = custMobile;
}

}
复制代码
Customer.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>

<hibernate-mapping>
<class name="cn.itcast.entity.Customer" table="t_customer">
<id name="cid" column="cid">
<generator class="native"></generator>
</id>
<property name="custName" column="custName"></property>
<property name="custLevel" column="custLevel"></property>
<property name="custSource" column="custSource"></property>
<property name="custPhone" column="custPhone"></property>
<property name="custMobile" column="custMobile"></property>
<!-- 在客户映射文件中，表示所有联系人 使用set标签表示所有联系人set标签里面有name属性：属性值写在客户实体类里面表示联系人的set集合名称inverse属性默认值：false不放弃关系维护true表示放弃关系维护-->
<set name="setLinkMan" batch-size="10">
<!-- 一对多建表，有外键hibernate机制：双向维护外键，在一和多那一方都配置外键    column属性值：外键名称-->
<key column="clid"></key>
<one-to-many class="cn.itcast.entity.LinkMan"/>
</set>
</class>
</hibernate-mapping>

复制代码
(2).LinkMan.java

复制代码
package cn.itcast.entity;

public class LinkMan {
private Integer lkm_id; // 联系人编号(主键)

private String lkm_name;// 联系人姓名private String lkm_gender;// 联系人性别private String lkm_phone;// 联系人办公电话// 在联系人实体类中表示所属客户，一个联系人只能有一个客户
private Customer customer;public Customer getCustomer() {return customer;
}public void setCustomer(Customer customer) {this.customer = customer;
}public Integer getLkm_id() {return lkm_id;
}public void setLkm_id(Integer lkm_id) {this.lkm_id = lkm_id;
}public String getLkm_name() {return lkm_name;
}public void setLkm_name(String lkm_name) {this.lkm_name = lkm_name;
}public String getLkm_gender() {return lkm_gender;
}public void setLkm_gender(String lkm_gender) {this.lkm_gender = lkm_gender;
}public String getLkm_phone() {return lkm_phone;
}public void setLkm_phone(String lkm_phone) {this.lkm_phone = lkm_phone;
}

}
复制代码
LinkMan.hbm.xml

复制代码

<?xml version="1.0" encoding="UTF-8"?>

<hibernate-mapping>
<class name="cn.itcast.entity.LinkMan" table="t_linkman">
<id name="lkm_id" column="lkm_id">
<generator class="native"></generator>
</id>
<property name="lkm_name" column="lkm_name"></property>
<property name="lkm_gender" column="lkm_gender"></property>
<property name="lkm_phone" column="lkm_phone"></property><!-- 表示联系人所属客户 name属性：因为在联系人实体类使用customer对象表示，写customer名称class属性：customer全路径column属性：外键名称-->
<many-to-one name="customer" class="cn.itcast.entity.Customer" column="clid"></many-to-one>
</class>
</hibernate-mapping>

复制代码
2.utils包(同上)

HibernateUtils.java

复制代码
package ustils;

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

public class HibernateUtils {

static Configuration cfg = null;static SessionFactory sessionFactory = null;
static {cfg = new Configuration();cfg.configure();sessionFactory = cfg.buildSessionFactory();
}public static Session getSessionobject() {return sessionFactory.getCurrentSession();
}public static SessionFactory getSessionFactory() {return sessionFactory;
}public static void main(String[] args) {}

}
复制代码
3.Hibernate核心配置文件

复制代码

<?xml version="1.0" encoding="UTF-8"?>

<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql:///hibernate_test4</property>
<property name="hibernate.connection.username">root</property>
<property name="hibernate.connection.password">root</property><property name="hibernate.show_sql">true</property>
<property name="hibernate.format_sql">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<property name="hibernate.current_session_context_class">thread</property><mapping resource="cn/itcast/entity/Customer.hbm.xml"/>
<mapping resource="cn/itcast/entity/LinkMan.hbm.xml"/>
</session-factory>
</hibernate-configuration>

复制代码
4.cn.itcast.hibernantetest包

（1）HibernateDemo.java

复制代码
package cn.itcast.hibernantetest;

import java.util.List;
import java.util.Set;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

import cn.itcast.entity.Customer;
import cn.itcast.entity.LinkMan;
import ustils.HibernateUtils;

public class HibernateDemo {

// 演示对象导航查询
@Test
public void testSelect1() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.查询cid=1客户Customer customer = session.get(Customer.class, 1);// 2.再查询这个客户里面的所有联系人(此时，得到set集合，没有发送语句)Set<LinkMan> linkman = customer.getSetLinkMan();// 发送了语句System.out.println(linkman.size());tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}// 演示检索策略
@Test
public void testSelect2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 根据cid=1客户// 执行get方法之后是否发送sql语句// 调用get方法马上发送sql语句查询数据库// Customer customer = session.get(Customer.class, 1);// System.out.println(customer.getCid());/** 1 调用load方法之后，不会马上发送sql语句 （1）返回对象里面只有 id值* * 2 得到对象里面不是id的其他值时候才会发送语句*/Customer customer = session.load(Customer.class, 1);System.out.println(customer.getCid());System.out.println(customer.getCustName());tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}// 演示批量抓取
@Test
public void testSelect3() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 查询所有客户Criteria criteria = session.createCriteria(Customer.class);// 得到每个客户里面所有的联系人List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());// 每个客户里面的所有联系人Set<LinkMan> setlinkman = customer.getSetLinkMan();for (LinkMan linkMan : setlinkman) {System.out.println((linkMan.getLkm_id() + "::" + linkMan.getLkm_name()));}}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}

}
复制代码
（2）HibernateHQL.java

复制代码
package cn.itcast.hibernantetest;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

import cn.itcast.entity.Customer;
import ustils.HibernateUtils;

public class HibernateHQL {

// 演示查询所有
@Test
public void testSelect1() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象Query query = session.createQuery("from Customer");// 2.调用方法得到结果List<Customer> list = query.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示条件查询
@Test
public void testSelect2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象// SELECT *FROM t_customer WHERE cid=? AND custName=?Query query = session.createQuery("from Customer c where c.cid=? and c.custName=?");// 2.设置条件// 向？里面设置值// setParameter方法两个参数// 第一个参数：int类型是？位置，？位置从0开始// 第二个参数：具体参数值// 设置第一个？值query.setParameter(0, 1);// 设置第二个？值query.setParameter(1, "百度");// 3.调用方法得到结果List<Customer> list = query.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示条件查询-模糊查询
@Test
public void testSelect3() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象Query query = session.createQuery("from Customer c where c.custName like ?");// 2.设置？的值query.setParameter(0, "%蒂%");// 3.调用方法得到结果List<Customer> list = query.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：排序查询
@Test
public void testSelect4() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象Query query = session.createQuery("from Customer order by cid desc");// 2.调用方法得到结果List<Customer> list = query.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示:分页查询
@Test
public void testSelect5() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象// 写查询所有的语句Query query = session.createQuery("from Customer");// 2.设置分页数据// 2.1.设置开始位置query.setFirstResult(3);// 2.2.设置每页记录数query.setMaxResults(3);// 3.调用方法得到结果List<Customer> list = query.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示:投影查询
@Test
public void testSelect6() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象Query query = session.createQuery("select custLevel from Customer");// 2.调用方法得到结果List<Object> list = query.list();for (Object object : list) {System.out.println(object);}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示:聚集函数的使用
@Test
public void testSelect7() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建query对象Query query = session.createQuery("select count(*) from Customer");// 2.调用方法得到结果// query对象里面有方法，直接返回对象形式Object obj = query.uniqueResult();// 返回int类型// int count=(int)obj;// 首先把object变成long类型，再变成int类型Long lobj = (Long) obj;int count = lobj.intValue();System.out.println(count);tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}

}
复制代码
（3）HibernateQBC.java

复制代码
package cn.itcast.hibernantetest;

import java.util.List;

import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Projections;
import org.hibernate.criterion.Restrictions;
import org.junit.Test;

import cn.itcast.entity.Customer;
import ustils.HibernateUtils;

public class HibernateQBC {

// 演示：查询所有
@Test
public void testSelect1() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建对象Criteria criteria = session.createCriteria(Customer.class);// 2.调用方法得到结果List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：条件查询
@Test
public void testSelect2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建criteria对象Criteria criteria = session.createCriteria(Customer.class);// 2.使用criteria对象里面的方法设置条件值// 首先使用add方法，表示设置条件值// 在add方法里面使用类的方法实现条件设置// 类似于cid=？// criteria.add(Restrictions.eq("cid", 1));// criteria.add(Restrictions.eq("custName", "玛莎拉蒂"));// 上面是eq，下面是likecriteria.add(Restrictions.like("custName", "%百%"));// 3.调用方法得到结果List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：排序查询
@Test
public void testSelect3() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建对象Criteria criteria = session.createCriteria(Customer.class);// 2.设置对哪个属性进行排序，设置排序规则criteria.addOrder(Order.desc("cid"));// 3.调用方法，得到结果List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：分页查询
@Test
public void testSelect4() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建对象Criteria criteria = session.createCriteria(Customer.class);// 2.设置分页，起始和记录数criteria.setFirstResult(3);criteria.setMaxResults(3);// 3.调用方法得到结果List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：统计查询
@Test
public void testSelect5() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建对象Criteria criteria = session.createCriteria(Customer.class);// 2.设置操作criteria.setProjection(Projections.rowCount());// 3.调用方法得到结果Object obj = criteria.uniqueResult();Long lobj = (Long) obj;int count = lobj.intValue();System.out.println(count);tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}// 演示：离线查询
@Test
public void testSelect6() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 1.创建对象// Criteria criteria = session.createCriteria(Customer.class);DetachedCriteria detachedCriteria = DetachedCriteria.forClass(Customer.class);// 2.最终执行时候才需要得到sessionCriteria criteria = detachedCriteria.getExecutableCriteria(session);List<Customer> list = criteria.list();for (Customer customer : list) {System.out.println(customer.getCid() + "::" + customer.getCustName());}tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}}

}
复制代码
（4）HibernateManyTable.java

复制代码
package cn.itcast.hibernantetest;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.junit.Test;

import ustils.HibernateUtils;

public class HibernateManyTable {

// 演示hql内连接查询（2种）
@Test
public void testSelect1() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 内连接的list返回的是数组的形式；迫切内外连接的list放回的是对象的形式// Query query = session.createQuery("from Customer c inner join// c.setLinkMan");// List list = query.list();Query query = session.createQuery("from Customer c inner join fetch c.setLinkMan");List list = query.list();tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}// 演示hql外连接查询（3种）
@Test
public void testSelect2() {SessionFactory sessionFactory = null;Session session = null;Transaction tx = null;try {sessionFactory = HibernateUtils.getSessionFactory();session = sessionFactory.openSession();tx = session.beginTransaction();// 左外连接的list返回的是数组的形式；迫切左外连接的list放回的是对象的形式// Query query = session.createQuery("from Customer c left outer// join c.setLinkMan");// List list = query.list();// Query query = session.createQuery("from Customer c left outer// join fetch c.setLinkMan");// List list = query.list();// 右外连接，没有迫切右外连接Query query = session.createQuery("from Customer c right outer join fetch c.setLinkMan");List list = query.list();tx.commit();} catch (Exception e) {e.printStackTrace();tx.rollback();} finally {session.close();sessionFactory.close();}
}

}
深圳网站建设www.sz886.com

查看全文
如若内容造成侵权/违法违规/事实不符，请联系编程学习网邮箱：809451989@qq.com进行投诉反馈，一经查实，立即删除！

zabbix监听nginx-rtmp
nginx-rtmp开启stats# nginx(--add-module=nginx-rtmp-module-master)nginx.conf:server {listen 81;location /stat {rtmp_stat all;}}http://127.0.0.1:81/statstat状态值详解codec: 编码bits/s: 码流size: 分辨率fps: 每秒传输帧数freq: 音频频率chan: 声道数定义zabbix监控…...
2024/4/24 12:03:46
tensorflow2.x实时绘制训练时的损失和准确率
sgd = SGD(lr=float(model_value[3]), decay=1e-6, momentum=0.9, nesterov=True) model.compile(loss=categorical_crossentropy, optimizer=sgd, metrics=[accuracy]) # validation_split：0~1之间的浮点数，用来指定训练集的一定比例数据作为验证集 history=model.fit(self.…...
2024/4/24 12:03:52
TCP协议三次握手的过程
TCP 协议，在建立连接需要经历三次握手的过程。你知道这三次握手的过程吗？第一次握手：是由客户端向服务器端发起的。这是用来去发起一个连接建立的请求，在这个报文中的SYN 位会被标记为1，我们把他叫做一个SYN 包。第二次握手：是由服务器向客户端发起的，这是来确认服务器…...
2024/4/24 12:03:43
脚本编译运行Java文件（Linux和Windows操作方法）
项目目录windows下使用bat脚本：创建dadaStart_win.sh文件，内容如下：cd ./src javac -encoding UTF-8 -cp ./ ./com/java/pojo/Car.java javac -encoding UTF-8 -cp ./ ./com/java/Operating.java javac -encoding UTF-8 -cp ./ ./com/java/Demo.javaecho "启动" j…...
2024/4/24 12:03:52
一键启动和关闭hadoop全部进程（shell脚本）
注意：路径可根据自己hadoop安装路径选择编写，博主hadoop为伪分布式部署编写启动所有hadoop进程脚本 vi mystart-all.sh#!/bin/bash /usr/local/hadoop-2.8.5/sbin/start-dfs.sh /usr/local/hadoop-2.8.5/sbin/start-yarn.sh /usr/local/hadoop-2.8.5/sbin/mr-jobhistory-dae…...
2024/4/24 12:03:45
socket中文乱码问题
问题描述：后端向前端发送中文，前端显示正常前端向后端发送中文，后端显示乱码解决：前端js引入最新版的 socket.io.js，不能使用socket.io.min.js <script src="{{url_for(static,filename=js/socket.io.dev.js)}}"></script>...
2024/4/24 12:03:40
【Flink】Flink TaskManager 内存不足导致重启
1.背景一个flink程序运行一段时间后，突然重启了，查看日志报错如下 2020-06-08 21:37:52 PM [Thread: flink-akka.actor.default-d...
2024/4/24 12:03:43
【Python行业分析】BOSS直聘招聘信息获取之爬虫程序分析
今天我们要正式使用程序来爬取BOSS的招聘数据了，我会从最基础的一步一步去完善程序，帮助大家来理解爬虫程序，其中还是有许多问题我没能解决，也希望有大佬可以留言帮助一下首先我们来访问下页面，看下结果是不是和浏览器访问是一致的具体的页面返回的信息太多了，我们可以…...
2024/4/24 12:03:39
软件测试学习笔记12：如何用禅道导出excel中的bug数据自动化生成word测试报告文档
我们常用的一些bug平台都有可以导出BUGLIST的功能，我用的是禅道，首先...
2024/4/24 12:03:40
二阶常系数齐次微分方程与传输线方程的紧密联系
传输线方程是射频电路学习的起点，也被称为电报方程。无论你是从麦克斯韦方程还是从等效的电路观点都能推出这个公式。一般我们只看电压公式。这是二阶微分方程，可以求得通解。这里的常数是有意义的，表示Z=0处入射电压和反射电压。信号传输入点我们一般认为在z<0处，Ass…...
2024/4/24 12:03:36
【C语言】——文件内容排序
#define _CRT_SECURE_NO_WARNINGS #include <stdio.h> #include <string.h>void swap(int* a, int* b) {int temp = *a;*a = *b;*b = temp; }//冒泡排序 void pupple(int* p, int n) {int i, j;for (i = 0; i < n; i++){for (j = 1; j < n - i; j++){if (p[j…...
2024/4/24 12:03:43
小程序不刷新页面更新数据
微信小程序不刷新页面更新数据小程序刷新页面过程大家都懂得，特别是网络不好的时候，觉得这te,ma,就是一种折磨，如何做到不刷新页面就可以更新数据？页面栈：小程序的每一个页面都是一个page对象，一个小程序最多有10层页面栈getCurrentPages let pages = getCurrentPages(…...
2024/4/24 12:03:34
列表组件与key
文章目录列表组件为什么需要keykey应该放哪儿一个合格的key是什么样列表组件为什么需要key列表<ul>新增子元素<li>Lucy</li>，且放最后面列表<ul>新增子元素<li>Lucy</li>，且放最前面都是给<ul>新增一个子元素<li>Lucy</…...
2024/4/24 12:03:33
Java基础------斗地主小案例
import java.util.ArrayList; import java.util.Collections;public class 斗地主 {public static void main(String[] args) {//准备牌//定义总的一个集合存放pokerArrayList<String>poker=new ArrayList<>();//定义花色数组String []color={"♥","…...
2024/4/25 2:04:43
ngx_http_image_filter_module使用
文章目录安装基本使用示例参数说明参考链接：nginx官方文档安装 ngx_http_image_filter_module一个官方模块，用于转换JPEG、GIF、PNG和WebP格式的图像。默认情况下，此模块不是启用的，在编译时使用--with-http_image_filter_module配置参数启用它。此模块使用libgd库。建…...
2024/4/19 20:40:13
velodyne VIP16激光雷达和basler usb相机在Ros下同时打开，并录制bag
前面两篇博客分别讲述了激光雷达和相机通过Ros打开的方法及步骤，详情请看前文介绍。文章目录一、相机打开二、激光雷达打开三、打开rviz，录制bag 一、相机打开（1）在相机工作空间catkin_basler目录下打开终端，输入命令 source ~/catkin_basler/devel/setup.bash roslaunc…...
2024/4/22 17:40:38
判断app是否需要更新（对比app版本号）
抓包获取app版本没有versionCode，只要versionName，手动解析versionName判断app是否有新版本，能够识别以下几种格式："1.1.0" "1.1.0-alpha" "1.1.0rc" "1.1.0" "7.59.1 build 27…...
2024/4/20 4:11:24
Ubuntu2004搭建esp32 开发环境
这里写自定义目录标题可选项建立文件夹环境搭建合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX…...
2024/4/24 12:03:40
ML基础：高斯混合模型是什么？
高斯混合模型是一种概率模型，它假设所有数据点都是从有限数量的高斯分布的混合参数中生成的。 1.高斯混合模型概念实际上，可以将混合模型视为对 k-means聚类算法的扩展，它包含了数据的协方差结构以及隐高斯模型中心的信息。该方法使用了高斯分布作为参数模型，并使用了期望…...
2024/4/24 12:03:34
Activity model汉化
@[Activity]Activity model汉化 Activity 5.22 汉化作为国人汉化应该是刻不容缓的，有需要的同仁请拿走。 stencilset.json...
2024/4/24 12:03:30

Java框架之Hibernate实战篇2

相关文章

最新文章