今天我们在 Springboot 上集成 mybatis 。首先创建一个 Maven 项目。
添加依赖
<!-Springboot 依赖-> <pendency> <puerpiD> org.springframework.boot <puadei> <TRAFACTID> SpringbootStarter <TRATIFACTID> </Dependency> <pendence> <pupulid> org.springframework.boot </groupid> <Artifactid> </dependency> <!-测试-> <pendency> <puperid> org.springframework.boot </frugiD> <TRAFACTID> Spring-boot-starter-test </stifactId> <coolpe> test </cope> </pendence> <!-集成 mybatis-> <pendency> <puperiD> org.mybatis.spring.boot </groupid> <stifactId> mybatis-spring-boot-starter <TartifactId> <bersion> 1.3.0 </versão> </dependency> <pendência> <purfactId> </siSSQL> <TarfactId> MySQL-Connector-Java </ArtifactId> <versão> 5.1.35 </versão </dependency>
在 SRC/Main/Recursos/目录下新建一个 Application.Properties 配置文件 ， 里面写数据源的配置
spring.dataSource.name = testspring.dataSource.url = jdbc: mysql: //127.0.0.1: 3306/testspring.datasource.username = rootspring.datasource.password = raiz
配置文件有两种写法 ， 我们还可以写成 yml 文件形式 ， 在 src/main/recursos/目录下新建一个 Application.yml 文件 （两种方式选其中一种就可以了）））
Primavera: DataSource: URL: JDBC: MySQL: //127.0.0.1: 3306/Teste Nome de usuário: Raiz Senha: ROOT Driver-class-name: com.mysql.cj.jdbc.driver
在本地数据库中创建 Teste 数据库 ， 并新建一个表 T_USER
Crie teste de banco de dados; crie a tabela `t_user` (` user_id` int (11) não nulo auto_increment, `user_name` varchar (225) não nulo,` senha 'varchar (225) não nulo, `telefone`char (225) não nulo, a chave primária (` user_id`)) mecan
这里我们使用 Mybatis-gerador 插件 ， 自动生成实体类 ， Mapper ， 以及 mapper.xml 文件
在 POM 中添加 Build 依赖 （放在层次外面））
<build> <werens> <cource> <Directory> src/main/recursos </diretório> <filtering> true </filtering> <cligires> <cligir> generator/** </cligir> </cligires> </source> </sourcens> <flugins> <lamp> <puperid> org.mybatis.generator </foupiD> <stifactId> mybatis-generator-maven-plugin </sutifactId> <versão> 1.3.4-snapshot </sipers> <pendencies> <pendency> <runderid> mysq <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> <verwrite> true </verwrite> <figurationfile> src/main/recursos/generator/generatorconfig.xml </figurationfile> </figuration> </plugin> </plugins> </fruct>
在src/main/resources/下面新建一个目录generator，在此目录下新建一个generatorConfig.xml文件(注意根据自己的目录，调整路径）
<? xml versão = "1.0" coding = "utf-8"?> <! Doctype geratorConfiguration public "-// mybatis.org//dtd mybatis generator configuration 1.0 //" <contexto id = "db2tables" TargetRuntime = "mybatis3"> <CommentGenerator> <propriedade name = "suprimdate" value = "true"/> <propriedade name = "suprimallcommments" value = "true"/> </comentário ConnectionUrl = "JDBC: mysql: //127.0.0.1: 3306/teste" userId = "root" senha = "root"> </jdbcconnection> <navatyperesolver> <namesolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversolversol: TargetPackage = "com.lw.study.dao.Domain" TargetProject = "src/main/java"> <propriedade name = "enablesubpackages" value = "true"/> <nome da propriedade = "trimStrings" value = "true"/> </javamodelGenerator> <!-"-"-") targetProject="src/main/resources/"> <property name="enableSubPackages" value="true"/> </sqlMapGenerator> <!--生成Dao类存放位置--> <!-- 客户端代码，生成易于使用的针对Model对象和XML配置文件 的代码 type="ANNOTATEDMAPPER",生成Java Model 和基于注解的Mapper对象 type="MIXEDMAPPER",生成基于注解的Java Model和相应的 Mapper 对象 Type = "XmlMapper", 生成 SQLMAP XML 文件和独立的 Mapper 接口 -> <JavaclientGenerator Type = "xmlmapper" TargetPackage = "com.lw.study.dao.mapper" TargetProject = "Src/main/java"> <nava "<nava", "names) </javaclientGenerator> <!-生成对应表及类名-> <!-<tabela schema = "loandb" tablename = "t_audit_job" domainObjectName = "auditjob">-> <!-<names name = "useAcTualColumnNames" = "true"/>-> <! identity = "true"/>-> <!-</ tabela>-> <table tableName = "t_user" domainObjectName = "user" enableCountByExample = "false" enableUpDateByExample = "false" ENFELTELETEBYEXAMPLE = "FALSE" enablelectByExample = "FalseByExempSoxeryId ="
然后运行 Gerador 配置文件。
在点击左上角的➕ ， 选择 Maven
DeSerctory de trabalho 选择自己的项目路径。然后 Aplicar ， 在右上角运行就可以了 ， 就会在指定的目录下生成三个文件 （实体类 ， Mapper 类 ， 和 mapper.xml 文件）））） 文件 文件 文件）） ，
最后在 src/main/java/com/lw/estudo/目录下新建一个 mybatisconfig 目录 ， 里面新建两个配置类。 里面新建两个配置类。
Mybatisconfig.java
@Configuration @EnabetransactionManagementPublic Classe mybatisconfig {@Bean @ConfigurationProperties (prefix = "spring.dataSource") public DataSource DataSource () {retorna new org.apache.tomcat.jdbc.pool.datasource (); } @Bean (name = "sqlSessionFactory") public sqlSessionFactory sqlSessionFactoryBean () lança exceção {sqlSessionFactoryBean sqlSessionFactoryBean = new SQLSessionFactoryBean (); sqlSessionFactoryBean.SetDataSource (DataSource ()); PathMatchingResourCepTatherNResolver Resolver = new PathMatchingResourCepTatternResolver (); sqlSessionFactoryBean.SetMapperLocations (Resolver.GetResources ("ClassPath:/sqlmap/*. Xml")); return sqlSessionFactoryBean.getObject (); }}Mybatismapperscannerconfig.java
@Configuration @AutoConfigurethter (mybatisconfig.class) classe MybatismapperScannerConfig {@Bean public MappersCannerConfigurer MappersCannerConfigurer () {MappersCannerConfigurer mapperCannerConfigur = newpapersCannerfigurer () MappersCannerConfigurer.SetSqlSessionFactoryBeanName ("SQLSessionFactory"); mapperscannerconfigurer.setBasePackage ("com.study.dao.mapper"); Retornar MapperScannerConfigurer; }}创建一个 Springboot 的启动类 ， Application.java
@SpringbooTApplication (scanBasePackages = {"com.lw.study.*"})@Mapperscan ("com.lw.study.mapper") public class Application {public static void main (string [] args) {springApplication.run (application.class, args); }}好了 ， 到这里我们在 Springboot 中通过 gerador 插件的方式集成 mybatis 就完成了。大家可以自己写一个测试类 ， 使用 mapeador 中的方法看能否在数据库中查到数据。
总结
以上所述是小编给大家介绍的创建 Springboot 工程并集成 mybatis 的方法 ， 希望对大家有所帮助 ， 如果大家有任何疑问请给我留言 ， 小编会及时回复大家的。在此也非常感谢大家对武林网网站的支持！