<\/p>\n
http:\/\/blog.naver.com\/PostView.nhn?blogId=vikong&logNo=60180414100<\/a><\/p>\n application-context.xml<\/strong><\/p>\n <\/p>\n 1) @Respository \ub85c DAO scanning \ubc0f bean \uc124\uc815 \ubb38\uc7a5<\/p>\n <context:component-scan base-package=”trust.repository” use-default-filters=”false”><\/p>\n <context:include-filter type=”annotation” expression=”org.springframework.stereotype.Repository” \/><\/p>\n <\/context:component-scan><\/p>\n <\/p>\n 2) @Transactional \uc744 \uc704\ud55c \uc124\uc815 \ubb38\uc7a5<\/p>\n <!– enable the configuration of transactional behavior based on annotations –><\/p>\n <tx:annotation-driven transaction-manager=”txManager” proxy-target-class=”true”\/><\/p>\n <\/p>\n <!– a PlatformTransactionManager is still required –><\/p>\n <bean id=”txManager” class=”org.springframework.jdbc.datasource.DataSourceTransactionManager”><\/p>\n <!– (this dependency is defined somewhere else) –><\/p>\n <property name=”dataSource” ref=”dataSource”\/><\/p>\n <\/bean><\/p>\n <\/p>\n mybatis-context.xml<\/strong><\/p>\n <\/p>\n 1) sqlSessionFactory \uc9c0\uc815<\/p>\n <bean id=”sqlSessionFactory” class=”org.mybatis.spring.SqlSessionFactoryBean”><\/p>\n <property name=”dataSource” ref=”dataSource” \/><\/p>\n <property name=”configLocation” value=”\/WEB-INF\/config\/mybatis-config.xml”\/><\/p>\n <\/bean><\/p>\n <\/p>\n 2) sqlSessoinTemplate \uc9c0\uc815<\/p>\n <bean id=”sqlSessionTemplate” class=”org.mybatis.spring.SqlSessionTemplate”><\/p>\n <constructor-arg ref=”sqlSessionFactory”\/><\/p>\n <\/bean><\/p>\n <\/p>\n <\/p>\n TestRepositoryImpl.java<\/strong><\/p>\n <\/p>\n @Repository<\/p>\n public class TestRepositoryImpl extends SqlSessionDaoSupport implements TestRepository<\/p>\n {<\/p>\n \/** Test Data \uc870\ud68c **\/<\/p>\n public List<TestModel> getTestData() throws DataAccessException<\/p>\n {<\/p>\n return getSqlSession().selectList(“test.list”, 0);<\/p>\n }<\/p>\n }<\/p>\n <\/p>\n \uc704\uc758 3\uac00\uc9c0 \ub0b4\uc6a9\ub9cc \ubcf4\uba74\u00a0TestRepositoryImpl \uacfc mybatis \uc758 \uc5f0\uad00 \uad00\uacc4\uac00 \uba85\ud655\ud558\uc9c0 \uc54a\ub2e4.<\/p>\n mybatis \ubb38\uc11c(http:\/\/www.mybatis.org\/spring\/sqlsession.html#SqlSessionDaoSupport)<\/a>\u00a0\ub97c \ubcf4\uc544\ub3c4<\/p>\n <\/p>\n SqlSessionDaoSupport\u00a0is an abstract support class that provides you with a\u00a0SqlSession. Calling\u00a0getSqlSession()\u00a0you will get aSqlSessionTemplate\u00a0which can then be used to execute SQL methods, like the following:<\/p>\n public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao { public User getUser(String userId) { return (User) getSqlSession().selectOne(“org.mybatis.spring.sample.mapper.UserMapper.getUser”, userId); } }<\/p>\n Usually\u00a0MapperFactoryBean\u00a0is preferred to this class, since it requires no extra code. But, this class is useful if you need to do other non-MyBatis work in your DAO and concrete classes are required.<\/p>\n SqlSessionDaoSupport\u00a0requires either an\u00a0sqlSessionFactory\u00a0or an\u00a0sqlSessionTemplate\u00a0property to be set. These can be set explicitly or autowired by Spring. If both properties are set, the\u00a0sqlSessionFactory\u00a0is ignored.<\/p>\n Assuming a class\u00a0UserDaoImpl\u00a0that subclasses\u00a0SqlSessionDaoSupport, it can be configured in Spring like the following:<\/p>\n <bean id=”userMapper” class=”org.mybatis.spring.sample.mapper.UserDaoImpl”> <property name=”sqlSessionFactory” ref=”sqlSessionFactory” \/> <\/bean><\/p>\n \uc5d0\uc11c \ucc98\ub7fc xml \uc5d0 DAO \uc5d0 \ub300\ud55c \uc124\uc815\uc744 \ud558\ub3c4\ub85d \ub418\uc5b4 \uc788\ub2e4.<\/p>\n <\/p>\n \uadf8\ub7f0\ub370\u00a0TestRepositoryImpl\u00a0 \uc5d0 \ub300\ud55c \ubcc4\ub3c4\uc758 bean \uc124\uc815 \uc5c6\uc774\ub3c4 \uc798 \ub3d9\uc791\ud55c\ub2e4.<\/p>\n <\/p>\n \uc774\uc720\ub294\u00a0org.mybatis.spring.support.SqlSessionDaoSupport<\/strong>\u00a0\ub97c \uc0ac\uc6a9\ud558\uc600\uae30 \ub54c\ubb38\uc774\ub2e4.<\/p>\n <\/p>\n SqlSessionDaoSupport\u00a0 \uc5d0\ub294 setter \uac00 \ub450\uac00\uc9c0 \uc874\uc7ac\ud55c\ub2e4.<\/p>\n \ub450\uac00\uc9c0 setter \ub294 \ub2e4\uc74c\uacfc \uac19\uc774 \uc815\uc758 \ub418\uc5b4 \uc788\ub2e4.<\/p>\n <\/p>\n \u00a0@org.springframework.beans.factory.annotation.Autowired(required=false)<\/strong><\/p>\n \u00a0public void setSqlSessionFactory(org.apache.ibatis.session.SqlSessionFactory sqlSessionFactory);<\/strong><\/p>\n \u00a0@org.springframework.beans.factory.annotation.Autowired(required=false)<\/strong><\/p>\n \u00a0public void setSqlSessionTemplate(org.mybatis.spring.SqlSessionTemplate sqlSessionTemplate);<\/strong><\/p>\n <\/p>\n mybatis-context.xml \uc5d0 \uc815\uc758\ub41c bean\u00a0sqlSessionFactory,\u00a0sqlSessionTemplate<\/p>\n \uc774 SqlSessionDaoSupport \uc5d0 injection \ub418\ub3c4\ub85d,<\/p>\n method \uc5d0 @Autowired annotation \uc774 \uc0ac\uc6a9\ub418\uc5b4 \uc788\uae30 \ub54c\ubb38\uc5d0 DAO \uc5d0 \ub300\ud55c ref bean \uc124\uc815 \uc5c6\uc774\ub3c4 \uc798 \ub3d9\uc791 \ud558\ub294 \uac83 \uc774\ub2e4.<\/p>\n \uacb0\ub860,\u00a0<\/strong>org.mybatis.spring.support.SqlSessionDaoSupport \ub97c \uc0ac\uc6a9\ud558\uc5ec DAO \ub97c \uad6c\uc131\ud558\uba74<\/strong><\/p>\n \ub2e4\uc74c\uacfc \uac19\uc774 sqlSessionFactory \uc640 sqlSessionTemplate \ub9cc \uc815\uc758\ud558\uba74 \ub41c\ub2e4.<\/strong><\/p>\n \ubcc4\ub3c4\uc758 DAO \uc640 sqlSession ref \uc124\uc815\uc740 \ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4.<\/strong><\/p>\n <\/p>\n <bean id=”sqlSessionFactory” class=”org.mybatis.spring.SqlSessionFactoryBean”><\/p>\n <property name=”dataSource” ref=”dataSource” \/><\/p>\n <property name=”configLocation” value=”\/WEB-INF\/config\/mybatis-config.xml”\/><\/p>\n <\/bean><\/p>\n <\/p>\n <bean id=”sqlSessionTemplate” class=”org.mybatis.spring.SqlSessionTemplate”><\/p>\n <constructor-arg ref=”sqlSessionFactory”\/><\/p>\n <\/bean><\/p>\n <\/p>\n <\/p>\n <\/p>\n ===========================================================================<\/p>\n \ud38c\u00a0http:\/\/purred.tistory.com\/11<\/a><\/p>\n iBatis RowHandler<\/strong><\/p>\n –\u00a0\uac1c\ubc1c\ud300 \ub0a8\ud55c\ud76c \ub300\ub9ac<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n ============================================================================<\/p>\n \ud38c\u00a0http:\/\/javastore.tistory.com\/62<\/a><\/p>\n iBatis\ub97c \uc0ac\uc6a9\ud560\ub54c template\ub97c \uc4f0\uc9c0 \uc54a\uc744\ub54c\ub294 \ud56d\uc0c1 SqlMapConfig\ud30c\uc77c\uc744 \ud1b5\ud574 SqlMapClient\ub97c \uc0dd\uc131\ud574\uc57c \ud55c\ub2e4. \uadf8\uac83\uc744 \uc27d\uac8c \ud574\uc8fc\uae30 \uc704\ud55c Abstract class\uc774\ub2e4. import com.ibatis.common.resources.Resources; import com.ibatis.sqlmap.client.SqlMapClient; import com.ibatis.sqlmap.client.SqlMapClientBuilder;<\/p>\n public abstract class SQLManager { public class UploadDAO extends\u00a0SQLManager<\/strong>{<\/p>\n public void insert(UploadDTO dto) throws SQLException{ <\/p>\n =============================================================================<\/p>\nSqlSessionDaoSupport<\/h3>\n
\n
\n
\n
iBatis – SqlMapClient class \ub9cc\ub4e4\uc5b4 \uc8fc\ub294 util<\/a><\/h1>\n
\npackage com.myhome.manager;<\/p>\n
\nprivate SqlMapClient sc = null;
\npublic SQLManager(){ try{ sc = SqlMapClientBuilder.buildSqlMapClient( Resources.getResourceAsReader( “com\/myhome\/manager\/SqlMapConfig.xml”));\u00a0\/\/sql\uc124\uc815\uc774 \ub4e4\uc5b4\uac00 \uc788\ub294 SqlMapConfig\ud30c\uc77c \uc704\uce58 \uc9c0\uc815 <\/strong>\/\/classes \ud3f4\ub354\uc5d0 \uc788\uc73c\uba74 SqlMapClient.xml\ub85c \ubc14\ub85c \uc9c0\uc815 \ud574\ub3c4 \ub428<\/strong> }catch(java.io.IOException ie){ ie.printStackTrace(); } }
\npublic SqlMapClient getSqlMap(){ return sc;\u00a0 } }
\n\uc0ac\uc6a9\ubc29\ubc95\uc740 extends\ub85c \ub2e4\uc74c \ud074\ub798\uc2a4 \ud30c\uc77c\uc744 \ud655\uc7a5 \ubc1b\uc740\ub2e4\uc74c\uc5d0 getSqlMap\uc744 \ud1b5\ud574 SqlMapCleint\ub97c \uc0dd\uc131\ud55c\ub2e4.
\n\uc608)<\/p>\n
\nthis.getSqlMap().<\/strong>insert(“uploadInsert”,dto);
\n}<\/p>\n