学习教程黑马mybatis教程全套视频教程2天Mybatis框架从入门到精通

https://mybatis.net.cn/index.html

MyBatis

创建user表添加数据创建模块导入坐标编写mybatis核心配置文件

统一管理sql语句解决硬编码问题编码

定义POJO类对应数据库的表加载核心配置文件获取SqlSessionFactory对象获取SQLSession对象执行sql语句释放资源

创建模块

dependencies!--mybatis依赖--dependencygroupIdorg.mybatis/groupIdartifactIdmybatis/artifactIdversion3.5.9/version/dependency!--mysql驱动依赖--dependencygroupIdmysql/groupIdartifactIdmysql-connector-java/artifactIdversion8.0.31/version/dependency!--

junit

--dependencygroupIdjunit/groupIdartifactIdjunit/artifactIdversion4.13.2/versionscopetest/scope/dependency!--

slf4j

--dependencygroupIdorg.slf4j/groupIdartifactIdslf4j-api/artifactIdversion1.7.30/version/dependency!--

logback

--dependencygroupIdch.qos.logback/groupIdartifactIdlogback-classic/artifactIdversion1.2.3/version/dependencydependencygroupIdch.qos.logback/groupIdartifactIdlogback-core/artifactIdversion1.2.3/version/dependency/dependenciessrc/main/resources/logback.xml

?xml

console表示当前日志信息是可以输出到控制台的--appender

nameConsole

classch.qos.logback.core.ConsoleAppenderencoderpattern【%level】

%cyan(【%thread】)

%n/pattern/encoder/appenderlogger

namecom.Carter_x

src/main/resources/mybatis-config.xml

?xml

3.0//ENhttp://mybatis.org/dtd/mybatis-3-config.dtd

iddevelopmenttransactionManager

typeJDBC/dataSource

valuecom.mysql.cj.jdbc.Driver/property

nameurl

valuejdbc:mysql://localhost:3306/test/property

nameusername

value123456//dataSource/environment/environmentsmappersmapper

resourceorg/mybatis/example/BlogMapper.xml//mappers

src/main/resources/UserMapper.xml表示是来操作user表的sql映射文件

?xml

3.0//ENhttp://mybatis.org/dtd/mybatis-3-mapper.dtd!--

namespace:

resultTypecom.example.pojo.Userselect

from

}修改mybatis-config.xml文件指定刚才创建的sql映射文件

mappers!--

org.apache.ibatis.io.Resources;

import

org.apache.ibatis.session.SqlSession;

import

org.apache.ibatis.session.SqlSessionFactory;

import

org.apache.ibatis.session.SqlSessionFactoryBuilder;public

class

1、加载mybatis的核心配置文件获取SqlSessionFactory对象下面的是从官网复制的String

resource

Resources.getResourceAsStream(resource);SqlSessionFactory

sqlSessionFactory

SqlSessionFactoryBuilder().build(inputStream);//

sqlSession

sqlSessionFactory.openSession();//

3、执行sql语句查询所有数据//

指定要执行的sql语句这里传入对应的标识对应UserMapper.xml文件中select

idselectAllUser

sqlSession.selectList(test.selectAllUser);System.out.println(userList);System.out.println(数据总条数

userList.size());//