{"id":53923,"date":"2016-03-17T16:00:22","date_gmt":"2016-03-17T14:00:22","guid":{"rendered":"https:\/\/www.javacodegeeks.com\/?p=53923"},"modified":"2016-03-18T09:01:05","modified_gmt":"2016-03-18T07:01:05","slug":"springboot-working-mybatis","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2016\/03\/springboot-working-mybatis.html","title":{"rendered":"SpringBoot : Working with MyBatis"},"content":{"rendered":"

MyBatis<\/b> is a SQL Mapping framework with support for custom SQL, stored procedures and advanced mappings.<\/p>\n

\n

SpringBoot doesn\u2019t provide official support for MyBatis integration, but MyBatis community built a SpringBoot starter for MyBatis.<\/p>\n<\/blockquote>\n

You can read about the SpringBoot MyBatis Starter release announcement at http:\/\/blog.mybatis.org\/2015\/11\/mybatis-spring-boot-released.html<\/a> and you can explore the source code on GitHub https:\/\/github.com\/mybatis\/mybatis-spring-boot<\/a>.<\/p>\n

Create a SpringBoot Maven project and add the following MyBatis Starter dependency. <\/b><\/p>\n

<dependency>\r\n    <groupId>org.mybatis.spring.boot<\/groupId>\r\n    <artifactId>mybatis-spring-boot-starter<\/artifactId>\r\n    <version>1.0.0<\/version>\r\n<\/dependency><\/pre>\n
We will be reusing User.java, schema.sql and data.sql<\/b> files created in my previous article SpringBoot : Working with JdbcTemplate<\/a><\/p>\n
Create MyBatis SQL Mapper interface\u00a0UserMapper.java <\/b>with few database operations as follows:<\/p>\n
package com.sivalabs.demo.domain;\r\n\r\npublic interface UserMapper\r\n{\r\n    void insertUser(User user);\r\n    User findUserById(Integer id);\r\n    List<User> findAllUsers();\r\n}<\/pre>\n
We need to create Mapper XML files to define the queries for the mapped SQL statements for the corresponding Mapper interface methods.<\/p>\n
Create\u00a0UserMapper.xml<\/b> file in\u00a0src\/main\/resources\/com\/sivalabs\/demo\/mappers\/ <\/b>directory as follows:<\/p>\n
<!DOCTYPE mapper\r\n    PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"\r\n    \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\">\r\n\r\n<mapper namespace=\"com.sivalabs.demo.mappers.UserMapper\">\r\n\r\n    <resultMap id=\"UserResultMap\" type=\"User\">\r\n        <id column=\"id\" property=\"id\" \/>\r\n        <result column=\"name\" property=\"name\" \/>\r\n        <result column=\"email\" property=\"email\" \/>\r\n    <\/resultMap>\r\n\r\n    <select id=\"findAllUsers\" resultMap=\"UserResultMap\">\r\n        select id, name, email from users\r\n    <\/select>\r\n\r\n    <select id=\"findUserById\" resultMap=\"UserResultMap\">\r\n        select id, name, email from users WHERE id=#{id}\r\n    <\/select>\r\n\r\n    <insert id=\"insertUser\" parameterType=\"User\" useGeneratedKeys=\"true\" keyProperty=\"id\">\r\n        insert into users(name,email) values(#{name},#{email})\r\n    <\/insert>\r\n<\/mapper><\/pre>\n
Few things to observe here are:
 
<\/div> <\/div><\/p>\n