spring 的纯注解配置实现CRUD

向右看齐 2023-07-18 12:42 15阅读 0赞

##  ##

#### 编写实体类 ####

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

### 编写业务层代码 ###

public interface IAccountService { 
        List<Account> findAllAccount();
        Account findAccountById(Integer accountId);
        void saveAccount(Account account);
        void updateAccount(Account account);
        void deleteAccount(Integer accountId);
    }

#### 编写业务层实现类 ####

@Service("accountService")
    public class AccountServiceImpl implements IAccountService { 
        @Autowired
        private IAccountDao accountDao;
        
        public List<Account> findAllAccount() { 
            return accountDao.findAllAccount();
        }
    
        public Account findAccountById(Integer accountId) { 
            return accountDao.findAccountById(accountId);
        }
    
        public void saveAccount(Account account) { 
            accountDao.saveAccount(account);
        }
    
        public void updateAccount(Account account) { 
            accountDao.updateAccount(account);
        }
    
        public void deleteAccount(Integer accountId) { 
            accountDao.deleteAccount(accountId);
        }
    }

### 编写持久层代码 ###

public interface IAccountDao { 
        List<Account> findAllAccount();
        Account findAccountById(Integer accountId);
        void saveAccount(Account account);
        void updateAccount(Account account);
        void deleteAccount(Integer accountId);
    }

#### 编写持久层实现类 ####

@Repository("accountDao")
    public class AccountDaoImpl implements IAccountDao { 
        @Autowired
        private QueryRunner 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 findAccountById(Integer accountId) { 
            try { 
                return runner.query("select * from account where id=?", new BeanHandler<Account>(Account.class), accountId);
            } 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 updateAccount(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 accountId) { 
            try { 
                runner.update("delete from account where id=?",accountId);
            } catch (Exception e) { 
                throw new RuntimeException(e);
            }
        }
    }

通过注解实现CRUD，虽然省去了配置bean.xml,但是需要两个配置类

jdbcConfig

@Configuration
    public class jdbcConfig { 
        @Value("${jdbc.driver}")
        private String driver;
        @Value("${jdbc.url}")
        private String url;
        @Value("${jdbc.username}")
        private String username;
        @Value("${jdbc.password}")
        private String password;
        @Bean(name = "runner")
        @Scope("prototype")
        public QueryRunner createQueryRunner(DataSource dataSource){ 
            return new QueryRunner(dataSource);
        }
        @Bean(name = "dataSource")
        public DataSource createDatasource(){ 
            try { 
                ComboPooledDataSource ds=new ComboPooledDataSource();
                ds.setDriverClass(driver);
                ds.setJdbcUrl(url);
                ds.setUser(username);
                ds.setPassword(password);
                return ds;
            } catch (Exception e) { 
                throw new RuntimeException(e);
            }
        }

SpringConfiguration

//@Configuration
    @ComponentScan("com.itxiaoliu")
    @Import(jdbcConfig.class)
    @PropertySource("classpath:jdbcConfig.properties")
    public class SpringConfiguration { 
    
    }

jdbcConfig.properties

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql:///address?serverTimezone=UTC
    jdbc.username=xiaoliu
    jdbc.password=960614abcd

#### 编写测试类 ####

@RunWith(SpringJUnit4ClassRunner.class)
    @ContextConfiguration(classes = SpringConfiguration.class)
    public class AccountServiceTest { 
    
        @Autowired
        private IAccountService as;
    
        @Test
        public void testFindAll() { 
            //ApplicationContext ac=new ClassPathXmlApplicationContext("bean.xml");
            List<Account> accounts=as.findAllAccount();
            for (Account account : accounts) { 
                System.out.println(account);
            }
        }
    
        @Test
        public void testFindOne() { 
            //ApplicationContext ac=new ClassPathXmlApplicationContext("bean.xml");
            Account account=as.findAccountById(1);
            System.out.println(account);
        }
    
        @Test
        public void testSave() { 
            Account account=new Account();
            account.setName("test");
            account.setMoney(12345f);
            as.saveAccount(account);
        }
    
        @Test
        public void testUpdate() { 
            Account account=as.findAccountById(1);
            account.setMoney(23456f);
            as.updateAccount(account);
        }
    
        @Test
        public void testDelete() { 
            as.deleteAccount(4);
        }
    }

这样就实现了纯注解通过spring实现CRUD