SpringBoot2.x+mybatis+mysql+Redis搭建一个简单的项目

SpringBoot2.x+mybatis+mysql+Redis项目实例

开发工具
IntelliJ IDEA
一、
项目结构

2、pom.xml加载依赖
<?xml version="1.0" encoding="UTF-8"?>

4.0.0

org.springframework.boot
spring-boot-starter-parent
2.1.4.RELEASE


com.example
hello
0.0.1-SNAPSHOT
hello
Demo project for Spring Boot

<properties>
    <java.version>1.8</java.version>
</properties>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-redis</artifactId>
    </dependency>
    <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>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.1</version>
    </dependency>
</dependencies>

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
        </plugin>
    </plugins>
</build>

3、application.yml配置数据源 #默认使用配置 spring: profiles: active: dev

#公共配置与profiles选择无关 mapperLocations指的路径是src/main/resources
mybatis:
typeAliasesPackage: com.example.hello.entity
mapperLocations: classpath:mapper/*.xml

#配置数据源
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/stmstest?useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries=true
username: root
password: root
driver-class-name: com.mysql.jdbc.Driver
# 使用druid数据源
type: com.alibaba.druid.pool.DruidDataSource
4、创建实体类
package com.example.hello.entity;
import java.util.Date;
public class SysUser {
private static final long serialVersionUID = 1L;

private String id;

private String username;
public String getId() {
    return id;
}

public void setId(String id) {
    this.id = id == null ? null : id.trim();
}

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username == null ? null : username.trim();
}

}
5、Service层
package com.example.hello.service;

import java.util.List;
import java.util.Map;

public interface SysUserService {
public List<Map<String,Object>> selectAll();
}
6、impl层
package com.example.hello.service.impl;

import com.example.hello.dao.SysUserDao;
import com.example.hello.service.SysUserService;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;

@Service
public class SysUserServiceImpl implements SysUserService {
/**
*
*/
@Resource
private SysUserDao sysuserDao;
@Override
public List<Map<String, Object>> selectAll() {
List<Map<String,Object>> list =sysuserDao.selectAll();
return list;
}
}
7、DAO
package com.example.hello.dao;

import java.util.List;
import java.util.Map;

public interface SysUserDao {
public List<Map<String,Object>> selectAll();
}
8、测试类
package com.example.hello.controller;

import com.example.hello.service.SysUserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.data.redis.core.StringRedisTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;
import java.util.Map;

@Controller
public class testController {
@Autowired
private StringRedisTemplate stringRedisTemplate;
@Resource
private SysUserService sysuserService;
@RequestMapping("/helloword")
public String test(){
stringRedisTemplate.opsForValue().set(“hh”,“干啥”);
String hh = stringRedisTemplate.opsForValue().get(“hh”);
String a = “hello word”;
System.out.println(a+hh);
return a+hh;
}
@RequestMapping("/testsql")
@ResponseBody
public List<Map<String,Object>> testsql(){
List<Map<String,Object>> list = sysuserService.selectAll();
return list;
}
}
9、mapper
<?xml version="1.0" encoding="UTF-8" ?>

</resultMap>
<sql id="Base_Column_List">
	id, username
</sql>
<select id="selectAll" resultType="java.util.Map">
    select * from t_sys_user
</select>

问题：如果出现下方标红处报红色  File | Settings | Languages & Frameworks | Schemas and DTDs