从XML文件搭建Mybatis

最新推荐文章于 2024-04-20 18:36:56 发布

siaber

最新推荐文章于 2024-04-20 18:36:56 发布

阅读量106

点赞数

分类专栏： MyBatis 文章标签： MyBatis

本文链接：https://blog.csdn.net/u012634608/article/details/89925921

版权

MyBatis 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

参考：http://www.mybatis.org/mybatis-3/zh/getting-started.html

1、maven添加依赖

<dependency>
  <groupId>org.mybatis</groupId>
  <artifactId>mybatis</artifactId>
  <version>x.x.x</version>
</dependency>

2、在classpath添加mybais配置文件mybatis-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>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${db.driver}"/>
                <property name="url" value="${db.url}"/>
                <property name="username" value="${db.user}"/>
                <property name="password" value="${db.pwd}"/>
            </dataSource>
        </environment>
    </environments>
</configuration>

3、从 XML 中构建 SqlSessionFactory

String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

4、从 SqlSessionFactory 中获取 SqlSession

SqlSession session = sqlSessionFactory.openSession();
try {
  Blog blog = (Blog) session.selectOne("org.mybatis.example.BlogMapper.selectBlog", 101);
} finally {
  session.close();
}

SqlSession便是我们用来和数据库打交道了的了。