编写外网可访问接口

编写外网可访问接口

1. 创建工程
   打开idea: File -> New -> Project-> Spring Intializr-> 编写项目信息;
2. 导入依赖
   ① Web相关

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

② Mybatis相关

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.1.2</version>
</dependency>

③ 数据库相关

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

④ 测试相关

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
    <exclusions>
        <exclusion>
            <groupId>org.junit.vintage</groupId>
            <artifactId>junit-vintage-engine</artifactId>
        </exclusion>
    </exclusions>
</dependency>

⑤ 数据转发视图相关

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>

⑥ Lombok

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
</dependency>

3. 添加注解
   在工程Application文件中配置Mapper包扫描
   @MapperScan(“cn.bite.a01.mapper”)
4. 配置数据库连接
   在工程application.properties文件中配置数据库信息

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/main?characterEncoding=utf8&useSSL=false&serverTimezone=Asia/Shanghai&rewriteBatchedStatements=true
spring.datasource.username=root
spring.datasource.password=root

5. 编写实体类对象实现序列化接口

@Data
public class User implements Serializable {
    private Integer id;
    private String name;
    
}

6. 编写Mapper接口

public interface UserMapper {
    @Select("select name from user where id=#{id}")
    String selectUsernameById(Integer id);

    @Select("select * from user")
    List<User> getUsers();
}

7. 编写Controller

@Controller
public class UserController {
    @Resource
    UserMapper userMapper;

    @GetMapping("/get")
    @ResponseBody
    public List<User> getUsers(){
        List<User> users = userMapper.getUsers();
        return users;
    }
}

8. 启动项目
9. 访问: http://localhost:8080/get