如何使用MyBatis

1.准备阶段

a、下载MyBatis相应jar包

        b、创建Java工程，导入MyBatis jar包（mybatis-3.4.4.jar）和数据库驱动包

        c、创建表并添加数据

2.使用

a.创建接口

package com.jd.area;

import com.jd.vo.Area;
import org.apache.ibatis.annotations.Param;

public interface IAreaDao {
    String getName(Area area);

    int delete(@Param("id") String id);

    boolean insert(Area area);

    boolean update(Area area);
}

b.创建Test类

package com.jd.test;

import com.jd.area.IAreaDao;
import com.jd.person.IPersonDao;
import com.jd.vo.Area;
import com.jd.vo.Person;
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.InputStream;

public class Test {
    public static void main(String[] args) {
        try {
            InputStream inputStream = Resources.getResourceAsStream("mybatis-confing.xml");
            SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession sqlSession = factory.openSession();
            IAreaDao areaDao = sqlSession.getMapper(com.jd.area.IAreaDao.class);
            Area area = new Area();
            area.setId("0774a568-bfa7-40c3-8c96-75c0e81037a7");
            area.setCode("440281");
            area.setName("信阳信阳A");
            System.out.println(areaDao.update(area));
            /*System.out.println(areaDao.delete("0605ae9d-8564-4588-99a6-2c5e17423c4e"));*/
            /*String name = areaDao.getName("0774a568-bfa7-40c3-8c96-75c0e81037a7","440281");*/
            /*Area area = new Area();
            area.setCode("440281");
            area.setId("0774a568-bfa7-40c3-8c96-75c0e81037a7");
            String name = areaDao.getName(area);
            System.out.println(name);*/
            /*IPersonDao personDao = sqlSession.getMapper(com.jd.person.IPersonDao.class);
            Person person = personDao.getById("3f25059c-831d-48c5-a792-0d92beca4ba7");
            System.out.println(person.getUserName());*/
            sqlSession.commit();
            sqlSession.close();
        }catch (Exception e){
            e.printStackTrace();
        }
    }
}

c.创建名为mybatis-config.xml的xlm文件

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <typeAliases>
        <typeAlias type="java.lang.String" alias="kate"></typeAlias>
        <typeAlias type="com.jd.vo.Person" alias="aaa"></typeAlias>
    </typeAliases>
    <environments default="dev">
        <environment id="dev">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="username" value="root"/>
                <property name="password" value="root"/>
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="area.xml"></mapper>
    </mappers>
</configuration>

d.创建名为UserInfoMapper.xml的xlm文件，代码如下：

<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jd.area.IAreaDao">
    <select id="getName" resultType="kate">
        select name from area where id = #{id} and code = #{code}
    </select>
    <delete id="delete" >
        delete from area where id=#{id}
    </delete>
    <insert id="insert">
        insert into area (id,code,name,parent_code) values (#{id},#{code},#{name},#{parentCode})
    </insert>

    <update id="update">
        update area set code=#{code} ,name=#{name} where id=#{id}
    </update>
</mapper>