SpringBoot整合Freemarker+Mybatis

开发工具

，

开始

新建工程

.选择Spring Initializr

下一步

下一步，选择需要的组件

..改一下工程名，Finish

..目录结构

首先，修改pom文件

然后，将application.properties改成yml文件，并且配置相关参数

我的数据库很简单，user表，int类型的自增id，varchar类型的name。

之后建立各个文件，目录结构如下：

HelloController

package com.example.controller;

import com.example.entity.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.autoconfigure.EnableAutoConfiguration;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import java.util.HashMap;
import java.util.Map;

@RestController
public class HelloController {

    @Autowired
    private UserService userService;

    @RequestMapping("/index")
    public String index(){
        return "Hello !!";
    }

    @RequestMapping("/add")
    public Map<Integer, Integer> addUsers(){
        Map<Integer, Integer> map = new HashMap<>();
        for (int i = 0; i < 10; i++){
            map.put(i, userService.addUser(new User("name-" + i)));
        }
        return map;
    }


    @RequestMapping("/get")
    public Map<String, Object> getUsers(){
        Map<String, Object> map = new HashMap<>();
        map.put("users", userService.getUsers());
        return map;
    }

    @RequestMapping("/view")
    public ModelAndView viw(){
        ModelAndView mv = new ModelAndView("home");
        mv.addObject("name","Tom's Table");
        mv.addObject("users", userService.getUsers());
        return mv;
    }
}

View Code

UserDAO

package com.example.dao;

import com.example.entity.User;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface UserDAO {

    int addUser(User user);

    List<User> getUsers();
}

View Code

User

package com.example.entity;

public class User {

    private int id;
    private String name;

    public User(String name) {
        this.name = name;
    }

    public User() {
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                '}';
    }
}

View Code

UserService

package com.example.service;

import com.example.entity.User;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public interface UserService {

    int addUser(User user);

    List<User> getUsers();
}

View Code

UserServiceImpl

package com.example.service.impl;

import com.example.dao.UserDAO;
import com.example.entity.User;
import com.example.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDAO userDAO;

    @Override
    public int addUser(User user) {
        return userDAO.addUser(user);
    }

    @Override
    public List<User> getUsers() {
        return userDAO.getUsers();
    }
}

View Code

然后在Resource文件夹新建一个mybatis文件夹，用来存放mapper

UserDAO.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.example.dao.UserDAO">

    <insert id="addUser" parameterType="User">INSERT INTO USER(NAME) VALUES (#{name})</insert>

    <select id="getUsers" resultType="User">SELECT * FROM USER </select>

</mapper>

home.css

@charset "UTF-8";


h1{
    color: #ff527d;
}

home.ftl

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8" />
    <title></title>
    <link rel="stylesheet" type="text/css" href="/css/home.css">
</head>
<body>
    <h1>${name}</h1>
    <table>
        <thead>
        <tr>
            <th>ID</th>
            <th>Name</th>
        </tr>
        </thead>
        <tbody>
        <#list users as u>
            <tr>
                <td>${u.id}</td>
                <td>${u.name}</td>
            </tr>
        </#list>
        </tbody>
    </table>
</body>
</html>

对于mybatis相关xml生成以及操作，ftl文件的新建，请看最后。

最关键的类：启动类，很有必要说明一下。

package com.example.demo;

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

@SpringBootApplication
@MapperScan("com.example.dao")
@ComponentScan("com.example")
public class DemoApplication {

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