mybatis作用:
数据持久化:
- 持久化就是将程序的数据持久状态和瞬时状态的过程
- 内存:断电信息就会丢失
- 数据库(jdbc),io文件的持久化
为什么需要持久化?
- 有一些对象不能让他丢掉
- 内存太贵
为什么使用Mybatis?
帮助程序员将数据存入数据库
方便
传统jdbc代码太复杂,简化框架
优点:
SQL和代码分离,提高了可维护性
提供映射标签,支持对象和数据库的orm字段的关系映射
提供了xml标签,支持动态SQL
mybatis思路
搭建环境 - 导入mybatis - 编写代码 -测试
1,新建数据库
2,新建maven项目
3.导入依赖
mysql mybatis Junit lombok
<dependencies>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.12</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.17</version>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.13</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.5</version>
</dependency>
</dependencies>
<build>
<resources>
<resource>
<directory>src/main/java</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xm</include>
</includes>
<filtering>false</filtering>
</resource>
<resource>
<directory>src/main/resources</directory>
<includes>
<include>**/*.properties</include>
<include>**/*.xml</include>
</includes>
<filtering>false</filtering>
</resource>
</resources>
</build>
4,新建模块
5,模块下在resources下新建xml配置文件
(1)数据库连接
- 新建db.properties文件
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/xinzhishopa?useSSL=true&&useUnicode=true&serverTimezone=GMT%2B8&characterEncoding=utf8
username=root
password=Root123456
(2)xml中配置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!--导入数据源-->
<properties resource="db.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
<!--导入配置的xml映射文件-->
<mappers>
<mapper resource="mapper/UserMapper.xml"/>
</mappers>
</configuration>
6.编写mybatis工具类
private static SqlSessionFactory sqlSessionFactory;
static {
try {
//加载xml配置文件
String resource = "mybatis-config.xml";
InputStream resourceAsStream = Resources.getResourceAsStream(resource);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
}catch (Exception e){
e.printStackTrace();
}
}
public static SqlSession getSqlSession(){
return sqlSessionFactory.openSession();
}
7.编写代码
1.新建pojo实体类
2.新建接口和接口实习类
3.编写mapper.xml
<?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.dao.IUserDao">
****sql代码***
</mapper>
# resultMap 结果集
# resultType="com.pojo.User" 返回类型
# resultMap 参数
# parameterType 参数类型
8.给自己的类设定别名
在pom中加
<typeAliases>
<typeAlias type="com.xinzhi.entity.User" alias="别名"/>
</typeAliases>
注解加别名
@Alias("User")
9.Test测试类
private SqlSession session;
@Before
public void before(){
try {
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
session = sqlSessionFactory.openSession();
}catch (Exception e){
e.printStackTrace();
}
}
@Test
public void selAllUser(){
UserDaoMapper mapper = session.getMapper(UserDaoMapper.class);
List<User> user = mapper.user();
for (User user1 : user) {
System.out.println(user1);
}
}
@After
public void after(){
session.commit();
session.close();
}
mybatis核心配置文件:
configuration(配置)
-properties(属性)
-settings(设置)
-typeAliases(类型别名)
-typeHandlers(类型处理器)
-objectFactory(对象工厂)
-plugins(插件)
-environments(环境配置)
environment(环境变量)
transactionManager(事务管理器)
dataSource(数据源)
-databaseIdProvider(数据库厂商标识)
-mappers(映射器)
properties(属性)
数据库连接:
- 新建db.properties文件
driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/xinzhishopa?useSSL=true&&useUnicode=true&serverTimezone=GMT%2B8&characterEncoding=utf8
username=root
password=Root123456
- xml中配置
<!--导入数据源-->
<properties resource="db.properties"/>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<property name="driver" value="${driver}"/>
<property name="url" value="${url}"/>
<property name="username" value="${username}"/>
<property name="password" value="${password}"/>
</dataSource>
</environment>
</environments>
typeAliases(类型别名)
&实体类(entity,pojo)比较少的时候使用第一种,实体类比较多的时候使用第二种
#注意要写在mybatis-config.xml文件的最上面位置,当别名定义完之后,在mapper.xml中返回值就可以直接用Author来表示
<typeAliases>
<typeAlias alias="Author" type="com.entity.***"/>
</typeAliases>
#扫包起别名
<typeAliases>
<package name="com.entity"/>
</typeAliases>
#注解起别名
在实体类上加
@Alias("User")注解
settings(设置)
cacheEnabled 缓存开启关闭 true | false
mapUnderscoreToCamelCase 驼峰式命名 true | false
mappers(映射器)
扫包的形式进行映射
<!-- 将包内的映射器接口实现全部注册为映射器 -->
<mappers>
<package name="org.mybatis.builder"/>
</mappers>