01-项目搭建

前端项目搭建

参见yuque

后端项目搭建

1、下载并导入springboot工程
https://start.spring.io/

2、添加依赖

<!-- 热部署模块 -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-devtools</artifactId>
        <scope>runtime</scope>
    </dependency>
    <!-- mybatis新增 begin -->
    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>2.0.1</version>
    </dependency>
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
        <scope>runtime</scope>
    </dependency>
    <!--mybatis end -->

添加MyBatis相关配置

server.port=8082

\u914D\u7F6E\u6570\u636E\u6E90\u4FE1\u606F

spring.datasource.url=jdbc:mysql://localhost:3306/java7?characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=root

\u914D\u7F6Emapper\u6620\u5C04\u6587\u4EF6\u8DEF\u5F84

mybatis.mapper-locations=classpath:mapper/*.xml

\u914D\u7F6E\u626B\u63CF\u5B9E\u4F53\u5305\uFF0C\u7ED9\u5B9E\u4F53\u7C7B\u8BBE\u7F6E\u522B\u540D

mybatis.type-aliases-package=com.example.study7.domain

改造主启动类

    @SpringBootApplication
    @MapperScan("com.example.study7.mapper")
    public class Study7Application {
    
        public static void main(String[] args) {
            SpringApplication.run(Study7Application.class, args);
        }
    
    }

写测试

@GetMapping("/findAll")
   public List<Dept> findAll(){
       return service.findAll();
   }

@GetMapping("/findById")
   public Dept findById(int id){
       return service.findById(id);
   }


    @Service
    public class DeptServiceImpl implements IDeptService {
        @Autowired
        DeptMapper mapper;
        @Override
        public List<Dept> findAll() {
            return mapper.findAll();
        }
        @Override
        public Dept findById(int id) {
            // TODO Auto-generated method stub
            return mapper.findById(id);
        }
    
    }


    public interface DeptMapper {
        
       public List<Dept> findAll();
       @Select("select * from dept where deptno=#{id}")
       public Dept findById(int id);
    }

    <?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.example.study7.mapper.DeptMapper">
        
        <select id = "findAll"  resultType="Dept">
            select * from dept
        </select>
    </mapper>