java使用myBatis+mariadb

最新推荐文章于 2024-01-21 03:38:31 发布

zijid

最新推荐文章于 2024-01-21 03:38:31 发布

阅读量586

点赞数

分类专栏： Java学习文章标签： mybatis java mariadb

本文链接：https://blog.csdn.net/qq_33958502/article/details/128407630

版权

Java学习专栏收录该内容

1 篇文章 0 订阅

订阅专栏

创建maven项目在这里插入图片描述
目录结构

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org</groupId>
    <artifactId>test</artifactId>
    <version>1.0-SNAPSHOT</version>

    <properties>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.11</version>
        </dependency>
        <dependency>
            <groupId>org.mariadb.jdbc</groupId>
            <artifactId>mariadb-java-client</artifactId>
            <version>3.0.6</version>
        </dependency>


    </dependencies>
</project>

添加mybatis坐标和mariadb.jdbc坐标

mybatis.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="org.mariadb.jdbc.Driver"/>
                <property name="url" value="jdbc:mariadb://localhost:3306/test"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

定义数据源和mapper

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="test">
    <select id="selectAll" resultType="org.dao.User">
        select * from user
    </select>
</mapper>

定义sql语句和数据类型这里的数据类型是org.dao.User,
namespace和id都是使用时会用到的如：

sqlSession.selectList("test.selectAll");

User.class

public class User {
    int id;
    String name;
}

定义数据结构，和数据表一样的结构

Main.class

public class Main {
    public static void main(String[] args) throws IOException {
        InputStream inputStream= Resources.getResourceAsStream("mybatis.xml");
        SqlSessionFactoryBuilder sqlSessionFactoryBuilder=new SqlSessionFactoryBuilder();
        SqlSessionFactory sql=sqlSessionFactoryBuilder.build(inputStream);
        SqlSession sqlSession=sql.openSession();
        List<User> users= sqlSession.selectList("test.selectAll");
        System.out.println(users);
    }
}

启动类

InputStream inputStream= Resources.getResourceAsStream(“mybatis.xml”);//加载mybatis配置
SqlSessionFactoryBuilder sqlSessionFactoryBuilder=new SqlSessionFactoryBuilder();
SqlSessionFactory sql=sqlSessionFactoryBuilder.build(inputStream);//获取SqlSessionFactory实例
SqlSession sqlSession=sql.openSession();//获取SqlSession 的实例
List users= sqlSession.selectList(“test.selectAll”);//使用并获得结果

可参考：MyBatis官网和b站视频