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

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

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

为了不影响源码项目的目录结构，新建了两个source folder存放自己编写的代码，如下图

这个小Demo我已经写好，整个项目的文件下载链接：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的配置。成功运行测试类，往数据库插入数据。