springboot上集成mybatis。首先創建一個maven項目。
添加依賴
<!--springboot依賴--><dependency><groupId>org.springframework.boot<groupI><artifactId>springbootstarter<artifactId></dependency><dependency><groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-web</artifactId>在<! - 集成mybatis-> <dependenty> <groupId> org.mybatis.spring.spring.boot </groupId> <ArtifactId> mybatis-spring-boot-boot-starter <ARTIFACTID> <ARTIFACTID> </artifactid> </decord> </distry> 1.3.0 </verion> </distory> </distion> </distion> <trifactid> mysql-connector-java </artifactid> <版本> 5.1.35 </version> </deverency>
在src/main/resources/目錄下新建一個application.properties配置文件,裡面寫數據源的配置
spring.datasource.name = testspring.datasource.url = jdbc:mysql://127.0.0.0.1:3306/testspring.datasource.username = rootspring.datasource.datasource.passource.pasperword = root = root
配置文件有兩種寫法,我們還可以寫成,YML文件形式,在src/main/resources/resources/respaction.yml 文件(兩種方式選其中一種就可以了)
春季:dataSource:url:jdbc:mysql://127.0.0.1:3306/test用戶名:root password:root driver-class-name:com.mysql.cj.jdbc.driver
在本地數據庫中創建測試數據庫,並新建一個表t_user
CREATE DATABASE test;CREATE TABLE `t_user` ( `user_id` int(11) NOT NULL AUTO_INCREMENT, `user_name` varchar(225) NOT NULL, `password` varchar(225) NOT NULL, `phone` varchar(225) NOT NULL, PRIMARY KEY (`user_id`)) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8
Mybatis生成器插件,自動生成實體類,映射器,mapper.xml文件
在(POM)(build 依賴(放在層次外面)
<build> <resources> <resource> <Directory> src/main/resources </Directory> <filtering> true </Filtering> <dubludes> <Exprude> generator> Generator/** </delpude> </dextudes> </resource> </resources> <plugins> <glugin> <groupId> org.mybatis.generator </groupId> <ArtifactId> mybatis-generator-maven-plugin </artifactid> </artifactid> <版本> <版本> <版本> 1.3.4-snapshot </snapshot </snapshot> <artifactId>mysql-connector-java</artifactId> <version>5.1.39</version></dependency><dependency><groupId>org.mybatis.generator</groupId><artifactId>mybatis-generator-core</artifactId> <version>1.3.4-SNAPSHOT</version></dependency></dependencies> <configuration> <oferwrite> true </offrite> <ConfigurationFile> src/main/resources/resources/generator/generatorConfig.xml </configurationFile> </configuration> </plugin> </plugin> </plugins> </build> </build>
在src/main/resources/下面新建一個目錄發電機,在此目錄下新建一個generatorConfig.xml文件(注意根據自己的目錄,調整路徑)
<? xml版本=“ 1.0”編碼=“ utf-8”? > <! doctype generatorContorContorConfiguration public public' - // mybatis.org//dtd mybatis generator generator generator配置1.0 // en“ http:// http://mybatis.ormbatis.ormbatis.ormbatis.ormbatis.ormbatis-dtdd/mybatis-genertis-genertigritation> <context id =“ db2tables” targetRuntime =“ mybatis3”> <commentgenerator> <propert name =“ propert name =“ propersdate” value =“ true”/> <property name =“ puspressallComments” value =“ true”/> </commentgenerator> <! - > - > - > - > - > - > - > <jdbcconnection driverclass =“ ConnectionUrl =“ JDBC:mySQL://127.0.0.1:3306/test“ userId =“ root” password =“ root”> </jdbcconnection> <JavatyPeresolver> <javatyperesolver> <property name =“ forcebigdecimals” targetpackage =“ com.lw.study.dao.doain” targetProject =“ src/src/main/java”> <屬性名稱=“ EnablesubPackages” value =“ true”/> <propert name =“ trimstrings” trimstrings“ value =” value =“ true”/> </javamodelgenerator> </javamodelgenerator> targetProject =“ src/main/resources/”> <屬性名稱=“ enablesubPackages” value =“ true”/> </> </sqlmapgenerator> <!<! - 生成dao類存放位置-> <! - > <! - 客戶端代碼,生成易於使用的針對,生成易於使用的針對生成易於使用的針對xml對象和xml對象和xml對象和xml對象和和相應的映射器對象type =“ xmlmapper”,生成sqlmap xml thig smapper接口-> <javaclientGenerator type =“ xmlmapper” targetpackage =“ com.lw.study.dao.dao.dao.dao.mapper.mapper” </javaclientGenerator> <! - 生成對應表及類名-> <! - <table Schema =“ loandb” tablename =“ t_audit_job” domainObjectName =“ AuditJob”> - > <! Identity =“ true”/> - > <! - </table> - > <table tableName =“ t_user” domainObjectName =“ enbleCountByExample =” enableCountByExample =“ false” enableUpdateByExample =“ false” enabledeletebyeletebyeletebyExample =“
然後運行發電機配置文件。
在點擊左上角的➕,選擇
工作derectory選擇自己的項目路徑。然後應用,在右上角運行就可以了,就會在指定的目錄下生成三個文件(實體類,映射器類
最後在src/main/java/com/lw/study/sron/目錄下新建一個mybatisconfig目錄,裡面新建兩個配置類。 ,裡面新建兩個配置類。
mybatisconfig.java
@configuration @enabletransactionManagementpublic類MyBatisconFig {@bean @configurationProperties(prefix =“ spring.datasource”)public datasource dataSource dataSource() } @bean(name =“ sqlsessionFactory”)public sqlsessionfactory sqlsessionfactorybean()拋出異常{sqlsessionfactorybean sqlsessionfactorybean = new Sqlsessionfactoryfactorybean(); sqlsessionfactorybean.setdatasource(dataSource()); pathMatchingResourcePatternresolver resolver = new PathMatchingResourcePatternresolver(); sqlsessionfactorybean.setMapperLocations(resolver.getResources(“ classPath:/sqlmap/*。xml”));返回sqlsessionfactorybean.getObject(); }}}mybatismapperscannerconfig.java
@configuration @autoconfigureatter(mybatisconfig.class)公共類mybatismapperscannerconconfig {@bean Public Mapperscannercannerconfigurer mmapperscannerconnerconfigurer() mapperscannerconfigurer.setsqlsessionfactorybeanname(“ sqlSessionFactory”); mapperscannerconfigurer.setbasepackage(“ com.study.dao.mapper”);返回mapperscannerconfigurer; }}}創建一個Springboot的啟動類,application.java
@springbootapplication(scanbasepackages = {“ com.lw.study。 }}}好了,到這裡我們在springboot中通過發電機插件的方式集成mybatis就完成了。大家可以自己寫一個測試類,使用映射器中的方法看能否在數據庫中查到數據。
總結
springboot工程並集成mybatis的方法,希望對大家有所幫助,如果大家有任何疑問請給我留言,小編會及時回復大家的。在此也非常感謝大家對武林網網站的支持! ,小編會及時回復大家的。在此也非常感謝大家對武林網網站的支持!