IDEA完整搭建mybatis（一）

1.使用idea搭建mybatis—基于接口
新建maven工程，然后在pom.xml导入依赖。

<dependencies>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>6.0.6</version>
    </dependency>
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
    <dependency>
        <groupId>org.mybatis</groupId>
        <artifactId>mybatis</artifactId>
        <version>3.4.6</version>
    </dependency>
</dependencies>

2.mybtis 的工作流程

//加载配置文件，sqlsessionFactorybuilder创建sqlsessionfactory对象

Reader reader = Resources.getResourceAsReader("config/mybatis-conf.xml");
sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);

//1.创建sqlsessionFactory
SqlSessionFactory sqlSessionFactory = DBtools.getSqlSessionFactory();

//2.创建SqlSession
SqlSession session = sqlSessionFactory.openSession();

//3.session 中创建相应的接口代理类，即mapper对象
UserBeanMapper userBeanMapper = session.getMapper(UserBeanMapper.class);

3.整个工程如下

IDEA完整搭建mybatis（一）

配置mybatis的配置文件mybatis-conf.xml:

<?xml version="1.0" encoding="UTF-8"?>

<!-- Continue editing here -->
<typeAliases>
    <package name="com.jun.entity"></package>
</typeAliases>

<environments default="mybatis">
    <environment id="mybatis">
        <transactionManager type="JDBC"></transactionManager>
        <!-- mybatis提供了3种数据源类型，分别是：POOLED,UNPOOLED,JNDI -->
        <!-- POOLED 表示支持JDBC数据源连接池 -->
        <!-- UNPOOLED 表示不支持数据源连接池 -->
        <!-- JNDI 表示支持外部数据源连接池 -->
        <dataSource type="POOLED">
            <property name="driver" value="${jdbc.driver}" />
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
        </dataSource>
    </environment>
</environments>

<mappers>
    <mapper resource="mapper/UserMapper.xml"></mapper>
</mappers>

mysql.properties

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

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.jun.dao.UserBeanMapper">
    <resultMap id="userBean" type="UserBean">
        <id property="id" column="id"></id>
        <result property="name" column="name"></result>
        <result property="age" column="age"></result>
    </resultMap>
    <select id="queryUserByName"  resultType="UserBean">
        select * from user where name=#{name}
    </select>
    <select id="queryAll" resultMap="userBean">
      select * from user
    </select>

    <insert id="insertUser" parameterType="UserBean">
      insert into user values(#{id},#{name},#{age})
    </insert>

    <delete id="deleteUserByName" parameterType="string">
        delete from user where name=#{name}
    </delete>

    <update id="updateUserById" >
        update user set name=#{name},set age=#{age} where id=#{id}
    </update>

</mapper>

UserBean.java

package com.jun.entity;

/**
 * @author jun
 * @date 2019/1/31
 */
public class UserBean {

    private int id;
    private String name;
    private int age;

    public int getId() {
        return id;
    }

    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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", age=" + age +
                '}';
    }

}

DBtools.java工具类创建sqlsessionfactory

package com.jun;

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

import java.io.IOException;
import java.io.Reader;

/**
 * @author jun
 * @date 2019/1/31
 */
public class DBtools {

    private static SqlSessionFactory sqlSessionFactory;
    static {
        try {
            Reader reader = Resources.getResourceAsReader("config/mybatis-conf.xml");
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(reader);
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
    public static SqlSessionFactory getSqlSessionFactory(){
        return sqlSessionFactory;
    }

}

UserBeanMapper.java

package com.jun.dao;

import com.jun.entity.UserBean;

import java.util.List;

/**
 * @author jun
 * @date 2019/1/31
 */
public interface UserBeanMapper {

    UserBean queryUserByName(String name);

    List<UserBean> queryAll();

    int insertUser(UserBean userBean);

    int deleteUserByName(String name);

    int updateUserById(UserBean userBean,int id);
}

进行验证

    public static void main(String[] args){
       //1.创建sqlsessionFactory
        SqlSessionFactory sqlSessionFactory = DBtools.getSqlSessionFactory();
        //2.创建SqlSession
        SqlSession session = sqlSessionFactory.openSession();
        //3.session 中创建相应的接口代理类，即mapper对象
        UserBeanMapper userBeanMapper = session.getMapper(UserBeanMapper.class);
        System.out.println(userBeanMapper.queryAll());
        try {
            System.out.println(userBeanMapper.deleteUserByName("jun"));
            UserBean u1 = new UserBean();
            u1.setAge(28);
            u1.setName("king");
            u1.setId(3);
            System.out.println(userBeanMapper.insertUser(u1));
            session.commit();//一定要提交，不然所有增删改操作不会生效的
            System.out.println(userBeanMapper.queryAll());
        }catch (Exception e){
            session.rollback();//回滚
        }
    }

4.结合ssm整合来看，mybatis提供了一个整合包，来整合，不过原理大概也是这样子的。都是用sqlsessionfactory来进行持久化。
以上内容，有些是看到别人写的，加上自己也开始学，先记下笔记，也方便后来人看。
http://www.mybatis.org/mybatis-3/zh/configuration.html#typeAliases
详细请看官网更加好。

IDEA完整搭建mybatis（一）

相关推荐