Mybatisselect记录封装的实现

  select * from tbl_employee where last_name like #{lastName}

  select * from tbl_employee where id=#{id}

//@MapKey:告诉mybatis封装这个map的时候使用哪个属性作为map的key
@MapKey("lastName")
public Map getEmpByLastNameLikeReturnMap(String lastName);

  select * from tbl_employee where last_name like #{lastName}

create table tb_dept (

id int(11) primary key auto_increment,

dept_name varchar(255)

)

alter table tb_emp add column d_id int(11);

alter table tb_emp add constraint fk_emp_dept foreign key(d_id) references tb_dept(id);

   
   
   
     
     
     
     
     
     
     
   



  
  
    select id,dept_name departmentName from tbl_dept where id=#{id}
  

   
  
  
    
    
    
    
      
      
      
      
      
    
  
  
  
    SELECT d.id did,d.dept_name dept_name,
        e.id eid,e.last_name last_name,e.email email,e.gender gender
    FROM tbl_dept d
    LEFT JOIN tbl_employee e
    ON d.id=e.d_id
    WHERE d.id=#{id}