java——mybatis——环境搭建——xml实现方式示例

淡淡的烟草味﹌ 2024-03-31 12:15 60阅读 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.example</groupId>
      <artifactId>shujuku</artifactId>
      <version>1.0-SNAPSHOT</version>
    
      <name>shujuku</name>
      
      <url>http://www.example.com</url>
    
      <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.8</maven.compiler.source>
        <maven.compiler.target>1.8</maven.compiler.target>
      </properties>
    
      <dependencies>
        <dependency>
          <groupId>junit</groupId>
          <artifactId>junit</artifactId>
          <version>4.11</version>
          <scope>test</scope>
        </dependency>
    
        <dependency>
          <groupId>mysql</groupId>
          <artifactId>mysql-connector-java</artifactId>
          <version>8.0.27</version>
        </dependency>
    
        <dependency>
          <groupId>org.mybatis</groupId>
          <artifactId>mybatis</artifactId>
          <version>3.5.1</version>
        </dependency>
    
      </dependencies>
    
      <build>
        <pluginManagement>
          <plugins>
            
            <plugin>
              <artifactId>maven-clean-plugin</artifactId>
              <version>3.1.0</version>
            </plugin>
            
            <plugin>
              <artifactId>maven-resources-plugin</artifactId>
              <version>3.0.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-compiler-plugin</artifactId>
              <version>3.8.0</version>
            </plugin>
            <plugin>
              <artifactId>maven-surefire-plugin</artifactId>
              <version>2.22.1</version>
            </plugin>
            <plugin>
              <artifactId>maven-jar-plugin</artifactId>
              <version>3.0.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-install-plugin</artifactId>
              <version>2.5.2</version>
            </plugin>
            <plugin>
              <artifactId>maven-deploy-plugin</artifactId>
              <version>2.8.2</version>
            </plugin>
            
            <plugin>
              <artifactId>maven-site-plugin</artifactId>
              <version>3.7.1</version>
            </plugin>
            <plugin>
              <artifactId>maven-project-info-reports-plugin</artifactId>
              <version>3.0.0</version>
            </plugin>
          </plugins>
        </pluginManagement>
      </build>
    </project>

sun：

![c1d9227924c8427b641b817dc079c2f1.png][]

![9ddafde1391e0a0ec44b361a4fd3c98f.png][]

创建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.jdbc.Driver" />
                    
                    <property name="url" value="jdbc:mysql://localhost:3306/mysql8?characterEncoding=utf8" />
                    <property name="username" value="root" />
                    <property name="password" value="123456" />
                </dataSource>
            </environment>
        </environments>
        
        <mappers>
            <mapper resource="com/sunxl/dao/UserDao.xml"/>
        </mappers>
    </configuration>

![1b1db3e31e8854c5549837fa056fffa8.png][]

创建pojo类：

package com.sunxl.pojo;
    
    public class User {
    
        Integer id;
        String name;
        Integer age;
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    
        public Integer getAge() {
            return age;
        }
    
        public void setAge(Integer age) {
            this.age = age;
        }
    
        @Override
        public String toString() {
            return "Users{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", age=" + age +
                    '}';
        }
    
    }

![69c5ac1634373cee5be9a6039aca5636.png][]

创建dao接口：

package com.sunxl.dao;
    
    import com.sunxl.pojo.User;
    
    import java.util.List;
    
    public interface UserDao {
        List<User> findAll();
    
    }

![2009324ff741789656e4dff050f95a10.png][]

创建映射文件UserDao.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="com.sunxl.dao.UserDao">
        
        <select id="findAll" resultType="com.sunxl.pojo.User">
            select * from USERs
        </select>
    </mapper>

![47ce0aacae1c2f0d97b17148b112f121.png][]

创建测试：

import com.sunxl.dao.UserDao;
    import com.sunxl.pojo.User;
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    public class MybatisTest {
    
        public static void main(String[] args) throws IOException {
    
            InputStream config = Resources.getResourceAsStream("mybatis-config.xml");
    
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
    
            SqlSessionFactory factory = builder.build(config);
    
            SqlSession ss = factory.openSession();
    
            UserDao userdao = ss.getMapper(UserDao.class);
    
            List<User> users = userdao.findAll();
    
            for (User user: users){
                System.out.println(user);
            }
    
            ss.commit();
    
            //4. 释放资源
            ss.close();
    
            config.close();
    
        }
    
    }

![617f06fac73447a3e51c05183c6c7bd2.png][]

结果：

![3f8ed021d768fad3070898c091c30a28.png][]

[c1d9227924c8427b641b817dc079c2f1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/f82f85525c394e6985366f44c8a45d30.png
[9ddafde1391e0a0ec44b361a4fd3c98f.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/28151e5eb0be46848ddf78b4731b18cd.png
[1b1db3e31e8854c5549837fa056fffa8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/2cf32bf929204b80bacf4cbe5551f12f.png
[69c5ac1634373cee5be9a6039aca5636.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/368044ab732a40148351b36b3253f694.png
[2009324ff741789656e4dff050f95a10.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/68fde0cc1e884ad08ae955cf64b2aee0.png
[47ce0aacae1c2f0d97b17148b112f121.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/c98c24a91f14461fbbfb151c1e5e1282.png
[617f06fac73447a3e51c05183c6c7bd2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/79e83488cda541b0807e09500c5c5be1.png
[3f8ed021d768fad3070898c091c30a28.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/961c46d81744491c959044eaff65c16e.png