{"id":2001,"date":"2017-06-16T11:16:25","date_gmt":"2017-06-16T03:16:25","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=2001"},"modified":"2026-08-18T11:23:50","modified_gmt":"2026-08-18T03:23:50","slug":"springboot%e4%b8%8emybatis%e9%9b%86%e6%88%90","status":"publish","type":"post","link":"https:\/\/ai.zhousir.top\/?p=2001","title":{"rendered":"SpringBoot\u4e0eMybatis\u96c6\u6210"},"content":{"rendered":"
\n

\u5728 Spring Boot \u91cc\u63a5 MyBatis\uff0c\u6838\u5fc3\u5c31\u4e94\u6b65\uff1astarter \u4f9d\u8d56<\/strong>\u3001\u5b9e\u4f53 \/ Mapper \/ XML\u3001application.yml<\/code> \u6570\u636e\u6e90\u3001Mapper \u626b\u63cf\u3001\u518d\u5199\u4e00\u4e2a\u767b\u5f55 Controller \u9a8c\u8bc1\u3002\u4e0b\u9762\u6309\u539f\u6587\u5de5\u7a0b com.ittx.java1608.sbdemo2<\/code> \u8d70\u4e00\u904d\u3002<\/p>\n

\u5305\u540d\u91cc\u7684 mybaits \u662f\u539f\u6587\u76ee\u5f55\u62fc\u5199\uff0c\u914d\u7f6e\u8def\u5f84\u4fdd\u6301\u539f\u6837\uff0c\u907f\u514d\u5bf9\u4e0d\u4e0a\u626b\u63cf\u3002<\/p>\n

\u4e00\u3001\u5f15\u5165\u4f9d\u8d56<\/h2>\n
<!-- mybatis\/spring \u5305 -->\n<dependency>\n    <groupId>org.mybatis.spring.boot<\/groupId>\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\n    <version>1.2.0<\/version>\n<\/dependency>\n\n<!-- mysql \u6570\u636e\u9a71\u52a8 -->\n<dependency>\n    <groupId>mysql<\/groupId>\n    <artifactId>mysql-connector-java<\/artifactId>\n<\/dependency><\/code><\/pre>\n
\u4e8c\u3001Bean\u3001\u63a5\u53e3\u548c\u6620\u5c04\u6587\u4ef6<\/h2>\n
\u5b9e\u4f53\u3001Dao \u63a5\u53e3\u548c Mapper XML \u53ef\u7528\u63d2\u4ef6\u751f\u6210\u3002\u5de5\u7a0b\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n
\"mybaits\"<\/a><\/p>\n
\u4e09\u3001application.yml\uff1a\u6570\u636e\u6e90\u548c Mapper \u626b\u63cf<\/h2>\n
spring:\n  mvc:\n    view:\n     prefix: \/WEB-INF\/views\/\n     suffix: .jsp\n  datasource:\n    driver-class-name: com.mysql.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/springboot?characterEncoding=utf8&useSSL=true\n    username: root\n    password: b123\nmybatis:\n  mapper-locations: classpath:com\/ittx\/java1608\/sbdemo2\/mapping\/*.xml\n\n# springboot \u4e2d\u914d\u7f6e mybatis \u65e5\u5fd7\u8f93\u51fa\nlogging:\n    level:\n        com.ittx.java1608.sbdemo2.dao: TRACE<\/code><\/pre>\n\n\n\n\n\n\n\n
\u914d\u7f6e\u9879<\/th>\n\u4f5c\u7528<\/th>\n<\/tr>\n<\/thead>\n
spring.datasource.*<\/code><\/td>\nJDBC \u8fde\u63a5 MySQL<\/td>\n<\/tr>\n
mybatis.mapper-locations<\/code><\/td>\n\u626b\u63cf mapping \u76ee\u5f55\u4e0b\u7684 XML<\/td>\n<\/tr>\n
logging.level...dao: TRACE<\/code><\/td>\n\u63a7\u5236\u53f0\u6253\u5370 Mapper SQL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\u56db\u3001MapperScannerConfigurer<\/h2>\n
\u76f8\u5f53\u4e8e\u4f20\u7edf xml \u91cc\u7684 MapperScannerConfigurer<\/code>\uff1a\u544a\u8bc9 Spring \u53bb\u54ea\u4e2a\u5305\u627e Dao \u63a5\u53e3\uff0c\u5e76\u7ed1\u5230 sqlSessionFactory<\/code>\u3002<\/p>\n
\/**\n * MyBatis \u626b\u63cf\u63a5\u53e3\n *  <!-- DAO \u63a5\u53e3\u6240\u5728\u5305\u540d\uff0cSpring \u4f1a\u81ea\u52a8\u67e5\u627e\u5176\u4e0b\u7684\u7c7b -->\n    <bean class=\"org.mybatis.spring.mapper.MapperScannerConfigurer\">\n        <property name=\"basePackage\" value=\"com.ittx.java1608.sbdemo2.dao\" \/>\n        <property name=\"sqlSessionFactoryBeanName\" value=\"sqlSessionFactory\"><\/property>\n    <\/bean>\n *\/\n@Configuration\npublic class MyBatisMapperScannerConfig {\n\n    @Bean\n    public MapperScannerConfigurer mapperScannerConfigurer() {\n        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();\n        mapperScannerConfigurer.setSqlSessionFactoryBeanName(\"sqlSessionFactory\");\n        mapperScannerConfigurer.setBasePackage(\"com.ittx.java1608.sbdemo2.dao\");\n        return mapperScannerConfigurer;\n    }\n}<\/code><\/pre>\n
\u4e94\u3001\u7528\u767b\u5f55\u63a5\u53e3\u9a8c\u8bc1<\/h2>\n
\u914d\u7f6e\u5b8c\u6210\u540e\uff0c\u6ce8\u5165 UserMapper<\/code> \u505a\u767b\u5f55\u6821\u9a8c\uff1a<\/p>\n
@Controller\npublic class LoginController {\n    @Autowired\n    private UserMapper userMapper;\n\n    @RequestMapping(\"\/login\")\n    public String login() {\n        return \"login\";\n    }\n\n    @RequestMapping(\"\/login_submit\")\n    public String loginSubmit(String username, String password, Model model) {\n        User user = userMapper.checkLogin(username, password);\n        if (user != null) {\n            model.addAttribute(\"message\", \"\u767b\u5f55\u6210\u529f!\");\n        } else {\n            model.addAttribute(\"message\", \"\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef!\");\n        }\n        return \"login\";\n    }\n}<\/code><\/pre>\n
\n
\u4e00\u53e5\u8bdd\u603b\u7ed3\uff1aSpring Boot \u96c6\u6210 MyBatis\uff1astarter + \u6570\u636e\u6e90 yml + mapper-locations + \u63a5\u53e3\u5305\u626b\u63cf\uff1b\u7528\u4e00\u6b21\u771f\u5b9e\u67e5\u8be2\uff08\u4f8b\u5982\u767b\u5f55\uff09\u786e\u8ba4 SQL \u80fd\u6253\u51fa\u6765\u3001\u7ed3\u679c\u80fd\u5c01\u88c5\u3002<\/strong><\/p>\n<\/blockquote>\n<\/section>\n","protected":false},"excerpt":{"rendered":"
\u5728 Spring Boot \u91cc\u63a5 MyBatis\uff0c\u6838\u5fc3\u5c31\u4e94\u6b65\uff1astarter \u4f9d\u8d56\u3001\u5b9e\u4f53 \/ Mapper \/ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[93],"tags":[188,184,186],"_links":{"self":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/2001"}],"collection":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2001"}],"version-history":[{"count":3,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/2001\/revisions"}],"predecessor-version":[{"id":2014,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/2001\/revisions\/2014"}],"wp:attachment":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2001"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}