使用IDEA创建一个spring+springMVC+MyBatis+JDBC+MySQL项目,并且添加Swagger2和Generator依赖.

布满荆棘的人生 2022-01-27 06:21 110阅读 0赞

## IDEA创建一个spring+springMVC+MyBatis+JDBC+MySQL项目,并且添加Swagger2和Generator依赖. ##

注意:使用Generator的时候,必须保证数据库的连通性和数据库是否有表  
1.首先,create new project,创建一个spring Initializr项目  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70]  
2.然后点击下一步  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 1]  
3.添加依赖  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 2]  
4.打开application.propertries文件  
添加如下配置

spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
    spring.datasource.url=jdbc:mysql://ip地址:端口号/数据库名称?useUnicode=true&characterEncoding=UTF-8
    spring.datasource.username=你的数据库用户名
    spring.datasource.password=你设置的密码
    server.port=自定义一个端口号
    mybatis.mapper-locations= classpath:/mapper/**/*.xml

保证包结构的完整性,创建一个generatorConfig.xml文件  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 3]  
generatorConfig.xml文件中添加如下配置

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE generatorConfiguration
            PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
            "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
    
    <generatorConfiguration>
      <classPathEntry location="这里是本地仓库的/mysql-connector-java-8.0.15.jar插件的位置" />
    
      <context id="DB2Tables" targetRuntime="MyBatis3">
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                        connectionURL="jdbc:mysql://还是你的数据库的ip地址:端口号/数据库连接名"
                        userId="用户名"
                        password="密码">
          
          <property name="useInformationSchema" value="true"/>
        </jdbcConnection>
    
        
        <javaTypeResolver >
          <property name="forceBigDecimals" value="false" />
        </javaTypeResolver>
    
        
        <javaModelGenerator targetPackage="com.jzt.system.bean" targetProject="./src/main/java">
          <property name="enableSubPackages" value="true" />
          <property name="trimStrings" value="true" />
        </javaModelGenerator>
    
        
        <sqlMapGenerator targetPackage="mapper"  targetProject="./src/main/resources">
          <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>
    
        
        <javaClientGenerator type="XMLMAPPER" targetPackage="com.jzt.system.mapper"  targetProject="./src/main/java">
          <property name="enableSubPackages" value="true" />
        </javaClientGenerator>
    
    
        
        <table tableName="这里添加你的表名" domainObjectName="这里用表名的首字母大写,比如Tablename" ></table>
      <--这里如果不止一张表的话需要手动添加多张表--->
    
      </context>
    </generatorConfiguration>

然后在pom.xml文件里添加依赖

<?xml version="1.0" encoding="UTF-8"?>
    <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>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>2.1.4.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.刚才的包名</groupId>
        <artifactId>项目名</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>system</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <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>
                <scope>runtime</scope>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger2</artifactId>
                <version>2.6.1</version>
            </dependency>
            <dependency>
                <groupId>io.springfox</groupId>
                <artifactId>springfox-swagger-ui</artifactId>
                <version>2.6.1</version>
            </dependency>
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
            
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
            </dependency>
            
    
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
                <plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.5</version>
                </plugin>
            </plugins>
        </build>
    
    </project>

然后在config文件夹中创建MybatisConfig和Swagger2和WebConfig文件  
源文件:链接：[https://pan.baidu.com/s/1fT2Js6\_6ld8L\_-GZWiZb8g][https_pan.baidu.com_s_1fT2Js6_6ld8L_-GZWiZb8g]  
提取码：omw4

5.在控制台运行

mvn -Dmybatis.generator.overwrite=true mybatis-generator:generate

然后就会自动生成bean和mapper里的文件,所有需要用到的数据库语句都会自动生成.  
创建需要的Service和Impl和Controller  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 4]  
启动项目,去浏览器查看swagger  
localhost:你的端口/swagger.ui.html  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 5]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70]: /images/20220127/4d341a42197f41a19451265abf4f09a5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 1]: /images/20220127/14ebd02c31244c7abad288d0ba780746.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 2]: /images/20220127/7d14070b81064495a96642a7405cf85d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 3]: /images/20220127/b56bcd148f0c48028e554c00c0b78dca.png
[https_pan.baidu.com_s_1fT2Js6_6ld8L_-GZWiZb8g]: https://pan.baidu.com/s/1fT2Js6_6ld8L_-GZWiZb8g
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 4]: /images/20220127/08ecffb1189c446f90fd3c94e8a2a4c8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzk3Njg5MA_size_16_color_FFFFFF_t_70 5]: /images/20220127/b5a7223a9c8044c9b35d03fa52818f6c.png