Hibernate_又快又准的Hibernate映射技巧

╰+哭是因爲堅強的太久メ 2022-06-16 11:29 198阅读 0赞

说明：
    	1,练习到一对多、多对多、一对一映射。
    	2,需要管理Session,要做增删改查工作。
    	3,有多种查询的要求。
    
    ----------------------------
    要做的事：
    1,根所类图写出JavaBean。
    2,写出映射文件并建表。
    3,完成以下操作
    
    ------------------------------------------------------------
    
    1,实体：
    	Department
    	Employee
    	UserAccount
    	Privilege
    
    2,操作:
    	部门:
    		增加一个部门
    		更新一个部门的信息(更改名称)
    		把部门中所有的员工都取消关联
    		删除一个部门,并把所有的子部门删掉,如果部门中有员工,则不能删除。
    		查询最顶级部门,按id升序排列(最顶级的就是没有上级的部门)
    		查询某部门的所有子部门,按id升序排序
    		统计:员工的总数量,部站的总数量,每个部门中员工的数量。
    	员工:
    		增加一个员工
    		为员工分配一个用户账号(指定登录名与密码)
    		更新员工的信息
    		更改员工所属的部门
    		更新员工账号的密码
    		删除员工的账号
    		删除一个员工,并同时删除他的账号
    		根据登录名与密码查询一个员信息(登录时使用)
    		查询所有分配了账号的员工
    		把有所员工的密码都重置为"1234"(使用update语句实现)
    	权限:
    		添加若干个权限数据,用于测试(权限没有增删改,是一开始就定义好了的)
    		为某个员工分配一些权限(为员工关联一些权限,例如关联3个)
    		移除某员工中的一个权限
    		检测某员工是否有某权限
    		查询出所有含有某权限的员工
    
    3,提示
    	注意属性是否与所有的数据库中的关键字冲突。
    	员工的生日只保存年月日。
    	一对一映射采用基于外键的方式。

===================================== 模板 =====================================
    一对多(Set)：
    	<set name="">
    		<key column="" />
    		<one-to-many class="" />
    	</set>
    	
    多对一：
    	<many-to-one name="" class="" column="" />
    	
    多对多(Set)：
    	<set name="" table="">
    		<key column="" />	
    		<many-to-many class="" column="" />
    	</set>
    
    一对一(基于外键的有外键方)：
    	<many-to-one name="" class="" column="" unique="true"/>
    	
    一对一(基于外键的无外键方)：
    	<one-to-one name="" class="" property-ref=""/>
    	
    ===================================== 填空 =====================================	
    ①②③④⑤⑥⑦⑧⑨⑩
    
    ------①----------------------②---------③--------------
    
    1,name属性:
    	填①
    2,class属性：
    	填②
    3,column属性：
    	在many-to-one中：写name属性值加id后缀。
    	在一对多的<key>中：写对方类的表达此关系的外键列名。
    	在多对多的<key>中：写自已类的名称加id后缀。
    	在多对多的many-to-many的column中：写对方类的名称加id后缀。

Configuration.cfg.xml

<!DOCTYPE hibernate-configuration PUBLIC
    	"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
    	"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
    
    <hibernate-configuration>
    	<session-factory name="foo">
    		
    		<property name="hibernate.dialect">
    			org.hibernate.dialect.MySQLDialect
    		</property>
    		<property name="connection.url">
    			jdbc:mysql://localhost:3306/hibernate_test
    		</property>
    		<property name="connection.driver_class">
    			com.mysql.jdbc.Driver
    		</property>
    		<property name="connection.username">root</property>
    		<property name="connection.password">root</property>
    
    		
    		
    		<property name="hibernate.hbm2ddl.auto">update</property>
    
    		
    		<property name="show_sql">true</property>
    
    		
    		
    		<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
    		
    		<property name="c3p0.min_size">5</property>
    		
    		<property name="c3p0.max_size">20</property>
    		
    		<property name="c3p0.timeout">120</property>
    		
    		<property name="c3p0.idle_test_period">3000</property>
    
    		
    		<mapping resource="cn/itcast/test/entity/Department.hbm.xml" />
    		<mapping resource="cn/itcast/test/entity/Employee.hbm.xml" />
    		<mapping resource="cn/itcast/test/entity/Privilege.hbm.xml" />
    		<mapping resource="cn/itcast/test/entity/UserAccount.hbm.xml" />
    	</session-factory>
    </hibernate-configuration>

Department

package cn.itcast.test.entity;
    
    import java.util.HashSet;
    import java.util.Set;
    
    /**
     * 实体：部门
     * 
     * @author 风清杨
     * @version V5.0
     */
    public class Department {
    	/** 部门编号 */
    	private Long id;
    	/** 部门名称 */
    	private String name;
    	/** 部门说明 */
    	private String description;
    	/** 部门员工 */
    	private Set<Employee> employee = new HashSet<Employee>();
    	/** 上级部门 */
    	private Department parent;
    	/** 下级部门 */
    	private Set<Department> children = new HashSet<Department>();
    
    	public Department() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	public Department(Long id, String name, String description, Set<Employee> employee, Department parent, Set<Department> children) {
    		super();
    		this.id = id;
    		this.name = name;
    		this.description = description;
    		this.employee = employee;
    		this.parent = parent;
    		this.children = children;
    	}
    
    	public Long getId() {
    		return id;
    	}
    
    	public void setId(Long id) {
    		this.id = id;
    	}
    
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    
    	public String getDescription() {
    		return description;
    	}
    
    	public void setDescription(String description) {
    		this.description = description;
    	}
    
    	public Set<Employee> getEmployee() {
    		return employee;
    	}
    
    	public void setEmployee(Set<Employee> employee) {
    		this.employee = employee;
    	}
    
    	public Department getParent() {
    		return parent;
    	}
    
    	public void setParent(Department parent) {
    		this.parent = parent;
    	}
    
    	public Set<Department> getchildren() {
    		return children;
    	}
    
    	public void setchildren(Set<Department> children) {
    		this.children = children;
    	}
    
    }

Employee

package cn.itcast.test.entity;
    
    import java.util.Date;
    
    /**
     * 实体：员工信息
     * 
     * @author 风清杨
     * @version V5.0
     */
    public class Employee {
    	/** 员工编号 */
    	private Long id;
    	/** 员工姓名 */
    	private String name;
    	/** 员工性别 */
    	private boolean gender;
    	/** 员工生日 */
    	private Date birthday;
    	/** 员工描述*/
    	private String description;
    	/** 员工部门 */
    	private Department department;
    	/** 员工账号 */
    	private UserAccount userAccount;
    
    	public Employee() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	public Employee(Long id, String name, boolean gender, Date birthday, String description, Department department, UserAccount userAccount) {
    		super();
    		this.id = id;
    		this.name = name;
    		this.gender = gender;
    		this.birthday = birthday;
    		this.description = description;
    		this.department = department;
    		this.userAccount = userAccount;
    	}
    
    	public Long getId() {
    		return id;
    	}
    
    	public void setId(Long id) {
    		this.id = id;
    	}
    
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    
    	public boolean isGender() {
    		return gender;
    	}
    
    	public void setGender(boolean gender) {
    		this.gender = gender;
    	}
    
    	public Date getBirthday() {
    		return birthday;
    	}
    
    	public void setBirthday(Date birthday) {
    		this.birthday = birthday;
    	}
    
    	public String getDescription() {
    		return description;
    	}
    
    	public void setDescription(String description) {
    		this.description = description;
    	}
    
    	public Department getDepartment() {
    		return department;
    	}
    
    	public void setDepartment(Department department) {
    		this.department = department;
    	}
    
    	public UserAccount getUserAccount() {
    		return userAccount;
    	}
    
    	public void setUserAccount(UserAccount userAccount) {
    		this.userAccount = userAccount;
    	}
    
    }

UserAccount

package cn.itcast.test.entity;
    
    import java.util.HashSet;
    import java.util.Set;
    
    /**
     * 实体：用户的账号
     * 
     * @author 风清杨
     * @version V5.0
     */
    public class UserAccount {
    	/** 账号编号 */
    	private Long id;
    	/** 账号用户名 */
    	private String loginName;
    	/** 账号密码 */
    	private String password;
    	/** 账号员工 */
    	private Employee employee;
    	/** 账号权限 */
    	private Set<Privilege> privileges = new HashSet<Privilege>();
    
    	public UserAccount() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	public UserAccount(Long id, String loginName, String password, Employee employee, Set<Privilege> privileges) {
    		super();
    		this.id = id;
    		this.loginName = loginName;
    		this.password = password;
    		this.employee = employee;
    		this.privileges = privileges;
    	}
    
    	public Long getId() {
    		return id;
    	}
    
    	public void setId(Long id) {
    		this.id = id;
    	}
    
    	public String getLoginName() {
    		return loginName;
    	}
    
    	public void setLoginName(String loginName) {
    		this.loginName = loginName;
    	}
    
    	public String getPassword() {
    		return password;
    	}
    
    	public void setPassword(String password) {
    		this.password = password;
    	}
    
    	public Employee getEmployee() {
    		return employee;
    	}
    
    	public void setEmployee(Employee employee) {
    		this.employee = employee;
    	}
    
    	public Set<Privilege> getPrivileges() {
    		return privileges;
    	}
    
    	public void setPrivileges(Set<Privilege> privileges) {
    		this.privileges = privileges;
    	}
    
    }

Privilege

package cn.itcast.test.entity;
    
    import java.util.HashSet;
    import java.util.Set;
    
    /**
     * 实体：权限
     * 
     * @author 风清杨
     * @version V5.0
     */
    public class Privilege {
    	/** 权限编号 */
    	private Long id;
    	/** 权限名称 */
    	private String action;
    	/** 权限员工 */
    	private Set<UserAccount> userAccount = new HashSet<UserAccount>();
    
    	public Privilege() {
    		super();
    		// TODO Auto-generated constructor stub
    	}
    
    	public Privilege(Long id, String action, Set<UserAccount> userAccount) {
    		super();
    		this.id = id;
    		this.action = action;
    		this.userAccount = userAccount;
    	}
    
    	public Long getId() {
    		return id;
    	}
    
    	public void setId(Long id) {
    		this.id = id;
    	}
    
    	public String getAction() {
    		return action;
    	}
    
    	public void setAction(String action) {
    		this.action = action;
    	}
    
    	public Set<UserAccount> getUserAccount() {
    		return userAccount;
    	}
    
    	public void setUserAccount(Set<UserAccount> userAccount) {
    		this.userAccount = userAccount;
    	}
    
    }

Department.hbm.xml

<?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC 
    	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    
    <hibernate-mapping package="cn.itcast.test.entity">
    	
    	<class name="Department" table="t_department">
    		<id name="id" type="long" column="id">
    			<generator class="native" />
    		</id>
    		<property name="name" type="string" column="name" />
    
    		
    		<set name="employee">
    			<key column="departmentId" />
    			<one-to-many class="Employee" />
    		</set>
    
    		
    		<many-to-one name="parent" class="Department" column="parentId" />
    
    		
    		<set name="children">
    			<key column="parentId" />
    			<one-to-many class="Department" />
    		</set>
    	</class>
    
    </hibernate-mapping>

Employee.hbm.xml

<?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC 
    	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    
    <hibernate-mapping package="cn.itcast.test.entity">
    	
    	<class name="Employee" table="t_employee">
    		<id name="id" type="long" column="id">
    			<generator class="native" />
    		</id>
    		<property name="name" type="string" column="name"></property>
    		<property name="gender" type="boolean" column="gender"></property>
    		<property name="birthday" type="date" column="birthday"></property>
    		<property name="description" type="string" column="description"></property>
    
    		
    		<many-to-one name="department" class="Department" column="departmentId" />
    		
    		
    		<one-to-one name="userAccount" class="UserAccount" property-ref="employee"/>
    	</class>
    
    </hibernate-mapping>

UserAccount.hbm.xml

<?xml version="1.0"?>
    <!DOCTYPE hibernate-mapping PUBLIC 
    	"-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    	"http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd">
    
    <hibernate-mapping package="cn.itcast.test.entity">
    	
    	<class name="UserAccount" table="t_useraccount">
    		<id name="id" type="long" column="id">
    			<generator class="native" />
    		</id>
    		<property name="loginName" type="string" column="loginName"></property>
    		<property name="password" type="string" column="password"></property>
    
    		
    		<many-to-one name="employee" class="Employee" column="employeeId" unique="true" />
    
    		
    		<set name="privileges" table="t_userAccount_privilege">
    			<key column="userAccountId" />
    			<many-to-many class="Privilege" column="privilegeId" />
    		</set>
    		
    	</class>
    
    </hibernate-mapping>

Privilege.hbm.xml