基于自定义Mybatis框架实现数据库操作

末蓝、 2021-12-11 22:35 231阅读 0赞

# 一、场景模拟 #

基于自定义Mybatis框架和已有的Mysql数据库Mybatis，查询所有用户信息。

# 二、创建工程并引入自定义Mybatis框架的坐标 #

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]

<?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>com.william</groupId>
        <artifactId>TestDIYMybatisFramework</artifactId>
        <version>1.0-SNAPSHOT</version>
    
        <properties>
            <maven.compiler.source>1.8</maven.compiler.source>
            <maven.compiler.target>1.8</maven.compiler.target>
        </properties>
        <dependencies>
         
            <dependency>
                <groupId>com.william</groupId>
                <artifactId>DIYMybatisFramework</artifactId>
                <version>1.0-SNAPSHOT</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.6</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
            </dependency>
        </dependencies>
    </project>

# 三、创建domain #

package com.william.domain;
    
    import Framework.domain.Mapper;
    
    import java.util.HashMap;
    import java.util.Map;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/7/9  16:54
     * @description ：
     * @version: 1.0
     */
    public class User {
        private Integer id;
        private String username;
        private String password;
        private String sex;
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    ", sex='" + sex + '\'' +
                    '}';
        }
    
        public Integer getId() {
            return id;
        }
    
        public void setId(Integer id) {
            this.id = id;
        }
    
        public String getUsername() {
            return username;
        }
    
        public void setUsername(String username) {
            this.username = username;
        }
    
        public String getPassword() {
            return password;
        }
    
        public void setPassword(String password) {
            this.password = password;
        }
    
        public String getSex() {
            return sex;
        }
    
        public void setSex(String sex) {
            this.sex = sex;
        }
    }

# 四、创建Sql文件UserMapper.xml #

<?xml version="1.0" encoding="utf-8" ?>
    <mapper namespace="com.william.dao.UserDao">
        <select id="findAll" resultType="com.william.domain.User">
            select * from user
        </select>
    </mapper>

# 五、3.1.5 创建核心配置文件SqlMapConfig.xml #

<?xml version="1.0" encoding="UTF-8" ?>
    <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://127.0.0.1:3306/web02?characterEncoding=utf8" />
                    <property name="username" value="root" />
                    <property name="password" value="root" />
                </dataSource>
            </environment>
        </environments>
    	<mappers>
    		<mapper resource="com/william/mapper/UserMapper.xml"></mapper>
        </mappers>
    </configuration>

# 六、3.1.6 测试 #

## 1.测试程序 ##

package com.william;
    import Framework.dao.SqlSession;
    import Framework.factory.SqlSessionFactory;
    import Framework.factory.SqlSessionFactoryBuilder;
    import org.junit.Test;
    import java.io.InputStream;
    import java.util.List;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/7/9  17:05
     * @description ：
     * @version: 1.0
     */
    public class TestFramework {
        @Test
        public void  test(){
            //获取核心配置文件的流对象
            InputStream inputStream = TestFramework.class.getClassLoader().getResourceAsStream("SqlMapConfig.xml");
            //构建sqlSessionFactory对象
           SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
           //生产SqlSession对象
            SqlSession sqlSession = sqlSessionFactory.openSession();
            //调用selectList方法
            List list = sqlSession.selectList("com.william.dao.UserDao" + "." + "findAll");
            for (Object o : list) {
                System.out.println(o);
            }
            //释放资源
            sqlSession.close();
        }
    }

## 2.测试效果 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70 1]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]: /images/20211211/0e2f2ee3b51a4055bf9e4a01b6b91c66.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70 1]: /images/20211211/193de93778e043bea8933d81f9d433a6.png