技術(shù)員聯(lián)盟提供win764位系統(tǒng)下載,win10,win7,xp,裝機(jī)純凈版,64位旗艦版,綠色軟件,免費軟件下載基地!

當(dāng)前位置:主頁 > 教程 > 服務(wù)器類 >

SpringBoot+MyBatis簡單數(shù)據(jù)訪問應(yīng)用的代碼實例

來源:技術(shù)員聯(lián)盟┆發(fā)布時間:2017-10-08 06:10┆點擊:

因為實習(xí)用的是MyBatis框架,所以寫一篇關(guān)于SpringBoot整合MyBatis框架的總結(jié)。

一,Pom文件

<?xml version="1.0" encoding="UTF-8"?> <project xmlns="" xmlns:xsi="" xsi:schemaLocation=" http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId> <artifactId>example</artifactId> <version>1.0-SNAPSHOT</version> <packaging>jar</packaging> //這里設(shè)置為jar,因為我們會使用jar包部署運行 <parent> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-parent</artifactId> <version>1.4.2.RELEASE</version> </parent> <dependencies> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId> </dependency> <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --> <dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> //Mybatis的jar包 <version>1.1.1</version> </dependency> <dependency> <groupId>org.codehaus.jackson</groupId> <artifactId>jackson-mapper-asl</artifactId> //json數(shù)據(jù)格式和對象的轉(zhuǎn)換jar包 <version>1.9.8</version> <type>jar</type> <scope>compile</scope> </dependency> <dependency> <groupId>com.h2database</groupId> //內(nèi)嵌數(shù)據(jù)庫 <artifactId>h2</artifactId> <version>1.3.156</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> //lombok插件,方便model對象的處理 <version>1.16.2</version> </dependency> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> //mysql驅(qū)動 <version>5.1.18</version> </dependency> </dependencies> <build> <finalName>example</finalName> //打包后的jar包名稱 <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> //必須要的SpringBoot繼承的maven插件,缺少了無法打包jar。 <executions> <execution> <goals> <goal>repackage</goal> </goals> </execution> </executions> </plugin> <plugin> <artifactId>maven-resources-plugin</artifactId> //因為jar包中可能存在很多其他的配置資源,例如mapper文件所以打包為jar包需要將其加入,所以需要此資源打包插件 <version>2.5</version> <executions> <execution> <id>copy-xmls</id> <phase>process-sources</phase> <goals> <goal>copy-resources</goal> </goals> <configuration> <outputDirectory>${basedir}/target/classes</outputDirectory> <resources> <resource> <directory>${basedir}/src/main/java</directory> <includes> <include>**/*.xml</include> </includes> </resource> </resources> </configuration> </execution> </executions> </plugin> </plugins> <resources> //打包包含相應(yīng)的資源文件 <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> <include>**/*.tld</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> <include>**/*.tld</include> </includes> <filtering>false</filtering> </resource> </resources> </build> <repositories>//設(shè)置倉庫 <repository> <id>spring-milestone</id> <url></url> </repository> </repositories> </project>

好了簡單的SpringBoot整合Mybatis框架的基礎(chǔ)環(huán)境已經(jīng)搭建完成了,一個Pom文件搞定,接下來我們配置我們的配置文件。

二,配置文件

我們寫在resources目錄下的application.properties文件中。

spring.datasource.url=jdbc:mysql://localhost:3306/數(shù)據(jù)庫名稱?useUnicode=true&characterEncoding=UTF8 spring.datasource.username=用戶名 spring.datasource.password=用戶密碼 spring.datasource.driver-class-name=com.mysql.jdbc.Driver mybatis.mapper-locations=classpath*:/mapper/*Mapper.xml //mapper文件的路徑 mybatis.type-aliases-package=map.model //mapper文件中的前綴 server.port=監(jiān)聽端口號,不設(shè)置默認(rèn)8080

ok,現(xiàn)在環(huán)境已經(jīng)徹底搭建完成我們可以編寫自己的代碼了。

三,編寫代碼

Model對象

@Data//@Data lombok插件的注解自動添加get set方法 public class ExampleModel { private Long id; private String name; } //一個簡單的model對象

Dao層