SpringBoot系列：springboot整合mybatis

最新推荐文章于 2024-06-18 21:26:36 发布

逻辑喵师傅逻辑不通

最新推荐文章于 2024-06-18 21:26:36 发布

阅读量130

点赞数

分类专栏： Java 文章标签： springboot mybatis

本文链接：https://blog.csdn.net/lin252552/article/details/83506257

版权

Java 专栏收录该内容

24 篇文章 0 订阅

订阅专栏

引入依赖

	<dependencies>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.0</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.0.29</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

引入数据源

jdbc_url=jdbc:mysql://192.168.1.124:3306/m2_db?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false
jdbc_user=root
jdbc_password=password
jdbc_driverClassName=com.mysql.jdbc.Driver

实体类及注解形式的dao层：

@Data
@NoArgsConstructor
@AllArgsConstructor
public class People{
   private Long id ;
   private String name ;
}


@Mapper 
public interface PeopleMapper { 

    @Select("select id, name from people where id = #{id}") 
    People findPeople(@Param("id") Long id); 

    @Select("select id, name from people") 
    List<People> findPeopleList(); 

    @Insert("insert into people(name) values(#{name}) 
    int add(@Param("name") String name); 

    @Update("update people set name = #{name} where id = #{id}") 
    int update(@Param("name") String name, @Param("id") Long id); 

    @Delete("delete from people where id = #{id}") 
    int delete(Long id); 

}