Mybatis 配置文件
spring:application:name: springboot-mybatis-quickstart#数据库的连接信息datasource:type: com.alibaba.druid.pool.DruidDataSourceurl: jdbc:mysql://localhost:3306/web01driver-class-name: com.mysql.cj.jdbc.Driverusername: rootpassword: 1234
#配置Mybatis的相关配置
mybatis:configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImplmapper-locations: classpath:mapper/*.xml
Web进阶
新建项目步骤
开始工程搭建
每一个空项目创建好之后都需要去检查JDK版本
项目结构里面检查maven路径
更改字符集
安装依赖
创建，准备对应封装类和架构
接口开发（查询部门）
第77集 框架构建开始
package com.itheima.controller;import com.itheima.pojo.Dept;
import com.itheima.pojo.Result;
import com.itheima.service.DeptSerive;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController
public class DeptController {@Autowiredprivate DeptSerive deptSerive;//@RequestMapping(value = "/depts",method = RequestMethod.GET)//请求路径，就是浏览器要怎么搜出来@GetMapping("/depts")public Result List(){System.out.println("查询全部部门数据");List<Dept> deptList = deptSerive.findAll();return Result.success(deptList);}
}
package com.itheima.service.impl;import com.itheima.mapper.DeptMapper;
import com.itheima.pojo.Dept;
import com.itheima.service.DeptSerive;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class DeptServiceimpl implements DeptSerive {@Autowiredprivate DeptMapper deptMapper;@Overridepublic List<Dept> findAll() {return deptMapper.findAll();}
}
package com.itheima.service;import com.itheima.pojo.Dept;import java.util.List;public interface DeptSerive {/*** 查询所有的部门数据* @return*/List<Dept> findAll();
}
package com.itheima.mapper;import com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;import java.util.List;
@Mapper
public interface DeptMapper {/*** 查询所有的部门数据* @return*/@Select("select id, name, create_time, update_time from dept order by update_time desc ;")List<Dept> findAll();
}
下面是实体类
package com.itheima.pojo;import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;import java.time.LocalDateTime;@Data
@NoArgsConstructor
@AllArgsConstructor
public class Dept {private Integer id;private String name;private LocalDateTime createTime;private LocalDateTime updateTime;
}
package com.itheima.pojo;import lombok.Data;import java.io.Serializable;/*** 后端统一返回结果*/
@Data
public class Result {private Integer code; //编码：1成功，0为失败private String msg; //错误信息private Object data; //数据public static Result success() {Result result = new Result();result.code = 1;result.msg = "success";return result;}public static Result success(Object object) {Result result = new Result();result.data = object;result.code = 1;result.msg = "success";return result;}public static Result error(String msg) {Result result = new Result();result.msg = msg;result.code = 0;return result;}}
（推荐）
spring:application:name: tilas-web-management#数据库的连接信息datasource:url: jdbc:mysql://localhost:3306/tilasdriver-class-name: com.mysql.cj.jdbc.Driverusername: rootpassword: 1234
#配置Mybatis的相关配置
mybatis:configuration:log-impl: org.apache.ibatis.logging.stdout.StdOutImpl#配置映射，开启了驼峰命名映射的开关map-underscore-to-camel-case: true
package com.itheima.mapper;import com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;import java.util.List;
@Mapper
public interface DeptMapper {/*** 查询所有的部门数据* @return*///方式一：手动结果映射
// @Results({
// @Result(column = "create_time",property = "createTime"),
// @Result(column = "update_time",property = "updateTime")
// })//方式二：起别名//@Select("select id, name, create_time createTime, update_time updateTime from dept order by update_time desc ;")@Select("select id, name, create_time , update_time from dept order by update_time desc ;")List<Dept> findAll();
}
前后端联调
location ^~ /api/ {
rewrite ^/api/(.*)$ /$1 break;
proxy_pass http://localhost:8080;}
1. location ^~ /api/
^~是 Nginx 的匹配优先级标记，表示 “当路径以/api/开头时，优先匹配该location，不再检查后续的正则location（如~或~*开头的规则）”。- 作用：确保所有以
/api/开头的请求（如http://localhost:90/api/depts）都会进入该配置块处理。
2. rewrite ^/api/(.*)$ /$1 break;
这是核心的正则重写规则，用于修改请求路径：
-
正则部分
^/api/(.\*)$：^表示匹配字符串的开头；/api/是固定匹配的路径前缀；(.*)是捕获组，表示 “匹配任意字符（除换行外）任意次数”，并将匹配到的内容保存为变量$1；- $表示匹配字符串的结尾整体含义：“匹配以/api/开头，后面跟着任意内容的路径”。
-
替换部分
/$1：表示将原路径替换为 “
/加上捕获组$1中的内容”。
package com.itheima.controller;import com.itheima.pojo.Dept;
import com.itheima.pojo.Result;
import com.itheima.service.DeptSerive;
import jakarta.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;@RestController
public class DeptController {@Autowiredprivate DeptSerive deptSerive;//@RequestMapping(value = "/depts",method = RequestMethod.GET)//请求路径，就是浏览器要怎么搜出来/*** 查询部门* @return*/@GetMapping("/depts")//调用方式不一致：405public Result List(){System.out.println("查询全部部门数据");List<Dept> deptList = deptSerive.findAll();return Result.success(deptList);}// /**
// * 删除部门-方式1：HttpServletRequest 获取请求参数
// * @param request
// * @return
// */
// @DeleteMapping("/depts")
// public Result delete(HttpServletRequest request){
// String idStr = request.getParameter("id");
// int id = Integer.parseInt(idStr);
// System.out.println("根据ID删除部门："+id);
// return Result.success();
// }
// /**
// * 删除部门-方式2：@RequestParam
// * 一旦我们声明了@RequestParam，该参数在请求是必须；如果不传递会报错，（默认required为true）
// */
// @DeleteMapping("/depts")
// public Result delete(@RequestParam(value = "id",required = false) Integer deptId){
// System.out.println("根据ID删除部门："+deptId);//不传递参数的话，这个就是null
// return Result.success();
// }/*** 删除部门-方式3：省略@RequestParam（前端传递的请求参数名和服务端方法形参名字一致）*/@DeleteMapping("/depts")public Result delete(Integer id){System.out.println("根据ID删除部门："+id);//不传递参数的话，这个就是nullreturn Result.success();}
}
package com.itheima.controller;import com.itheima.pojo.Dept;
import com.itheima.pojo.Result;
import com.itheima.service.DeptSerive;
import jakarta.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;@RestController
public class DeptController {@Autowiredprivate DeptSerive deptSerive;//@RequestMapping(value = "/depts",method = RequestMethod.GET)//请求路径，就是浏览器要怎么搜出来/*** 查询部门* @return*/@GetMapping("/depts")//调用方式不一致：405public Result List(){System.out.println("查询全部部门数据");List<Dept> deptList = deptSerive.findAll();return Result.success(deptList);}// /**
// * 删除部门-方式1：HttpServletRequest 获取请求参数
// * @param request
// * @return
// */
// @DeleteMapping("/depts")
// public Result delete(HttpServletRequest request){
// String idStr = request.getParameter("id");
// int id = Integer.parseInt(idStr);
// System.out.println("根据ID删除部门："+id);
// return Result.success();
// }
// /**
// * 删除部门-方式2：@RequestParam
// * 一旦我们声明了@RequestParam，该参数在请求是必须；如果不传递会报错，（默认required为true）
// */
// @DeleteMapping("/depts")
// public Result delete(@RequestParam(value = "id",required = false) Integer deptId){
// System.out.println("根据ID删除部门："+deptId);//不传递参数的话，这个就是null
// return Result.success();
// }/*** 删除部门-方式3：省略@RequestParam（前端传递的请求参数名和服务端方法形参名字一致）*/@DeleteMapping("/depts")public Result delete(Integer id){System.out.println("根据ID删除部门："+id);//不传递参数的话，这个就是nulldeptSerive.deleteById(id);return Result.success();}
}
package com.itheima.mapper;import com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.*;import java.util.List;
@Mapper
public interface DeptMapper {/*** 查询所有的部门数据* @return*///方式一：手动结果映射
// @Results({
// @Result(column = "create_time",property = "createTime"),
// @Result(column = "update_time",property = "updateTime")
// })//方式二：起别名//@Select("select id, name, create_time createTime, update_time updateTime from dept order by update_time desc ;")@Select("select id, name, create_time , update_time from dept order by update_time desc ;")List<Dept> findAll();/*** 根据id删除部门* @param id*/@Delete("delete from dept where id = #{id}")void deteleById(Integer id);
}
package com.itheima.service;import com.itheima.pojo.Dept;import java.util.List;public interface DeptSerive {/*** 查询所有的部门数据* @return*/List<Dept> findAll();/*** 根据id删除部门的方法* @param id*/void deleteById(Integer id);
}
package com.itheima.service.impl;import com.itheima.mapper.DeptMapper;
import com.itheima.pojo.Dept;
import com.itheima.service.DeptSerive;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;import java.util.List;@Service
public class DeptServiceimpl implements DeptSerive {@Autowiredprivate DeptMapper deptMapper;@Overridepublic List<Dept> findAll() {return deptMapper.findAll();}@Overridepublic void deleteById(Integer id) {deptMapper.deteleById(id);}
}