SpringBoot + MyBatis +MySQL8 +Druid数据库连接池，基于注解实现查询功能

r囧r小猫 2023-10-18 16:46 112阅读 0赞

1、整体项目结构:

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70][]

功能模块的依赖说明：

mysql-boot ：springboot基础环境依赖  
mysql-boot-api :无  
mysql-boot-dao :依赖 mysql-boot-api 和mybatis-spring-boot-starter(springboot与mybatis 集成)  
mysql-boot-service:依赖api 、dao、数据库连接池(druid)、和mysql驱动

第一、依赖pom.xml

mysql-boot的pom.xml 文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
      <modelVersion>4.0.0</modelVersion>
      <groupId>com.zzg</groupId>
      <artifactId>mysql-boot</artifactId>
      <version>0.0.1-SNAPSHOT</version>
      <packaging>pom</packaging>
      
      <parent>
    		<groupId>org.springframework.boot</groupId>
    		<artifactId>spring-boot-starter-parent</artifactId>
    		<version>2.1.2.RELEASE</version>
    	</parent>
    	
    	<dependencies>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-web</artifactId>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-devtools</artifactId>
    			<optional>true</optional>
    		</dependency>
    		
    		<dependency>
    			<groupId>org.springframework.boot</groupId>
    			<artifactId>spring-boot-starter-test</artifactId>
    			<scope>test</scope>
    		</dependency>
    	</dependencies>
    	<modules>
    	<module>mysql-boot-api</module>
    	<module>mysql-boot-service</module>
    	<module>mysql-boot-web</module>
    	<module>mysql-boot-dao</module>
    	</modules>
    </project>

mysql-boot-dao的pom.xml 文件

mysql-boot-service的pom.xml 文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    	<modelVersion>4.0.0</modelVersion>
    	<parent>
    		<groupId>com.zzg</groupId>
    		<artifactId>mysql-boot</artifactId>
    		<version>0.0.1-SNAPSHOT</version>
    	</parent>
    	<artifactId>mysql-boot-service</artifactId>
    
    	<dependencies>
    		
    		<dependency>
    			<groupId>com.zzg</groupId>
    			<artifactId>mysql-boot-api</artifactId>
    			<version>0.0.1-SNAPSHOT</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.zzg</groupId>
    			<artifactId>mysql-boot-dao</artifactId>
    			<version>0.0.1-SNAPSHOT</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>com.alibaba</groupId>
    			<artifactId>druid-spring-boot-starter</artifactId>
    			<version>1.1.10</version>
    		</dependency>
    		
    		<dependency>
    			<groupId>mysql</groupId>
    			<artifactId>mysql-connector-java</artifactId>
    			<version>8.0.12</version>
    		</dependency>
    	</dependencies>
    </project>

第二、核心代码文件：

mysql-boot-api:实体和接口文件

package com.zzg.entity;
    
    import java.io.Serializable;
    
    public class Book implements Serializable {
    
    	/**   
    	 * @Fields serialVersionUID : TODO(用一句话描述这个变量表示什么)   
    	 */   
    	private static final long serialVersionUID = 1L;
    	
    	private Long id;
    	
    	private String name;
    
    	public Long getId() {
    		return id;
    	}
    
    	public void setId(Long id) {
    		this.id = id;
    	}
    
    	public String getName() {
    		return name;
    	}
    
    	public void setName(String name) {
    		this.name = name;
    	}
    }

package com.zzg.api;
    
    import java.util.List;
    import com.zzg.entity.Book;
    
    public interface BookService {
    	 List<Book> getBooks();
    }

mysql-boot-dao:mapper 注解配置文件

package com.zzg.mapper;
    
    import java.util.List;
    import org.apache.ibatis.annotations.Select;
    import com.zzg.entity.Book;
    
    public interface BookMapper {
    	@Select("select * from book where 1=1")
    	List<Book> getBooks();
    }

mysql-boot-service:程序入口、服务实现和接口测试

package com.zzg;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    @MapperScan("com.zzg.mapper")
    public class Application {
    
    	public static void main(String[] args) {
    		// TODO Auto-generated method stub
    		SpringApplication.run(Application.class, args);
    	}
    
    }

package com.zzg.service;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.zzg.api.BookService;
    import com.zzg.entity.Book;
    import com.zzg.mapper.BookMapper;
    
    @Service
    public class BookServiceImpl implements BookService{
    	@Autowired
    	private BookMapper mapper;
    
    	@Override
    	public List<Book> getBooks() {
    		// TODO Auto-generated method stub
    		return mapper.getBooks();
    	}
    
    }

package com.zzg.controller;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RequestMethod;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import com.zzg.api.BookService;
    import com.zzg.entity.Book;
    
    @Controller
    @RequestMapping
    public class BookController {
    	@Autowired
    	private BookService service;
    	
    	@RequestMapping(value = "/books", method = { RequestMethod.GET })
    	@ResponseBody
    	public List<Book> getBooks() {
    		List<Book> result = service.getBooks();
    		return result;
    	}
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190408173534647.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3pob3V6aGl3ZW5nYW5n,size_16,color_FFFFFF,t_70