Springboot整合Mybatis传值的常用方式总结

public interface UserMapper {
    public List<User> getUserById(int id);
}

<?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.lxc.SpringBoot.mapper.UserMapper" >
    <select id="getUserById" resultType="com.lxc.springboot.domain.User">
        select * from user where id = #{id}
    </select>
</mapper>

public interface UserMapper {
    public List<User> getLikeList(@Param("name")String pname);
}

<?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.lxc.springboot.mapper.UserMapper" >
 
    <select id="getLikeList" resultType="com.lxc.springboot.domain.User">
        select id, user, name, age, passWord from user where name like '%${name}%'
    </select>
 
</mapper>

import com.lxc.springboot.domain.User;
import org.apache.ibatis.annotations.Param;
 
import java.util.List;
import java.util.Map;
 
public interface UserMapper {
    // 插入数据
    public void insertUser(Map<String, Object> 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" >
 
<!--接口-->
<mapper namespace="com.lxc.springboot.mapper.UserMapper" >
 
    <insert id="insertUser" parameterType="HashMap">
        insert into user(user, name, age, password) values (#{userPost}, #{userName}, #{userAge}, #{userPassword})
    </insert>
</mapper>