纯注解的开发

深碍√TFBOYSˉ_ 2022-01-27 07:59 194阅读 0赞

## 使用纯注解开发 ##

### 目录结构 ###

![目录结构][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]

### JdbcConfiguration ###

package com.itheima.Config;
    
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    import org.apache.commons.dbutils.QueryRunner;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.ComponentScan;
    import org.springframework.context.annotation.Configuration;
    
    import javax.sql.DataSource;
    import java.beans.PropertyVetoException;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/5/25  21:41
     * @description ：
     * @version: 1.0
     */
    @Configuration
    @ComponentScan("com.itheima")
    public class JdbcConfiguration {
        @Value("${jdbc.driver}")
        private String driver;
        @Value("${jdbc.url}")
        private String jdbcUrl;
        @Value("${jdbc.user}")
        private String user;
        @Value("${jdbc.password}")
        private String password;
    
        @Bean("dataSource")
        public DataSource createDataSouce(){
            ComboPooledDataSource dataSource = new ComboPooledDataSource();
            try {
                dataSource.setDriverClass(driver);
            } catch (PropertyVetoException e) {
                e.printStackTrace();
            }
            dataSource.setJdbcUrl(jdbcUrl);
            dataSource.setUser(user);
            dataSource.setPassword(password);
          return dataSource;
        }
        @Bean("queryRunner")
        public QueryRunner createQueryRunner(DataSource dataSource){
            QueryRunner queryRunner = new QueryRunner(dataSource);
            return queryRunner;
        }
    }

### SpringConfiguration ###

package com.itheima.Config;
    
    import com.mchange.v2.c3p0.ComboPooledDataSource;
    import org.apache.commons.dbutils.QueryRunner;
    import org.springframework.context.annotation.*;
    
    import javax.sql.DataSource;
    import java.beans.PropertyVetoException;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/5/25  21:41
     * @description ：
     * @version: 1.0
     */
    @Configuration
    @ComponentScan("com.itheima")
    @PropertySource("db.properties")
    @Import(JdbcConfiguration.class)
    public class SpringConfiguration {
    
    }

### TestCRUD ###

package com.itheima;
    
    import com.itheima.Config.SpringConfiguration;
    import com.itheima.domain.Account;
    import com.itheima.service.AccountService;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.annotation.AnnotationConfigApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    import java.util.List;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/5/25  17:36
     * @description ：
     * @version: 1.0
     */
    public class TestCRUD {
        /**
         * 查询所有用户信息
         * @param
         */
        @Test
        public void testfindAll(){
            ApplicationContext ac = new AnnotationConfigApplicationContext(SpringConfiguration.class);
            AccountService accountService = ac.getBean(AccountService.class);
            System.out.println("accountService:"+accountService);
            List<Account> accountList = accountService.findAll();
            System.out.println("accountList:"+accountList);
            for (Account account1 : accountList) {
                System.out.println(account1);
            }
        }
    }

### db.properties配置文件 ###

![db.properties][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]: /images/20220127/a9b753669fff46db8094a8c9fc46a34f.png
[db.properties]: /images/20220127/9ce9c020d2a34604a0e1637658af59a7.png