在实际开发中,字段名与实体类属性名不相同的问题,本章主要看一下解决方法

主要看第3个步骤中的操作说明,观察resultMap配置前后的结果

1、环境准备,建表

2、创建Pojo实体类,属性与数据库表中的column不一致

package nh.ui.automation.tools.Mybaits;/** * 项目 ：UI自动化测试 Mybaits 类描述： *  * @author Eric * @date 2017年3月4日 nh.ui.automation.tools.Mybaits */public class Order {    private int id;    private String orderNo;    private float price;    /**     *      */    public Order() {        super();    }    /**     * @param id     * @param orderNo     * @param price     */    public Order(int id, String orderNo, float price) {        super();        this.id = id;        this.orderNo = orderNo;        this.price = price;    }    /**     * @return the id     */    public int getId() {        return id;    }    /**     * @param id     *            the id to set     */    public void setId(int id) {        this.id = id;    }    /**     * @return the orderNo     */    public String getOrderNo() {        return orderNo;    }    /**     * @param orderNo     *            the orderNo to set     */    public void setOrderNo(String orderNo) {        this.orderNo = orderNo;    }    /**     * @return the price     */    public float getPrice() {        return price;    }    /**     * @param price     *            the price to set     */    public void setPrice(float price) {        this.price = price;    }    /*     * (non-Javadoc)     *      * @see java.lang.Object#toString()     */    @Override    public String toString() {        return "Order [id=" + id + ", orderNo=" + orderNo + ", price=" + price + "]";    }}

3、创建mapper文件

     
         
              select * from orders where id=#{id}        
      
               insert into        orders(order_no,order_price) values(#{orderNo},#{price})    
          
              select * from orders        //第一次测试代码时可以不引用resultMap,观察执行结果。    
              
               
               
           
      
     

4、在Mybaits配置文件中注册orderMapper文件

 

5、测试代码

String statement = "nh.ui.automation.tools.Mybaits.Order.orderMapper.getOrder";        Order order1 = sqlSession.selectOne(statement,1);        System.out.println(order1);                String statement1 = "nh.ui.automation.tools.Mybaits.Order.orderMapper.addOrder";        int insert = sqlSession.insert(statement1,new Order(1,"dsf",11));        System.out.println(insert);                String statement2 = "nh.ui.automation.tools.Mybaits.Order.orderMapper.getAllOrder";                List