二十九、spring-boot集成MyBatis使用注解配置增删改查

野性酷女 2022-05-17 01:56 87阅读 0赞

\#      spring-boot集成MyBatis使用注解配置增删改查

Spring Boot集成Mybatis后，只需要一个Mapper类，不需要配置文件。

package com.yang.repo;
    
    import java.util.Map;
    
    import org.apache.ibatis.annotations.Delete;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.apache.ibatis.annotations.Update;
    
    
    import com.yang.domain.Enterprise2;
    
    @Mapper
    public interface Enterprise2Mapper {
    
    	@Select("select * from enterprise where id=#{id}") 	
    	public Enterprise2 findByID(@Param("id") Integer id);
    	
    	@Select("insert into enterprise(name,address) values(#{name},#{address})") 	
    	public void insert(@Param("name") String name,@Param("address") String address);
    	
    	//以map形式接受参数
        @Insert("INSERT INTO enterprise(name, address) VALUES(#{name,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR})")
        int insertByMap(Map<String, Object> map);
        
        
        //以实体类形式接受参数
        @Insert("INSERT INTO enterprise(NAME, address) VALUES(#{name}, #{address})")
        int insertByEnterprise2(Enterprise2 enterprise2);
        
        
        //更新
        @Update("update enterprise set name='胖兔子' where id=#{id}")
        void update(@Param("id") Integer id); 
        
        
        //删除
        @Delete("DELETE FROM enterprise WHERE id =#{id}")
        void delete(Integer id);
    	
    	
    	
    }

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ld2JpZV85MDc0ODY4NTI_size_16_color_FFFFFF_t_70_pic_center][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L25ld2JpZV85MDc0ODY4NTI_size_16_color_FFFFFF_t_70_pic_center]: /images/20220517/842cb0b2c6fb4a1e8a4ddac4513ccaf3.png