MyBatis框架学习Ⅴ

MyBatis参数传递详解

最新推荐文章于 2024-11-08 22:35:29 发布

原创最新推荐文章于 2024-11-08 22:35:29 发布 · 158 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#MyBatis

一个被转后台的Android开发专栏收录该内容

34 篇文章

订阅专栏

本文详细介绍了在MyBatis中如何使用pojo类型和Map作为参数传递到SQL语句中，包括配置文件、实体类、Mapper接口及XML映射文件的编写方式，并通过测试文件验证了功能的正确性。

文章目录

parameterType 使用

parameterType 使用

pojo类型

工程结构

在这里插入图片描述

配置文件

<?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="db.properties">
    </properties>

    <environments default="development">
        <environment id="development">
            <!-- 配置JDBC事务控制，由mybatis进行管理 -->
            <transactionManager type="JDBC"></transactionManager>
            <!-- 配置数据源，采用mybatis连接池 -->
            <dataSource type="POOLED">
                <property name="driver" value="${db.driver}"/>
                <property name="url" value="${db.url}"/>
                <property name="username" value="${db.username}"/>
                <property name="password" value="${db.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 加载映射文件 -->
    <mappers>
        <package name="dao.mapper"></package>
    </mappers>
</configuration>

db.driver = com.mysql.jdbc.Driver
db.url = jdbc:mysql://localhost:3306/ee19_batis_day03?useUnicode=true&characterEncoding=utf-8
db.username = root
db.password = 123

实体类

package entity;

import java.util.Date;

public class User {
    private int id;
    private String username;
    private Date birthday;
    private String address;
    private String sex;

    public int getId() {
        return id;
    }

    public void setId(int 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 getAddress() {
        return address;
    }

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

    public String getSex() {
        return sex;
    }

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

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

package entity;

public class UserQueryVo {
    private User user;

    public User getUser() {
        return user;
    }

    public void setUser(User user) {
        this.user = user;
    }
}

Mapper文件

package dao.mapper;

import entity.User;
import entity.UserQueryVo;

import java.util.List;

public interface UserMapper {
    List<User> findUserList(UserQueryVo vo) throws Exception;
}

<?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.mapper.UserMapper">

    <select id="findUserList" parameterType="entity.UserQueryVo" resultType="entity.User">
        SELECT * FROM user WHERE username
        LIKE '%${user.username}%'
        AND sex = #{user.sex}
    </select>

</mapper>

测试文件

package execute;

import entity.User;
import entity.UserQueryVo;
import dao.mapper.UserMapper;
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.Test;

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

public class MyBatis {
    @Test
    public void testFindUserList() throws Exception {
        //读取配置文件
        //全局配置文件的路径
        String resource = "SqlMapConfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //创建SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //创建SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        UserQueryVo userQueryVo = new UserQueryVo();
        User user = new User();
        user.setUsername("chaoge111");
        user.setSex("1");
        userQueryVo.setUser(user);
        List<User> userList = mapper.findUserList(userQueryVo);
        System.out.println("userList = " + userList);
        sqlSession.close();
    }
}

使用Map

工程结构

参考上面

配置文件

参考上面

实体类

参考上面

Mapper文件

package dao.mapper;

import entity.User;
import entity.UserQueryVo;

import java.util.HashMap;
import java.util.List;

public interface UserMapper {
    List<User> findUserByHashMap(HashMap hashMap) throws Exception;
}

<?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.mapper.UserMapper">

    <select id="findUserByHashMap" parameterType="hashmap" resultType="entity.User">
        SELECT * FROM user WHERE username
        LIKE '%${username}%'
    </select>
</mapper>

测试文件

	@Test
    public void testMap() throws Exception {
        //读取配置文件
        //全局配置文件的路径
        String resource = "SqlMapConfig.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);

        //创建SqlSessionFactory
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        //创建SqlSession
        SqlSession sqlSession = sqlSessionFactory.openSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        HashMap<String, Object> map = new HashMap<String, Object>();

        map.put("username", "王");

        List<User> userByHashMap = mapper.findUserByHashMap(map);

        System.out.println("userByHashMap = " + userByHashMap);
        sqlSession.close();
    }