當前位置：首頁 > 运维知识 > 数据库 >内容正文

数据库

SpringBoot框架与MyBatis集成，连接Mysql数据库

發布時間：2025/7/14 数据库 16 豆豆

生活随笔收集整理的這篇文章主要介紹了 SpringBoot框架与MyBatis集成，连接Mysql数据库小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

　　SpringBoot是一種用來簡化新Spring應用初始搭建及開發過程的框架，它使用特定方式來進行配置，使得開發人員不再需要定義樣板化的配置。MyBatis是一個支持普通SQL查詢、存儲和高級映射的持久層框架，它消除了幾乎所有的JDBC代碼和參數的手工配置以及對結果集的檢索封裝，可以使用簡單的XML或注解用于配置和原始映射，將接口和Java的對象映射成數據庫中的記錄。

　　最近的項目有相關需求，集成SpringBoot和MyBatis框架后，進行Mysql數據庫的數據訪問，實現功能后總結于此博客，方便以后查看。

　　首先下載一個SpringBoot的demo程序，然后在它上面集成，訪問：demo下載，如下圖所示，勾選Web選項后點擊Generate Project即可下載工程。

　　打開demo后可以更改項目名稱，設置目錄為如下圖形式，其中需要的jar包自行下載，

　　然后對每一個文件進行編輯，示例中有Disaster和Economic兩部分內容，僅介紹Disaster部分原理即可。

　　先構建Disaster類，根據Mysql中表的數據情況建立對象，Disaster.java代碼如下：

1 package smm.springboot.bean; 2 3 public class Disaster { 4 private int id; 5 private String deathtoll;//死亡人數 6 private String injuriesnumber;//受傷人數 7 private String disappearancenumber;//失蹤人數 8 private String total;//總人數 9 private String did; 10 public int getId() { 11 return id; 12 } 13 public void setId(int id) { 14 this.id = id; 15 } 16 public String getDeathtoll() { 17 return deathtoll; 18 } 19 public void setDeathtoll(String deathtoll) { 20 this.deathtoll = deathtoll; 21 } 22 public String getInjuriesnumber() { 23 return injuriesnumber; 24 } 25 public void setInjuriesnumber(String injuriesnumber) { 26 this.injuriesnumber = injuriesnumber; 27 } 28 public String getDisappearancenumber() { 29 return disappearancenumber; 30 } 31 public void setDisappearancenumber(String disappearancenumber) { 32 this.disappearancenumber = disappearancenumber; 33 } 34 public String getTotal() { 35 return total; 36 } 37 public void setTotal(String total) { 38 this.total = total; 39 } 40 public String getDid() { 41 return did; 42 } 43 public void setDid(String did) { 44 this.did = did; 45 } 46 }

　　接下來是Mybatis的接口DisasterMapper.java，代碼如下：

1 package smm.springboot.mapper; 2 import org.apache.ibatis.annotations.Mapper; 3 4 import smm.springboot.bean.Disaster; 5 6 @Mapper 7 public interface DisasterMapper { 8 public void insert(Disaster disaster);//插入數據 9 public Disaster find(int id);//查找數據 10 }

　　對應的mapper文件，DisasterMapper.xml，插入數據和查找數據的程序都是在這個XML文件中生成，代碼如下：

1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> 3 4 <mapper namespace="smm.springboot.mapper.DisasterMapper"> 5  6 <insert id="insert" parameterType="smm.springboot.bean.Disaster"> 7 INSERT INTO d_disaster_overview(deathtoll,injuriesnumber,disappearancenumber,total,did) VALUE(#{deathtoll},#{injuriesnumber},#{disappearancenumber},#{total},#{did}); 8 </insert> 9 10  11 <select id="find" parameterType="int" resultType="smm.springboot.bean.Disaster"> 12 SELECT sum(deathtoll) as deathtoll,sum(injuriesnumber) as injuriesnumber,sum(disappearancenumber) as disappearancenumber, sum(total) as total FROM d_disaster_overview WHERE ID=#{id} 13 </select> 14 </mapper>

　　然后是業務層的接口與實現類，DisasterIService.java的代碼如下：

1 package smm.springboot.service; 2 import org.springframework.stereotype.Component; 3 import org.springframework.web.servlet.DispatcherServlet; 4 5 import smm.springboot.bean.Disaster; 6 7 public interface DisasterIService{ 8 9 public boolean insert(Disaster disaster); 10 public Disaster find(int id); 11 }

　　DisasterService.java的代碼如下：

1 package smm.springboot.service.impl; 2 3 import javax.annotation.Resource; 4 import org.springframework.context.annotation.ComponentScan; 5 import org.springframework.stereotype.Service; 6 7 import smm.springboot.bean.Disaster; 8 import smm.springboot.mapper.DisasterMapper; 9 import smm.springboot.service.DisasterIService; 10 11 @ComponentScan({"smm.springboot.mapper"}) 12 @Service("disasterService") 13 public class DisasterService implements DisasterIService{ 14 @Resource 15 private DisasterMapper disasterMapper; 16 @Override 17 public boolean insert(Disaster disaster) { 18 19 try { 20 disasterMapper.insert(disaster); 21 } catch (Exception e) { 22 //TODO Auto-generated catch block 23 return false; 24 } 25 return true; 26 } 27 @Override 28 public Disaster find(int id) { 29 return disasterMapper.find(id); 30 } 31 }

　　接下來是比較重要的前端控制器AllController.java，它之中關于Disaster的部分代碼如下：

1 package com.example.demo; 2 3 import javax.annotation.Resource; 4 import org.mybatis.spring.annotation.MapperScan; 5 import org.springframework.context.annotation.ComponentScan; 6 import org.springframework.stereotype.Controller; 7 import org.springframework.web.bind.annotation.RequestMapping; 8 import org.springframework.web.bind.annotation.ResponseBody; 9 import com.google.gson.JsonObject; 10 11 import smm.springboot.bean.*; 12 import smm.springboot.service.impl.*; 13 14 @Controller 15 @ComponentScan({"smm.springboot.service"}) 16 @MapperScan({"smm.springboot.mapper"}) 17 public class AllController { 18 19 @Resource 20 private DisasterService disasterService; 21 //Disaster部分 22 @RequestMapping("/DisasterSaveresult") 23 @ResponseBody 24 public String helloD(Disaster disaster) { 25 boolean result=disasterService.insert(disaster); 26 JsonObject json=new JsonObject(); 27 if(result){ 28 json.addProperty("manager", "添加成功"); 29 json.addProperty("result", "1"); 30 }else{ 31 json.addProperty("manager", "添加失敗"); 32 json.addProperty("result", "0"); 33 } 34 return json.toString(); 35 } 36 @RequestMapping("/DisasterFind") 37 @ResponseBody 38 public String sayD(int id){ 39 Disaster d=disasterService.find(id); 40 JsonObject json=new JsonObject(); 41 json.addProperty("deathtoll", d.getDeathtoll()); 42 json.addProperty("injuriesnumber", d.getInjuriesnumber()); 43 json.addProperty("disappearancenumber", d.getDisappearancenumber()); 44 json.addProperty("total", d.getTotal()); 45 return json.toString(); 46 } 47 @RequestMapping("/DisasterSave") 48 public String jspD() { 49 return "DisasterIndex"; 50 } 51 } View Code

　　還有ServletInitializer.java，其代碼如下：

1 package com.example.demo; 2 3 import org.springframework.boot.builder.SpringApplicationBuilder; 4 import org.springframework.boot.web.servlet.support.SpringBootServletInitializer;; 5 6 public class ServletInitializer extends org.springframework.boot.web.servlet.support.SpringBootServletInitializer{ 7 @Override 8 protected SpringApplicationBuilder configure(SpringApplicationBuilder application) { 9 return application.sources(this.getClass()); 10 } 11 }

　　還有SpringBoot的配置文件application.properties，內容如下：

server.context-path=/HelloWorldspring.datasource.driver-class-name =com.mysql.jdbc.Driver spring.datasource.url =jdbc:mysql://10.10.10.7:3306/mysql spring.datasource.username =name spring.datasource.password =passwordmybatis.typeAliasesPackage=smm.springboot.bean mybatis.mapperLocations=classpath:mapper/*Mapper.xmlspring.freemarker.template-loader-path=classpath:/templates/ spring.freemarker.cache=false spring.freemarker.charset=UTF-8 spring.freemarker.check-template-location=true spring.freemarker.content-type=text/html spring.freemarker.expose-request-attributes=true spring.freemarker.expose-session-attributes=true spring.freemarker.request-context-attribute=request spring.freemarker.suffix=.ftlspring.mvc.view.prefix = /WEB-INF/jsp/ spring.mvc.view.suffix = .jsp View Code

　　還有maven項目的配置文件pom.xml，內容如下：

1 <?xml version="1.0" encoding="UTF-8"?> 2 <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 3 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 4 <modelVersion>4.0.0</modelVersion> 5 6 <groupId>disaster</groupId> 7 <artifactId>disaster</artifactId> 8 <version>0.0.1-SNAPSHOT</version> 9 <packaging>war</packaging> 10 11 <name>springbootone</name> 12 <url>http://maven.apache.org</url> 13 14 <properties> 15 <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> 16 </properties> 17 18  19 <parent> 20 <groupId>org.springframework.boot</groupId> 21 <artifactId>spring-boot-starter-parent</artifactId> 22 <version>2.1.0.RELEASE</version> 23 </parent> 24 25 <dependencies> 26  27 <dependency> 28 <groupId>org.springframework.boot</groupId> 29 <artifactId>spring-boot-starter-web</artifactId> 30 </dependency> 31  32 <dependency> 33 <groupId>mysql</groupId> 34 <artifactId>mysql-connector-java</artifactId> 35 <version>5.1.19</version> 36 </dependency> 37  38 <dependency> 39 <groupId>org.mybatis</groupId> 40 <artifactId>mybatis</artifactId> 41 <version>3.4.5</version> 42 </dependency> 43 <dependency> 44 <groupId>org.mybatis</groupId> 45 <artifactId>mybatis-spring</artifactId> 46 <version>1.3.1</version> 47 </dependency> 48 <dependency> 49 <groupId>org.springframework</groupId> 50 <artifactId>spring-webmvc</artifactId> 51 <version>5.1.2.RELEASE</version> 52 </dependency> 53 <dependency> 54 <groupId>org.springframework</groupId> 55 <artifactId>spring-tx</artifactId> 56 <version>5.1.2.RELEASE</version> 57 </dependency> 58 <dependency> 59 <groupId>org.apache.logging.log4j</groupId> 60 <artifactId>log4j-core</artifactId> 61 <version>2.7</version> 62 </dependency> 63 <dependency> 64 <groupId>com.alibaba</groupId> 65 <artifactId>druid</artifactId> 66 <version>1.1.6</version> 67 </dependency> 68 <dependency> 69 <groupId>org.springframework</groupId> 70 <artifactId>spring-jdbc</artifactId> 71 <version>5.0.2.RELEASE</version> 72 </dependency> 73 <dependency> 74 <groupId>org.mybatis.spring.boot</groupId> 75 <artifactId>mybatis-spring-boot-starter</artifactId> 76 <version>1.2.0</version> 77 </dependency> 78 <dependency> 79 <groupId>org.springframework.boot</groupId> 80 <artifactId>spring-boot-starter-web</artifactId> 81 </dependency> 82  83 <dependency> 84 <groupId>org.springframework.boot</groupId> 85 <artifactId>spring-boot-starter-tomcat</artifactId> 86 <scope>provided</scope> 87 </dependency> 88 <dependency> 89 <groupId>org.apache.tomcat.embed</groupId> 90 <artifactId>tomcat-embed-jasper</artifactId> 91 <scope>provided</scope> 92 </dependency> 93  94 <dependency> 95 <groupId>javax.servlet</groupId> 96 <artifactId>jstl</artifactId> 97 </dependency> 98 <dependency> 99 <groupId>com.google.code.gson</groupId> 100 <artifactId>gson</artifactId> 101 <version>2.8.0</version> 102 </dependency> 103 </dependencies> 104 105 <build> 106 <finalName>BOOT</finalName> 107 <plugins> 108  109 <plugin> 110 <groupId>org.apache.maven.plugins</groupId> 111 <artifactId>maven-compiler-plugin</artifactId> 112 <configuration> 113 <source>1.8</source> 114 <target>1.8</target> 115 <compilerVersion>1.8</compilerVersion> 116 <encoding>UTF-8</encoding> 117 </configuration> 118 </plugin> 119  120 <plugin> 121 <groupId>org.apache.maven.plugins</groupId> 122 <artifactId>maven-resources-plugin</artifactId> 123 <configuration> 124 <encoding>UTF-8</encoding> 125 </configuration> 126 </plugin> 127 </plugins> 128 </build> 129 </project>

　　另外還配置了一個用來輸入數據的頁面DisasterIndex.jsp，目錄如下圖：

　　內容代碼如下：

1 <%@ page language="java" contentType="text/html; charset=UTF-8" 2 pageEncoding="UTF-8"%> 3 <!DOCTYPE html> 4 <html> 5 <head> 6 <title>輸入災害數據</title> 7 </head> 8 <body> 9 <h1>Please input disaster data!</h1> 10 <form action="DisasterSaveresult" name="form"> 11 <p> 12 <table border="1"> 13 <tr> 14 <td>死亡人數</td> 15 <td>受傷人數</td> 16 <td>失蹤人數</td> 17 <td>總人數</td> 18 <td>Did</td> 19 </tr> 20 <tr> 21 <td><input name="deathtoll" type="text" /></td> 22 <td><input name="injuriesnumber" type="text" /></td> 23 <td><input name="disappearancenumber" type="text" /></td> 24 <td><input name="total" type="text" /></td> 25 <td><input name="did" value="1" type="text" /></td> 26 </tr> 27 </table> 28 </p> 29 <tr> 30 <td><input type="submit" value="確定" size="50" /></td> 31 <td><input type="reset" value="取消" size="50" /></td> 32 </tr> 33 </form> 34 </body> 35 </html>

　　最后是程序啟動類DemoApplication.java，內容如下：

1 package com.example.demo; 2 3 import org.springframework.boot.SpringApplication; 4 import org.springframework.boot.autoconfigure.SpringBootApplication; 5 import java.net.*; 6 import java.util.ArrayList; 7 import java.util.List; 8 import java.io.FileOutputStream; 9 import java.io.InputStream; 10 import java.io.FileNotFoundException; 11 import java.io.IOException; 12 13 import org.apache.http.HttpEntity; 14 import org.apache.http.HttpResponse; 15 import org.apache.http.NameValuePair; 16 import org.apache.http.client.HttpClient; 17 import org.apache.http.client.methods.HttpGet; 18 import org.apache.http.client.entity.UrlEncodedFormEntity; 19 import org.apache.http.client.methods.HttpPost; 20 import org.apache.http.impl.client.DefaultHttpClient; 21 import org.apache.http.message.BasicNameValuePair; 22 import org.apache.http.util.EntityUtils; 23 import org.codehaus.jettison.json.JSONObject; 24 25 26 @SpringBootApplication 27 public class DemoApplication { 28 public static void main(String[] args) { 29 SpringApplication.run(DemoApplication.class, args); 30 } 31 }

　　點擊Run As Java Application后啟動，可看到如下信息：

　　在瀏覽器輸入http://localhost:8080//DisasterSave，得到以下頁面，便可在表格中輸入數據并插入到Mysql數據庫的表中。

　　至此，整個工程已經完成！

轉載于:https://www.cnblogs.com/MatthewHome/p/9919375.html

總結

以上是生活随笔為你收集整理的SpringBoot框架与MyBatis集成，连接Mysql数据库的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。

上一篇： MySQL数据库性能优化的八种方式
下一篇：查询x,y之间的素数