Mybatis-牛刀小试

最新推荐文章于 2025-06-02 09:40:08 发布

原创最新推荐文章于 2025-06-02 09:40:08 发布 · 168 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MyBatis

MyBatis 专栏收录该内容

1 篇文章

订阅专栏

本文详细介绍了如何使用MyBatis框架与MySQL数据库进行整合，包括在Maven项目中配置MyBatis依赖、数据库驱动，以及创建Mapper映射文件和配置文件。通过一个具体的例子，展示了如何从数据库中查询Blog数据。

用 Maven 来构建项目，则需将下面的 dependency 代码置于 pom.xml 文件中：

        <!-- 引入mybatis依赖 -->
        <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>3.2.6</version>
        </dependency>
        <!-- 数据库驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.11</version>
        </dependency>

BlogMapper.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="zl.mapper.BlogMapper">
<select id="selectBlog" resultType="zl.bean.Blog">
    select * from blog where id = #{id}
  </select>
</mapper>

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="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://192.168.199.174:3306/mybatis?useUnicode=true&amp;useSSL=false"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="mybatis/mapper/BlogMapper.xml"/>
    </mappers>
</configuration>

Blog

public class Blog {

    private int id;

    private String dbname;
//省略get set toString method
 }

编写测试类

public class Test {
    public static void main(String[] args) throws IOException {
        String resource = "mybatis/config/mybatis-config.xml";
        InputStream inputStream = null;
        inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //zl.mapper.BlogMapper.selectBlog = namespace.id
        Blog blog = sqlSessionFactory.openSession().selectOne("zl.mapper.BlogMapper.selectBlog", 1);
        System.out.println(blog);
    }
}

在这里插入图片描述