SpringBoot+mybatis+mysql接口开发
文章目录
项目地址,略有不同,可以参考:https://download.csdn.net/download/qq_38234785/20010725
下载不了的,下方留邮箱
一、项目搭建
1、选择“Spring Initializr”
2、选择配置
Web下勾选Spring Web Start,(网上创建springboot项目多是勾选Web选项,而较高版本的Springboot没有此选项,勾选Spring Web Start即可,2.1.8版本是Spring Web);Template Englines勾选Thymeleaf;SQL勾选:MySQL Driver,JDBC API 和 MyBatis Framework三项;点击next;
3、新建的项目目录
4、新建项目启动初始化页面
5、Controller编写
新建controller文件夹,在controller文件夹下建一个简单的helloController类;(Controller类要添加@Controller注解,项目启动时,SpringBoot会自动扫描加载Controller)
package com.example.demo.controller;
import com.example.demo.bean.UserBean;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
public class helloController {
@RequestMapping("/index")
public String sayHello(){
return "index";
}
}
6、添加数据信息
在resources文件夹下application中先配置DataSource基本信息,application文件有两种文件格式,一种是以.properties为后缀,一种是以.yml为后缀的,两种配置方式略有差别,详情可参考这个网址:https://blog.csdn.net/qq_29648651/article/details/78503853;在这我是用.yml后缀的文件格式。右键application文件选择Refact,选择Rename,将后缀改为yml;
spring:
datasource:
name: healthmanagement #数据库名
url: jdbc:mysql://localhost:3306/blockchain #url
username: root #用户名
password: 123456 #密码
driver-class-name: com.mysql.jdbc.Driver #数据库链接驱动
7、运行DemoApplication.java
返回项目启动页面
也可以返回一个用户的json数据,一下步骤可不做:
新建两个类
Userbean.java
package com.example.demo.bean;
public class UserBean {
private int id;
private String name;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
userController.java
package com.example.demo.controller;
import com.example.demo.bean.UserBean;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("UserBean")
public class userController {
@RequestMapping("getUser")
public UserBean test(){
UserBean user = new UserBean();
user.setId(1);
user.setName("zhanghaoliang");
user.setPassword("1231");
return user;
}
}
8、连接数据库
使用的数据库连接驱动版本是:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.23</version>
<scope>runtime</scope>
</dependency>
测试数据库连接是否成功
9、SpringBoot项目结构
(1)DAO层:包括XxxMapper.java(数据库访问接口类),XxxMapper.xml(数据库链接实现);(这个命名,有人喜欢用Dao命名,有人喜欢用Mapper,看个人习惯了吧)
(2)Bean层:也叫model层,模型层,entity层,实体层,就是数据库表的映射实体类,存放POJO对象;
(3)Service层:也叫服务层,业务层,包括XxxService.java(业务接口类),XxxServiceImpl.java(业务实现类);(可以在service文件夹下新建impl文件放业务实现类,也可以把业务实现类单独放一个文件夹下,更清晰)
(4)Web层:就是Controller层,实现与web前端的交互。
(1)在application配置文件中添加MyBatis配置:
spring:
datasource:
name: test #数据库名
url: jdbc:mysql://47.94.148.82:3306/test #url
username: newroot #用户名
password: 123456 #密码
driver-class-name: com.mysql.jdbc.Driver #数据库链接驱动
mybatis:
mapper-locations: classpath:mapper/*.xml #配置映射文件
type-aliases-package: com.example.test.bean #配置实体类
(2)Bean实体类,依据数据库表
package com.example.demo.bean;
public class UserBean {
private int id;
private String name;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
(3)DAO层访问数据库接口文件
package com.example.demo.mapper;
import com.example.demo.bean.UserBean;
public interface UserMapper {
UserBean getInfo(String name, String password);
}
(4)DAO层访问数据库实现文件
(需在resource包下创建mapper文件夹,然后再创建一个UserMapper.xml.在application配置文件中mybatis:mapper-locations:对应的就是该文件地址),注意标签的namespace属性要填写 访问数据库接口类文件路径:
<?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.demo.mapper.UserMapper">
<select id="getInfo" parameterType="String" resultType="com.example.demo.bean.UserBean">
SELECT * FROM user WHERE name = #{name} AND password = #{password}
</select>
</mapper>
(5)Service层业务接口类编写:
package com.example.demo.service;
import com.example.demo.bean.UserBean;
public interface UserService {
UserBean loginIn(String name, String password);
}
(6)Service层业务实现类编写,注意要注解@Service,注入DAO
serviceImpl>UserServiceImpl.java
package com.example.demo.serviceImpl;
import com.example.demo.bean.UserBean;
import com.example.demo.mapper.UserMapper;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@Service
public class UserServiceImpl implements UserService {
//将DAO注入Service层
@Autowired
private UserMapper userMapper;
@Override
public UserBean loginIn(String name, String password) {
return userMapper.getInfo(name, password);
}
}
(7)项目启动类要添加注解@MapperScan项目启动时扫描mapper接口,否则会报错找不到mapper文件:
DemoApplication.java
package com.example.demo;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.example.demo.mapper")
public class DemoApplication {
public static void main(String[] args) {
SpringApplication.run(DemoApplication.class, args);
}
}
(8)编辑用户接口
controller>userController.java
package com.example.demo.controller;
import com.example.demo.bean.UserBean;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("user")
public class userController {
@Autowired
UserService userService;
@RequestMapping("getuser")
public String test(){ // 返回测试字符串
return "test getuser";
}
@RequestMapping("login")
public UserBean login(String name, String password){ // 接受前端传来的参数 name, password
UserBean userBean = userService.loginIn(name, password); // 数据库查询结果
return userBean;
}
}
访问:http://localhost:8080/user/getuser
访问:http://localhost:8080/user/login?name=slh&password=123455
二、端口调试篇(Postman)
1、下载并注册postman
2、新建一个collection
重命名一下
3、添加一个请求
右键刚才新建的文件夹 Add Request
4、用这种方式调试上面两个API
访问:http://localhost:8080/user/getuser
访问:http://localhost:8080/user/login
5、添加全局变量
点击右上角的眼镜,添加一个springUrl变量为:http://localhost:8080