mapper配置:
主配置文件:
主函数写法:
package com.mxh;
import com.mxh.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主配置文件的名称,从类路径的根开始(target/classes)
String config = "mybatis.xml";
//2.读取这个config表示的文件
InputStream is = Resources.getResourceAsStream(config);
//3.创建了SQLSessionFactoryBuilder对象
SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
//4.创建SqlSessionFactory对象
SqlSessionFactory factory = builder.build(is);
//5.【重要】获取SqlSession对象,从SQLSessionFactory中获取SqlSession
SqlSession sqlSession = factory.openSession();
//6.【重要】指定要执行的SQL语句的标识:SQL映射文件中的namespace + "." + 标签中的id值
String sqlId = "com.mxh.dao.StudentDao"+ "." + "selectStudent";
//7.执行SQL语句,通过sqlId找到语句
List selectList = sqlSession.selectList(sqlId);
//8.输出结果
for (Student student : selectList) {
System.out.println("学生:"+student);
}
//9.关闭SQLSession对象
sqlSession.close();
}
}
pom配置文件
4.0.0
com.mxh
day01_helloMybatis
1.0
UTF-8
1.8
1.8
junit
junit
4.11
test
org.mybatis
mybatis
3.5.1
mysql
mysql-connector-java
8.0.26
src/main/java
***.xml
false
src/main/resources
***.xml
false
mybatis的操作步骤