Mybatis动态sql语句

sql语句

drop table if exists user;
create table user(
    id int primary key auto_increment,
    name varchar(20) not null unique,
    age int
);

实体类

import lombok.Getter;
import lombok.Setter;
import lombok.ToString;

/**
 * ClassName:User
 * Package:model
 * Description:
 *
 * @Date:2020/7/30 21:20
 * @Author:DangWei
 */
@Getter
@Setter
@ToString
public class User {
    private Integer id;
    private String name;
    private Integer age;
}

Dao接口

package Dao;

import model.User;

import java.util.List;
import java.util.Map;

/**
 * ClassName:UserDao
 * Package:Dao
 * Description:
 *
 * @Date:2020/7/30 21:21
 * @Author:DangWei
 */
public interface UserDao {

    List<User> select(User user);

    void insert(User user);

    void update(User user);

    void deleteByArray(int[] arr);

    void deleteByList(List<Integer> list);

    void deleteByMap(Map<String,Object> map);
}

UserDao.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="Dao.UserDao">
    
    <resultMap id="result" type="model.User">
        <id column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="age" property="age"/>
    </resultMap>


    <select id="select" parameterType="model.User" resultMap="result">
        select * from user
        <where>
            <if test="name!=null">
                name=#{name}
            </if>
            <if test="age!=null">
                and age=#{age}
            </if>
        </where>
    </select>

    <insert id="insert" parameterType="model.User">
        insert into user(name,age) values (#{name},#{age})
    </insert>

    <update id="update" parameterType="model.User">
        update user
        <set>
            <if test="name!=null">
                name=#{name},
            </if>
            <if test="age!=null">
                age=#{age}
            </if>
        </set>
        where id=#{id}
    </update>

    <delete id="deleteByArray" parameterType="int[]">
        delete from user where id in
        <foreach collection="array" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>

    <delete id="deleteByList" parameterType="java.util.List">
        delete from user where id in
        <foreach collection="list" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>

    <delete id="deleteByMap" parameterType="java.util.Map">
        delete from user where id in 
        <foreach collection="ids" item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>
</mapper>

Mybatis-config.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>

    <environments default="mysql">
        <environment id="mysql">
            <transactionManager type="JDBC"></transactionManager>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/course?characterEncoding=utf8"/>
                <property name="username" value="root"/>
                <property name="password" value=""/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <mapper resource="Dao/UserDao.xml"/>
    </mappers>

</configuration>