12. Spring整合mybatis

1. 环境说明

在pom.xml中添加spring-context、druid、mybatis、mysql-connector-java等基础依赖

1.1 数据层dao

public interface AccountDao {
   

    @Insert("insert into tbl_account(name,money)values(#{name},#{money})")
    void save(Account account);

    @Delete("delete from tbl_account where id = #{id} ")
    void delete(Integer id);

    @Update("update tbl_account set name = #{name} , money = #{money} where id = #{id} ")
    void update(Account account);

    @Select("select * from tbl_account")
    List<Account> findAll();

    @Select("select * from tbl_account where id = #{id} ")
    Account findById(Integer id);
}

1.2 业务层接口

public interface AccountService {
   

    void save(Account account);

    void delete(Integer id);

    void update(Account account);

    List<Account> findAll();

    Account findById(Integer id);

}

1.3 业务层实现类

@Service
public class AccountServiceImpl implements AccountService {
   

    @A