spring+jdbc开发

1.所需要的jar包

spring基本jar包+ commons-dbcp.jar commons-pool.jar

数据库驱动mysql-connector-java-3.1.13-bin.jar

如果采用注解方式管理组件要引入common-annotations.jar

2.注解方式管理事务的XML的配置

<?xml version="1.0" encoding="UTF-8"?>

3.示例代码(注解方式管理事务)

package com.westsoft.serviceimpl;

import java.util.List;

import javax.annotation.Resource;
import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Propagation;
import org.springframework.transaction.annotation.Transactional;

import com.westsoft.bean.Person;
import com.westsoft.dao.PersonDao;
import com.westsoft.service.PersonService;

@Service @Transactional
public class PersonServiceBean implements PersonService {


    private JdbcTemplate jdbcTemplate;

    @Resource
    public void setJdbcTemplate(DataSource dataSource) {
        this.jdbcTemplate = new JdbcTemplate(dataSource);
    }

    @Resource
    private PersonDao personDao;

    public PersonDao getPersonDao() {
        return personDao;
    }

    public void setPersonDao(PersonDao personDao) {
        this.personDao = personDao;
    }


    @Override
    public void delete(Integer id) {
        // TODO Auto-generated method stub

    }

    @Override
    public Person getPerson(Integer id) {
        // TODO Auto-generated method stub
        return null;
    }

    @Override @Transactional(propagation=Propagation.NOT_SUPPORTED)
    public List<Person> getPersons() {
        // TODO Auto-generated method stub
        return null;
    }

    /*
     * 新增
     * @Transactional(rollbackFor=Exception.class)
     * RuntimeException运行期例外,默认回滚
     * Exception 非运行期例外,不回滚
     * @Transactional(rollbackFor=Exception.class)
     * @Transactional(propagation=Propagation.NOT_SUPPORTED):不开启事务
     * @Transactional(propagation=Propagation.REQUIRED):默认事务行为,如果方法运行时已经处在一个事务中,则加入该事务,
     *                                                     否则为自己创建一个事务
     * @Transactional(propagation=Propagation.REQUIREDNEW):必须开启一个新事务,事务中嵌套事务

     *  @Transactional(propagation=Propagation.SUPPORTS):如果方法在已存在的事务中执行,则加入该事务,如果不在事务中执行,
     *                                                  则方法在没有事务的环境下执行.
     *  @Transactional(propagation=Propagation.MANDATORY):指定方法只能在已有的事务中执行,不会自动创建事务,如果没有在事务
     *                                                  中执行,则抛出异常.
     *  @Transactional(propagation=Propagation.NEVER):不能在事务中执行,否则抛出异常
     *
     *  @Transactional(propagation=Propagation.NESTED):
     *
     */
    @Override @Transactional(propagation=Propagation.REQUIRED)
    public void save(String name) throws Exception {
        // TODO Auto-generated method stub

        this.jdbcTemplate.update("insert into person(name) values(?)", new Object[]{name},
                    new int[]{java.sql.Types.VARCHAR});
        throw new RuntimeException("运行期例外");

    }

    @Override
    public void update(Person person) {
        // TODO Auto-generated method stub

    }
}

4.XML配置方式管理事务

<?xml version="1.0" encoding="UTF-8"?>

5.将(3)中的类中除去事务的注解