{"id":2001,"date":"2017-06-16T11:16:25","date_gmt":"2017-06-16T03:16:25","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=2001"},"modified":"2017-06-16T11:44:44","modified_gmt":"2017-06-16T03:44:44","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":"

\u4e00\u3001SpringBoot\u4e0eMybatis\u96c6\u6210\u6b65\u9aa4\u5982\u4e0b<\/h2>\n

1. \u5f15\u5165mybatis-spring-boot\u76f8\u5173\u4f9d\u8d56<\/h3>\n

[java]<!– mybatis\/spring\u5305 –>
\n<dependency>
\n\t<groupId>org.mybatis.spring.boot<\/groupId>
\n\t<artifactId>mybatis-spring-boot-starter<\/artifactId>
\n\t<version>1.2.0<\/version>
\n<\/dependency><\/p>\n

<!– mysql\u6570\u636e\u9a71\u52a8 –>
\n<dependency>
\n\t<groupId>mysql<\/groupId>
\n\t<artifactId>mysql-connector-java<\/artifactId>
\n<\/dependency>[\/java]<\/p>\n

2. \u5b9e\u73b0mybaits\u76f8\u5173Bean\u7c7b,\u63a5\u53e3\u548c\u6620\u5c04\u6587\u4ef6(\u53ef\u7528\u63d2\u4ef6\u751f\u6210)<\/h3>\n

\"mybaits\"<\/a><\/p>\n

3. \u5728application.yml\u6587\u4ef6\u4e2d\u6dfb\u52a0\u6570\u636e\u6e90\u548cmybaits\u6620\u5c04\u6587\u4ef6\u626b\u63cf\u914d\u7f6e<\/h3>\n

[java] 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<\/p>\n

# springboot\u4e2d\u914d\u7f6emybaits\u65e5\u5fd7\u8f93\u51fa
\nlogging:
\n level:
\n com.ittx.java1608.sbdemo2.dao: TRACE<\/p>\n

[\/java]<\/p>\n

4. \u7f16\u5199\u5de5\u5177\u7c7b\u5b9e\u73b0sqlSessionFactory\u548cmybatis\u63a5\u53e3\u626b\u63cf<\/h3>\n

[java]\/**
\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\t<bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
\n\t\t<property name="basePackage" value="com.ittx.java1608.sbdemo2.dao" \/>
\n\t\t<property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"><\/property>
\n\t<\/bean>
\n *\/
\n@Configuration
\npublic class MyBatisMapperScannerConfig {<\/p>\n

\t@Bean
\n\tpublic MapperScannerConfigurer mapperScannerConfigurer() {
\n\t\tMapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
\n\t\tmapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
\n\t\tmapperScannerConfigurer.setBasePackage("com.ittx.java1608.sbdemo2.dao");
\n\t\treturn mapperScannerConfigurer;
\n\t}
\n}[\/java]<\/p>\n

5. \u7ecf\u8fc7\u4ee5\u4e0a\u914d\u7f6espringboot\u5df2\u6210\u529f\u96c6\u6210mybatis.\u7f16\u5199\u6d4b\u8bd5LoginController\u5b9e\u73b0\u767b\u5f55<\/h3>\n

[java]@Controller
\npublic class LoginController {
\n\t@Autowired
\n\tprivate UserMapper userMapper;<\/p>\n

\t@RequestMapping("\/login")
\n\tpublic String login(){
\n\t\treturn "login";
\n\t}<\/p>\n

\t@RequestMapping("\/login_submit")
\n\tpublic String loginSubmit(String username,String password,Model model){
\n\t\tUser user = userMapper.checkLogin(username, password);
\n\t\tif(user != null){
\n\t\t\tmodel.addAttribute("message", "\u767b\u5f55\u6210\u529f!");
\n\t\t}else{
\n\t\t\tmodel.addAttribute("message", "\u7528\u6237\u540d\u6216\u5bc6\u7801\u9519\u8bef!");
\n\t\t}
\n\t\treturn "login";
\n\t}
\n}[\/java]<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4e00\u3001SpringBoot\u4e0eMybatis\u96c6\u6210\u6b65\u9aa4\u5982\u4e0b 1. \u5f15\u5165mybatis-spring-boot\u76f8\u5173\u4f9d\u8d56 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[93],"tags":[],"_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":5,"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}]}}