MyBatis

        
	
		select id,last_name ,email,gender from tbl_employee where id = #{id}
	

    
    
        select id,last_name ,email,gender from tbl_employee where id > #{id}
    

    
    
        select id,last_name ,email,gender from tbl_employee where id = #{id} AND  last_name=#{last_name}
    


    
    
        select id,last_name ,email,gender from tbl_employee where id = #{id} AND last_name=#{last_name}
    



    
    
    
        INSERT INTO tbl_employee(last_name,email,gender)VALUE (#{lastName},#{email},#{gender})
    



    
    
        UPDATE  tbl_employee
                SET last_name =#{lastName},email = #{email},gender = #{gender}
                WHERe id = #{id}
    


    
    
        DELETE FROM tbl_employee WHERe id = #{id}
    

    
    
        select id,last_name ,email,gender from tbl_employee where id = #{id}
    


    
    
        select id,last_name ,email,gender from tbl_employee where id > #{id}
    


 
2.多表查询一对一（一个员工对应一个部门）： 




    
    
    
        
        
        
        
        
        
        
    
    
        select id,last_name ,email,gender from tbl_employee where id = #{id}
    

    
    
    
        
        
        
        
        
        
    

    
    
        
        
        
        
        
        
            
            
        
    

    
       select e.id id,e.last_name last_name,e.email email,e.gender gender,e.demp_id demp_id, d.id did,d.dept_name demp_name from tbl_employee e,tbl_dept d
        where e.demp_id=d.id AND e.id = #{id}
    


    

    
    
        
        
        
        
        
        
        
    
    
        select id,last_name ,email,gender,demp_id from tbl_employee where id = #{id}
    


    


    
    
        select id,last_name lastName ,email,gender from tbl_employee where demp_id = #{id}
    


 
3.多表查询一对多（一个部门对应多个员工）： 
?xml version="1.0" encoding="UTF-8" ?>



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


    

    
    
        
        
        
        
            
            
            
            
        

    
    
       select d.id did,d.dept_name name ,e.id id ,e.last_name lastName,e.gender gender,e.email email,e.demp_id demp_id
       FROM tbl_dept d
       LEFT JOIN tbl_employee e
       ON d.id = demp_id
       WHERe d.id = #{id}
    

    
    
        
        
        
        

    
    
        SELECT id did, dept_name name  FROM tbl_dept WHERe id =#{id}