StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Add the MyBatis-Spring jar in your class path at first</p> <p>Start with your spring context file.In your context file add following lines</p> <pre><code><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> </code></pre> <p>your mybatis-config.xml should be something like this: </p> <pre><code><?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> </code></pre> <p>and your userMapper.xml in src/com/yourcomp/domain/ might be something like this</p> <pre><code><?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="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> </code></pre> <p>now in your DAO layer you might have class like follows:</p> <pre><code>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; } } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload