一、创建Springboot项目
二、搭建数据库环境
在本地新建数据库,创建表结构
二、SpringBoot集成Mybatis-plus
1、pom.xml添加依赖
2、在application-dev.yml文件中,配置mybatis-plus,还要配置数据源及数据库连接参数
3、代码部分,包括entity、dao、service、serviceImpl和controller5个类以及resource里面对应的.xml文件
4、测试
三、Springboot集成Swagger
1、pom.xml添加依赖
2、在application-dev.yml文件中,配置swagger
2、使用注解来进行启动swagger,即
(1)添加 @Configuration 注解,用于定义配置类,方便被Spring Boot配置;
(2)添加 @EnableSwagger2 注解启动 Swagger 文档构建能力
3、配置Controller
4、测试,地址:IP地址:端口号/swagger-ui.html
延伸:Swagger 是一个规范和完整的框架,用于生成、描述、调用和可视化 RESTful 风格的 Web 服务
四、业务逻辑操作
使用小案例讲解带参数的查询数据的实现过程,如商品
1、entity类
实体类被实例化,实现Serializable
@Data
@TableName("tb_goods")
public class SysGoodEntity implements Serializable {
private static final long serialVersionUID = 1L;
@TableId
private Long goodsId;
private String name;
private String intro;
private BigDecimal price;
private Integer num;
}
2、.yml
<?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>
<resultMap id="goodsMap" type="io.renren.modules.sys.entity">
<result property="goodsId" column="goods_id"/>
<result property="name" column="name"/>
<result property="intro" column="intro"/>
<result property="price" column="price"/>
<result property="num" column="num"/>
</resultMap>
</mapper>
<select id="queryResumeByUserName" resultType="com.example.employ.modules.entity.ResumeEntity">
select * from resume where sname = #{sname}
</select>
3、dao类,接口类
@Mapper
public interface SysGoodDao extends BaseMapper<SysGoodEntity> {
}
ResumeEntity queryResumeByUserName(String sname);
4、service类(定义方法)
public interface SysGoodService extends IService<SysGoodEntity> {
PageUtils queryPage(Map<String, Object> params);
}
ResumeEntity queryResumeByUserName(String username);
5、serviceImpl类(实现方法)
@Service("sysGoodsService")
public class SysGoodServiceImpl extends ServiceImpl<SysGoodDao, SysGoodEntity> implements SysGoodService {
@Override
public PageUtils queryPage(Map<String, Object> params) {
IPage<SysGoodEntity> page = this.page(
new Query<SysGoodEntity>().getPage(params),
new QueryWrapper<SysGoodEntity>()
);
return new PageUtils(page);
}
}
@Override
public ResumeEntity queryResumeByUserName(String username) {
return this.baseMapper.queryResumeByUserName(username);
}
延伸:Springboot的entity,dao,service,controller层级理解点击链接:
https://blog.csdn.net/weixin_44495678/article/details/106396908
6、controller类
@RequestMapping("/queryResumeByUserName")
public R queryResumeByUserName(String sname){
ResumeEntity resumeEntity = this.resumeService.queryResumeByUserName(sname);
return R.ok().put("data", JSON.toJSONString(resumeEntity));
}
7、ajax技术(前端技术,实现前后端数据的交互)
<script type="text/javascript">
let _user = null;
function init_data () {
$.ajax({
url: 'http://127.0.0.1:8000/generator/resume/queryResumeByUserName',
type: "get",
dataType: "json",
data: {
"sname": getCookie("username")
},
// contentType: "application/json;charset=utf-8",
success: function(resultVal) {
if (resultVal.code === 0) {
console.log(resultVal.data)
let info = JSON.parse(resultVal.data)
document.getElementById("sname").value = info.sname
} else {
alert(resultVal.msg);
}
}
});