案例一：XMLIOC案例-编写spring的Ioc配置（从数据库查询账户信息）

1. dao层

   public class AccountDaoImpl implements IAccountDao {
   
       private QueryRunner runner;
   
       public void setRunner(QueryRunner runner) {
           this.runner = runner;
       }
   
       public List<Account> findAllAccount() {
           try{
               return runner.query("select * from account",new BeanListHandler<Account>(Account.class));
           }catch (Exception e) {
               throw new RuntimeException(e);
           }
       }
   }
   

   public interface IAccountDao {
       List<Account> findAllAccount();
   }
   

2. service层

   public class AccountServiceImpl implements IAccountService{
       private IAccountDao accountDao;
       public void setAccountDao(IAccountDao accountDao) {
           this.accountDao = accountDao;
       }
       public List<Account> findAllAccount() {
           List<Account> account= accountDao.findAllAccount();
           return accountDao.findAllAccount();
       }
   }
   

   public interface IAccountService {
       List<Account> findAllAccount();
   }
   
   

3. domain层

   public class Account implements Serializable {
   
       private Integer id;
       private String name;
       private Float money;
   
       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;
       }
   
       public Float getMoney() {
           return money;
       }
   
       public void setMoney(Float money) {
           this.money = money;
       }
   
       @Override
       public String toString() {
           return "Account{" +
                   "id=" + id +
                   ", name='" + name + '\'' +
                   ", money=" + money +
                   '}';
       }
   }
   

4. 配置文件bean.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"
          xsi:schemaLocation="http://www.springframework.org/schema/beans
           http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context
           http://www.springframework.org/schema/context/spring-context.xsd">
   
       <!--<context:component-scan base-package="com.chen"></context:component-scan>-->
   
       <!--配置QueryRunner-->
       <bean id="runner" class="org.apache.commons.dbutils.QueryRunner" scope="prototype">
           <!--注入数据源-->
           <constructor-arg name="ds" ref="dataSource"></constructor-arg>
       </bean>
   
       <!--配置数据库连接文件-->
    <context:property-placeholder location="classpath:jdbcConfig.properties"></context:property-placeholder>
   
    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <!--连接数据库的必备信息-->
        <property name="driverClass" value="${jdbc.driver}"></property>
        <property name="jdbcUrl" value="${jdbc.url}"></property>
        <property name="user" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>
   
       <!--配置dao层-->
       <bean id="accountDao" class="com.chen.dao.impl.AccountDaoImpl">
           <property name="runner" ref="runner"></property>
       </bean>
   
       <!--配置service层-->
       <bean id="accountService" class="com.chen.service.impl.AccountServiceImpl">
           <property name="accountDao" ref="accountDao"></property>
       </bean>
   </beans>
   

5. 数据库连接信息jdbcConfig.properties

   jdbc.driver=com.mysql.jdbc.Driver
   jdbc.url=jdbc:mysql://localhost:3306/nba
   jdbc.username=root
   jdbc.password=root
   

6. 测试层

   @RunWith(SpringJUnit4ClassRunner.class)
   @ContextConfiguration("classpath:bean.xml")
   public class TestSpring {
   
       @Autowired
       private IAccountService is;
       @Test
       public void test(){
           List<Account> account = is.findAllAccount();
           System.out.println(account);
       }
   }