Mybatis查询操作

package com.yuhang;


import com.yuhang.domain.Student;
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.InputStream;
import java.util.List;

public class MyApp {
    public static void main(String[] args) throws IOException {
        //访问mybatis读取student数据
        //1.定义mybatis主配置文件的名称,从路径的根开始
        String config = "mybatis.xml";
        //2.读取这个config表示文件
        InputStream in = Resources.getResourceAsStream(config);
        //3.创建SqlSessionFactoryBuilder对象
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        //4.创建SqlSessionFactory对象
        SqlSessionFactory factory = builder.build(in);
        //5.【重要】获取SqlSession对象,从SqlSessionFactory中获取SqlSession
        SqlSession sqlSession =factory.openSession();
        //6.【重要】指定要执行的sql语句的标识,sql映射文件的namespace+"."+标签的id值
        String sqlId = "com.yuhang.dao.StudenDao"+"." +"selectStudents";
        //7.执行sql语句,通过sqlId找到语句
        List<Student> studentList = sqlSession.selectList(sqlId);
        //8.输出结果
//        for (Student stu:studentList){
//            System.out.println(stu);
//        }
        studentList.forEach(student -> System.out.println(student));

        //9.关闭sqlSession对象
        sqlSession.close();
    }
}

 

posted @ 2021-09-29 16:38  wbnsyw  阅读(137)  评论(0)    收藏  举报