1. package com.github.ybqdren;
    2. import com.github.ybqdren.dao.UserMapper;
    3. import com.github.ybqdren.pojo.User;
    4. import org.apache.ibatis.io.Resources;
    5. import org.apache.ibatis.session.SqlSession;
    6. import org.apache.ibatis.session.SqlSessionFactory;
    7. import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    8. import org.springframework.boot.autoconfigure.SpringBootApplication;
    9. import java.io.IOException;
    10. import java.io.InputStream;
    11. import java.sql.SQLException;
    12. import java.util.List;
    13. /**
    14. * <h1> </h1>
    15. *
    16. * @Author zhao wen
    17. * @Version 0.0.1
    18. * @Date 2022/3/4
    19. **/
    20. @SpringBootApplication
    21. public class MyBatisDemoApplication {
    22. public static void main(String[] args) throws ClassNotFoundException, SQLException {
    23. // 第一阶段:MyBatis 初始化阶段
    24. String resource = "mybatis-config.xml";
    25. // 得到配置文件的输入流
    26. InputStream inputStream = null;
    27. try {
    28. // 讲配置文件的路径传递给了 Resource 中的 getResourceAsStream 方法
    29. inputStream = Resources.getResourceAsStream(resource);
    30. } catch (IOException e) {
    31. e.printStackTrace();
    32. }
    33. // 得到 SqlSessionFactory
    34. SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
    35. // 第二阶段:数据读写阶段
    36. try (SqlSession session = sqlSessionFactory.openSession()) {
    37. // 找到接口对应的实现
    38. UserMapper userMapper = session.getMapper(UserMapper.class);
    39. // 组建查询参数
    40. User userParam = new User();
    41. userParam.setSchoolName("Sunny School");
    42. //调用接口展开数据库操作
    43. List<User> userList = userMapper.queryUserBySchoolName(userParam);
    44. // 打印查询结果
    45. for (User user : userList) {
    46. System.out.println("name: " + user.getName() + "; email" + user.getEmail());
    47. }
    48. }
    49. }
    50. }