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的方法,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持!,小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持!