SpringBoot模擬員工數據庫并實現增刪改查操作

更新時間：2021年09月20日 11:19:08 作者：夜色架構師

這篇文章主要給大家介紹了關于SpringBoot模擬員工數據庫并實現增刪改查操作的相關資料,文中通過示例代碼介紹的非常詳細,對大家學習或者工作具有一定的參考學習價值,需要的朋友可以參考下

1：首先創(chuàng)建一個pojo層在里面定義數據

Department部門：

package com.example.springbootweb.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author ${范濤之}
 * @Description
 * @create 2021-09-19 10:25
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Department {
    private  Integer id;
    private String department;
}

Employee部門：

package com.example.springbootweb.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

/**
 * @author ${范濤之}
 * @Description
 * @create 2021-09-19 10:26
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
public class Employee {
    private Integer id;
    private  String lastname;
    private  String email;
    private  Integer gender; //0代表女 1代表男
    private  Department department;
    private Data birth;
}

請?zhí)砑訄D片描述

2：編寫dao層注入數據：

部門層：

package com.example.springbootweb.dao;

import com.example.springbootweb.pojo.Department;

import java.util.Collection;
import java.util.HashMap;
import java.util.Map;

/**
 * @author ${范濤之}
 * @Description
 * @create 2021-09-19 10:28
 */
//部門dao
public class DepartmentDao {
    //模擬數據庫中的數據

    private  static Map<Integer, Department> department = null;
    static {
        department = new HashMap<Integer,Department>(); //創(chuàng)建一個部門表

        department.put(101,new Department(101,"教學部"));
        department.put(102,new Department(101,"教研部"));
        department.put(103,new Department(101,"市場部"));
        department.put(104,new Department(101,"運營部"));
        department.put(105,new Department(101,"清潔部"));
    }

    //獲得所有部門信息
    public Collection<Department> getDepartment(){

        return  department.values();

    }
    //通過id得到部門
    public  Department getDepartment(Integer id){
        return  department.get(id);

    }

}

請?zhí)砑訄D片描述

員工層：

package com.example.springbootweb.dao;

import com.example.springbootweb.pojo.Department;
import com.example.springbootweb.pojo.Employee;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.HashMap;
import java.util.Map;

/**
 * @author ${范濤之}
 * @Description
 * @create 2021-09-19 10:44
 */
@Repository
public class EmployeeDao {

    //模擬數據庫中的數據
    private  static Map<Integer, Employee> employees = null;
    //員工有所屬的部門
    @Autowired
    private  DepartmentDao departmentDao;

    static {
        employees = new  HashMap<Integer,Employee>();

        employees.put(1001,new Employee(1001,"AA","2831826106@qq.com",1,new Department(101,"教學部")));
        employees.put(1002,new Employee(1002,"BB","2831826106@qq.com",1,new Department(101,"教研部")));
        employees.put(1003,new Employee(1003,"CC","2831826106@qq.com",1,new Department(101,"市場部")));
        employees.put(1004,new Employee(1004,"DD","2831826106@qq.com",1,new Department(101,"運營部")));
        employees.put(1005,new Employee(1005,"EE","2831826106@qq.com",1,new Department(101,"清潔部")));

    }
    
    //主鍵自增
    private  static  Integer ininID = 1006;
    // 增加一個員工
    public  void  save(Employee employee){
        if (employee.getId()== null){
            employee.setId(ininID++);
        }
        employee.setDepartment(departmentDao.getDepartmentByid(employee.getDepartment().getId()));
        
        employees.put(employee.getId(),employee);
        
    }
    //查詢全部員工
    public Collection<Employee> getAll(){
        return  employees.values();
    }
    //通過ID查詢員工
    public  Employee getEmployeeByid(Integer id){
        return  employees.get(id);
        
    }
    //刪除員工拖過ID
    public  void  delete(Integer id){
        employees.remove(id);
    }
    


}

部門層

package com.example.springbootweb.dao;

import com.example.springbootweb.pojo.Department;
import org.springframework.stereotype.Repository;

import java.util.Collection;
import java.util.HashMap;
import java.util.Map;

/**
 * @author ${范濤之}
 * @Description
 * @create 2021-09-19 10:28
 */
//部門dao
@Repository
public class DepartmentDao {
    //模擬數據庫中的數據

    private  static Map<Integer, Department> department = null;
    static {
        department = new HashMap<Integer,Department>(); //創(chuàng)建一個部門表

        department.put(101,new Department(101,"教學部"));
        department.put(102,new Department(101,"教研部"));
        department.put(103,new Department(101,"市場部"));
        department.put(104,new Department(101,"運營部"));
        department.put(105,new Department(101,"清潔部"));
    }

    //獲得所有部門信息
    public Collection<Department> getDepartmentByid(){

        return  department.values();

    }
    //通過id得到部門
    public  Department getDepartmentByid(Integer id){
        return  department.get(id);

    }

}