org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLException: No suitable driver found for http://www.example.com ### The error may exist in com/daydaystudy/dao/UserMapper.java (best guess) ### The error may involve com.daydaystudy.dao.UserMapper.getUsers ### The error occurred while executing a query ### Cause: java.sql.SQLException: No suitable driver found for http://www.example.com问题原因:
在mybatis-config.xml 配置文件中,使用EL表达式时,出现识别错误,可能识别到了其他的资源
# db.properties文件 driver=com.mysql.cj.jdbc.Driver #就是这个url url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF8 username=root password=root
解决方法:
将.properties文件中的数据库url参数后加一个字母或数字,使其唯一
# db.properties文件 driver=com.mysql.cj.jdbc.Driver #例如,改为url1 url1=jdbc:mysql://localhost:3306/mybatis?useSSL=true&useUnicode=true&characterEncoding=UTF8 username=root password=root
测试结果
(。・`ω´・)



