{"id":917,"date":"2012-02-15T19:18:00","date_gmt":"2012-02-15T19:18:00","guid":{"rendered":"http:\/\/www.javacodegeeks.com\/2012\/10\/mybatis-3-spring-integration-tutorial.html"},"modified":"2012-10-21T23:00:42","modified_gmt":"2012-10-21T23:00:42","slug":"mybatis-3-spring-integration-tutorial","status":"publish","type":"post","link":"https:\/\/www.javacodegeeks.com\/2012\/02\/mybatis-3-spring-integration-tutorial.html","title":{"rendered":"MyBatis 3 – Spring integration tutorial"},"content":{"rendered":"
As a first step of this tutorial, Spring MVC 3 CRUD example with MyBatis 3, we will define a MyBatis service that will help us to perform CRUD operation on database.<\/p>\n

We have a domain class for User and a database table to store the User information on database. We will use xml configuration model for our example to define SQL commands that will perform CRUD operation.<\/p>\n

Our Domain class<\/strong><\/p>\n

package com.raistudies.domain;\r\n\r\nimport java.io.Serializable;\r\n\r\npublic class User implements Serializable{\r\n\r\n    private static final long serialVersionUID = 3647233284813657927L;\r\n\r\n    private String id;\r\n    private String name = null;\r\n    private String standard = null;\r\n    private String age;\r\n    private String sex = null;\r\n\r\n    \/\/setter and getter have been omitted to make the code short\r\n\r\n    @Override\r\n    public String toString() {\r\n        return \"User [name=\" + name + \", standard=\" + standard + \", age=\" + age\r\n        + \", sex=\" + sex + \"]\";\r\n    }\r\n}\r\n<\/pre>\n
We have five properties in our domain class called User for which have to provide database services.<\/p>\n
Our Database Table<\/strong><\/p>\n
Following is our database table:<\/p>\n
CREATE TABLE `user` (\r\n    `id` varchar(36) NOT NULL,\r\n    `name` varchar(45) DEFAULT NULL,\r\n    `standard` varchar(45) DEFAULT NULL,\r\n    `age` varchar(45) DEFAULT NULL,\r\n    `sex` varchar(45) DEFAULT NULL,\r\n    PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8\r\n<\/pre>\n
Creating interface for CRUD operations<\/strong><\/p>\n
For defining the CRUD database operation using MyBatis 3, we have to specify the methods that will be used to perform CRUD operation. Following is the interface for our example:<\/p>\n
package com.raistudies.persistence;\r\n\r\nimport java.util.List;\r\n\r\nimport com.raistudies.domain.User;\r\n\r\npublic interface UserService {\r\n\r\n    public void saveUser(User user);\r\n    public void updateUser(User user);\r\n    public void deleteUser(String id);\r\n    public List<User> getAllUser();\r\n}\r\n<\/pre>\n
We have four methods here to perform operations create,update , delete and get from database.<\/p>\n
XML Mapping file for UserService interface<\/strong><\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE mapper 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.raistudies.persistence.UserService\">\r\n\r\n    <resultMap id=\"result\" type=\"user\">\r\n        <result property=\"id\" column=\"id\"\/>\r\n        <result property=\"name\" column=\"name\"\/>\r\n        <result property=\"standard\" column=\"standard\"\/>\r\n        <result property=\"age\" column=\"age\"\/>\r\n        <result property=\"sex\" column=\"sex\"\/>\r\n    <\/resultMap>\r\n\r\n    <select id=\"getAllUser\" parameterType=\"int\" resultMap=\"result\">\r\n        SELECT id,name,standard,age,sex\r\n        FROM user;\r\n    <\/select>\r\n\r\n    <insert id=\"saveUser\" parameterType=\"user\">\r\n        INSERT INTO user (id,name,standard,age,sex)\r\n        VALUE (#{id},#{name},#{standard},#{age},#{sex})\r\n    <\/insert>\r\n\r\n    <update id=\"updateUser\" parameterType=\"user\">\r\n        UPDATE user\r\n        SET\r\n        name = #{name},\r\n        standard = #{standard},\r\n        age = #{age},\r\n        sex = #{sex}\r\n        where id = #{id}\r\n    <\/update>\r\n\r\n    <delete id=\"deleteUser\" parameterType=\"int\">\r\n        DELETE FROM user\r\n        WHERE id = #{id}\r\n    <\/delete>\r\n<\/mapper>\r\n<\/pre>\n
You will see a lot of things new here:<\/p>\n
The mapping file will contain element <mapper\/><\/strong> to define the SQL statement for the services. Here the property \u201cnamespace<\/strong>\u201d defines the interface for which this mapping file has been defined.<\/p>\n
<insert\/><\/strong> tag defines that the operation is of type insert. The value of \u201cid<\/strong>\u201d property specifies the function name for which the SQL statement is been defined. Here it is \u201csaveUser<\/strong>\u201c. The property \u201cparameterType<\/strong>\u201d defines the parameter of the method is of which type. We have used alias for the class User here. The alias will be configured in MyBatis Configuration file later. Then, we have to define the SQL Statement. #{id}<\/strong> defines that the property \u201cid<\/strong>\u201d of class User will be passed as a parameter to the SQL query.
 
<\/div> <\/div><\/p>\n
<resultMap\/><\/strong> tag is used to specify the mapping between the User class and user table. id<\/strong> of <resultMap\/> is a unique name to the mapping definition. Under this tag, we define the different properties and which column is bounded to which property.<\/p>\n
<select\/><\/strong> tag is used to specify a select SQL statement. The value of \u201cid<\/strong>\u201d property specifies the function name for which the SQL statement is been defined.<\/p>\n
The attribute resultMap<\/strong> is used to define the return type of the SQL statement as a collection.<\/p>\n
MyBatis 3 Configuration file<\/strong><\/p>\n
Following is our configuration file for MyBatis:<\/p>\n
<?xml version=\"1.0\" encoding=\"UTF-8\"?>\r\n<!DOCTYPE configuration\r\nPUBLIC \"-\/\/mybatis.org\/\/DTD Config 3.0\/\/EN\"\r\n\"http:\/\/mybatis.org\/dtd\/mybatis-3-config.dtd\">\r\n\r\n<configuration>\r\n    <settings>\r\n        <!-- changes from the defaults -->\r\n       <setting name=\"lazyLoadingEnabled\" value=\"false\" \/>\r\n    <\/settings>\r\n    <typeAliases>\r\n        <typeAlias type=\"com.raistudies.domain.User\" alias=\"user\"\/>\r\n    <\/typeAliases>\r\n<\/configuration>\r\n<\/pre>\n
You can see, we have not defined some very important properties here:<\/p>\n
    \n
  1. Database connection properties.<\/li>\n
  2. Transaction related properties.<\/li>\n
  3. And also have not defined mappers configuration.<\/li>\n<\/ol>\n
    MyBatis 3 is very powerful SQL mapping framework with automatic database access class generation using a proxy implementation of the services defined by users. We get realize it\u2019s true power if you integrate MyBatis 3 with Spring framework and use these proxy implementation. It will reduce our database work by 80%. Below, we will see how to integrate MyBatis 3 with Spring 3 framework. Previously, we created the CRUD database service for class User using MyBatis 3. Now, we will integrate the data services implemented using MyBatis with Spring framework.<\/p>\n
    Tools Used:<\/strong><\/p>\n