今天完成的事情：

Spring整合Mybatis

编写实体类

编写持久层接口

编写service层接口

编写service层实现类

Spring 配置文件

测试类

明天计划的事情：

学会使用Junit

遇到的问题：

错误信息: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'accountService'

解决

无法创建service实体类，因为在spring容器中id已经存在了，所以报这个错

错误信息：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 

### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

### The error may exist in com/xiuzhen/dao/AccountDao.java (best guess)

### The error may involve com.xiuzhen.dao.AccountDao.findAll

### The error occurred while executing a query

### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!

解决

修改前

修改后

sql语句编写，应该是因为预编译的问题

收获：

学会了Spring整合Mybatis