[스프링3트랜잭션강좌/예제]Spring Framework3.X TransactionManager이용한프로그래밍적트랜잭션예제,spring framework3.X transaction, 스프링교육강좌,스프링프레임워크강좌교육

[스프링3트랜잭션강좌/예제]Spring Framework3.X TransactionManager이용한프로그래밍적트랜잭션예제,spring framework3.X transaction, 스프링교육강좌,스프링프레임워크강좌교육

import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.dao.DataAccessException;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;
import org.springframework.transaction.TransactionDefinition;
import org.springframework.transaction.TransactionStatus;
import org.springframework.transaction.support.DefaultTransactionDefinition;

public class TrTest1 {
DataSource dataSource;
PlatformTransactionManager transactionManager;

public static void main(String[] args) {
BasicDataSource ds = new BasicDataSource();
ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
ds.setUrl("jdbc:oracle:thin:@192.168.0.7:1521:onj");
ds.setUsername("scott");
ds.setPassword("tiger");

DataSourceTransactionManager tm = new DataSourceTransactionManager();
tm.setDataSource(ds);

TrTest1 update = new TrTest1();
update.setDataSource(ds);
update.setTransactionManager(tm);

// execute 
update.doUpdate();
System.out.println("<<<<<<<<<<<<< TR OK >>>>>>>>>>>>");
}

public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}

public void setTransactionManager(
PlatformTransactionManager transactionManager) {
this.transactionManager = transactionManager;
}

public void doUpdate() {
DefaultTransactionDefinition td = new DefaultTransactionDefinition(
TransactionDefinition.PROPAGATION_REQUIRED);
td.setIsolationLevel(TransactionDefinition.ISOLATION_READ_COMMITTED);
td.setTimeout(10);
TransactionStatus status = transactionManager.getTransaction(td);
try {
updateSal(3000);
} catch (DataAccessException e) {
transactionManager.rollback(status);
throw e;
}
transactionManager.commit(status);
}
private void updateSal(int newSal) throws DataAccessException {
String strQuery = "update emp set sal = " + newSal + " where ename = 'SMITH'";
JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
jdbcTemplate.update(strQuery);
}
}

• 자바
• 오라클/빅데이터
• 아이폰/안드로이드
• 닷넷/WPF
• 표준웹/HTML5
• 채용/취업무료교육
• 초보자코스

[기업100%환급]자바기초에서 JDBC, Servlet/JSP까지	총	5일	40시간		02-05
[기업100%환급]Spring ,MyBatis,Hibernate실무과정	총	5일	40시간		02-24
자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지	총	24일	72시간		02-06
Spring3.X, MyBatis, Hibernate실무과정	총	12일	36시간		02-11
Spring3.X, MyBatis, Hibernate실무과정	총	5일	35시간		02-15
자바기초에서JSP,Ajax,jQuery,Spring3.2,MyBatis까지	총	10일	70시간		02-15
JAVA&WEB프레임워크실무과정	총	14일	98시간		03-08