mybatis学习（2）---建立Demo

不念不忘少年蓝@ 2022-09-26 03:14 130阅读 0赞

**写mybatis相关的博客主要是为了学习源码，都是现学现写，更新速度龟速。前期先写mybatis的运用，之后再深入理解。**

上一节已经导入了mybatis源码项目，这次我们建立一个小Demo，往数据库里插入数据，需要在pom.xml配置mysql连接的jar。

为了不影响源码项目的目录结构，新建了两个source folder存放自己编写的代码，如下图  
![这里写图片描述][20160919175430187]  
这个小Demo我已经写好，整个项目的文件下载链接：[http://pan.baidu.com/s/1mhOSvA4][http_pan.baidu.com_s_1mhOSvA4] 密码：8je4

SqlSessionFactoryUtil.java

package cn.wtzvae.util;
    
    import java.io.IOException;
    import java.io.Reader;
    
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    
    public class SqlSessionFactoryUtil {
    
    
        public static SqlSessionFactory getSqlSessionFactory(){
            String path = "mybatis-config.xml";
            SqlSessionFactory sqlSessionFactory = null;
            try {
                Reader reader = Resources.getResourceAsReader(path);
                sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
            } catch (IOException e) {
                System.out.println("获取配置文件失败");
                e.printStackTrace();
            }
    
            return sqlSessionFactory;
        }
    }

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>
        <typeAliases>
            <package name="cn.wtzvae.model"/>
        </typeAliases>
    
        <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/db_mybatis" />
                    <property name="username" value="mybatis" />
                    <property name="password" value="123456"/>
                </dataSource>
            </environment>
        </environments>
    
    
        <mappers>
            <mapper resource="cn/wtzvae/mappers/PersonMapper.xml"/>
        </mappers>
    
    </configuration>

PersonMapper.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="cn.wtzvae.dao.PersonDao">
    
        <insert id="insert" parameterType="Person">
            INSERT INTO person (name, age, phone, email, address)
            VALUES(#{name},#{age},#{phone},#{email},#{address})
        </insert>   
    
    </mapper>

Person.java

package cn.wtzvae.model;
    
    public class Person {
    
        private int id;
        private String name;
        private int age;
        private String phone;
        private String email;
        private String address;
        //....
        getXXX();
        setXXX();
    }

PersonDao.java

package cn.wtzvae.dao;
    
    import cn.wtzvae.model.Person;
    
    public interface PersonDao { 
    
        public int insert(Person p);
    }

TestFactory.java

package cn.wtzvae.test;
    
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.junit.Test;
    
    import cn.wtzvae.dao.PersonDao;
    import cn.wtzvae.model.Person;
    import cn.wtzvae.util.SqlSessionFactoryUtil;
    
    public class TestFactory {
    
        @Test
        public void test(){
            SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtil.getSqlSessionFactory();
            SqlSession sqlSession = sqlSessionFactory.openSession();
            sqlSession.getConnection();
            PersonDao personDao =  sqlSession.getMapper(PersonDao.class);
            Person p = new Person();
            p.setAddress("广东省");
            p.setAge(12);
            p.setEmail("jinanvae@163.com");
            p.setName("啊角");
            p.setPhone("110");
            personDao.insert(p);
            sqlSession.commit();
            sqlSession.close();
        }
    }

以上是本次小demo的多有代码，之后再详细介绍mybatis的配置。成功运行测试类，往数据库插入数据。

[20160919175430187]: /images/20220717/242d7cf2ad9f43248e96d92d8b8e5fd5.png
[http_pan.baidu.com_s_1mhOSvA4]: http://pan.baidu.com/s/1mhOSvA4