ibatis 一条信息要用到两张表里面的数据 ibatis怎么配置？

最新推荐文章于 2023-03-14 11:58:49 发布

u010227447

最新推荐文章于 2023-03-14 11:58:49 发布

阅读量879

点赞数

本文链接：https://blog.csdn.net/u010227447/article/details/25209841

版权

1.一张设备表实体

public class DaEmotecontrol {
   private Integer id;
   private String emotecontrolname;   //远程设备名称
   private String devicename;           //设备名称
   private String deviceid;           //设备
   private String status;               //状态
   private String openDescription;       //开启描述
   private String colseDescription;   //关闭描述
   private String terminal;           //端子
   private String types;               //类型
   private String control;               //是否被控制
   private String devicetype;           //类型
   private Long roomid;           //大棚
   private Integer positionId;           //类型
   private Integer recommend;           //推荐

//get ，set省掉了

}

2.在创建一个实体类，DaEmotecontrolExt，将用到的属性添加进来，并继承DaEmotecontrol类

public class DaEmotecontrolExt extends DaEmotecontrol
{
   private String status;


   public String getStatus()
   {
       return status;
   }

   public void setStatus(String status)
   {
       this.status = status;
   }


}

3.ibatis配置文件

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">

   
<sqlMap>
   <resultMap id="result"
       class="com.redoor.da.module.daservicemgr.vo.DaEmotecontrol">
       <result property="id" column="id" />
       <result property="emotecontrolname" column="emotecontrolname" />
       <result property="devicename" column="devicename" />
       <result property="deviceid" column="deviceid" />
       <result property="status" column="status" />
       <result property="openDescription" column="openDescription" />
       <result property="colseDescription" column="colseDescription" />
       <result property="terminal" column="terminal" />
       <result property="types" column="types" />
       <result property="control" column="control" />
       <result property="devicetype" column="devicetype" />
       <result property="roomid" column="roomid" />
       <result property="positionId" column="positionId" />
       <result property="recommend" column="recommend" />

   </resultMap>

    <resultMap id="resultExt"
       class="com.redoor.da.module.daservicemgr.vo.DaEmotecontrolExt"
       extends="result">
       <result property="status" column="statusExt" />
   </resultMap>   //新创建的实体类并继承extends="result"

    <select id="daEmotecontrols" resultMap="resultExt">
       select
       d2.emotecontrolname as emotecontrolname ,d2.devicename as
       devicename,d2.deviceid as deviceid ,d2.status as
       status,d2.opendescription as opendescription,
       d2.colsedescription as
       colsedescription,d2.id as id,d2.control as control,d2.devicetype as
       devicetype,
       d2.roomid as roomid,d2.positionId as
       positionId,d2.recommend as recommend,
       d2.terminal as terminal,d2.types as types,d1.status as statusExt from
       da_heightlowelectrical_info d1,da_emotecontrol d2 where d1.deviceid
       =d2.id
   </select>//查询两张表需要的信息