mybatis mysql xml配置_Mybatis 之 xml 配置映射文件

1.导入依赖

11

11

org.mybatis

mybatis

3.5.5

mysql

mysql-connector-java

5.1.47

junit

junit

4.11

test

src/main/java

**/*.properties

**/*.xml

false

2. 主配置文件

/p>

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

3. UserMapper.java

public interface UserMapper {

List findAllUser();

}

4. UserMapper.xml

/p>

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

select * from user

5. 测试

public class TestA {

@Test

public void sta() throws IOException {

String path="mybatis-config.xml";

InputStream in = Resources.getResourceAsStream(path);

SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);

SqlSession sqlSession = sessionFactory.openSession();

UserMapper mapper = sqlSession.getMapper(UserMapper.class);

System.out.println(mapper.findAllUser());

}

}