Mybatis的基本使用实例

文章是看了mybatis快速入门视频之后整理的实例资源笔记，想学习如何搭建mybatis连接数据库的可以参考一下、异常处理不捕捉了、

所需jar包

mybatis-3.1.1完整包，可以去官网下载，下载论坛也可以搜索到，内含核心包mybatis-3.1.1.jar和几个dtd模板，lib里有功能依赖包用于拓展.

1.新建java工程，工程路径下新建文件夹lib，复制mybatis-3.1.1.jar和
mysql-connector-java-5.1.16.jar进lib，右键两个jar 添加进build path放入Refference Library

2.在src下创建配置文件conf.xml,待会写，创建com.ft.mybatisUtil包，新建MybatisUtil类

package com.ft.mybatis.mybatisUtil;

import java.io.InputStream;

import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import com.ft.mybatis.Test;

public class MybatisUtil {
    public static SqlSessionFactory getSessionFactory(){
        String resource = "conf.xml";
        InputStream reader = Test.class.getClassLoader().getResourceAsStream(resource);
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(reader);
        return sessionFactory;
    }
}

3.配置数据库mysql，分别执行下列语句,建立一个简单用户表

CREATE DATABASE mybatis;
USE mybatis;
CREATE TABLE users(id INT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(20),age INT);
INSERT INTO users(name,age) Values('Tom',12);

4.配置conf.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>  

<properties resource="db.properties"></properties>

<typeAliases>
        <typeAlias type="com.ft.mybatis.User" alias="User"/>
</typeAliases>
    <!-- 对事务的管理和连接池的配置 --> 
     <!-- development可改为work，前者是开发模式，后者是工作模式 --> 
    <environments default="development">  
        <environment id="development">  
            <transactionManager type="JDBC" />  
            <dataSource type="POOLED">  
                <property name="driver" value="${driver}" />  
                <property name="url" value="${url}" />  
                <property name="username" value="${username}" />  
                <property name="password" value="${password}" />

            </dataSource>  
        </environment>  
    </environments>  

    <!-- mapping 文件路径配置 -->  

    <mappers>  
        <mapper resource="com/ft/mybatis/userMapper.xml" /> 
        <mapper class="com.ft.test3.UserMapper" />
    </mappers>  
</configuration>

其中，db.properties单独建立在src下:

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis
username=root
password=123

conf.xml底下的mapping注册配置有两个，第一个是用Xmapper.xml来配置sql语句，第二个是用接口注解来配置sql语句，的两种注册方式.

5.创建包com.ft.mybatis,包内新建类User.java，这是model实体

package com.ft.mybatis;

public class User {
    private int id;


    public User(int id, String name, int age) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public User( String name, int age) {
        super();
        this.name = name;
        this.age = age;
    }
    private String name;
    private int age;

    public int getId() {
        return id;
    }
    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }

    public User(){}
}

同位置创建userMapper.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="com.ft.mybatis.userMapper">
   <!-- 根据id获取user -->
    <select id="getUser" parameterType="int" resultType="User">
        select * from users where id=#{id}  
    </select>

    <insert id="addUser" parameterType="User">
        insert into users(name,age) values(#{name},#{age})
    </insert>

    <delete id="deleteUser" parameterType="int">
        delete from users where id=#{id}
    </delete>
    <update id="updateUser" parameterType="User">
        update users set name=#{name},age=#{age} where id=#{id} 
    </update>

    <select id="getAllUser" resultType="User">
        select * from users 
    </select>
  </mapper>

这是基于配置来处理sql语句，对USER的CRUD操作,该Mapper文件已经在conf.xml里注册，可以回过头去看，同位置新建Test.java,内容如下:

package com.ft.mybatis;

import java.io.IOException;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;

import com.ft.mybatis.mybatisUtil.MybatisUtil;

public class Test {
    public static void main(String[] args) throws IOException {


        //获得Session
        SqlSessionFactory sessionFactory = MybatisUtil.getSessionFactory();
        SqlSession session = sessionFactory.openSession();
        //定位配置里的命名空间和userMapper里的select标签的id
        String statement = "com.ft.mybatis.userMapper"+".getUser";
        int queryId = 1;
        User user = session.selectOne(statement,queryId);
        System.out.println(user);
    }
}

可以注意内个statement是由userMapper.xml的namespace和id组成，执行一下Test.java,会在控制台输出

User [id=1, name=Tom, age=12]

第一种使用方法介绍完了，然后是基于接口注解处理sql语句

新建包com.ft.test3,新建Test3.java

package com.ft.test3;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.junit.Test;

import com.ft.mybatis.User;
import com.ft.mybatis.mybatisUtil.MybatisUtil;

public class Test3 {
    @Test
    public void testAnnotationUpdate(){
        try {
            SqlSessionFactory sessionFactory = MybatisUtil.getSessionFactory();
            SqlSession session = sessionFactory.openSession();

            UserMapper userMapper = session.getMapper(UserMapper.class);
            int i = userMapper.addUser(new User("Pink",9));
            session.commit();
            session.close();
            System.out.println(i);
        } catch (Exception e) {
            // TODO: handle exception
            System.out.println(e);
        }

    }
}

这里直接用单元测试的方法做了，也可以像上面一样用main
同位置新建接口类UserMapper.java

package com.ft.test3;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.ft.mybatis.User;

public interface UserMapper {
    @Insert("insert into users(name,age) values(#{name},#{age})")
    public int addUser(User user);

    @Delete("delete from users where id=#{id}")
    public int deleteUserById(int id);

    @Update("update users set name=#{name},age=#{age} where id=#{id}")
    public int update(User user);

    @Select("select * from users where id=#{id}")
    public int getUserById(int id);

    @Select("select * from users")
    public List<User> getAll();
}

然后右键把Test3跑起来，执行结果1，并且数据库中多了Pink用户的数据.值得注意的是，mybatis的session提交是默认手动提交事务，也就是说如果不commit一下，数据库中不会真正添加进数据，但是实际上添加过，这一点你可以手动添加一个用户试试，自增长的id会跳两位。