Spring学习笔记（五）

最新推荐文章于 2020-05-26 18:44:12 发布

yaodick

最新推荐文章于 2020-05-26 18:44:12 发布

阅读量481

点赞数

分类专栏： spring 文章标签： spring integer exception attributes aop string

本文链接：https://blog.csdn.net/zhangyaoming2004/article/details/6930080

版权

spring 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

Spring提供了强大的JDBC Template来操纵数据库。

先看一段线上实例代码：

/src/main/resource/conf/jdbc.properties:

driverClassName=com.mysql.jdbc.Driver
           url=jdbc:mysql://localhost:3306/preson_db?useUnicode=true&characterEncoding=gbk&autoReconnect=true
           username=root
           password=123
           initialSize=1        
           maxActive=500

maxIdle=2

minIdle=1

/src/main/resource/conf/jdbcTemplate.xml:

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
             xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
             xmlns:context="http://www.springframework.org/schema/context"
             xmlns:aop="http://www.springframework.org/schema/aop"
             xmlns:tx="http://www.springframework.org/schema/tx"
             xsi:schemaLocation="http://www.springframework.org/schema/beans
                     http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
                     http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
                     http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
                     http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">

    <context:property-placeholder location="conf/jdbc.properties"/>
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
         <property name="driverClassName" value="${driverClassName}"/>
         <property name="url" value="${url}"/>
         <property name="username" value="${username}"/>
         <property name="password" value="${password}"/>
            
     <property name="initialSize" value="${initialSize}"/>
     
     <property name="maxActive" value="${maxActive}"/>
     
     <property name="maxIdle" value="${maxIdle}"/>
     
     <property name="minIdle" value="${minIdle}"/>
    </bean>

<bean id="txManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"/>
        </bean>

<aop:config>
        <aop:pointcut id="transactionPointcut" expression="execution(* cn.comp.service..*.*(..))"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="transactionPointcut"/>
</aop:config>
<tx:advice id="txAdvice" transaction-manager="txManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true" propagation="NOT_SUPPORTED"/>
            <tx:method name="*"/>
        </tx:attributes>
</tx:advice>

    <bean id="fileService" class="com.koubei.syn.service.impl.FileServiceBean">
        <property name="dataSource" ref="dataSource"/>
</bean>
</beans>

/src/main/resource/applicationcontext.xml:

POJO类：

package com.koubei.jdbctemplate;

/**
* Hello world!
*
*/
public class Person
{
      private Integer id;
      private String name;

      public Person(){}

      public Person(String name) {
        this.name = name;
      }

      public Person(int id,String name){
          this.id = id;
          this.name = name;
      }
      public Integer getId() {
        return id;
      }
      public void setId(Integer id) {
        this.id = id;
      }
      public String getName() {
        return name;
      }
      public void setName(String name) {
        this.name = name;
      }
}

提供对Person的操作接口：PersonService.java

package com.koubei.jdbctemplate;

import java.util.List;

public interface PersonService {

      public void save(Person person);

      public void update(Person person);

      public Person getPerson(Integer personid);

      public List<Person> getPersons();

      public void delete(Integer personid) throws Exception;

   }

提供对接口的实现类：PersonServiceBean.java

package com.koubei.jdbctemplate;

import java.util.List;

import javax.sql.DataSource;

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

@Transactional
public class PersonServiceBean implements PersonService {
      private JdbcTemplate jdbcTemplate;

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

      @Transactional(noRollbackFor=RuntimeException.class)
      public void delete(Integer personid) throws Exception{
        jdbcTemplate.update("delete from person where id=?", new Object[]{personid},
            new int[]{java.sql.Types.INTEGER});
        throw new RuntimeException("运行期例外");
      }

      @Transactional(propagation=Propagation.NOT_SUPPORTED)
      public Person getPerson(Integer personid) {
        return (Person)jdbcTemplate.queryForObject("select * from person where id=?", new Object[]{personid},
            new int[]{java.sql.Types.INTEGER}, new PersonRowMapper());
      }

      @SuppressWarnings("unchecked")
      public List<Person> getPersons() {
        return (List<Person>)jdbcTemplate.query("select * from person", new PersonRowMapper());
      }

      public void save(Person person) {
        jdbcTemplate.update("insert into person(id,name) values(?,?)", new Object[]{person.getId(),person.getName()},
            new int[]{java.sql.Types.INTEGER,java.sql.Types.VARCHAR});
      }

      public void update(Person person) {
        jdbcTemplate.update("update person set name=? where id=?", new Object[]{person.getName(), person.getId()},
            new int[]{java.sql.Types.VARCHAR, java.sql.Types.INTEGER});
      }
   }

提供在查询对象时，记录的映射回调类： PersonRowMapper.java

package com.koubei.jdbctemplate;

import java.sql.ResultSet;
import java.sql.SQLException;

import org.springframework.jdbc.core.RowMapper;

public class PersonRowMapper implements RowMapper {

   public Object mapRow(ResultSet rs, int index) throws SQLException {
        Person person = new Person(rs.getString("name"));
        person.setId(rs.getInt("id"));
        return person;
      }
}

测试类：
package com.koubei.jdbctemplate;

import org.springframework.context.support.ClassPathXmlApplicationContext;

public class Test {

   public static void main(String[] args) throws Exception {

       String[] config={"beans.xml"};
       PersonServiceBean person = (PersonServiceBean) new ClassPathXmlApplicationContext(config).getBean("personService");
       Person person1 = new Person(1,"zhangsan");
       person.save(person1);
   }
}

需要引入的jar包有：
commons-logging.jar

commons-dbcp.jar

commons-collections.jar

jta.jar

aspectjweaver

aspectjrt

spring.jar