问题1:Cause: java.io.IOException: Could not find resource com/sz/mapper/GirlMapper.xml
目录如下,此问题首先检查GirlMapper.xml路径是否正确
1.将mapper放在resources目录下面
2.在mybatiis.cfg.xml中配制<mappers></mapper>
<mappers>
<mapper resource="com/sz/mapper/GirlMapper.xml"/>
</mappers>
改为
<mappers>
<mapper resource="com.sz.mapper/GirlMapper.xml"/>
</mappers>
此处注意idea的resources中目录不像class一样分级,而是直接作为了目录名
问题2:连接mysql8.0是要用mysql-connector-java8.0版本的
配制如下
<environments default="dev">
<environment id="dev">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="UNPOOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT"/>
<property name="username" value="root"/>
<property name="password" value="root123"/>
</dataSource>
</environment>
</environments>
mysql8.0中有时区的差别,故要添加上serverTimezone=GMT
由于idea将&当做特殊字符,故使用&代替