springBoot集成mybatis无实体类配置

1.新建spring项目参照https://blog.youkuaiyun.com/linsa_pursuer/article/details/84304924

注意这里开始创建jar包不要选择jpa，选择JDBC和Mybatis，web和mysql基本要选

具体项目里文件位子如下图：

2.application.properties文件里配置（配置mapper文件位置）

spring.datasource.url=jdbc:mysql://localhost:3306/back?serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#配置项目端口号
server.port=8080
#配置项目名
server.servlet.context-path=/back

# 定位模板的目录
#spring.mvc.view.prefix=classpath:/templates/
# 给返回的页面添加后缀名
#spring.mvc.view.suffix=.html
spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp

# mybatis接口文件位置
mybatis.mapper-locations: classpath*:mapper/*Mapper.xml

3.默认生成的XXXApplication文件里加入扫描mapper对应dao类的注解

package com.cooperation.back;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.cooperation.back.dao")
public class BackApplication {

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

4.IconMapper.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.cooperation.back.dao.IconMapper">

	<select id="selectAll" resultType="HashMap">
		select url,sort,icon from icon
	</select>

</mapper>

5.IconMapper.java

package com.cooperation.back.dao;

import java.util.HashMap;
import java.util.List;

/**
 * 图标管理
 */
public interface IconMapper {
    List<HashMap<String,Object>> selectAll();
}

 

6.IconService.java

package com.cooperation.back.service;

import com.cooperation.back.dao.IconMapper;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;

/**
 * 图标管理
 */

@Service
public class IconService implements IconMapper {

    @Resource
    private IconMapper iconMapper;

    @Override
    public List<HashMap<String,Object>> selectAll() {
        return iconMapper.selectAll();
    }
}

7.IconController.java

package com.cooperation.back.controller.system;

import com.cooperation.back.service.IconService;
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.ResponseBody;

import java.util.HashMap;
import java.util.List;

@Controller
public class IconController {

    @Autowired
    IconService iconService;

    @RequestMapping("icon_list")
    @ResponseBody
    public List<HashMap<String,Object>> list(){
        List<HashMap<String,Object>> list = iconService.selectAll();
        return list;
    }
}

8.访问结果如下图：