MyBatis基本使用1

1.pom.xm中添加依赖坐标

<dependency>
    <groupId>org.mybatisgroupId>
    <artifactId>mybatisartifactId>
    <version>3.5.5version>
dependency>

2.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="mysql">
        
        <environment id="mysql">
            
            <transactionManager type="JDBC">transactionManager>
            
            <dataSource type="POOLED">
                
                <property name="driver" value="org.postgresql.Driver" />
                <property name="url" value="jdbc:postgresql://localhost:5432/wh3" />
                <property name="username" value="postgres" />
                <property name="password" value="123456" />
            dataSource>
        environment>
    environments>

    <mappers>
        
        <mapper resource="TestMapper.xml" />
    mappers>

configuration>

3.TestMapper.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="test" >
    <select id="GetAll" resultType="com.ld.model.Test" >
        select * from test;
    select>
mapper>

4.使用

//加载mybatis配置文件，SqlSessionFactory
 String resource="mybatis-config.xml";
 InputStream inputStream = Resources.getResourceAsStream(resource);
 SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

 //获取sqlsession对象，用来执行sql
SqlSession sqlSession=sqlSessionFactory.openSession();

 //执行sql
 List tests= sqlSession.selectList("test.GetAll");

 System.out.println(tests);

 sqlSession.close();