{"id":1770,"date":"2025-09-08T19:44:39","date_gmt":"2025-09-08T11:44:39","guid":{"rendered":"https:\/\/zero-zl.cn\/?p=1770"},"modified":"2025-09-09T19:19:42","modified_gmt":"2025-09-09T11:19:42","slug":"05-springboot3vue3%e5%ae%9e%e7%8e%b0%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e3%80%81%e5%88%86%e9%a1%b5%e6%9f%a5%e8%af%a2%e3%80%81%e6%89%b9%e9%87%8f%e5%88%a0%e9%99%a4%ef%bc%88%e4%b8%8a%ef%bc%89","status":"publish","type":"post","link":"https:\/\/zero-zl.cn\/index.php\/2025\/09\/08\/05-springboot3vue3%e5%ae%9e%e7%8e%b0%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5%e3%80%81%e5%88%86%e9%a1%b5%e6%9f%a5%e8%af%a2%e3%80%81%e6%89%b9%e9%87%8f%e5%88%a0%e9%99%a4%ef%bc%88%e4%b8%8a%ef%bc%89\/","title":{"rendered":"05.Springboot3+vue3\u5b9e\u73b0\u589e\u5220\u6539\u67e5\u3001\u5206\u9875\u67e5\u8be2\u3001\u6279\u91cf\u5220\u9664\uff08\u4e0a\uff09"},"content":{"rendered":"\n

\u5b89\u88c5axios\u5c01\u88c5\u524d\u540e\u7aef\u5bf9\u63a5\u6570\u636e\u5de5\u5177<\/h2>\n\n\n\n
npm i axios -S<\/code><\/pre>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u7b80\u5355\u6d4b\u8bd5axios<\/h2>\n\n\n\n
axios.get('http:\/\/localhost:9999\/admin\/selectAll').then(res => {\n  console.log(res)\n})<\/code><\/pre>\n\n\n\n
\u8de8\u57df\u5904\u7406<\/h2>\n\n\n\n
\u8de8\u57df\u9519\u8bef<\/h3>\n\n\n\n
has been blocked by CORS policy: No ‘Access-Control-Allow-Origin’ header is present on the requested resource.<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5728spring boot\u91cc\u9762\u8bbe\u7f6e\u7edf\u4e00\u7684\u8de8\u57df\u5904\u7406<\/h3>\n\n\n\n
common\/CorsConfig.java<\/p>\n\n\n\n
package org.example.springdemo.common;\n\nimport org.springframework.context.annotation.Bean;\nimport org.springframework.context.annotation.Configuration;\nimport org.springframework.web.cors.CorsConfiguration;\nimport org.springframework.web.cors.UrlBasedCorsConfigurationSource;\nimport org.springframework.web.filter.CorsFilter;\n\n\/**\n * \u8de8\u57df\u914d\u7f6e\u7c7b\n *\/\n\n@Configuration\npublic class CorsConfig {\n\n    @Bean\n    public CorsFilter corsFilter() {\n        UrlBasedCorsConfigurationSource source = new UrlBasedCorsConfigurationSource();\n        CorsConfiguration corsConfiguration = new CorsConfiguration();\n        corsConfiguration.addAllowedOrigin(\"*\");    \/\/1 \u8bbe\u7f6e\u8bbf\u95ee\u6e90\u5730\u5740\n        corsConfiguration.addAllowedHeader(\"*\");    \/\/2 \u8bbe\u7f6e\u8bbf\u95ee\u6e90\u8bf7\u6c42\u5934\n        corsConfiguration.addAllowedMethod(\"*\");    \/\/3 \u8bbe\u7f6e\u8bbf\u95ee\u6e90\u8bf7\u6c42\u65b9\u6cd5\n        source.registerCorsConfiguration(\"\/**\", corsConfiguration); \/\/4 \u5bf9\u63a5\u53e3\u914d\u7f6e\u8de8\u57df\u8bbe\u7f6e\n        return new CorsFilter(source);\n    }\n\n}\n<\/code><\/pre>\n\n\n\n
\u91cd\u542f\u540e\u7aef\u518d\u6b21\u6d4b\u8bd5<\/h3>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5c01\u88c5\u7edf\u4e00\u7684\u8bf7\u6c42\u5de5\u5177<\/h2>\n\n\n\n
src\/utils\/request.js<\/h3>\n\n\n\n
import axios from \"axios\";\nimport {ElMessage} from \"element-plus\";\n\nconst request = axios.create({\n    baseURL: \"http:\/\/localhost:9999\",\n    timeout: 3000   \/\/\u540e\u53f0\u63a5\u53e3\u8d85\u65f6\u65f6\u95f4\n})\n\n\/\/request\u62e6\u622a\u5668\n\/\/\u53ef\u4ee5\u81ea\u8bf7\u6c42\u53d1\u9001\u524d\u5bf9\u8bf7\u6c42\u505a\u4e00\u4e9b\u5904\u7406\nrequest.interceptors.request.use(config => {\n    config.headers['Content-Type'] = 'application\/json;charset=utf-8';\n    return config\n}, error => {\n    return Promise.reject(error)\n});\n\n\/\/response\u62e6\u622a\u5668\n\/\/\u53ef\u4ee5\u5728\u63a5\u53e3\u54cd\u5e94\u540e\u5bf9\u6570\u636e\u7edf\u4e00\u5904\u7406\nrequest.interceptors.response.use(\n    response => {\n        let res = response.data;\n        if(typeof res == 'string'){\n            res = res ? JSON.parse(res) : res;\n        }\n        return res;\n    },\n    error => {\n        if (error.response) {\n            if (error.response.status === 404) {\n                ElMessage.error(\"\u672a\u627e\u5230\u8bf7\u6c42\u63a5\u53e3\")\n            } else if (error.response.status === 500) {\n                ElMessage.error(\"\u7cfb\u7edf\u5f02\u5e38\uff0c\u8bf7\u67e5\u770b\u540e\u7aef\u63a7\u5236\u53f0\u62a5\u9519\")\n            }\n        } else {\n            ElMessage.error(\"\u7f51\u7edc\u9519\u8bef\uff0c\u8bf7\u68c0\u67e5\u8fde\u63a5\")\n            console.error(error.message)\n        }\n        return Promise.reject(error)\n    }\n)\n\nexport default request<\/code><\/pre>\n\n\n\n
\u4f7f\u7528request\u5de5\u5177\u53d1\u8d77\u4e00\u6b21\u8bf7\u6c42<\/p>\n\n\n\n
request.get('\/admin\/selectAll').then(res => {\n  if (res.code === 200) {\n    console.log(res)\n  }else{\n    ElMessage.error(res.msg)\n  }\n})<\/code><\/pre>\n\n\n\n
\u83b7\u53d6\u7684\u6570\u636e\u6837\u4f8b\uff1a<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5206\u9875\u67e5\u8be2<\/h2>\n\n\n\n
\u5206\u9875\u5bf9\u8c61<\/h3>\n\n\n\n
total\uff1a\u6570\u636e\u5e93\u8868\u6240\u6709\u6570\u636e\u7684\u4e2a\u6570
list\uff1a\u8fd4\u56de\u7684\u6570\u636e\u6570\u7ec4
pageNum\uff1a\u5f53\u524d\u9875\u7801
pageSize\uff1a\u6bcf\u9875\u5c55\u793a\u7684\u4e2a\u6570<\/p>\n\n\n\n
\u4f7f\u7528 PageHelper \u63d2\u4ef6<\/h3>\n\n\n\n
\u5728pom.xml\u91cc\u6dfb\u52a0\u4f9d\u8d56<\/p>\n\n\n\n
        <dependency>\n            <groupId>com.github.pagehelper<\/groupId>\n            <artifactId>pagehelper-spring-boot-starter<\/artifactId>\n            <version>1.4.6<\/version>\n            <exclusions>\n                <exclusion>\n                    <groupId>org.mybatis<\/groupId>\n                    <artifactId>mybatis<\/artifactId>\n                <\/exclusion>\n            <\/exclusions>\n        <\/dependency><\/code><\/pre>\n\n\n\n
\u540e\u7aef\u8fd4\u56de\u7684\u5206\u9875\u5bf9\u8c61<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5b8c\u6574\u7684\u5206\u9875\u67e5\u8be2\u8bf7\u6c42\u65b9\u6cd5<\/h3>\n\n\n\n
    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-table :data=\"data.tableData\" style=\"width: 100%\" :header-cell-style=\"{ color: '#333',backgroundColor: '#eaf4ff' }\">\n        <el-table-column type=\"selection\" width=\"55\" \/>\n        <el-table-column prop=\"username\" label=\"\u8d26\u53f7\" \/>\n        <el-table-column prop=\"name\" label=\"\u540d\u79f0\" \/>\n        <el-table-column prop=\"phone\" label=\"\u7535\u8bdd\" \/>\n        <el-table-column prop=\"email\" label=\"\u90ae\u7bb1\" \/>\n      <\/el-table>\n    <\/div>\n    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-pagination\n          v-model:current-page=\"data.pageNum\"\n          :page-size=\"data.pageSize\"\n          layout=\"total, prev, pager, next\"\n          :total=\"data.total\"\n          @current-change=\"load\"\n      \/>\n    <\/div><\/code><\/pre>\n\n\n\n
const load = () => {\n  request.get(\"\/admin\/selectPage\",{\n    params: {\n      pageNum: data.pageNum,\n      pageSize: data.pageSize\n    }\n  }).then(res => {\n    if (res.code === '200'){\n      data.tableData = res.data.list\n      data.total = res.data.total\n    } else {\n      ElMessage.error(res.msg)\n    }\n  })\n}\nload()<\/code><\/pre>\n\n\n\n
\u6761\u4ef6\u67e5\u8be2<\/h2>\n\n\n\n
\u524d\u7aef\u4f20\u5165\u6761\u4ef6\uff0c\u540e\u7aef\u7ed9\u51fa\u7ed3\u679c\uff0c\u6ce8\u610f\u770bsql\u8bed\u53e5<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u5728\u7f51\u7edc\u8bf7\u6c42\u7684\u8f7d\u8377\u91cc\u9762\u6709\u6570\u636e<\/p>\n\n\n\n
\"\"<\/div><\/figure>\n\n\n\n
\u6761\u4ef6\u67e5\u8be2\u7684sql\u8bed\u53e5<\/h3>\n\n\n\n
    <select id=\"selectAll\" resultType=\"org.example.springdemo.entity.Admin\">\n        select * from `admin`\n        <where>\n            <if test=\"username != null\">username like concat('%',#{username},'%')<\/if>\n            <if test=\"name != null\">and name like concat('%',#{name},'%')<\/if>  <!--\u76f8\u5f53\u4e8e name like '%1%'-->\n        <\/where>\n        order by id desc\n    <\/select><\/code><\/pre>\n\n\n\n
vue\u8c03\u7528<\/h3>\n\n\n\n
const data = reactive({\n  username: null,\n  name: null,\n  pageNum: 1,\n  pageSize: 5,\n  total: 0,\n  tableData: []\n});\n\nconst load = () => {\n  request.get(\"\/admin\/selectPage\",{\n    params: {\n      pageNum: data.pageNum,\n      pageSize: data.pageSize,\n      username: data.username,\n      name: data.name\n    }\n  }).then(res => {\n    if (res.code === '200'){\n      data.tableData = res.data.list\n      data.total = res.data.total\n    } else {\n      ElMessage.error(res.msg)\n    }\n  })\n}\nload()<\/code><\/pre>\n\n\n\n
\u4ee3\u7801\u6848\u4f8b<\/h2>\n\n\n\n
Admin.vue<\/h3>\n\n\n\n
<template>\n  <div>\n    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-input clearable @clear=\"load\" style=\"width: 260px; margin-right: 5px;\" v-model=\"data.username\" placeholder=\"\u8bf7\u8f93\u5165\u8d26\u53f7\u67e5\u8be2\" :prefix-icon=\"Search\"><\/el-input>\n      <el-input clearable @clear=\"load\" style=\"width: 260px; margin-right: 5px;\" v-model=\"data.name\" placeholder=\"\u8bf7\u8f93\u5165\u540d\u79f0\u67e5\u8be2\" :prefix-icon=\"Search\"><\/el-input>\n      <el-button type=\"primary\" @click=\"load\">\u67e5\u8be2<\/el-button>\n      <el-button type=\"info\" @click=\"reset\">\u91cd\u7f6e<\/el-button>\n    <\/div>\n    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-button type=\"danger\">\u6279\u91cf\u5220\u9664<\/el-button>\n      <el-button type=\"primary\">\u65b0 \u589e<\/el-button>\n      <el-button type=\"success\">\u6279\u91cf\u5bfc\u5165<\/el-button>\n      <el-button type=\"info\">\u6279\u91cf\u5bfc\u51fa<\/el-button>\n    <\/div>\n    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-table :data=\"data.tableData\" style=\"width: 100%\" :header-cell-style=\"{ color: '#333',backgroundColor: '#eaf4ff' }\">\n        <el-table-column type=\"selection\" width=\"55\" \/>\n        <el-table-column prop=\"username\" label=\"\u8d26\u53f7\" \/>\n        <el-table-column prop=\"name\" label=\"\u540d\u79f0\" \/>\n        <el-table-column prop=\"phone\" label=\"\u7535\u8bdd\" \/>\n        <el-table-column prop=\"email\" label=\"\u90ae\u7bb1\" \/>\n      <\/el-table>\n    <\/div>\n    <div class=\"card\" style=\"margin-bottom: 5px\">\n      <el-pagination\n          v-model:current-page=\"data.pageNum\"\n          v-model:page-size=\"data.pageSize\"\n          layout=\"total, sizes, prev, pager, next, jumper\"\n          :page-sizes=\"[5, 10, 20]\"\n          :total=\"data.total\"\n          @current-change=\"load\"\n          @size-change=\"load\"\n      \/>\n    <\/div>\n  <\/div>\n<\/template>\n\n<script setup>\nimport { reactive } from \"vue\";\nimport {Search} from \"@element-plus\/icons-vue\";\nimport request from \"@\/utils\/request.js\";\nimport {ElMessage} from \"element-plus\";\n\nconst data = reactive({\n  username: null,\n  name: null,\n  pageNum: 1,\n  pageSize: 5,\n  total: 0,\n  tableData: []\n});\n\nconst load = () => {\n  request.get(\"\/admin\/selectPage\",{\n    params: {\n      pageNum: data.pageNum,\n      pageSize: data.pageSize,\n      username: data.username,\n      name: data.name\n    }\n  }).then(res => {\n    if (res.code === '200'){\n      data.tableData = res.data.list\n      data.total = res.data.total\n    } else {\n      ElMessage.error(res.msg)\n    }\n  })\n}\nload()\n\nconst reset = () => {\n  data.username = null\n  data.name = null\n  load()\n}\n\n<\/script><\/code><\/pre>\n\n\n\n
AdminController<\/h3>\n\n\n\n
package org.example.springdemo.controller;\n\nimport com.github.pagehelper.PageInfo;\nimport jakarta.annotation.Resource;\nimport org.example.springdemo.common.Result;\nimport org.example.springdemo.entity.Admin;\nimport org.example.springdemo.service.AdminService;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RequestMapping;\nimport org.springframework.web.bind.annotation.RequestParam;\nimport org.springframework.web.bind.annotation.RestController;\n\nimport java.util.List;\n\n@RestController\n@RequestMapping(\"\/admin\")\npublic class AdminController {\n\n    @Resource\n    AdminService adminService;\n\n    @GetMapping(\"\/selectAll\")   \/\/\u5b8c\u6574\u7684\u8bf7\u6c42\u8def\u5f84\u4e3a\uff1ahttp:\/\/localhost:9999\/admin\/selectAll\n    public Result selectAll()\n    {\n        List<Admin> adminList = adminService.selectAll();\n        return Result.success(adminList);\n    }\n\n\n    \/**\n     * \u5206\u9875\u67e5\u8be2\n     * pageNum:\u5f53\u524d\u9875\u7801\n     * pageSize:\u6bcf\u9875\u663e\u793a\u7684\u8bb0\u5f55\u6570\n     *\/\n    @GetMapping(\"\/selectPage\")\n    public Result selectPage(@RequestParam(defaultValue = \"1\") Integer pageNum,\n                             @RequestParam(defaultValue = \"10\") Integer pageSize,\n                             Admin admin)\n    {\n        PageInfo<Admin> pageInfo = adminService.selectPage(pageNum, pageSize, admin);\n        return Result.success(pageInfo);    \/\/\u8fd4\u56de\u7684\u662f\u5206\u9875\u7684\u5bf9\u8c61\n    }\n}<\/code><\/pre>\n\n\n\n
AdminService<\/h3>\n\n\n\n
package org.example.springdemo.service;\n\nimport com.github.pagehelper.PageHelper;\nimport com.github.pagehelper.PageInfo;\nimport jakarta.annotation.Resource;\nimport org.example.springdemo.entity.Admin;\nimport org.example.springdemo.mapper.AdminMapper;\nimport org.springframework.stereotype.Service;\n\nimport java.util.List;\n\n@Service\npublic class AdminService {\n\n    @Resource\n    AdminMapper adminMapper;\n\n    public List<Admin> selectAll() {\n\n        return adminMapper.selectAll(null);\n    }\n\n    public PageInfo<Admin> selectPage(Integer pageNum, Integer pageSize, Admin admin) {\n        \/\/\u5f00\u542f\u5206\u9875\u67e5\u8be2\n        PageHelper.startPage(pageNum, pageSize);\n        List<Admin> list = adminMapper.selectAll(admin);\n        return PageInfo.of(list);\n    }\n}\n<\/code><\/pre>\n\n\n\n
AdminMapper.xml<\/h3>\n\n\n\n
<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n<!DOCTYPE mapper\n        PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\n        \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\n<mapper namespace=\"org.example.springdemo.mapper.AdminMapper\">\n\n    <select id=\"selectAll\" resultType=\"org.example.springdemo.entity.Admin\">\n        select * from `admin`\n        <where>\n            <if test=\"username != null\">username like concat('%',#{username},'%')<\/if>\n            <if test=\"name != null\">and name like concat('%',#{name},'%')<\/if>  <!--\u76f8\u5f53\u4e8e name like '%1%'-->\n        <\/where>\n        order by id desc\n    <\/select>\n\n<\/mapper><\/code><\/pre>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5b89\u88c5axios\u5c01\u88c5\u524d\u540e\u7aef\u5bf9\u63a5\u6570\u636e\u5de5\u5177 \u7b80\u5355\u6d4b\u8bd5axios \u8de8\u57df\u5904\u7406 \u8de8\u57df\u9519\u8bef has been blocked […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[114,102],"tags":[],"class_list":["post-1770","post","type-post","status-publish","format-standard","hentry","category-spring-boot3vue3","category-102"],"_links":{"self":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1770","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/comments?post=1770"}],"version-history":[{"count":4,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1770\/revisions"}],"predecessor-version":[{"id":1785,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/posts\/1770\/revisions\/1785"}],"wp:attachment":[{"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/media?parent=1770"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/categories?post=1770"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zero-zl.cn\/index.php\/wp-json\/wp\/v2\/tags?post=1770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}