"use strict"; const {Fragment: _Fragment, jsx: _jsx, jsxs: _jsxs} = arguments[0]; function _createMdxContent(props) { const _components = { a: "a", br: "br", code: "code", figure: "figure", h2: "h2", h3: "h3", h4: "h4", img: "img", li: "li", p: "p", pre: "pre", span: "span", strong: "strong", ul: "ul", ...props.components }; return _jsxs(_Fragment, { children: [_jsx(_components.h2, { children: "一、准备工作：" }), "\n", _jsx(_components.h3, { children: "1、工具准备" }), "\n", _jsxs(_components.p, { children: ["IDEA", _jsx(_components.br, {}), "\n", "Mysql", _jsx(_components.br, {}), "\n", "Navicate", _jsx(_components.br, {}), "\n", "JDK", _jsx(_components.br, {}), "\n", _jsx(_components.a, { href: "https://so.csdn.net/so/search?q=Postman&spm=1001.2101.3001.7020", children: "Postman" }), _jsx(_components.br, {}), "\n", "俗话说的好，工欲善其事必先利其器嘛，所以这些开发工具要安装好。安装完成后就进入项目的准备工作。"] }), "\n", _jsx(_components.h3, { children: "2、项目准备" }), "\n", _jsxs(_components.p, { children: ["前往", _jsx(_components.a, { href: "http://start.spring.io%EF%BC%8C%E7%94%9F%E6%88%90%E4%B8%80%E4%B8%AASpringBoot%E9%A1%B9%E7%9B%AE", children: "http://start.spring.io，生成一个SpringBoot项目" })] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124524.png", alt: "image-20220818211215464" }) }), "\n", _jsx(_components.p, { children: "创建一个Mysql表，用于测试数据" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "sql", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "sql", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "DROP" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " TABLE" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " IF" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " EXISTS" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "api_test" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CREATE" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " TABLE" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "api_test" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "` (" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "id" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " int" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NOT NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " AUTO_INCREMENT," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "name" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " varchar" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "12" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CHARACTER" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " SET" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4 " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "COLLATE" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4_0900_ai_ci " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " DEFAULT" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "address" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " varchar" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "255" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CHARACTER" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " SET" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4 " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "COLLATE" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4_0900_ai_ci " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " DEFAULT" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "age" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " int" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " DEFAULT" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "sex" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " char" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "2" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CHARACTER" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " SET" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4 " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "COLLATE" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4_0900_ai_ci " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " DEFAULT" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " `" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "phone" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " varchar" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "20" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CHARACTER" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " SET" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4 " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "COLLATE" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4_0900_ai_ci " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " DEFAULT" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " NULL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " PRIMARY KEY" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "id" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "`" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "USING" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " BTREE" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ") ENGINE " }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " InnoDB " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "CHARACTER" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " SET" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4 " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "COLLATE" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " utf8mb4_0900_ai_ci ROW_FORMAT " }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " Dynamic" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " })] }) }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "sql", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "sql", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "INSERT INTO" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " api_test (" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "address" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", age, sex, phone) " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "VALUES" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "张三" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "北京四合院儿" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "18" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "男" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "13823123456" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ");" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "INSERT INTO" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " api_test (" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "address" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", age, sex, phone) " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "VALUES" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "李四" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "山东菏泽曹县" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "16" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "男" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "13832131254" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ");" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "INSERT INTO" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " api_test (" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "address" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", age, sex, phone) " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "VALUES" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "王五" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "广东河源紫金" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "13" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "女" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "13123555131" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ");" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "INSERT INTO" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " api_test (" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "address" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", age, sex, phone) " }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "VALUES" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "赵六" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "homeless" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: "20" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "男" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ", " }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "13512312455" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: ");" })] })] }) }) }), "\n", _jsx(_components.h2, { children: "二、开发" }), "\n", _jsx(_components.h3, { children: "1、打开文件" }), "\n", _jsx(_components.p, { children: "上面的我们下载的文件引入IDEA中后，会是这个样子。" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124601.png", alt: "image-20220818213007523" }) }), "\n", _jsx(_components.h3, { children: "2、连接数据库。" }), "\n", _jsxs(_components.p, { children: ["我们需要先连接数据库，数据库位置位于", _jsx(_components.strong, { children: "src/resource/application.properties" })] }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "properties", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "properties", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "server.port" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "8001" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "spring.datasource.url" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "jdbc:mysql://localhost:3306/test?" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "serverTimezone" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "GMT%2B8&" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "characterEncoding" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "utf-8&" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "useSSL" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "false" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "spring.datasource.username" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "root" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "spring.datasource.password" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "password" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "spring.datasource.driver-class-name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "=" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#D8DEE9FF" }, children: "com.mysql.cj.jdbc.Driver" })] })] }) }) }), "\n", _jsxs(_components.p, { children: ["上面就是需要配置连接数据库的设置。", _jsx(_components.br, {}), "\n", "第二个红框中的是需要设置的服务端口号，这个可以自己修改测试。", _jsx(_components.br, {}), "\n", "第三个细的红框是需要注意的地方，一定是自己的存放表的数据库的名称。"] }), "\n", _jsx(_components.h3, { children: "3、数据查询" }), "\n", _jsx(_components.p, { children: "接下来分层来创建类，SSM框架中的分层及其作用如下" }), "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["\n", _jsx(_components.p, { children: "entity层" }), "\n", _jsxs(_components.p, { children: ["同类： ", _jsx(_components.a, { href: "https://so.csdn.net/so/search?q=model&spm=1001.2101.3001.7020", children: "model" }), "层 = entity层 = domain层"] }), "\n", _jsxs(_components.p, { children: ["作用：用于存放我们的", _jsx(_components.a, { href: "https://so.csdn.net/so/search?q=%E5%AE%9E%E4%BD%93%E7%B1%BB&spm=1001.2101.3001.7020", children: "实体类" }), "，与数据库中的属性值基本保持一致。"] }), "\n"] }), "\n", _jsxs(_components.li, { children: ["\n", _jsx(_components.p, { children: "mapper层" }), "\n", _jsx(_components.p, { children: "同类： mapper层 = dao层" }), "\n", _jsx(_components.p, { children: "作用：对数据库进行数据持久化操作，他的方法语句是直接针对数据库操作的" }), "\n"] }), "\n", _jsxs(_components.li, { children: ["\n", _jsx(_components.p, { children: "service层" }), "\n", _jsx(_components.p, { children: "同类：只有一个 service层" }), "\n", _jsx(_components.p, { children: "作用： service层是针对 controller层的 controller，也就是针对我们使用者。service的 impl 是把mapper和service进行整合的文件。" }), "\n"] }), "\n", _jsxs(_components.li, { children: ["\n", _jsx(_components.p, { children: "controller层" }), "\n", _jsx(_components.p, { children: "同类： controller层 = web 层" }), "\n", _jsx(_components.p, { children: "作用：控制器，导入service层，因为service中的方法是我们使用到的，controller通过接收前端传过来的参数进行业务操作，再将处理结果返回到前端。" }), "\n"] }), "\n"] }), "\n", _jsx(_components.p, { children: "其他包：" }), "\n", _jsxs(_components.ul, { children: ["\n", _jsxs(_components.li, { children: ["\n", _jsx(_components.p, { children: "domain" }), "\n", _jsx(_components.p, { children: "在domain包下面的实体类，其中的属性会包含数据库中的字段，还可以包含其他的自定义属性。" }), "\n"] }), "\n", _jsxs(_components.li, { children: ["\n", _jsxs(_components.p, { children: ["vo", _jsx(_components.br, {}), "\n", "在vo包下面的实体类，其中的属性与数据库并没有关系，因为它们是用来和前端进行交互的数据类。"] }), "\n"] }), "\n", _jsxs(_components.li, { children: ["\n", _jsxs(_components.p, { children: ["pojo", _jsx(_components.br, {}), "\n", "在pojo包下面的实体类并没有严格定义，可以看做是entity、domain、vo的集合包。"] }), "\n"] }), "\n"] }), "\n", _jsx(_components.h4, { children: "（一）创建实体类" }), "\n", _jsxs(_components.p, { children: ["在你创建的包名下新建一个包名为", _jsx(_components.code, { children: "entity" }), "用于存放实体类，并创建一个名为", _jsx(_components.code, { children: "User" }), "的实体类"] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124620.png", alt: "image-20220818213819680" }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "package" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "entity" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " lombok" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Data" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Data" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " class" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " id" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " name" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " address" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " age" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " sex" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " phone" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "}" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " })] }) }) }), "\n", _jsx(_components.h4, { children: "（二）创建数据操作接口" }), "\n", _jsxs(_components.p, { children: ["在你创建的包名下新建一个包名为", _jsx(_components.code, { children: "mapper" }), "用于存放mapper层类，并创建一个名为", _jsx(_components.code, { children: "UserMapper" }), "的接口"] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124642.png", alt: "image-20220818231738382" }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "package" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "mapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "entity" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "apache" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "ibatis" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "annotations" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#81A1C1" }, children: "*" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "springframework" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "transaction" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "annotation" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Transactional" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " java" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "util" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " interface" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " UserMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Select" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "select * from api_test" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " findAll" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "()" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Insert" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "INSERT INTO api_test (name, address, age, sex, phone) VALUES (#{name}, #{address}, #{age}, #{sex}, #{phone});" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#EBCB8B" }, children: "\\n" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Transactional" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " save" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Update" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "UPDATE api_test SET name=#{name}, address=#{address}, age=#{age}, sex=#{sex}, phone=#{phone} WHERE id = #{id}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Transactional" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " updateUserById" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Delete" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "delete from api_test where id = #{id}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " deleteUserById" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Long" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " id" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Select" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "select * from api_test WHERE id = #{id}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " User" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " getById" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Long" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " id" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Select" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "select * from api_test limit #{offset}, #{pageSize}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " findByPage" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " offset" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "}" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: " " })] }) }) }), "\n", _jsx(_components.h4, { children: "（三）创建控制层类来写向外传输数据的接口" }), "\n", _jsxs(_components.p, { children: ["在你创建的包名下新建一个包名为", _jsx(_components.code, { children: "controller" }), "用于存放controller层类，并创建一个名为", _jsx(_components.code, { children: "UserController" }), "的类"] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124655.png", alt: "image-20220818223646844" }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "package" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "controller" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "entity" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "mapper" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "UserMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "springframework" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "web" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "bind" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "annotation" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#81A1C1" }, children: "*" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " javax" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "annotation" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Resource" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " java" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "util" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RestController" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestMapping" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "/user" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " class" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " UserController" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Resource" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " UserMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: " // 查找数据接口" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "GetMapping" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "()" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " getUser" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "findAll" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "()" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " }" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: " // 增加数据接口" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "PostMapping" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " addUser" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestBody" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "save" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "success" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " }" }) }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "}" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " })] }) }) }), "\n", _jsx(_components.h4, { children: "（四）运行项目" }), "\n", _jsx(_components.p, { children: "代码写完了，下面把项目运行起来。回到谷歌浏览器中检查一下。注意地址要写正确。别忘了加上面@RequesMapping中后的那个路径" }), "\n", _jsx(_components.p, { children: "到ApitestApplication类中添加包扫描后运行" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124711.png", alt: "image-20220818223904162" }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "package" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "mybatis" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "spring" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "annotation" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "MapperScan" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "springframework" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "boot" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "SpringApplication" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " org" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "springframework" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "boot" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "autoconfigure" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "SpringBootApplication" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "SpringBootApplication" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "MapperScan" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "com.yzh.apitest.mapper" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " class" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " ApitestApplication" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "\tpublic" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " static" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " main" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "String" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "[]" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-light-font-style": "italic", "--shiki-dark": "#D8DEE9", "--shiki-dark-font-style": "inherit" }, children: " args" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: "\t\tSpringApplication" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "run" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: "ApitestApplication" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: "class" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " args" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "\t}" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "}" }) })] }) }) }), "\n", _jsxs(_components.p, { children: ["接着到浏览器中访问接口即可接收到数据 ", _jsx(_components.a, { href: "http://localhost:port/user", children: "http://localhost:port/user" })] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124735.png", alt: "image-20220818224231522" }) }), "\n", _jsx(_components.h3, { children: "4、数据增加" }), "\n", _jsx(_components.p, { children: "步骤同上，如果有照着上面的步骤打齐代码，数据增加不需要新增代码" }), "\n", _jsx(_components.h4, { children: "（一）先写增加数据的mysql数据库语句" }), "\n", _jsx(_components.p, { children: "前文已经写了，增加的内容在UserMapper中的save方法" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Insert" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "INSERT INTO api_test (name, address, age, sex, phone) VALUES (#{name}, #{address}, #{age}, #{sex}, #{phone});" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#EBCB8B" }, children: "\\n" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Transactional" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " save" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] })] }) }) }), "\n", _jsx(_components.h4, { children: "（二）在controller中写向外暴露的接口" }), "\n", _jsx(_components.p, { children: "前文也写了捏，是PostMapping注解下的addUser方法" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "PostMapping" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " addUser" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestBody" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "save" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "success" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "}" }) })] }) }) }), "\n", _jsx(_components.h4, { children: "（三）在Postman中测试接口" }), "\n", _jsx(_components.p, { children: "Post方法无法直接使用路由器访问，所以需要使用Postman来测试接口" }), "\n", _jsxs(_components.p, { children: ["接口地址仍然是", _jsx(_components.a, { href: "http://localhost:port/user", children: "http://localhost:port/user" })] }), "\n", _jsxs(_components.p, { children: ["请求方式选择", _jsx(_components.code, { children: "Post" }), "，在Body处，选择row并且选择JSON格式，按照字段来添加信息"] }), "\n", _jsx(_components.p, { children: "成功则返回success" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124827.png", alt: "image-20220818225530407" }) }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124841.png", alt: "image-20220818225703053" }) }), "\n", _jsx(_components.p, { children: "可以看到成功插入了数据" }), "\n", _jsx(_components.h3, { children: "5、数据修改" }), "\n", _jsx(_components.h4, { children: "（一）在UserMapper接口中写入更新的语句" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Insert" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "INSERT INTO api_test (name, address, age, sex, phone) VALUES (#{name}, #{address}, #{age}, #{sex}, #{phone});" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#EBCB8B" }, children: "\\n" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Transactional" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " save" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] })] }) }) }), "\n", _jsx(_components.h4, { children: "（二）在controller中写向外的接口" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: "// 修改数据接口" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "PutMapping" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " updateUser" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestBody" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " User" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " user" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "updateUserById" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "user" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "update success" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "}" }) })] }) }) }), "\n", _jsx(_components.h4, { children: "（三）在Postman中测试接口" }), "\n", _jsxs(_components.p, { children: ["接口地址仍然是", _jsx(_components.a, { href: "http://localhost:port/user", children: "http://localhost:port/user" })] }), "\n", _jsxs(_components.p, { children: ["请求方式选择", _jsx(_components.code, { children: "Put" }), "，在Body处，选择row并且选择JSON格式，按照字段来添加信息"] }), "\n", _jsx(_components.p, { children: "成功则返回update success" }), "\n", _jsx(_components.p, { children: "如：修改上文数据增加中的小别扇为蔡徐坤" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124902.png", alt: "image-20220818231626363" }) }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124916.png", alt: "image-20220818231639710" }) }), "\n", _jsx(_components.p, { children: "可以看到更新成功" }), "\n", _jsx(_components.h3, { children: "6、数据删除" }), "\n", _jsx(_components.h4, { children: "（一）写语句" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Delete" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "delete from api_test where id = #{id}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "void" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " deleteUserById" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Long" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " id" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] })] }) }) }), "\n", _jsx(_components.h4, { children: "（二）写接口" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: "// 删除数据接口" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "DeleteMapping" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "/{id}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " String" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " deleteUser" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "PathVariable" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "id" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Long" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " id" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "deleteUserById" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "id" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "delete success" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "}" }) })] }) }) }), "\n", _jsx(_components.h4, { children: "（三）在Postman中测试接口" }), "\n", _jsxs(_components.p, { children: ["接口地址是", _jsx(_components.a, { href: "http://localhost:port/user/id", children: "http://localhost:port/user/id" })] }), "\n", _jsxs(_components.p, { children: ["请求方式选择", _jsx(_components.code, { children: "Delete" })] }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124935.png", alt: "image-20220818232641070" }) }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_124948.png", alt: "image-20220818232656189" }) }), "\n", _jsx(_components.h3, { children: "7、分页查询" }), "\n", _jsx(_components.h4, { children: "（一）创建类" }), "\n", _jsx(_components.p, { children: "首先创建一个vo包，在里面创建一个page类" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_125007.png", alt: "image-20220818233900838" }) }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "package" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: " com" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "yzh" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "apitest" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#8FBCBB" }, children: "vo" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " lombok" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Data" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "import" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " java" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "util" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Data" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " class" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "T" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " {" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " pageNum" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " total" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " private" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "T" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " data" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "}" }) }), "\n", _jsx(_components.span, { "data-line": "", children: " " })] }) }) }), "\n", _jsx(_components.h4, { children: "（二）Mapper中写sql" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: "// 翻页查询的语句" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Select" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "select * from api_test limit #{offset}, #{pageSize}" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "List" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " findByPage" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " offset" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: "// 统计列数的语句" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "Select" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "select count(id) from user" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " conutUser" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "()" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] })] }) }) }), "\n", _jsx(_components.h4, { children: "（三）Controller写分页接口" }), "\n", _jsx(_components.figure, { "data-rehype-pretty-code-figure": "", children: _jsx(_components.pre, { style: { "--shiki-light": "#abb2bf", "--shiki-dark": "#d8dee9ff", "--shiki-light-bg": "#282c34", "--shiki-dark-bg": "#2e3440ff" }, tabIndex: "0", "data-language": "java", "data-theme": "one-dark-pro nord", children: _jsxs(_components.code, { "data-language": "java", "data-theme": "one-dark-pro nord", style: { display: "grid" }, children: [_jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#7F848E", "--shiki-light-font-style": "italic", "--shiki-dark": "#616E88", "--shiki-dark-font-style": "inherit" }, children: "// 分页查询接口" }) }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "GetMapping" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "/page" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: "public" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Page" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: " findByPage" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "@" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestParam" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#D8DEE9" }, children: "defaultValue" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "1" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " pageNum" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "," })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: " @" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D08770" }, children: "RequestParam" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#D8DEE9" }, children: "defaultValue" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: " \"" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#A3BE8C" }, children: "10" }), _jsx(_components.span, { style: { "--shiki-light": "#98C379", "--shiki-dark": "#ECEFF4" }, children: "\"" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "){" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " offset" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: " (" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: "pageNum " }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: "-" }), _jsx(_components.span, { style: { "--shiki-light": "#D19A66", "--shiki-dark": "#B48EAD" }, children: " 1" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " *" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " List" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " userData" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "findByPage" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "offset" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "," }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: " pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: "User" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ">" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " new" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "<>" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "()" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "setData" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "userData" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#8FBCBB" }, children: " Integer" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9" }, children: " total" }), _jsx(_components.span, { style: { "--shiki-light": "#56B6C2", "--shiki-dark": "#81A1C1" }, children: " =" }), _jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " userMapper" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "conutUser" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "()" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: "；" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "setTotal" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "total" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "setPageNum" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "pageNum" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#E5C07B", "--shiki-dark": "#D8DEE9" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "." }), _jsx(_components.span, { style: { "--shiki-light": "#61AFEF", "--shiki-dark": "#88C0D0" }, children: "setPageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: "(" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#D8DEE9FF" }, children: "pageSize" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#ECEFF4" }, children: ")" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: " " }), "\n", _jsxs(_components.span, { "data-line": "", children: [_jsx(_components.span, { style: { "--shiki-light": "#C678DD", "--shiki-dark": "#81A1C1" }, children: " return" }), _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#D8DEE9FF" }, children: " page" }), _jsx(_components.span, { style: { "--shiki-light": "#ABB2BF", "--shiki-dark": "#81A1C1" }, children: ";" })] }), "\n", _jsx(_components.span, { "data-line": "", children: _jsx(_components.span, { style: { "--shiki-light": "#E06C75", "--shiki-dark": "#ECEFF4" }, children: "}" }) })] }) }) }), "\n", _jsx(_components.h4, { children: "（四）在Postman中测试接口" }), "\n", _jsxs(_components.p, { children: ["接口地址是", _jsx(_components.a, { href: "http://localhost:port/user/page", children: "http://localhost:port/user/page" })] }), "\n", _jsx(_components.p, { children: "传值方式选Params，传入页数pageNum和范围pageSize即可查询" }), "\n", _jsx(_components.p, { children: "成功返回Page<>的数据" }), "\n", _jsx(_components.p, { children: _jsx(_components.img, { src: "https://yuzoi-1255554319.cos.ap-chengdu.myqcloud.com/MarkDown/clipboard_20220825_125039.png", alt: "image-20220819000446222" }) }), "\n", _jsx(_components.h3, { children: "三、注解解释" }), "\n", _jsxs(_components.p, { children: [_jsx(_components.code, { children: "@RequestBody" }), "：主要用来接收前端传递给后端的json字符串中的数据的"] }), "\n", _jsxs(_components.p, { children: [_jsx(_components.code, { children: "@RequestParam" }), "：相比@RequestBody，可以接收多个参数"] }), "\n", _jsxs(_components.p, { children: [_jsx(_components.code, { children: "@PathVariable" }), "：映射 URL 绑定的占位符"] })] }); } function MDXContent(props = {}) { const {wrapper: MDXLayout} = props.components || ({}); return MDXLayout ? _jsx(MDXLayout, { ...props, children: _jsx(_createMdxContent, { ...props }) }) : _createMdxContent(props); } return { default: MDXContent };

评论区

评论区