springboot entity date_员工管理系统B站陈艳男老师的笔记(springboot 入门级)

1.项目开始

使用开发工具:IDEA

使用spring Initializr初始化一个springboot项目

选择配件时勾选springWeb和Thymeleaf

---

2.导入静态资源

将html放到templates目录下

---

3.配置文件中增添相关配置

使用的数据源是阿里巴巴的

在pom文件中添加相关依赖

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.19</version>
</dependency>

---

4.数据库库表设计

DROP TABLE IF EXISTS `t_emp`;
CREATE TABLE `t_emp` (
  `id` varchar(40) NOT NULL,
  `name` varchar(60) DEFAULT NULL,
  `salary` double(7,2) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  `bir` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;


-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` varchar(40) NOT NULL,
  `username` varchar(40) DEFAULT NULL,
  `realname` varchar(40) DEFAULT NULL,
  `password` varchar(40) DEFAULT NULL,
  `sex` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

---

5.编写实体类

emp实体类

使用了lombok省去了各种构造方法

package 

---

6.编写DAO

EmpDAO

package com.sawyer.dao;

import com.sawyer.entity.Emp;

import java.util.List;

public interface EmpDAO {
    List<Emp> findAll();

    void save(Emp emp);

    void delete(String id);

    Emp find(String id);

    void update(Emp emp);
}

---

7.编写Mapper

EmpDAOMapper

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.sawyer.dao.EmpDAO">

    <!--    查询所有-->
    <select id="findAll" resultType="Emp">

        select  id,name,salary,age,bir from t_emp
    </select>

    <!--    添加员工-->
    <insert id="save" parameterType="Emp">
        insert into t_emp values (#{id},#{name},#{salary},#{age},#{bir})
    </insert>

    <!--    删除员工-->
    <delete id="delete" parameterType="String">
        delete from t_emp where id=#{id}
    </delete>

    <!--    根据ID查询员工-->
    <select id="find" parameterType="String" resultType="Emp">
        select id,name,salary,age,bir from t_emp where id =#{id}
    </select>

    <!--    修改员工-->
    <update id="update" parameterType="Emp">
        update t_emp set name=#{name},salary=#{salary},age=#{age},bir=#{bir}
        where id=#{id}
    </update>
</mapper>

---

8.service层编写

EmpService

package 

empServiceimpl

package 

---

9.controller的编写

empController

@Controller

---

10.效果