這期內(nèi)容當(dāng)中小編將會給大家?guī)碛嘘P(guān)如何進(jìn)行Mapper多表關(guān)聯(lián)查詢，文章內(nèi)容豐富且以專業(yè)的角度為大家分析和敘述，閱讀完這篇文章希望大家可以有所收獲。

在雙河等地區(qū)，都構(gòu)建了全面的區(qū)域性戰(zhàn)略布局，加強(qiáng)發(fā)展的系統(tǒng)性、市場前瞻性、產(chǎn)品創(chuàng)新能力，以專注、極致的服務(wù)理念，為客戶提供網(wǎng)站設(shè)計制作、成都網(wǎng)站設(shè)計 網(wǎng)站設(shè)計制作按需定制網(wǎng)站,公司網(wǎng)站建設(shè),企業(yè)網(wǎng)站建設(shè),品牌網(wǎng)站制作,網(wǎng)絡(luò)營銷推廣,成都外貿(mào)網(wǎng)站制作,雙河網(wǎng)站建設(shè)費(fèi)用合理。

1、首先寫sql語句

select p.id, p.create_time, p.update_time, p.create_user, p.update_user, p.project_name, p.test_user, 
    p.dev_user, p.simple_desc, p.other_desc, p.project_code, p.belong_env_id, p.status_id,u.status_name,u.description from projectinfo_temp p LEFT JOIN usestatus u on p.status_id = u.id

2、關(guān)聯(lián)pojo

@ToString
public class ProjectinfoTemp {

    private Integer id;

    private Date createTime;

    private Date updateTime;

    private String createUser;

    private String updateUser;

    private String projectName;

    private String testUser;

    private String devUser;

    private String simpleDesc;

    private String otherDesc;

    private String projectCode;

    private Integer belongEnvId;

    private Integer statusId;
    /**
     *  關(guān)聯(lián)狀態(tài)表 激活狀態(tài)
     */
    private Usestatus usestatus;

狀態(tài)表

/**
 *
 * @author liwen406
 * @date 2019-04-21 09:12
 */
@ToString
public class Usestatus {
    private Integer id;

    private String statusName;

    private String description;

3編寫關(guān)聯(lián)sql語句

模仿寫法

<sql id="WithBase_Column_List" >
p.id, p.create_time, p.update_time, p.create_user, p.update_user, p.project_name, p.test_user,
p.dev_user, p.simple_desc, p.other_desc, p.project_code, p.belong_env_id, p.status_id,u.status_name,u.description
</sql>

    select
    
      distinct
    
    
    from projectinfo_temp
    
      
    
    
      order by ${orderByClause}
    
  

  
    select
    
      distinct
    
    
    from projectinfo_temp p LEFT JOIN usestatus u on p.status_id = u.id
    
      
    
    
      order by ${orderByClause}
    
  

4前端調(diào)用寫法

                                
                                    
                                    
                                        應(yīng)用編號
                                        應(yīng)用名稱
                                        測試負(fù)責(zé)人
                                        開發(fā)負(fù)責(zé)人
                                        模塊/接口/用例
                                        狀態(tài)
                                        操作
                                    
                                    
                                    
                                    
                                        
                                        
                                        
                                        
                                        
                                        
                                        
                                            運(yùn)行
                                            編輯
                                            刪除
                                        
                                    
                                    
                                
                                
                                    
                                        
                                            ,