Hibernate第五课.docVIP

第五课 员工管理系统的升级 使用Struts+Hibernate完成员工管理系统 建立数据库和表 create database empdb go use empdb go --部门表 create table dep( depid int identity primary key, depname varchar(50) unique ) --职位表 create table positions( pid int identity primary key, pname varchar(50) not null unique ) --福利表 create table welfare( wid int identity primary key, wname varchar(50) not null unique ) --员工表 create table emp( eid int identity primary key, ename varchar(50), sex varchar(4), address varchar(150), birthday datetime, depid int not null references dep(depid), pid int not null references positions(pid), photo image ) --员工福利表 create table empwelfare( ewid int identity primary key, eid int not null references emp(eid), wid int not null references welfare(wid) ) --薪资表 create table salary( sid int identity primary key, smoney money, eid int not null unique references emp(eid) ) --插入基础数据 insert into dep values(技术部) insert into dep values(财务部) insert into dep values(市场部) insert into dep values(行政部) insert into dep values(人事部) insert into dep values(研发部) insert into positions values(软件工程师) insert into positions values(系统设计师) insert into positions values(财务专员) insert into positions values(测试工程师) insert into positions values(行政专员) insert into positions values(人事专员) insert into welfare values(三金) insert into welfare values(交通补助) insert into welfare values(住房补助) insert into welfare values(取暖费) insert into welfare values(降温费) insert into welfare values(通讯费) insert into welfare values(午餐费) 关系图如下: 实现步骤 在当前工程引入struts和hibernate组件包 生成pojo类和dao类 生成的实体类如下所示: (1)Dep.java package com.po; import java.util.HashSet; import java.util.Set; public class Dep implements java.io.Serializable { // Fields private Integer depid; private String depname; private Set emps = new HashSet(0); // Constructors /** default constructor */ public Dep() { } /** full constructor */ public Dep(String depname, Set emps) { this.depname = depname; this.emps = emps; } // Property access