Mybatis sql构造

简单记录一些Mybatis构造的常用sql写法，仅做为笔记记录，无其他作用。

        insert into ${downloadTable}
        
            ${key}
        
        values
        
            #{value}
        
    

mapper接口层

List

mapper实现层

        SELECT *
        FROM ${tableName}
        
            ${ew.customSqlSegment}
        
    
 
 
3.构造where条件和sql语句where条件混用1 
 
 
mapper接口层
 
 
    
    List
 
 
 
mapper接口实现层
 
 
   
        SELECT ${fields}
        FROM ${tableName}
        
            
                ${joinCustomSqlSql}
                
                    AND
                
                ${ew.sqlSegment}
            
        
        order by ${orderBySql}
    

mapper接口层

List

mapper接口实现层

        SELECT a.`ORDNO`, a.`ORDAMT`
        FROM `exam_${examId}_examinee` a,`exam_config` cg
        
            
                a.SS = cg.department_code
                AND cg.examid = #{examId}
                
                    AND
                
                ${ew.sqlSegment}