如何使用Mybatis

1、下载MyBatis相应jar包

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

3、创建表并添加数据

4、创建接口

package com.jd.area;

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

public interface IAreaDao {
    //一个基本数据类型或String类型参数  mapper中可以使用任意字符串 #{str} 如果两个以上参数，则默认0,1，param1，param2
    //正式开发使用@Param()将参数和#{key}一一对应
    //一个自定义类型，则#{key} key直接是自定义类型属性名
    //String getName(@Param("id")String id,@Param("code")String code);
    String getName(Area area);

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

    boolean insert(Area area);

    boolean update(Area area);


}

5、创建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.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.apache.ibatis.io.Resources;
import java.io.InputStream;

public class Test {
    public static void main(String[] args) {
        try {
            //配置全局加载文件
            InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            //SqlSession对象表示一次数据库连接
            SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession sqlSession=factory.openSession();//true则自动提交事务，false则需要手动提交,默认false
            //从SqlSession获取接口实现类对象

            IAreaDao areaDao=sqlSession.getMapper(com.jd.area.IAreaDao.class);
            //String name=areaDao.getName("000f9a36-cdc1-4784-9ffc-fe1d8a4a0d15","370982");
            /*
            Area area=new Area();
            area.setId("000f9a36-cdc1-4784-9ffc-fe1d8a4a0d15");
            area.setCode("370982");
            String name=areaDao.getName(area);
            System.out.println(name);
            */
            /*
            IPersonDao personDao=sqlSession.getMapper(IPersonDao.class);
            Person person=personDao.getById("13bdf205-9a59-4d96-898f-efc20804406e");
            System.out.println(person.getUserName());
            */
            //System.out.println(areaDao.delete("00224385-6704-45cf-a3f3-00a5d05635c3"));
            Area area=new Area();
            area.setId("000f9a36-cdc1-4784-9ffc-fe1d8a4a0d15");
            area.setCode("11111");
            area.setName("吉林省");
            //area.setParentCode(null);
            System.out.println(areaDao.update(area));

            sqlSession.commit();
            sqlSession.close();
        } catch (Exception e){
            e.printStackTrace();
        }
    }
}

6、创建名为mybatis-config.xml的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>
    <settings>
        <setting name="mapUnderscoreToCamelCase" value="true"/>
    </settings>
    <typeAliases>
        <typeAlias type="java.lang.String" alias="lsq"></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>

        <environment id="test">
            <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对应一个mapper文件-->
        <mapper url="file:///C:/workspace/dubhe/src/main/resources/area.xml"></mapper>
        <mapper resource="person.xml"></mapper>
    </mappers>
</configuration>

7、创建名为UserInfoMapper.xml的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">

<!--namespace 指定接口全名-->
<mapper namespace="com.jd.area.IAreaDao">

    <!--id指定接口中定义的方法名-->
    <select id="getName" resultType="lsq">
        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>