在spring配置文件中(如:spring.xml,你可以定义其他名字)beans标签 添加如下内容
<!--事务配置开始位置-->
<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<!-- enable transaction annotation support -->
<tx:annotation-driven transaction-manager="txManager"/>
<!--事务配置结束-->
<!-- 配置jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"/>
</bean>
import org.apache.commons.lang.exception.ExceptionUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
import org.springframework.test.annotation.Rollback;
import org.springframework.transaction.annotation.Transactional;
import com.cms.po.Code;
import com.cms.po.Content;
@Transactional
@Repository
public class NoteDao {
@Autowired
private JdbcTemplate jdbcTemplate;
private Logger log = LoggerFactory.getLogger(NoteDao.class);
public List<Content> findContentsByNoteId(String noteId) {
List<Content> list = null;
try {
String sql = "select * from content where note_id=? ";
list = jdbcTemplate.query(sql,new Object[]{noteId}, new BeanPropertyRowMapper<Content>(Content.class));
} catch (Exception e) {
}
return list;
}
}