SSH—员工管理模块之添加员工.删除.修改

悠悠 2022-06-14 08:58 223阅读 0赞

我的员工管理界面中，员工和小组属于多对一关系，小组和到部门属于多对一关系，这几张表关联在一块。

emp:

/*
    Navicat MySQL Data Transfer
    
    Source Server         : localhost_3306
    Source Server Version : 50515
    Source Host           : localhost:3306
    Source Database       : message
    
    Target Server Type    : MYSQL
    Target Server Version : 50515
    File Encoding         : 65001
    
    Date: 2017-06-15 17:38:40
    */
    
    SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for `emp`
    -- ----------------------------
    DROP TABLE IF EXISTS `emp`;
    CREATE TABLE `emp` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `name` varchar(255) DEFAULT NULL,
      `tid` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`),
      KEY `tid` (`tid`),
      CONSTRAINT `tid` FOREIGN KEY (`tid`) REFERENCES `team` (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=301004 DEFAULT CHARSET=utf8;
    
    -- ----------------------------
    -- Records of emp
    -- ----------------------------
    INSERT INTO `emp` VALUES ('101001', '陈龙', '101');
    INSERT INTO `emp` VALUES ('102001', '廖梦琪', '102');
    INSERT INTO `emp` VALUES ('103001', '王梦', '103');
    INSERT INTO `emp` VALUES ('201001', '陈韩', '201');
    INSERT INTO `emp` VALUES ('202001', '韩梦', '202');
    INSERT INTO `emp` VALUES ('301001', '王哥', '301');
    INSERT INTO `emp` VALUES ('301002', '罗哥', '302');
    INSERT INTO `emp` VALUES ('301003', '林丽丽', '101');

team:  
/\*  
Navicat MySQL Data Transfer  
  
  
Source Server         : localhost\_3306  
Source Server Version : 50515  
Source Host           : localhost:3306  
Source Database       : message  
  
  
Target Server Type    : MYSQL  
Target Server Version : 50515  
File Encoding         : 65001  
  
  
Date: 2017-06-15 17:38:33  
\*/  
  
  
SET FOREIGN\_KEY\_CHECKS=0;  
  
  
\-- ----------------------------  
\-- Table structure for \`team\`  
\-- ----------------------------  
DROP TABLE IF EXISTS \`team\`;  
CREATE TABLE \`team\` (  
  \`id\` int(11) NOT NULL AUTO\_INCREMENT,  
  \`team\` varchar(255) DEFAULT NULL,  
  \`dip\` int(11) DEFAULT NULL,  
  \`resp\` varchar(255) DEFAULT NULL,  
  PRIMARY KEY (\`id\`),  
  KEY \`dip\` (\`dip\`),  
  CONSTRAINT \`dip\` FOREIGN KEY (\`dip\`) REFERENCES \`department\` (\`id\`)  
) ENGINE=InnoDB AUTO\_INCREMENT=303 DEFAULT CHARSET=utf8;  
  
  
\-- ----------------------------  
\-- Records of team  
\-- ----------------------------  
INSERT INTO \`team\` VALUES ('101', '收银组', '1', '收银');  
INSERT INTO \`team\` VALUES ('102', '前台组', '1', '存放东西');  
INSERT INTO \`team\` VALUES ('103', '客服组', '1', '接打电话');  
INSERT INTO \`team\` VALUES ('201', '质检组', '2', '检验质量');  
INSERT INTO \`team\` VALUES ('202', '监督组', '2', '监督各小组');  
INSERT INTO \`team\` VALUES ('301', '保安组', '3', '维护秩序');  
INSERT INTO \`team\` VALUES ('302', '巡查组', '3', '巡查仓库');

图片![Center][]

这里不再叙述删除和修改和查询，这两个功能和前面会员账号管理中的功能重复，不再记录。

新增：

![Center 1][]

这里面的部门，由于雇员表的外键关联小组表，所以这里需要将Team持久层的信息显示出来

public List<Team> insert() {
    		// TODO Auto-generated method stub
    		Session s=sessionFactory.openSession();
    		List<Team> list=s.createQuery("from Team").list();
    		return list;
    	}

但是添加到Emp表中是外键，所以里面value设置成team的主键。

添加功能核心代码：

持久层

public Emp(int id, String name, Team team) {
    	super();
    	this.id = id;
    	this.name = name;
    	this.team = team;
    }

业务层：

public void insert2(int id, String name, Team tid) {
    		// TODO Auto-generated method stub
    		 Session s=sessionFactory.openSession();
    		 Transaction t=s.beginTransaction();
    		 Emp emp =new Emp(id, name, tid);
    		 s.save(emp);
    		 t.commit();
    	}

action：

public String ensureIn(){
    		System.out.println(emp.getId());
    		System.out.println(emp.getName());
    		System.out.println(team.getId()+"forgin***************************");
    
    		ApplicationContext ac=new ClassPathXmlApplicationContext("applicationContext.xml");
    		 EmpInter emp1=(EmpInter) ac.getBean("empImp");
    		 emp1.insert2(emp.getId(), emp.getName(), team);
    		 System.out.println("*********");
    		return "ensureIn";
    	}

效果图：

![Center 2][]

[Center]: /images/20220614/2b3b23f1dc784199abed57c724df30ee.png
[Center 1]: /images/20220614/19ccfeb9771649318395ba3e11062337.png
[Center 2]: /images/20220614/d8d49a05297e4e268bdcf947f77a869d.png