springboot+mybatis+Thymeleaf

1.项目结构

2.代码展示

 1.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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.4.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.bl</groupId>
    <artifactId>test</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <packaging>war</packaging>
    <name>test</name>
    <description>Demo project for Spring Boot</description>

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

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.1</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
            <version>5.1.47</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-tomcat</artifactId>
            <scope>provided</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>

    </dependencies>

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

    </build>

</project>
4.0.0 org.springframework.boot spring-boot-starter-parent 2.1.4.RELEASE com.bl test 0.0.1-SNAPSHOT war test Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-jdbc org.springframework.boot spring-boot-starter-web org.mybatis.spring.boot mybatis-spring-boot-starter 2.0.1 mysql mysql-connector-java runtime 5.1.47 org.springframework.boot spring-boot-starter-tomcat provided org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-maven-plugin

 2.application.properties

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aaa
spring.datasource.username=root
spring.datasource.password=aaa

spring.thymeleaf.cache=false
spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aaa spring.datasource.username=root spring.datasource.password=aaa spring.thymeleaf.cache=false

3.实体类test 

package com.bl.test.pojo;

public class Test {
    private int id;
    private int y;
    private int w;

    public int getId() {
        return id;
    }

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

    public int getY() {
        return y;
    }

    public void setY(int y) {
        this.y = y;
    }

    public int getW() {
        return w;
    }

    public void setW(int w) {
        this.w = w;
    }
}
package com.bl.test.pojo; public class Test { private int id; private int y; private int w; public int getId() { return id; } public void setId(int id) { this.id = id; } public int getY() { return y; } public void setY(int y) { this.y = y; } public int getW() { return w; } public void setW(int w) { this.w = w; } }

 4.mapper层(接口和映射文件)

 接口

package com.bl.test.mapper;

import com.bl.test.pojo.Test;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
@Mapper
public interface TestMapper {
    public List<Test> queryAll();
    public Test queryOne(int id);
    public void update(Test test);
    public void delete(int id);
    public void add(Test test);

}
package com.bl.test.mapper; import com.bl.test.pojo.Test; import org.apache.ibatis.annotations.Mapper; import java.util.List; @Mapper public interface TestMapper { public List queryAll(); public Test queryOne(int id); public void update(Test test); public void delete(int id); public void add(Test test); }

映射文件

<?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.bl.test.mapper.TestMapper">

    <resultMap id="BaseResultMap" type="com.bl.test.pojo.Test">
        <id column="id" jdbcType="INTEGER" property="id" />
        <result column="y" jdbcType="INTEGER" property="y" />
        <result column="w" jdbcType="INTEGER" property="w" />
    </resultMap>
    <select id="queryAll" resultMap="BaseResultMap">
        select * from test
    </select>
    <select id="queryOne" resultMap="BaseResultMap">
        select * from test where id=#{id}
    </select>
    <update id="update">
        update test set y=#{y},w=#{w} where id=#{id}
    </update>
    <insert id="add">
        insert into test values(null,#{y},#{w})
    </insert>
    <delete id="delete">
        delete from test where id=#{id}
    </delete>

</mapper>
update test set y=#{y},w=#{w} where id=#{id} insert into test values(null,#{y},#{w}) delete from test where id=#{id}

5.业务层

接口(TestService)

package com.bl.test.service;

import com.bl.test.pojo.Test;

import java.util.List;

public interface TestService {
    public List<Test> selectAll();
    public Test queryOne(int id);
    public void update(Test t);
    public void delete(int id);
    public void add(Test t);
}
package com.bl.test.service; import com.bl.test.pojo.Test; import java.util.List; public interface TestService { public List selectAll(); public Test queryOne(int id); public void update(Test t); public void delete(int id); public void add(Test t); }

实现类(TestServiceImpl)

package com.bl.test.service.impl;

import com.bl.test.mapper.TestMapper;
import com.bl.test.pojo.Test;
import com.bl.test.service.TestService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class TestServiceImpl implements TestService {
    @Autowired
    private TestMapper testMapper;

    @Override
    public List<Test> selectAll() {
        return testMapper.queryAll();
    }

    @Override
    public Test queryOne(int id) {
        return testMapper.queryOne(id);
    }

    @Override
    public void update(Test t) {
        testMapper.update(t);
    }

    @Override
    public void delete(int id) {
        testMapper.delete(id);
    }

    @Override
    public void add(Test t) {
        testMapper.add(t);
    }
}
package com.bl.test.service.impl; import com.bl.test.mapper.TestMapper; import com.bl.test.pojo.Test; import com.bl.test.service.TestService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class TestServiceImpl implements TestService { @Autowired private TestMapper testMapper; @Override public List selectAll() { return testMapper.queryAll(); } @Override public Test queryOne(int id) { return testMapper.queryOne(id); } @Override public void update(Test t) { testMapper.update(t); } @Override public void delete(int id) { testMapper.delete(id); } @Override public void add(Test t) { testMapper.add(t); } }

6.表示层(controller)

package com.bl.test.controller;

import com.bl.test.pojo.Test;
import com.bl.test.service.TestService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

@Controller
public class TestController {
    @Autowired
    private TestService testService;
    @RequestMapping("/test/queryAll")
    public String queryAll(Model model){
        List<Test> list=testService.selectAll();
        model.addAttribute("list",list);
        return "test";
    }

    @RequestMapping("/test/queryOne")
    public String queryOne(Model model,int id){
        Test t=testService.queryOne(id);
        model.addAttribute("test",t);
        return "testOne";
    }

    @RequestMapping("/test/update")
    public String update(Test test){

        testService.update(test);
        return "redirect:/test/queryAll";
    }

    @RequestMapping("/test/add")
    public String add(Test test){
        testService.add(test);
        return "redirect:/test/queryAll";
    }

    @RequestMapping("/test/delete")
    public String delete(int id){
        testService.delete(id);
        return "redirect:/test/queryAll";
    }

    @RequestMapping("{test}")
    public String test(@PathVariable("test") String test){
        return test;
    }
}
package com.bl.test.controller; import com.bl.test.pojo.Test; import com.bl.test.service.TestService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @Controller public class TestController { @Autowired private TestService testService; @RequestMapping("/test/queryAll") public String queryAll(Model model){ List list=testService.selectAll(); model.addAttribute("list",list); return "test"; } @RequestMapping("/test/queryOne") public String queryOne(Model model,int id){ Test t=testService.queryOne(id); model.addAttribute("test",t); return "testOne"; } @RequestMapping("/test/update") public String update(Test test){ testService.update(test); return "redirect:/test/queryAll"; } @RequestMapping("/test/add") public String add(Test test){ testService.add(test); return "redirect:/test/queryAll"; } @RequestMapping("/test/delete") public String delete(int id){ testService.delete(id); return "redirect:/test/queryAll"; } @RequestMapping("{test}") public String test(@PathVariable("test") String test){ return test; } }

7.启动类

package com.bl.test;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class TestApplication {

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

}
package com.bl.test; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class TestApplication { public static void main(String[] args) { SpringApplication.run(TestApplication.class, args); } }

8.前端

1.显示全部

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <table border="1" cellpadding="0">
        <tr>
            <th>编号</th>
            <th>y</th>
            <th>w</th>
            <th>操作</th>
        </tr>
        <tr th:each="list : ${list}">
            <td th:text="${list.id}"></td>
            <td th:text="${list.y}"></td>
            <td th:text="${list.w}"></td>
            <td>
                <a th:href="@{/test/queryOne(id=${list.id})}">修改</a>
                <a th:href="@{/test/delete(id=${list.id})}">删除</a>
            </td>
        </tr>
        <tr>
           <td colspan="4">
              <a th:href="@{/testAdd}">添加</a>
           </td>
        </tr>
    </table>
</body>
    <script>
        function a(id){
            alert(id);
        }
    </script>
</html>
Title
编号 y w 操作
修改 删除
添加

2.添加

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>添加</title>
</head>
<body>
    <form th:action="@{/test/add}">
        <table border="1" cellpadding="0">
            <tr>
                <th>y</th>
                <th>w</th>
                <th>操作</th>
            </tr>
            <tr >
                <td><input name="y" /></td>
                <td><input name="w"/></td>
                <td><input type="submit" value="提交" /> ></td>
            </tr>
        </table>
    </form>


</body>
    <script>
        function a(id){
            alert(id);
        }
    </script>
</html>
添加
y w 操作
>

3.修改

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
    <meta charset="UTF-8">
    <title>修改</title>
</head>
<body>
    <form th:action="@{/test/update}">
        <table border="1" cellpadding="0">
            <tr>
                <th>编号</th>
                <th>y</th>
                <th>w</th>
                <th>操作</th>
            </tr>
            <tr >
                <td>
                    <input name="id" readonly th:value="${test.id}" />
                </td>
                <td><input name="y" th:value="${test.y}" /></td>
                <td><input name="w" th:value="${test.w}" /></td>
                <td><input type="submit" value="提交" /> ></td>
            </tr>
        </table>
    </form>


</body>
    <script>
        function a(id){
            alert(id);
        }
    </script>
</html>
修改
编号 y w 操作
>
1.项目结构 2.代码展示  1.pom.xml 4.0.0 org.springframework.boot spring-boot-starter-parent 2.1.4.RELEASE com.bl test 0.0.1-SNAPSHOT war test Demo project for Spring Boot 1.8 org.springframework.boot spring-boot-starter-jdbc org.springframework.boot spring-boot-starter-web org.mybatis.spring.boot mybatis-spring-boot-starter 2.0.1 mysql mysql-connector-java runtime 5.1.47 org.springframework.boot spring-boot-starter-tomcat provided org.springframework.boot spring-boot-starter-test test org.springframework.boot spring-boot-starter-thymeleaf org.springframework.boot spring-boot-maven-plugin 2.application.properties spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://127.0.0.1:3306/aaa spring.datasource.username=root spring.datasource.password=aaa spring.thymeleaf.cache=false 3.实体类test  package com.bl.test.pojo; public class Test { private int id; private int y; private int w; public int getId() { return id; } public void setId(int id) { this.id = id; } public int getY() { return y; } public void setY(int y) { this.y = y; } public int getW() { return w; } public void setW(int w) { this.w = w; } }  4.mapper层(接口和映射文件)  接口 package com.bl.test.mapper; import com.bl.test.pojo.Test; import org.apache.ibatis.annotations.Mapper; import java.util.List; @Mapper public interface TestMapper { public List queryAll(); public Test queryOne(int id); public void update(Test test); public void delete(int id); public void add(Test test); } 映射文件 update test set y=#{y},w=#{w} where id=#{id} insert into test values(null,#{y},#{w}) delete from test where id=#{id} 5.业务层 接口(TestService) package com.bl.test.service; import com.bl.test.pojo.Test; import java.util.List; public interface TestService { public List selectAll(); public Test queryOne(int id); public void update(Test t); public void delete(int id); public void add(Test t); } 实现类(TestServiceImpl) package com.bl.test.service.impl; import com.bl.test.mapper.TestMapper; import com.bl.test.pojo.Test; import com.bl.test.service.TestService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; @Service public class TestServiceImpl implements TestService { @Autowired private TestMapper testMapper; @Override public List selectAll() { return testMapper.queryAll(); } @Override public Test queryOne(int id) { return testMapper.queryOne(id); } @Override public void update(Test t) { testMapper.update(t); } @Override public void delete(int id) { testMapper.delete(id); } @Override public void add(Test t) { testMapper.add(t); } } 6.表示层(controller) package com.bl.test.controller; import com.bl.test.pojo.Test; import com.bl.test.service.TestService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RestController; import java.util.List; @Controller public class TestController { @Autowired private TestService testService; @RequestMapping("/test/queryAll") public String queryAll(Model model){ List list=testService.selectAll(); model.addAttribute("list",list); return "test"; } @RequestMapping("/test/queryOne") public String queryOne(Model model,int id){ Test t=testService.queryOne(id); model.addAttribute("test",t); return "testOne"; } @RequestMapping("/test/update") public String update(Test test){ testService.update(test); return "redirect:/test/queryAll"; } @RequestMapping("/test/add") public String add(Test test){ testService.add(test); return "redirect:/test/queryAll"; } @RequestMapping("/test/delete") public String delete(int id){ testService.delete(id); return "redirect:/test/queryAll"; } @RequestMapping("{test}") public String test(@PathVariable("test") String test){ return test; } } 7.启动类 package com.bl.test; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication; @SpringBootApplication public class TestApplication { public static void main(String[] args) { SpringApplication.run(TestApplication.class, args); } } 8.前端 1.显示全部 Title
编号 y w 操作
修改 删除
添加
2.添加 添加
y w 操作
>
3.修改 修改
编号 y w 操作
>
经验分享 程序员 微信小程序 职场和发展