Java Spring IOC的xml配置

桃扇骨 2022-12-07 15:27 150阅读 0赞

# Java Spring IOC的xml配置 #

--------------------

## 一、案例 ##

*  利用xml配置
 *  连接数据库增删改查

--------------------

### 1.1、类包目录 ###

--------------------

![在这里插入图片描述][2020091619484534.png_pic_center]

### 1.2案例准备 ###

--------------------

*  导包

1.  pom.xml

···
    <packaging>jar</packaging>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>5.2.7.RELEASE</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
            </dependency>
            <dependency>
                <groupId>commons-dbutils</groupId>
                <artifactId>commons-dbutils</artifactId>
                <version>1.4</version>
            </dependency>
            <dependency>
                <groupId>com.mchange</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.5.2</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.13</version>
                <scope>test</scope>
            </dependency>
        </dependencies>
        ···

*  dao包

1.  AccountDao

public interface AccountDao {
        
        /**
         * 查询所有
         * @return
         */
        List<Account> findAllAccount();
    
    
        /**
         * 查询一个
         */
        Account findById(Integer id);
    
    
        /**
         * 保存
         */
        void saveAccount(Account account);
    
        /**
         * 更新
         */
        void uodateAccount(Account account);
    
        /**
         * 删除
         */
        void deleteAccount(Integer id);
    }

2 AccountDaoImpl

public class AccountDaoImpl implements AccountDao {
        
    
        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 Account findById(Integer id) {
        
            try{
        
                return runner.query("select * from account where id = ?",new BeanHandler<Account>(Account.class),id);
            }catch (Exception e){
        
                throw new RuntimeException(e);
            }
        }
    
        public void saveAccount(Account account) {
        
            try{
        
                runner.update("insert into account(name,money) values (?,?)",account.getName(),account.getMoney());
            }catch (Exception e){
        
                throw new RuntimeException(e);
            }
        }
    
        public void uodateAccount(Account account) {
        
            try{
        
                runner.update("update account set name = ?,money = ? where id = ?",account.getName(),account.getMoney(),account.getId());
            }catch (Exception e){
        
                throw new RuntimeException(e);
            }
    
        }
    
        public void deleteAccount(Integer id) {
        
            try{
        
                runner.update("delete from account where id = ?",id);
            }catch (Exception e){
        
                throw new RuntimeException(e);
            }
        }
    }

*  domain包

1.  Account

public class Account {
        
    
        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 +
                    '}';
        }
    }

*  service包

1.  AccountService

public interface AccountService {
        
    
    
        /**
         * 查询所有
         * @return
         */
        List<Account> findAllAccount();
    
    
        /**
         * 查询一个
         */
        Account findById(Integer id);
    
    
        /**
         * 保存
         */
        void saveAccount(Account account);
    
        /**
         * 更新
         */
        void uodateAccount(Account account);
    
        /**
         * 删除
         */
        void deleteAccount(Integer id);
    }

2 AccountServiceImpl

public class AccountServiceImpl implements AccountService {
        
    
        private AccountDao accountDao;
    
        public void setAccountDao(AccountDao accountDao) {
        
            this.accountDao = accountDao;
        }
    
        public List<Account> findAllAccount() {
        
            return accountDao.findAllAccount();
        }
    
        public Account findById(Integer id) {
        
            return accountDao.findById(id);
        }
    
        public void saveAccount(Account account) {
        
            accountDao.saveAccount(account);
        }
    
        public void uodateAccount(Account account) {
        
            accountDao.uodateAccount(account);
        }
    
        public void deleteAccount(Integer id) {
        
            accountDao.deleteAccount(id);
        }
    
    }

*  resources包

1.  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"
           xsi:schemaLocation="http://www.springframework.org/schema/beans
            http://www.springframework.org/schema/beans/spring-beans.xsd">
    
        
        <bean id="accountService" class="com.husxzx.service.impl.AccountServiceImpl">
            
            <property name="accountDao" ref="accountDao"></property>
        </bean>
    
        
        <bean id="accountDao" class="com.husxzx.dao.impl.AccountDaoImpl">
            
            <property name="runner" ref="runner"></property>
        </bean>
    
        
        <bean id="runner" class="org.apache.commons.dbutils.QueryRunner" scope="prototype">
            
            <constructor-arg name="ds" ref="dataSource"></constructor-arg>
        </bean>
    
        
    
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    
            
            <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
            <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/eesy"></property>
            <property name="user" value="root"></property>
            <property name="password" value="123456"></property>
        </bean>
        
    </beans>

### 1.3、数据库（mysql） ###

--------------------

![在这里插入图片描述][20200916200620857.png_pic_center]

### 1.4、测试 ###

--------------------

1.  test

public class AccountServiceTest {
        
    
    
        @Test
        public void testFindAll(){
        
            //获取容器
            ApplicationContext ac = new ClassPathXmlApplicationContext("bean.xml");
    
            AccountService as = ac.getBean("accountService",AccountService.class);
            List<Account> accounts = as.findAllAccount();
            for (Account account:accounts){
        
                System.out.println(account);
            }
        }
    
        @Test
        public void testFindOne(){
        
            //获取容器
            ApplicationContext ac = new ClassPathXmlApplicationContext("bean.xml");
    
            AccountService as = ac.getBean("accountService",AccountService.class);
            Account account = as.findById(3);
            System.out.println(account);
        }
    
        @Test
        public void testSave(){
        
    
        }
    
        @Test
        public void testUpdate(){
        
    
        }
    
        @Test
        public void testDelete(){
        
    
        }
    }

### 1.5、就是个例子是个例子 ###

[2020091619484534.png_pic_center]: /images/20221123/120153339ff647e393189c87d3528205.png
[20200916200620857.png_pic_center]: /images/20221123/8af50733364c4bfea8475fdd9e97af25.png