本文共 1880 字，大约阅读时间需要 6 分钟。

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

   
       
        
        
            select * from orders where order_id=#{id}        
            
             
             
         
    
   

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);        }}

转载地址：http://afkni.baihongyu.com/