Mybatis入门（三）Spring整合Mybatis - xml文件

• • 前言
  • 一、导入依赖
  • 二、编写User实体类
  • 三、编写持久层UserMapper接口
  • 四、编写UserMapper映射文件
  • 五、编写jdbc.properties配置文件
  • 六、编写springContext.xml配置文件
  • 七、编写UserMapperTests测试类
  • 八、demo_user数据库表模板

Mybatis-Spring整合：http://mybatis.org/spring/zh/index.html

pom.xml

        
        
            org.springframework
            spring-context
            5.3.9
        

        
        
            mysql
            mysql-connector-java
            8.0.26
        

        
        
            org.mybatis
            mybatis
            3.5.6
        

        
        
            org.mybatis
            mybatis-spring
            2.0.6
        

        
        
            org.springframework
            spring-jdbc
            5.3.9
        

        
        
            com.alibaba
            druid
            1.1.20
        

        
        
            junit
            junit
            4.13
            test
        

        
        
            org.projectlombok
            lombok
            1.18.20
            provided
        
    

User

@Data
@Accessors(chain = true)
public class User implements Serializable {
    private Integer id;
    private String name;
    private Integer age;
    private String sex;
}

UserMapper

public interface UserMapper {
    List getAllUser();   
}

UserMapper.xml

    
        select * from demo_user
    

jdbc.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/demo_admin?useSSL=false&useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=root

springContext.xml

UserMapperTests

public class UserMapperTests {

    private ApplicationContext ac;

    @Before
    public void init() {
        ac = new ClassPathXmlApplicationContext("springContext.xml");
    }

    @Test
    public void getAllUser() {
        UserMapper mapper = ac.getBean(UserMapper.class);
        List users = mapper.getAllUser();
        // [User(id=1, name=zs, age=18, sex=男), User(id=2, name=ls, age=20, sex=男), User(id=3, name=xiaohong, age=18, sex=女)]
        System.out.println(users);
    }
}