myBatis是一个JDBC的增强版,用于操作数据库。其思维导图如下:
p1/49p 三层架构
p2/49p 框架概念
p3/49p JDBC缺陷
p4/49p MyBatis能干什么
p5/49p MyBatis使用步骤
p6/49p 创建mapper文件
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bjpowernode.entity.StudentDao">
<select id="selectStudents" resultType="com.bjpowernode.entity.Student">
select id,name,email,age from student order by id
</select>
</mapper>
p7/49p 创建主配置文件【不用记住】![在这里插入图片描述](https://img-blog.csdnimg.cn/20210610214154333.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L216ajE1MTAxMjI5ODcx,size_16,color_FFFFFF,t_70)
p8/49p 创建SqlSession执行sql语句
package com.bjpowernode;
import com.bjpowernode.entity.Student;
import jdk.internal.loader.Resource;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.jdbc.SQL;
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;
/**
* @Author:马仲杰
* @Date 2021/6/10
**/
public class MyApp {
public static void main(String[] args) throws IOException {
//访问mybatis读取student数据
//1、定义mybatis主配置文件的信息
String config =