Spring
01: Spring简介
02: Spring–Spring组成及拓展
03: Spring–IoC理论推导&IoC本质
04: Spring–第一个Spring程序HelloSpring&修改上节案例
05: Spring–IoC创建对象方式
06: Spring–Spring配置
07: Spring–依赖注入(Dependency Injection)
08: Spring–Bean的作用域
09: Spring–自动装配Bean(使用自动装配xml配置)
10: Spring–使用注解实现自动装配(推荐使用)
11: Spring–注解开发
12: Spring–使用JavaConfig实现配置
13: Spring–静态代理再理解&AOP
14: Spring–AOP(通过 Spring API 实现&自定义类来实现Aop&使用注解实现)
15: Spring–回忆Mybatis
16: Spring–整合Mybatis
17: Spring–Spring声明式事务
1. 回忆Mybatis
1.1 步骤
- 1.编写实体类
- 2.编写核心配置文件
- 3.编写接口
- 4.编写Mapper.xml
- 5.测试
1.1.1 编写实体类
为下面这个表编写实体类
User.java
package com.tian.pojo;
import lombok.Data;
@Data
public class User {
private int id;
private String name;
private String pwd;
}
1.1.2 编写核心配置文件
mabatis-config.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核心配置文件-->
<configuration>
<typeAliases>
<package name="com.tian.pojo"/>
</typeAliases>
<environments default="development">
<environment id="development">
<transactionManager type="JDBC"/>
<dataSource type="POOLED">
<!--以下数据都是我自己的数据库的信息,请酌情修改-->
<!--&表示转义字符,其含义就是&-->
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url"
value="jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=true"/>
<property name="username" value="root"/>
<property name="password" value="317525"/>
</dataSource>
</environment>
</environments>
<!-- 每一个Mapper.xml都需要在Mybatis核心配置文件中注册!-->
<mappers>
<!-- 可以通过class或是resource配置-->
<!-- <mapper class="com.tian.mapper.UserMapper"/>-->
<mapper resource="com/tian/mapper/UserMapper.xml"/>
</mappers>
</configuration>
1.1.3 编写接口
UserMapper.java
package com.tian.mapper;
import com.tian.pojo.User;
import java.util.List;
public interface UserMapper {
public List<User> selectUser();
}
1.1.4 编写Mapper.xml
UserMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.tian.mapper.UserMapper">
<select id="selectUser" resultType="user">
select *
from mybatis.user;
</select>
</mapper>
1.1.5 测试
Test.java
@org.junit.Test
public void test() throws Exception {
String resources = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resources);
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
// 设置自动提交事务
SqlSession sqlSession = factory.openSession(true);
UserMapper mapper = sqlSession.getMapper(UserMapper.class);
List<User> users = mapper.selectUser();
for (User user : users) {
System.out.println(user);
}
// 关闭sqlSession
sqlSession.close()
}
运行结果: