MyBatis架构设计
mybatis架构四层作用:
MyBatis主要组件及其相互关系
组件介绍:
核心配置文件sqlMapConfig.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>
<!--第一部分:数据源配置-->
<environments default="development" >
<environment id="development">
<!-- 使用jdbc事务管理 -->
<transactionManager type="JDBC" />
<!-- 数据库连接池 -->
<dataSource type="POOLED">
<property name="driver" value="com.mysql.cj.jdbc.Driver" />
<property name="url"
value="jdbc:mysql:///mybatis" />
<property name="username" value="root" />
<property name="password" value="123456789" />
</dataSource>
</environment>
</environments>
<!--第二部分:引入映射配置文件-->
<mappers>
<mapper resource="mapper/UserMapper.xml"></mapper>
<!--<mapper class="mapper.UserMapper"></mapper>-->
<!--<package name="mapper"/>-->
</mappers>
</configuration>
实体类映射配置文件置UserMapper.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="user">
<select id="findUserById" parameterType="int" resultType="com.xc.pojo.User" >
SELECT id,username FROM user WHERE id = #{id}
</select>
</mapper>
User类
@Data
public class User{
// ID标识
private Integer id;
// 用户名
private String username;
}
测试类:传统方式,非mapper代理
@Test
public void test1() throws IOException {
InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = sqlSessionFactory.openSession();
User user = sqlSession.selectOne("user.findUserById", 100);
System.out.println(user);
System.out.println("MyBatis源码环境搭建成功....");
sqlSession.close();
}
输出结果:
DEBUG [main] - ==> Preparing: SELECT id,username FROM user WHERE id = ?
DEBUG [main] - ==> Parameters: 100(Integer)
DEBUG [main] - <== Total: 1
User(id=100, username=zhangsan)
MyBatis源码环境搭建成功....
进程已结束,退出代码0