四、Mybatis解决字段名与实体类属性名不相同的冲突

4.1准备数据表和简单数据
CREATE TABLE orders(
   order_id INT PRIMARY KEY AUTO_INCREMENT,
   order_no VARCHAR(20),
   order_price FLOAT
);INSERT INTO orders(order_no, order_price) VALUES('aaaa', 23);
INSERT INTO orders(order_no, order_price) VALUES('bbbb', 33);
INSERT INTO orders(order_no, order_price) VALUES('cccc', 22);
4.2定义实体类

Orders.java

package com.entity;

public class Orders {
    private int id;
    private String name;
    private int price;
    public Orders()
    {

    }
    public Orders(int id, String name, int price) {
        super();
        this.id = id;
        this.name = name;
        this.price = price;
    }
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getPrice() {
        return price;
    }
    public void setPrice(int price) {
        this.price = price;
    }
    @Override
    public String toString() {
        return "Orders [id=" + id + ", name=" + name + ", price=" + price + "]";
    }
}
4.3解决字段名和实体类属性名的两种不同配置方式

orderMapper.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="com.config.ordersMapper"

    !-- 方式一: 通过在 sql 语句中定义别名 select id="selectOrder" parameterType="int" resultType="com.entity.Orders" 
        select order_id id, order_no name,order_price price from orders where order_id=#{id} 
        /select --

    !-- 方式二: 通过resultMap --
    select id="selectOrderResultMap" parameterType="int" resultMap="orderResultMap"
        select * from orders where order_id=#{id}
    /select

    resultMap id="orderResultMap" type="com.entity.Orders"
        id property="id" column="order_id" /
        result property="name" column="order_no" /
        result property="price" column="order_price" /
    /resultMap
/mapper
4.4测试方法

Test3.java

package com.test;

import java.io.IOException;
import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.junit.Test;



import com.entity.Orders;
import com.inter.UserMapper;
import com.util.MybatisUtil;

public class Test3 {
        //测试查询
        @Test
        public void testGetOrders() throws IOException
        {
            SqlSession session=MybatisUtil.getSession();
            String statement="com.config.ordersMapper.selectOrderResultMap";
            Orders orders=session.selectOne(statement, 1);
            session.close();
            System.out.println(orders);
        }

}
最新回复(0)
/jishus4qSDwNQ8V2JpcPWH284UijMr572OwFC7sWZRw_3D_3D4795122
8 简首页