springboot+mybatis+Thymeleaf
2019-05-13 07:17:50来源:博客园 阅读 ()
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>
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<Test> 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>
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); }
实现类(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); } }
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; } }
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.显示全部
<!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>
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>
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>
原文链接:https://www.cnblogs.com/tysl/p/10849914.html
如有疑问请与原作者联系
标签:
版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有
- 代理项 Surrogate 2020-06-11
- 项目经理说这种代码必须重构,我同意了,这代码是写的是有多 2020-06-11
- eclipse下创建Maven项目(包含webapp目录结构) 2020-06-09
- 阿里巴巴26个屌炸天的开源项目,你知道几个? 2020-06-09
- Idea实现SpringBoot外置Tomcat的Web项目热部署(包含静态文 2020-06-04
IDC资讯: 主机资讯 注册资讯 托管资讯 vps资讯 网站建设
网站运营: 建站经验 策划盈利 搜索优化 网站推广 免费资源
网络编程: Asp.Net编程 Asp编程 Php编程 Xml编程 Access Mssql Mysql 其它
服务器技术: Web服务器 Ftp服务器 Mail服务器 Dns服务器 安全防护
软件技巧: 其它软件 Word Excel Powerpoint Ghost Vista QQ空间 QQ FlashGet 迅雷
网页制作: FrontPages Dreamweaver Javascript css photoshop fireworks Flash