mybatis注解——CRUD

1.Mybatis注解配置

注解方法使我们的开发变得简单，下面是步骤

1.1注解配置

注意：

1. 不用再配置Resource下的每一个dao中的配置文件为xxx.xml

在maven中导入jar包

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>org.example</groupId>
    <artifactId>day04_mybatis_@注解_demo01</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>

    <dependencies>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.10</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>log4j</groupId>
            <artifactId>log4j</artifactId>
            <version>1.2.17</version>
        </dependency>
    </dependencies>

</project>

加入配置文件

创建文件目录

SqlMapperConfig.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="jdbcConfig.properties"/>
    <!--配置别名-->
    <typeAliases>
        <package name="com.xiao.domain"/>
    </typeAliases>
    <!--配置环境-->
    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <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>
        <package name="com.xiao.dao"/>
    </mappers>
</configuration>

外部配置文件内容

2.Mybatis注解_CRUD

User类

package com.xiao.domain;

import java.util.Date;

/**
 * @_PackageName:com.xiao.domain
 * @_ClassName:User
 * @_Description:
 * @_Author：笑老二
 * @_data 2020/4/20 12:34
 */
public class User {
    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getUsername() {
        return username;
    }

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

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

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

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", birthday=" + birthday +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

UserDao类

package com.xiao.dao;

import com.xiao.domain.User;
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 java.util.List;

public interface UserDao {
    /**
     * 查询所有用户
     * @return
     */
    @Select("select * from user")
    List<User> findAll();

    /**
     * 保存用户
     * @param user
     */
    @Insert("insert into user (username,birthday,sex,address) values(#{username},#{birthday},#{sex},#{address})")
    void saveUser(User user);

    /**
     * 更新用户
     * @param user
     */
    @Update("update user set username = #{username},birthday = #{birthday},sex = #{sex},address = #{address} where id = #{id}")
    void updateUser(User user);

    /**
     * 删除
     * @param id
     */
    @Delete("delete from user where id = 51")
    void deleteUser(Integer id);

    /**
     * 根据id查询用户
     * @param id
     */
    @Select("select * from User where id = #{id}")
    User findById(Integer id);
}

Test类

package com.xiao;

import com.xiao.dao.UserDao;
import com.xiao.domain.User;
import org.apache.ibatis.annotations.Update;
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.Date;
import java.util.List;

/**
 * @_PackageName:com.xiao
 * @_ClassName:MybatisTest
 * @_Description:
 * @_Author：笑老二
 * @_data 2020/4/22 18:43
 */
public class AnnotationMybatisTest {
    private SqlSessionFactory factory;
    private InputStream is;
    private SqlSession sqlSession;
    private UserDao userDao;
    @Before
    public void init() throws Exception{
        is = Resources.getResourceAsStream("SqlMapperConfig.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        factory = builder.build(is);
        sqlSession = factory.openSession();
        userDao = sqlSession.getMapper(UserDao.class);
    }
    @After
    public void destroy() throws IOException {
        sqlSession.commit();
        sqlSession.close();
        is.close();
    }

    @Test
    public void findAllTest(){
        List<User> users = userDao.findAll();
        for (User user : users) {
            System.out.println(user);
        }
    }
    @Test
    public void saveUserTest(){
        User user = new User();
        user.setUsername("张三");
        user.setAddress("仙桃");
        user.setSex("男");
        userDao.saveUser(user);
    }
    @Test
    public void updateUserTest(){
        User user = new User();
        user.setId(51);
        user.setUsername("update");
        user.setSex("男");
        user.setAddress("武汉");
        user.setBirthday(new Date());
        userDao.updateUser(user);
    }
    @Test
    public void deleteUser(){
        userDao.deleteUser(51);
    }
    @Test
    public void findByIdTest(){
        User user = userDao.findById(49);
        System.out.println(user);
    }
}

3.Mybatis注解_多对一或一对一

4.Mybatis注解_一对多

package com.xiao;

import com.xiao.dao.AccountDao;
import com.xiao.dao.UserDao;
import com.xiao.domain.Account;
import com.xiao.domain.User;
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;

/**
 * @_PackageName:com.xiao
 * @_ClassName:MybatisTest
 * @_Description:
 * @_Author：笑老二
 * @_data 2020/4/22 18:43
 */
public class AnnotationAccountTest {
    private SqlSessionFactory factory;
    private InputStream is;
    private SqlSession sqlSession;
    private AccountDao accountDao;
    @Before
    public void init() throws Exception{
        is = Resources.getResourceAsStream("SqlMapperConfig.xml");
        SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
        factory = builder.build(is);
        sqlSession = factory.openSession();
        accountDao = sqlSession.getMapper(AccountDao.class);
    }
    @After
    public void destroy() throws IOException {
        sqlSession.commit();
        sqlSession.close();
        is.close();
    }

    @Test
    public void findAllTest(){
        List<Account> users = accountDao.findAll();
        for (Account account : users) {
            System.out.println(account);
        }
    }

}

@Test
    public void findAllTest(){
        List<User> users = userDao.findAll();
        for (User user : users) {
            System.out.println("------------------");
            System.out.println(user);
            System.out.println(user.getAccounts());
            System.out.println("------------------");
        }
    }