spring4 jdbc template java기반

spring4 jdbc template

config 

JavaScanConfig.java

package com.tistory.tazz009.spring4; import javax.sql.DataSource; import org.apache.commons.dbcp.BasicDataSource; import org.mybatis.spring.SqlSessionFactoryBean; import org.mybatis.spring.SqlSessionTemplate; import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Bean; import org.springframework.context.annotation.Configuration; import org.springframework.core.io.ClassPathResource; import org.springframework.core.io.Resource; import org.springframework.dao.annotation.PersistenceExceptionTranslationPostProcessor; import org.springframework.jdbc.datasource.DataSourceTransactionManager; import org.springframework.transaction.PlatformTransactionManager; import org.springframework.transaction.annotation.EnableTransactionManagement; @Configuration @EnableTransactionManagement @MapperScan("com.tistory.tazz009.spring4.dao") public class JavaScanConfig { @Bean public PersistenceExceptionTranslationPostProcessor postProcessor() { return new PersistenceExceptionTranslationPostProcessor(); } @Bean(destroyMethod="close") public DataSource dataSource() { BasicDataSource ds = new BasicDataSource(); try { ds.setDriverClassName("net.sf.log4jdbc.DriverSpy"); } catch (Exception e) { throw new RuntimeException(e); } ds.setUrl("jdbc:oracle:thin:@52.70.197.132:1521:ictdev"); ds.setUsername("ict"); ds.setPassword("ict@!"); return ds; } @Bean public PlatformTransactionManager transactionManager() { DataSourceTransactionManager tm = new DataSourceTransactionManager(); tm.setDataSource(dataSource()); return tm; } @Bean public SqlSessionFactoryBean sqlSessionFactory() throws Exception { SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean(); factoryBean.setDataSource(dataSource()); Resource[] mapperLocations = new Resource[1]; mapperLocations[0] = new ClassPathResource("/mybatis/testdao.xml"); //mapperLocations[0] = new ClassPathResource("/mybatis/itemdao.xml"); //mapperLocations[1] = new ClassPathResource("/mybatis/purchaseorderdao.xml"); factoryBean.setMapperLocations(mapperLocations); //factoryBean.setTypeAliases(new Class<?>[] { PurchaseOrder.class }); return factoryBean; } @Bean(destroyMethod="clearCache") public SqlSessionTemplate sqlSession() throws Exception { return new SqlSessionTemplate(sqlSessionFactory().getObject()); } } .

main class

MainForJavaScanConfig.java

package com.tistory.tazz009.spring4; import org.springframework.context.annotation.AnnotationConfigApplicationContext; import com.tistory.tazz009.spring4.dao.TestDao; public class MainForJavaScanConfig { public static void main(String[] args) { AnnotationConfigApplicationContext ctx = new AnnotationConfigApplicationContext(JavaScanConfig.class); TestDao dao = ctx.getBean(TestDao.class); String test = dao.test(); System.out.println(test); ctx.close(); } }

이것과 함께보세요 http://tazz009.tistory.com/1011

maven 빌드 

Run As > Maven build ... > assembly:assembly

jar 로 빌드 후 실행해보기

C:\temp>java -cp .;./spring4_chap13_mybatis-0.0.1-SNAPSHOT-jar-with-dependencies

.jar com.tistory.tazz009.spring4.MainForJavaScanConfig

출처 spring4 최범균 - 좋은 책은 사서 보세요. 두번 보세요.