MyBatis的介绍

一，MyBatis的简介

mybatis是一款用于持久层的、轻量级的半自动化ORM框架，封装了所有jdbc操作以及设置查询参数和获取结果集的操作，支持自定义sql、存储过程和高级映射。

是一个可以自定义SQL、存储过程和高级映射的持久层框架。MyBatis 摒除了大部分的JDBC代码、手工设置参数和结果集重获。MyBatis 只使用简单的XML 和注解来配置和映射基本数据类型、Map 接口和POJO 到数据库记录。相对Hibernate和Apache OJB等“一站式”ORM解决方案而言，Mybatis 是一种“半自动化”的ORM实现。

二，MyBatis的好处

1. 与JDBC相比，减少了50%以上的代码量。　
2. MyBatis是最简单的持久化框架，小巧并且简单易学。　
3. MyBatis灵活，不会对应用程序或者数据库的现有设计强加任何影响，SQL写在XML里，从程序代码中彻底分离，降低耦合度，便于统一管理和优化，可重用。　
4. 提供XML标签，支持编写动态SQL语句　
5. 提供映射标签，支持对象与数据库的ORM字段关系映射

三，使用MyBatis完成增删改查模糊查询

数据库部分代码

#判断存在即删除数据库
drop database if exists mydb;
#创建数据库
create database mydb;
#使用数据库
use mydb;


#创建表
create table t_user
(
	uid int primary key auto_increment,
	username varchar(20),
	password varchar(20),
	phone varchar(11),
	address varchar(50)
);


insert into t_user(username,password,phone,address) values('张三','666','18965423548','南阳');
insert into t_user(username,password,phone,address) values('李四','333','18754263548','许昌');
insert into t_user(username,password,phone,address) values('小美','123','18565234759','信阳');

select * from t_user;

运行效果

java部分项目结构

  需要使用的jar包

Java部分代码

package com.yang.bean;

public class User {
    private Integer uid;
    private String username;
    private String password;
    private String phone;
    private String address;

    public Integer getUid() {
        return uid;
    }

    public void setUid(Integer uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", phone='" + phone + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

package com.yang.dao;

import com.yang.bean.User;

import java.util.List;

public interface UserDao {
    /**
     *
     * 查询所有用户信息
     * @return
     */
    List<User> selectAll();

    User selectByUid(int uid);

    List<User> seach(String keyword);

    int add(User user);

    int delete(int uid);

    int update(User user);
}

<?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是映射的dao接口-->
<mapper namespace="com.yang.dao.UserDao">
    <select id="selectAll" resultType="com.yang.bean.User">
        select *from t_user;
    </select>
    <select id="selectByUid" parameterType="int" resultType="com.yang.bean.User">
        select *from t_user where uid=#{uid};
    </select>
    <select id="seach" parameterType="String" resultType="com.yang.bean.User">
        select *from t_user where username like concat('%',#{keyword},'%');
    </select>
    <insert id="add" parameterType="com.yang.bean.User">
        insert into t_user(username, password, phone, address)
        values (#{username}, #{password}, #{phone}, #{address});
    </insert>
    <delete id="delete" parameterType="int">
        delete from t_user where uid=#{uid};
    </delete>
    <update id="update" parameterType="com.yang.bean.User">
        update t_user set username=#{username},password=#{password},phone=#{phone},address=#{address} where uid=#{uid};
    </update>
</mapper>

package com.yang.test;


import com.yang.bean.User;
import com.yang.dao.UserDao;
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 org.junit.After;
import org.junit.Before;
import org.junit.Test;

import java.io.IOException;
import java.io.InputStream;
import java.util.List;

public class UserTest {
    InputStream stream = null;

    SqlSessionFactoryBuilder builder = null;

    SqlSessionFactory factory = null;

    SqlSession sqlSession = null;

    UserDao userDao = null;
    User user=null;

    @Before
    public void init() throws IOException {
        stream = Resources.getResourceAsStream("mybatis.xml");
        builder = new SqlSessionFactoryBuilder();
        factory = builder.build(stream);
        sqlSession = factory.openSession();
        userDao = sqlSession.getMapper(UserDao.class);

    }

    @Test
    public void testSelectAll() throws IOException {
        List<User> userList = userDao.selectAll();
        for (User user : userList) {
            System.out.println(user);
        }
    }

    @Test
    public void testSelectByUid() throws IOException{
        User user1 = userDao.selectByUid(1);
        System.out.println(user1);
    }

    @Test
    public void testAdd() throws IOException{
        user=new User();
        user.setUsername("mybatis");
        user.setPassword("666");
        user.setPhone("110");
        user.setAddress("github");

        int n = userDao.add(user);
        if (n>0){
            System.out.println("add success");
        }
    }

    @Test
    public void testDelete(){
        int uid = 5;
        int i = userDao.delete(uid);
        if (i>0){
            System.out.println("delect success");
        }
    }

    @Test
    public void testUpdate(){
        User oldUser = userDao.selectByUid(4);
        System.out.println("修改前："+oldUser);
        oldUser.setUsername("王小二");
        oldUser.setAddress("河南南阳");

        userDao.update(oldUser);

        User newUser = userDao.selectByUid(4);
        System.out.println("修改后："+newUser);
    }

    @Test
    public void testSeach(){
        List<User> userList=userDao.seach("小");
        for (User user1 : userList){
            System.out.println(user1);
        }
    }

    @After
    public void distroy() throws IOException {
        sqlSession.commit();
        sqlSession.close();
        stream.close();;
    }
}

<?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>

    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="jdbc"></transactionManager>
            <dataSource type="pooled">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/mydb"/>
                <property name="username" value="root"/>
                <property name="password" value="root"/>
            </dataSource>
        </environment>
        <environment id="oracle">
            <transactionManager type=""></transactionManager>
            <dataSource type=""></dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper class="com.yang.dao.UserDao"/>
    </mappers>
</configuration>