Mybatis查询结果集返回信息处理之多个Map和单个Map-----Mybatis框架

已于 2023-09-25 14:47:20 修改
阅读量1.2k 收藏
点赞数 1
分类专栏： # Mybatis框架 JAVA 文章标签： mybatis java maven xml 后端 mysql sql
于 2023-09-13 14:29:26 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2201_75960169/article/details/132852914
版权 
<?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>com.powernode</groupId>
    <artifactId>Mybatis-008-select</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>
    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.10</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.33</version>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.11</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <properties>
        <maven.compiler.source>17</maven.compiler.source>
        <maven.compiler.target>17</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

</project>
<?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>com.powernode</groupId>
    <artifactId>Mybatis-008-select</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>
    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.10</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.33</version>
        </dependency>
        <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.11</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
            <scope>test</scope>
        </dependency>
    </dependencies>
    <properties>
        <maven.compiler.source>17</maven.compiler.source>
        <maven.compiler.target>17</maven.compiler.target>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

</project>
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:13306/powernode
jdbc.username=root
jdbc.password=abc123
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:13306/powernode
jdbc.username=root
jdbc.password=abc123

<?xml version="1.0" encoding="UTF-8" ?>

<configuration debug="false">
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="org.apache.ibatis" level="TRACE">

    </logger>
    <logger name="java.sql.Connection" level="DEBUG">

    </logger>
    <logger name="java.sql.Statement" level="DEBUG">

    </logger>
    <logger name="java.sql.PreparedStatement" level="DEBUG">

    </logger>
    <!--日志级别,由低到高-->
    <!--ALL < TRACE < DEBUG < INFO < WARN < ERROR < FATAL < OFF-->
    <root level="DEBUG">
        <appender-ref ref="STDOUT">

        </appender-ref>
        <appender-ref ref="FILE">

        </appender-ref>
    </root>

</configuration>
<?xml version="1.0" encoding="UTF-8" ?>

<configuration debug="false">
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
        <encoder class="ch.qos.logback.classic.encoder.PatternLayoutEncoder">
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n</pattern>
        </encoder>
    </appender>

    <logger name="org.apache.ibatis" level="TRACE">

    </logger>
    <logger name="java.sql.Connection" level="DEBUG">

    </logger>
    <logger name="java.sql.Statement" level="DEBUG">

    </logger>
    <logger name="java.sql.PreparedStatement" level="DEBUG">

    </logger>
    <!--日志级别,由低到高-->
    <!--ALL < TRACE < DEBUG < INFO < WARN < ERROR < FATAL < OFF-->
    <root level="DEBUG">
        <appender-ref ref="STDOUT">

        </appender-ref>
        <appender-ref ref="FILE">

        </appender-ref>
    </root>

</configuration>
<?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="jdbc.properties"/>
    <settings>
        <setting name="logImpl" value="SLF4J"/>
    </settings>
    <typeAliases>
        <package name="com.powernode.mybatis.POJO"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <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.powernode.mybatis.mappers"/>
    </mappers>
</configuration>
<?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="jdbc.properties"/>
    <settings>
        <setting name="logImpl" value="SLF4J"/>
    </settings>
    <typeAliases>
        <package name="com.powernode.mybatis.POJO"/>
    </typeAliases>
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <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.powernode.mybatis.mappers"/>
    </mappers>
</configuration>
<?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.powernode.mybatis.mappers.CarMapper">
    <select id="selectById" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
    <select id="selectAll" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
    </select>
    <select id="selectByBrand" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            brand like '%${brand}%';
    </select>
    <select id="selectByCarId" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
<!--    查询结果没有合适的接收对象,没有合适的POJO类-->
    <select id="selectByIdGetMap" resultType="java.util.Map">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
    <select id="selectAllCar" resultType="Map">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
    </select>
</mapper>
<?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.powernode.mybatis.mappers.CarMapper">
    <select id="selectById" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
    <select id="selectAll" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
    </select>
    <select id="selectByBrand" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            brand like '%${brand}%';
    </select>
    <select id="selectByCarId" resultType="Car">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
<!--    查询结果没有合适的接收对象,没有合适的POJO类-->
    <select id="selectByIdGetMap" resultType="java.util.Map">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
        where
            id = #{id};
    </select>
    <select id="selectAllCar" resultType="Map">
        select
            id as id,
            car_num as carNum,
            brand as brand,
            guide_price as guidePrice,
            produce_time as produceTime,
            car_type as carType
        from
            t_car
    </select>
</mapper>
package com.powernode.mybatis.mappers;

import com.powernode.mybatis.POJO.Car;

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

public interface CarMapper
{
    List<Map<String,Object>> selectAllCar();
    Map<String,Object> selectByIdGetMap(Long id);
    List<Car> selectByCarId(Long id);
    //模糊查询的对象可能有多个,会出问题吗?
    Car selectByBrand(String brand);
    List<Car> selectAll();
    Car selectById(Long id);
}

package com.powernode.mybatis.mappers;

import com.powernode.mybatis.POJO.Car;

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

public interface CarMapper
{
    List<Map<String,Object>> selectAllCar();
    Map<String,Object> selectByIdGetMap(Long id);
    List<Car> selectByCarId(Long id);
    //模糊查询的对象可能有多个,会出问题吗?
    Car selectByBrand(String brand);
    List<Car> selectAll();
    Car selectById(Long id);
}

package com.powernode.mybatis.POJO;

public class Car
{
    //这是一个封装汽车相关信息的普通的java类,数据库表中的字段应该和属性一一对应
    //为什么使用包装类,因为当我们查值的时候,返回值有可能是null
    //避免数据不兼容
    private Long id;
    private String carNum;
    private String brand;
    private Double guidePrice;
    private String produceTime;
    private String carType;
    public Car(){};

    public Car(Long id, String carNum, String brand, Double guidePrice, String produceTime, String carType) {
        this.id = id;
        this.carNum = carNum;
        this.brand = brand;
        this.guidePrice = guidePrice;
        this.produceTime = produceTime;
        this.carType = carType;
    }

    public Long getId() {
        return id;
    }

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

    public String getCarNum() {
        return carNum;
    }

    public void setCarNum(String carNum) {
        this.carNum = carNum;
    }

    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    public Double getGuidePrice() {
        return guidePrice;
    }

    public void setGuidePrice(Double guidePrice) {
        this.guidePrice = guidePrice;
    }

    public String getProduceTime() {
        return produceTime;
    }

    public void setProduceTime(String produceTime) {
        this.produceTime = produceTime;
    }

    public String getCarType() {
        return carType;
    }

    public void setCarType(String carType) {
        this.carType = carType;
    }

    @Override
    public String toString() {
        return "Car{" +
                "id=" + id +
                ", carNum='" + carNum + '\'' +
                ", brand='" + brand + '\'' +
                ", guidePrice=" + guidePrice +
                ", produceTime='" + produceTime + '\'' +
                ", carType='" + carType + '\'' +
                '}';
    }
}

package com.powernode.mybatis.POJO;

public class Car
{
    //这是一个封装汽车相关信息的普通的java类,数据库表中的字段应该和属性一一对应
    //为什么使用包装类,因为当我们查值的时候,返回值有可能是null
    //避免数据不兼容
    private Long id;
    private String carNum;
    private String brand;
    private Double guidePrice;
    private String produceTime;
    private String carType;
    public Car(){};

    public Car(Long id, String carNum, String brand, Double guidePrice, String produceTime, String carType) {
        this.id = id;
        this.carNum = carNum;
        this.brand = brand;
        this.guidePrice = guidePrice;
        this.produceTime = produceTime;
        this.carType = carType;
    }

    public Long getId() {
        return id;
    }

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

    public String getCarNum() {
        return carNum;
    }

    public void setCarNum(String carNum) {
        this.carNum = carNum;
    }

    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    public Double getGuidePrice() {
        return guidePrice;
    }

    public void setGuidePrice(Double guidePrice) {
        this.guidePrice = guidePrice;
    }

    public String getProduceTime() {
        return produceTime;
    }

    public void setProduceTime(String produceTime) {
        this.produceTime = produceTime;
    }

    public String getCarType() {
        return carType;
    }

    public void setCarType(String carType) {
        this.carType = carType;
    }

    @Override
    public String toString() {
        return "Car{" +
                "id=" + id +
                ", carNum='" + carNum + '\'' +
                ", brand='" + brand + '\'' +
                ", guidePrice=" + guidePrice +
                ", produceTime='" + produceTime + '\'' +
                ", carType='" + carType + '\'' +
                '}';
    }
}

package com.powernode.mybatis.utils;

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 java.io.IOException;

public class SqlSessionUtil
{
    private SqlSessionUtil(){};
    private static SqlSessionFactory sqlSessionFactory;
    private static ThreadLocal<SqlSession> local = new ThreadLocal<>();
    static
    {
        try
        {
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        }
        catch (IOException e)
        {
            throw new RuntimeException(e);
        }
    }
    public static SqlSession openSession()
    {
        SqlSession sqlSession = local.get();
        if (sqlSession == null)
        {
            sqlSession = sqlSessionFactory.openSession();
            local.set(sqlSession);
        }
        return sqlSession;
    }
    public static void close(SqlSession sqlSession)
    {
        if(sqlSession != null)
        {
            sqlSession.close();
            local.remove();
        }
    }
}
package com.powernode.mybatis.utils;

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 java.io.IOException;

public class SqlSessionUtil
{
    private SqlSessionUtil(){};
    private static SqlSessionFactory sqlSessionFactory;
    private static ThreadLocal<SqlSession> local = new ThreadLocal<>();
    static
    {
        try
        {
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(Resources.getResourceAsStream("mybatis-config.xml"));
        }
        catch (IOException e)
        {
            throw new RuntimeException(e);
        }
    }
    public static SqlSession openSession()
    {
        SqlSession sqlSession = local.get();
        if (sqlSession == null)
        {
            sqlSession = sqlSessionFactory.openSession();
            local.set(sqlSession);
        }
        return sqlSession;
    }
    public static void close(SqlSession sqlSession)
    {
        if(sqlSession != null)
        {
            sqlSession.close();
            local.remove();
        }
    }
}
package com.powernode.mybatis.Test;

import com.powernode.mybatis.POJO.Car;
import com.powernode.mybatis.mappers.CarMapper;
import com.powernode.mybatis.utils.SqlSessionUtil;
import org.apache.ibatis.session.SqlSession;

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

public class Test
{
    @org.junit.Test
    public void TestPojoSelect()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        Car car = mapper.selectById(5l);
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectAll()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Car> carList = mapper.selectAll();
        carList.forEach(car -> {
            System.out.println(car);
        });
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestBrand()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        //会报错,因为返回了多条记录了
        Car car = mapper.selectByBrand("比亚迪");
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectByCarId()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Car> carList = mapper.selectByCarId(5L);
        carList.forEach(car -> {
            System.out.println(car);
        });
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectByIdGetMap()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        Map<String, Object> car = mapper.selectByIdGetMap(5l);
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestselectAllCar()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Map<String, Object>> maps = mapper.selectAllCar();
        maps.forEach(map ->{
            System.out.println(map);
        });
    }
}

package com.powernode.mybatis.Test;

import com.powernode.mybatis.POJO.Car;
import com.powernode.mybatis.mappers.CarMapper;
import com.powernode.mybatis.utils.SqlSessionUtil;
import org.apache.ibatis.session.SqlSession;

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

public class Test
{
    @org.junit.Test
    public void TestPojoSelect()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        Car car = mapper.selectById(5l);
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectAll()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Car> carList = mapper.selectAll();
        carList.forEach(car -> {
            System.out.println(car);
        });
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestBrand()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        //会报错,因为返回了多条记录了
        Car car = mapper.selectByBrand("比亚迪");
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectByCarId()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Car> carList = mapper.selectByCarId(5L);
        carList.forEach(car -> {
            System.out.println(car);
        });
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestSelectByIdGetMap()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        Map<String, Object> car = mapper.selectByIdGetMap(5l);
        System.out.println(car);
        SqlSessionUtil.close(sqlSession);
    }
    @org.junit.Test
    public void TestselectAllCar()
    {
        SqlSession sqlSession = SqlSessionUtil.openSession();
        CarMapper mapper = sqlSession.getMapper(CarMapper.class);
        List<Map<String, Object>> maps = mapper.selectAllCar();
        maps.forEach(map ->{
            System.out.println(map);
        });
    }
}
旧约Alatus
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
08 MyBatis之查询专题(返回对象/Map/List封装Map/Map封装Map)+列名与属性名映射的三种方法
m0_46671240的博客
02-23 436
查询专题(返回对象/Map/List封装Map/Map封装Map)+列名与属性名映射的三种方法
MyBatis查询返回Map类型数据
热门推荐
cydbetter的博客
01-16 12万+
今天在交通费计算交易中，需要查询全部base地的交通费，需要返回map集合。然后经查资料，实现过程如下： 1.Mapper中SQL：   &lt;!--查询返回base地的map集合--&gt; &lt;select id="getBaseMap" resultType="java.util.HashMap"&gt; select base,traffic_fare from T...
mybatis返回Map
最新发布
xuetong1995的博客
04-26 300
返回多条数据的时候，用map作为返回值，key保存一些标志性字符串，value保存具体的实体类或者是hashMap都很好用。
Mybatis 查询结果返回 Map、List＜Map＞、Pair
灵台方寸山斜月三星洞
02-16 3万+
com.jerry.mapper.TestMapper.java package com.jerry.mapper; import java.util.List; import java.util.Map; public interface TestMapper { /** * 查寻单个结果直接返回 Map&amp;amp;amp;lt;String, Object&amp;amp;amp;gt; * @param id * ..............
Mybatis-Plus查询返回Map类型数据
目标检测专栏持续更新中，改进YOLO系列通用，适用v5、v7、v8、所有博客均是团队原创博客，所有文章禁止转载，违者必究。
03-27 1万+
Mybatis-Plus查询返回Map类型数据 我们前面的案例都是返回的集合List； 集合List的弊端是会把所有的列属性都封装返回，但是我们有时候，只需要返回几个字段，然后再返回到用户端； 所以mp框架给我们提供了List<Map<String, Object>>返回类型，String是列名，Object是值，只返回select的字段； 举例： /** * 查询每个部门的平均薪资 * sql： SELECT departmentId,AVG(salary) AS avg_sa
MyBatis笔记
boilll的博客
03-17 883
自学笔记
mybatis 返回结果为Map
m0_67402341的博客
03-22 3339
表：members 中的gender 列是这样： Female Female Male Female Male Male Male Male Male 现在我们想统计 members 中男女人数分别是多少，很显然返回的结果应该是这样的： Femal: 3 Male: 6 对应的xml文件中的查询语句： <select id="genderCount" resultMap="genderCount"> select gender, count(gende
mybatis查询数据时，返回类型设置的map，然后出现这个错误java.lang.NoSuchMethodException: java.util.Map.＜init＞
七一
03-06 761
这个错误是因为 MyBatis 在将查询结果封装为。接口本身并没有定义无参构造方法，所以会抛出。要解决这个问题，可以尝试将返回类型改为。类的无参构造方法来创建一个新的。
资料-全面学习Mybatis插件之Mybatis-Plus.rar
05-18
6. **Insert插入操作**：Mybatis-Plus支持单个对象插入、多个对象批量插入，以及使用Map插入。插入时可以使用@Insert注解或XML配置SQL语句，自动处理主键生成策略。 7. **Update更新操作**：更新操作同样提供了便捷...
Java mybatis - 实践学习案例.zip
01-30
1. `<select>`：定义查询语句，可以返回单个结果、集合或Map。 2. `<insert>`：定义插入语句，支持自动回填主键（如果数据库支持）。 3. `<update>`：定义更新语句。 4. `<delete>`：定义删除语句。 5. `<resultMap>...
mybatis-3-mybatis-3.5.4-src-read.zip
04-28
MyBatis提供了多种结果集处理策略，包括List、Map、单个对象以及自定义的类型处理器。 9. **TypeHandler类型处理器**： TypeHandler负责Java类型与JDBC类型之间的转换。MyBatis内置了多种常见的类型处理器，也可以...
mybatis 使用 -【从头至尾，包含测试】
04-22
MyBatis 是一个优秀的轻量级持久层框架，它避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解进行配置和原始映射，将接口和 Java 的 POJOs(Plain Old Java Objects，...
MyBatis框架学习笔记
05-10
MyBatis还提供了强大的查询功能，如查询单个对象、列表、单个Map和多个Map，以及模糊查询、批量删除等。此外，动态SQL是MyBatis的一大亮点，通过`if`、`where`、`trim`、`choose`、`when`、`otherwise`和`foreach`等...
Mybatis查询结果集返回信息使用大Map进行封装实现不用POJO类的映射并达到对应取值的效果-----Mybatis框架
春风若有怜花意，可否许我再少年
09-13 628
Mybatis查询结果集返回信息使用大Map进行封装实现不用POJO类的映射并达到对应取值的效果-----Mybatis框架
Mybatis将两个返回值封装为map
baidu_28858901的博客
08-19 4936
一、问题 直接用map接收mybatis返回的两个参数（id，name），不能直接将id作为key，name作为value，会将id作为key，查询到的id值作为value；name作为key，查询到的name值作为value。 <select id="getNameMap" resultType="java.util.HashMap"> select id , name from student </select> 查询结果： map...
通过注解实现MyBatis将sql查询结果的两个字段分别作为map的key,value
lishuzhen5678的博客
11-04 6460
在使用mybatis时，遇到一个这样一个场景：select语句，返回两个字段，这两个字段分别作为key和value返回一个Map，返回一个Map<Stri...
MySQL.MyBatis怎么将查询的两个字段作为Map的key和value
潮汐先生的专栏
05-02 6094
MySQL.MyBatis怎么将查询的两个字段作为Map的key和value 问题的由来 前端使用Echarts图标显示汇总数据。需要形式如下的数据： { "C20": 42.01, "C30": 1693.10, "C35": 231.00 } 但是经过以下的SQL查询 SELECT gsom.intensity_level AS 强度等级, SUM(gsom.quantity) AS 生产方量 FROM gt_szls_out_master gsom WHERE org_id =
在mybatis中，使用map传递参数和进行模糊查询的方法
m0_64365419的博客
01-09 2012
在上篇文章中，我们是通过对象进行插入和修改的，每次进行操作时，都需要new一个实体类的对象，但是当实体类的属性或者字段中的参数过多时，这无疑大大增加了代码量。针对这种情况，我们可使用Map.
mybatis返回多个map结果
qq_38348679的博客
09-06 3879
如果返回一条结果，xml直接这样写： <select id="searchncomedateByInvestID" resultMap="java.util.HashMap"> select t1.invest_id , cast(t1.modify_time AS DATE) modify_time fro...
mybatis-plus 返回多个map 再转Map
04-21
其中，`mapper`是Mybatis-plus的Mapper对象，`wrapper`是查询条件对象，`selectMaps`方法返回多个Map。`flatMap`方法用于将多个Map合并成一个Stream，`toMap`方法用于将Stream转换成一个Map。最终得到的`result`就是...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值