初学springboot、springMVC、Mybatis项目--学习笔记

最新推荐文章于 2022-03-08 08:56:00 发布

原创最新推荐文章于 2022-03-08 08:56:00 发布 · 382 阅读

0 ·

CC 4.0 BY-SA版权

java 专栏收录该内容

5 篇文章

订阅专栏

本文详细介绍了如何在Spring Boot项目中集成MyBatis，包括项目创建、目录结构搭建、Maven配置、MyBatis配置、pom.xml依赖设置、application.properties配置以及generatorConfig.xml的使用。

1.创建sts项目
创建步骤链接：https://blog.youkuaiyun.com/he90227/article/details/53308222
（我在创建项目时，选择了mysql，但是初始测试时，未配置数据库链接，项目启动报错：Failed to configure a DataSource: ‘url’ attribute is not specified and no embedde，解决方法如图：在这里插入图片描述

注意：在使用Autowired自动注入时，需要将红色框体中的内容删除，否则报错，Property ‘sqlSessionFactory’ or
‘sqlSessionTemplate’ are required

）
2.创建目录结构，如图：
在这里插入图片描述
3.maven下载地址：archive.apache.org/dist/maven/maven-3
下载教程;https://blog.youkuaiyun.com/u012453843/article/details/52854255
配置教程：http://www.cnblogs.com/blogslee/p/6822591.html
4.配置mybatis

创建config包及Application文件:

package com.fengsx;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Import;

import com.fengsx.config.ApplicationConfig;

/**
 * 	Configuration配置spring并启动spring容器
 * 	Import--ApplicationConfig应用配置类
 * @author xi
 *
 */
@Configuration
@SpringBootApplication
@Import({ApplicationConfig.class})
public class Application {

	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}
}

ApplicationConfig文件：

package com.fengsx.config;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.ComponentScan;

/**
 * 	应用配置类
 * 	MapperScan(扫描mapper文件)
 * 	ComponentScan告诉Spring 哪个packages 的用注解标识的类 会被spring自动扫描并且装入bean容器
 * 		例如，如果你有个类用@Controller注解标识了，那么，如果不加上@ComponentScan，自动扫描该controller，
 * 		那么该Controller就不会被spring扫描到，更不会装入spring容器中，因此你配置的这个Controller也没有意义。
 * 	微服务 通过EnableFeignClients调用其他服务的api(这里未使用)
 * @author xi
 *
 */
@MapperScan("com.fengsx.domain.persistence")
@ComponentScan({"com.fengsx.api.controller",
		"com.fengsx.domain.service"})
public class ApplicationConfig {
	
}

5.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>

	<groupId>com.fengsx</groupId>
	<artifactId>demofengsx</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<packaging>jar</packaging>

	<name>demofengsx</name>
	<description>Demo project for Spring Boot</description>

	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.0.5.RELEASE</version>
		<relativePath /> <!-- lookup parent from repository -->
	</parent>

	<properties>
		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
		<java.version>1.8</java.version>
	</properties>

	<dependencies>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-rest</artifactId>
		</dependency>
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>
		
		<dependency>
		    <groupId>commons-logging</groupId>
		    <artifactId>commons-logging</artifactId>
		    <version>1.2</version>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<version>5.1.46</version>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<profiles>
		<profile>
			<id>develop</id>
			<properties>
				<profiles.active>develop</profiles.active>
			</properties>
			<activation>
				<activeByDefault>true</activeByDefault>
			</activation>
		</profile>
	</profiles>
	<build>
		<!-- 加载config中的application.properties -->
		<finalName>${project.artifactId}-${version}</finalName>
		<resources>
			<resource>
				<directory>src/main/resources</directory>
				<filtering>true</filtering>
				<excludes>
					<exclude>config/</exclude>
					<exclude>static/assets/**</exclude>
				</excludes>
			</resource>
			<resource>
				<directory>src/main/resources/config/${profiles.active}</directory>
				<targetPath>.</targetPath>
				<filtering>true</filtering>
			</resource>
			<resource>
				<directory>src/main/resources</directory>
				<includes>
					<include>static/assets/**</include>
				</includes>
			</resource>
		</resources>
		<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>
				<dependencies>
			        <dependency>
			            <groupId>mysql</groupId>
			            <artifactId>mysql-connector-java</artifactId>
			            <version>5.1.46</version>
			        </dependency>
				</dependencies>
			</plugin>
		</plugins>
	</build>


</project>

6.application.properties简单配置如下：

# --- {Logging}
#logging.level.DEBUG
logging.level.org.springframework.web=INFO
logging.level.com.netflix.discovery=DEBUG
logging.level.org.hibernate=ERROR
logging.level.org.springframework.boot.autoconfigure.security=WARN
logging.level.com.fengsx.domain.persistence=DEBUG

# --- {MyBatis}
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/cf_couture?characterEncoding=UTF-8&useSSL=false
spring.datasource.username=root
spring.datasource.password=123

mybatis.type-aliases-package=com.fengsx.domain

7.generatorConfig.xml自动生成modal、mapper.java、mapper.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">
<!-- Reference: http://www.mybatis.org/generator/index.html -->
<generatorConfiguration>
    <context id="MySQLTables" targetRuntime="MyBatis3">
    
        <!--===============-->
        <!-- 生成共通属性配置 -->
        <!--===============-->
        <commentGenerator>
            <property name="suppressDate" value="true" />
            <property name="suppressAllComments" value="true" />
        </commentGenerator>

        <!--===============-->
        <!-- MySQL数据源配置 -->
        <!--===============-->
        <jdbcConnection driverClass="com.mysql.jdbc.Driver"
            connectionURL="jdbc:mysql://127.0.0.1:3306/cf_couture?characterEncoding=UTF-8"
            userId="root" password="123" />

        <javaModelGenerator targetPackage="com.fengsx.domain.model"
            targetProject="src/main/java">
            <property name="enableSubPackages" value="true" />
            <property name="trimStrings" value="true" />
        </javaModelGenerator>

        <sqlMapGenerator targetPackage="com.fengsx.domain.persistence"
            targetProject="src/main/resources">
            <property name="enableSubPackages" value="true" />
        </sqlMapGenerator>

        <javaClientGenerator targetPackage="com.fengsx.domain.persistence"
            targetProject="src/main/java" type="XMLMAPPER">
            <property name="enableSubPackages" value="true" />
        </javaClientGenerator>

        <!--===============-->
        <!-- 生成的业务表配置 -->
        <!--===============-->
        <table tableName="t_edit_book" domainObjectName="EditBook"
            enableCountByExample="false" enableUpdateByExample="false"
            enableDeleteByExample="false" enableSelectByExample="false"
            selectByExampleQueryId="false">
            <property name="useActualColumnNames" value="false" />
        </table>
    </context>
</generatorConfiguration>