java.io.IOException: Could not find resource mybatis-conifg.xml

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | <?xml version="1.0" encoding="UTF-8" ?><!--文件名可以任意,文件类型一定要是xml文件--><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><!--mybatis.org官网-入门里copy dtd --><configuration> <settings> <!--可以把数据库中的字段如goods_id ==>goodsId --> <setting name="mapUnderscoreToCamelCase" value="true"/> </settings> <environments default="dev"> <!--default属性设置默认使用的数据库--> <environment id="dev"> <!--采用JDBC对数据库对事务commit/rollback--> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <!--使用连接池对数据进行管理--> <property name="driver" value="com.mysql.cj.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/babytun?useUnicode=true&characterEncoding=utf-8;serverTimezone=Asia/Shanghai&"/> <property name="username" value="root"/> <property name="password" value="root"/> </dataSource> </environment> <environment id="dev"> <!--采用JDBC对数据库对事务commit/rollback--> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://192.168.1.155:3306/babytun?useUnicode=true&characterEncoding=utf-8"/> <property name="username" value="root"/> <property name="password" value="abc123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="mappers/test.xml"/> </mappers></configuration> |
1 2 3 4 5 6 7 8 9 | <?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="test"> <select id="sample" resultType="String"> select 'success' </select></mapper> |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | package com.imooc.oa.utils;import org.apache.ibatis.io.Resources;import org.apache.ibatis.session.SqlSession;import org.apache.ibatis.session.SqlSessionFactory;import org.apache.ibatis.session.SqlSessionFactoryBuilder;import java.io.IOException;import java.io.Reader;import java.util.function.Function;public class MyBatilsUtils { private static SqlSessionFactory sqlSessionFactory = null; static { Reader reader = null; try { reader = Resources.getResourceAsReader("mybatis-conifg.xml"); sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader); } catch (IOException e) { throw new ExceptionInInitializerError(e); } } public static Object excuteQuery(Function<SqlSession,Object> func){ SqlSession session = sqlSessionFactory.openSession(); try { Object obj = func.apply(session); return obj; } finally { session.close(); } }} |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | <?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.imooc</groupId> <artifactId>imooc-oa</artifactId> <version>1.0-SNAPSHOT</version> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <configuration> <source>8</source> <target>8</target> </configuration> </plugin> </plugins> </build> <repositories> <repository> <id>aliyun</id> <name>aliyun</name> <url>https://maven.aliyun.com/repository/public</url> </repository> </repositories> <dependencies> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.9</version> </dependency> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.13.2</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.28</version> </dependency> </dependencies></project> |
1 2 3 4 5 6 7 8 9 10 11 | package com.imooc.oa.utils;import org.junit.Test;public class MyBatisUtilsTestor { @Test public void testor1(){ String result = (String)MyBatilsUtils.excuteQuery(sqlSession -> sqlSession.selectOne("test.sample") ); System.out.println(result); }} |

6
收起
正在回答 回答被采纳积分+1
2回答
好帮手慕小小
2022-04-04 13:23:57
同学你好,文件名书写有误,将mybaits-conifg修改为mybatis-config.xml后重新测试运行试下。另外截图中文件图标显示文件为文本文件,建议将其设置为xml格式的文件。可参考:http://class.imooc.com/course/qadetail/321914
祝学习愉快~
java工程师2020版
- 参与学习 人
- 提交作业 9409 份
- 解答问题 16556 个
综合就业常年第一,编程排行常年霸榜,无需脱产即可学习,北上广深月薪过万 无论你是未就业的学生还是想转行的在职人员,不需要基础,只要你有梦想,想高薪
了解课程
恭喜解决一个难题,获得1积分~
来为老师/同学的回答评分吧