MyBatis报错 java.io.IOException: Could not find resource SqlMapConfig.xml

MyBatis报错 java.io.IOException: Could not find resource SqlMapConfig.xml at org.apache.ibatis.io.R1 [待解决问题] 浏览: 15338次 MyBits JUnit 4测试报错项目结构图 全局配置文件 SqlMapConfig.xml 1 <?xml version="1.0" encoding="UTF-8" ?>
2
5
6
7
8
9
10
11
12
13
14
18
19
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
43
44
48
49
50
51
54
55
56
57
58  db.properties1 jdbc.driver=com.mysql.jdbc.Driver
2 jdbc.url=jdbc:mysql://localhost:3306/test
3 jdbc.username=root
4 jdbc.password=rootlog4j.properties1 # Global logging configuration
2 log4j.rootLogger=DEBUG, stdout
3 # Console output…
4 log4j.appender.stdout=org.apache.log4j.ConsoleAppender
5 log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
6 log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%nUser.java 1 package com.etc.po;
2
3 import java.util.Date;
4
5 public class User {
6
7 private int id;
8 private String name;
9 private String password;
10 private String sex;
11 private Date birth;
12 private int age;
13 public int getId() {
14 return id;
15 }
16 public void setId(int id) {
17 this.id = id;
18 }
19 public String getName() {
20 return name;
21 }
22 public void setName(String name) {
23 this.name = name;
24 }
25 public String getPassword() {
26 return password;
27 }
28 public void setPassword(String password) {
29 this.password = password;
30 }
31 public String getSex() {
32 return sex;
33 }
34 public void setSex(String sex) {
35 this.sex = sex;
36 }
37 public Date getBirth() {
38 return birth;
39 }
40 public void setBirth(Date birth) {
41 this.birth = birth;
42 }
43 public int getAge() {
44 return age;
45 }
46 public void setAge(int age) {
47 this.age = age;
48 }
49 @Override
50 public String toString() {
51 return “User [id=” + id + “, name=” + name + “, password=” + password
52 + “, sex=” + sex + “, birth=” + birth + “, age=” + age + “]”;
53 }
54
55
56 }UserMapper.java 1 package com.etc.mapper;
2
3 import java.util.List;
4
5 import com.etc.po.User;
6
7 public interface UserMapper {
8
9 //根据id查询用户
10 public User getUserById(int id) throws Exception;
11 //查询用户列表
12 public List getUsers() throws Exception;
13 }UserMapper.xml 1 <?xml version="1.0" encoding="UTF-8" ?>
2
5
6
7
8
9
19
20
21 SELECT * FROM USER WHERE id = #{id}
22
23
24
25
26
27
33
34 SELECT * FROM USER
35
36
37
38 <!--
41
42
43
44 keyProperty：将主键设置到pojo中哪个属性中
45 order：selectKey中sql执行的时机
46 resultType:selectKey中sql执行的结果类型
47 LAST_INSERT_ID:是insert后获取自增主键值
48
49
50 select LAST_INSERT_ID()
51
52 insert into user(name,password,sex,birth,age)
53 values(#{name},#{password},#{sex},#{birth},#{age})
54
55 -->
56
57
58
59
60  测试类 UserMapperTest.java 1 package test;
2
3 import java.io.IOException;
4 import java.io.InputStream;
5 import java.util.List;
6
7 import org.apache.ibatis.io.Resources;
8 import org.apache.ibatis.session.SqlSession;
9 import org.apache.ibatis.session.SqlSessionFactory;
10 import org.apache.ibatis.session.SqlSessionFactoryBuilder;
11 import org.junit.Before;
12 import org.junit.Test;
13
14 import com.etc.mapper.UserMapper;
15 import com.etc.po.User;
16
17 public class UserMapperTest {
18
19 private SqlSessionFactory sqlSessionFactory;
20
21 @Before
22 public void setUp() throws IOException{
23
24
25 String resource = “SqlMapConfig.xml”;
26 InputStream inputStream = Resources.getResourceAsStream(resource);
27 sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
28
29 }
30
31
32
33 @Test
34 public void test1() throws Exception{
35
36 SqlSession sqlSession = sqlSessionFactory.openSession();
37 UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
38 List users = userMapper.getUsers();
39 System.out.println(users.toString());
40
41 }
42
43
44 @Test
45 public void test2() throws Exception{
46
47 SqlSession sqlSession = sqlSessionFactory.openSession();
48 UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
49 User user = userMapper.getUserById(1);
50 System.out.println(user);
51
52 }
53
54
55 }  运行报错如图  跪求MyBatis高手解答MyBatis远歌 | 菜鸟二级 | 园豆：210 提问于：2016-04-14 11:57 显示帮助 使用"Ctrl+Enter"可进行快捷提交，评论支持部分 Markdown 语法：link italic bold code。 < > 找找看 分享 分享您的问题 微信扫一扫：分享微信里点“发现”，扫一下二维码便可将本文分享至朋友圈。

            所有回答(1)         0                         感觉你的和我用的不一样，你试试我的方法在UserMapper.xml中加入<resultMap id="userMap" type="com.etc.po.User">//对应你的user类--对应表字段<id property="id" column="id" javaType="java.lang.Long" jdbcType="BIGINT"/><result property="name" column="name" javaType="java.lang.String" jdbcType="VARCHAR" />其他。。。同上</resultMap><select id="findUserList" resultMap="userMap" >  SELECT * FROM USER  </select>希望能帮到你悠然886         |        园豆：222         (菜鸟二级)         |        2016-04-14 14:45     已经找到问题了，config -- buildpath。谢谢支持(0)反对(0)远歌         |        园豆：210         (菜鸟二级)         |        2016-04-14 14:58     @远歌: 你好，我也遇到相同的问题，请问您是怎么解决的呢支持(0)反对(0)tsinghua476         |        园豆：200         (初学一级)         |        2016-08-09 10:55     @tsinghua476: config 右键->Build Path->Use as Source Folder