maybatis逆向工程生成的mapper.xml详细解说

maybatis逆向工程生成的mapper.xml详细解说

  

  
    
    
    
    
    
  

  
  
    sid, sname, age, stime
  



  
  

--  base_Column_List将公共部分抽取出来，相当于
--  select
--     sid, sname, age, stime
    select
    
    from student
    where sid = #{sid,jdbcType=INTEGER}
  


  
    delete from student
    where sid = #{sid,jdbcType=INTEGER}
  

  
  
    insert into student (sid, sname, age, 
      stime)
    values (#{sid,jdbcType=INTEGER}, #{sname,jdbcType=CHAR}, #{age,jdbcType=INTEGER}, 
      #{stime,jdbcType=TIMESTAMP})
  

  

  
    insert into student
    
      
        sid,
      
      
        sname,
      
      
        age,
      
      
        stime,
      
    
    
      
        #{sid,jdbcType=INTEGER},
      
      
        #{sname,jdbcType=CHAR},
      
      
        #{age,jdbcType=INTEGER},
      
      
        #{stime,jdbcType=TIMESTAMP},
      
    
  



  
    update student
    
      
        sname = #{sname,jdbcType=CHAR},
      
      
        age = #{age,jdbcType=INTEGER},
      
      
        stime = #{stime,jdbcType=TIMESTAMP},
      
    
    where sid = #{sid,jdbcType=INTEGER}
  


  
    update student
    set sname = #{sname,jdbcType=CHAR},
      age = #{age,jdbcType=INTEGER},
      stime = #{stime,jdbcType=TIMESTAMP}
    where sid = #{sid,jdbcType=INTEGER}