搭建各种开发环境（第3篇） Java Web开发（Eclipse+SpringBoot+MyBatis）

1 安装Eclipse的MyBatis插件

2 pom.xml修改

2.1 下面依赖追加

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>

2.2 pom.xml中添加下面plugin

            <!-- mybatis generator 自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.1</version>
                <configuration>
                    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
            </plugin>

2.3 最终我的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>
    <artifactId>GerenWeb</artifactId>
    <groupId>com.jerrybin</groupId>
	<version>0.0.1-SNAPSHOT</version>

	<parent>
		<!-- 依赖管理，引入以后在声明其它dependency的时候就不需要version -->
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>1.5.9.RELEASE</version>
		<relativePath />
	</parent>

	<properties>
		<!-- 声明项目配置依赖编码格式为 utf-8 -->
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<!-- java jdk 版本声明 可变更 根据自己配置去匹配 -->
		<java.version>1.8</java.version>
		<maven.compiler.source>1.8</maven.compiler.source>
		<maven.compiler.target>1.8</maven.compiler.target>
		<fastjson.version>1.2.24</fastjson.version>
	</properties>

	<dependencies>
		<!-- 对web开发的支持，包含了spring webmvc和tomcat等web开发的特性 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<!-- spring boot核心,包括自动配置支持，日志和YAML -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
		</dependency>
        <!-- 使用jsp引擎，springboot内置tomcat没有此依赖 -->
        <dependency>
            <groupId>org.apache.tomcat.embed</groupId>
            <artifactId>tomcat-embed-jasper</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.21</version>
        </dependency>
	</dependencies>

	<build>
		<plugins>
			<!-- 如果我们要直接Main启动spring，那么以下plugin必须要添加，否则是无法启动的。 -->
			<!-- 如果使用maven的spring-boot:run的话就不需要此配置 -->
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
            <!-- mybatis generator 自动生成代码插件 -->
            <plugin>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-maven-plugin</artifactId>
                <version>1.3.1</version>
                <configuration>
                    <configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>
                    <overwrite>true</overwrite>
                    <verbose>true</verbose>
                </configuration>
            </plugin>
		</plugins>
	</build>
</project>												

3 application.properties添加下面内容

spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/gerenwebdb?serverTimezone=Asia/Shanghai&characterEncoding=utf8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.jpa.properties.hibernate.hbm2dd1.auto=update
spring.jpa.show-sql=true
mybatis.mapper-locations: classpath:com/jerrybin/repository/*.xml
mybatis.type-aliases-package: com.jerrybin.dto
logging.level.org.lzq.tide.mapper=debug
server.context-path=/gerenweb
server.port=8090

4 写sql xml

4.1 sql xml做成位置

4.2 sql xml内容

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jerrybin.repository.Amc01Repository">
    <insert
            id="insertDongManInfo" parameterType="com.jerrybin.dto.DongManEntity"
            useGeneratedKeys="true">
        insert into tbl_dongman(animeid,animecnname) values (#{animeid},#{animecnname})
    </insert>
</mapper>

5 其他文件内容以及位置

5.1 Amc01Serivce.java

package com.jerrybin.service;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.jerrybin.dto.Amc01InputDto;
import com.jerrybin.dto.DongManEntity;
import com.jerrybin.repository.Amc01Repository;

@Service
public class Amc01Service {
	
	@Autowired
	private Amc01Repository amc01Repository;
	
	public void excute(Amc01InputDto amc01InputDto) {
		DongManEntity dongManEntity = new DongManEntity();
		dongManEntity.setAnimeid(1);
		dongManEntity.setAnimecnname(amc01InputDto.getAnimecnname());
		amc01Repository.insertDongManInfo(dongManEntity);
	}
}

5.2 Amc01Repository.java

package com.jerrybin.repository;

import org.apache.ibatis.annotations.Mapper;

import com.jerrybin.dto.DongManEntity;

@Mapper
public interface Amc01Repository {

	/**
	 * 
	 */
	public void insertDongManInfo(DongManEntity dongManEntity);
}

5.3 DongmanEntity.java

package com.jerrybin.dto;

public class DongManEntity {
	private int animeid;
	private String animecnname;
	public int getAnimeid() {
		return animeid;
	}
	public void setAnimeid(int animeid) {
		this.animeid = animeid;
	}
	public String getAnimecnname() {
		return animecnname;
	}
	public void setAnimecnname(String animecnname) {
		this.animecnname = animecnname;
	}
}