How to start myBatis implementation using spring?

Question

I want to work with myBatis. I read the MyBatis-3 user manual. Now I am trying to implement it. I recently learned spring. Therefore, it is difficult for me to implement it. Therefore, I need some useful resource with which I can implement it step by step.

Answer 1

First add the MyBatis- Spring jar to your class path

Start with your spring context file. In your context file add the following lines

<beans:bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" p:driverClassName="yourDriverClassName" p:url="yourUrl" p:username="yourUsername" p:password="yourPassword" /> <beans:bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <beans:property name="dataSource" ref="dataSource" /> <beans:property name="configLocation" value="/WEB-INF/mybatis-config.xml" /> </beans:bean> <beans:bean id="userDao" class="com.yourcomp.dao.Userdao"> <beans:property name="sqlSessionFactory" ref="sqlSessionFactory" /> </beans:bean> 

your mybatis-config.xml should look something like this:

 <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration> <settings> </settings> <typeAliases> <typeAlias alias="User" type ="com.yourcomp.domain.User" /> </typeAliases> <mappers> <mapper resource="com/yourcomp/domain/UserMapper.xml"/> <mapper resource="com/yourcomp/domain/AnotherDomainObjectMapper.xml"/> </mappers> </configuration> 

and your userMapper.xml in src / com / yourcomp / domain / might be something like this

 <?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <!--<mapper namespace="org.pbl.rms.RMSUserDao">--> <mapper namespace="com.yourcomp.domain.User"> <resultMap id="userMap" type="User"> <id property="userId" column="USER_ID" javaType="int" jdbcType="NUMERIC"/> <result property="userName" column="USER_NAME" javaType="String" jdbcType="VARCHAR"/> <result property="userFullName" column="USER_FULL_NAME" javaType="String" jdbcType="VARCHAR"/> <result property="password" column="PASSWORD" javaType="String" jdbcType="VARCHAR"/> <result property="passwordExpiryDate" column="PASWRD_EXPIRY_DATE" javaType="java.util.Date" jdbcType="DATE"/> <result property="status" column="STATUS" javaType="_integer" jdbcType="DECIMAL"/> </resultMap> <select id="getUserById" parameterType="map" resultMap="userMap"> select * from user where USER_ID=#{userId} </select> </mapper> 

now at your DAO level you can have the following class:

 public class UserDAO{ private SqlSessionFactory sqlSessionFactory; public UserDAO() { } public UserDAO(SqlSessionFactory sqlSessionFactory ) { this.sqlSessionFactory = sqlSessionFactory; } public String getUserById(Integer userId) { SqlSession session = sqlSessionFactory.openSession(); String name=null; try { name = (String)session.selectOne("com.yourcomp.domain.User.getUserById",userId); }catch(Exception e){ }finally { session.close(); } return name; } } 

Answer 2

For this you need MyBatis-Spring. See the link here and here. They provide you with a step. If you need any specific information, you need to re-request.

Also check spring reference for IBatis support.