MyBatisPlus介绍入门以及项目集成MyBatisPlus
場(chǎng)景
項(xiàng)目專欄
https://blog.csdn.net/column/manage/37194
簡(jiǎn)介
MybatisPlus是一個(gè)MyBatis的增強(qiáng)工具包,只做增強(qiáng)不做改變。
為簡(jiǎn)化開發(fā)工作、提高生產(chǎn)效率而生。
官網(wǎng):
https://mp.baomidou.com/
GitBub地址:
https://github.com/baomidou/mybatis-plus
碼云地址:
https://gitee.com/baomidou/mybatis-plus
官方文檔:
https://baomidou.gitee.io/mybatis-plus-doc/#/quick-start
實(shí)現(xiàn)
新建數(shù)據(jù)庫(kù)mp,新建表Employee
插入數(shù)據(jù)
新建項(xiàng)目
打開Eclipse--new--Maven Project--Create a simple project
輸入組織名等
新建項(xiàng)目后打開pom.xml引入項(xiàng)目依賴
注意:
Mybatis以及Mybatis-Soring依賴不要加入到項(xiàng)目配置中,以免引起版本沖突,因?yàn)镸ybatis-Plus會(huì)自動(dòng)維護(hù)。
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.badao.mp</groupId><artifactId>hellomp</artifactId><version>0.0.1-SNAPSHOT</version><dependencies><!-- mp依賴mybatisPlus 會(huì)自動(dòng)的維護(hù)Mybatis 以及MyBatis-spring相關(guān)的依賴--><dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus</artifactId><version>2.3</version></dependency>??<!--junit --><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>4.9</version></dependency><!-- log4j --><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency><!-- c3p0 --><dependency><groupId>com.mchange</groupId><artifactId>c3p0</artifactId><version>0.9.5.2</version></dependency><!-- mysql --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.11</version></dependency><!-- spring --><dependency><groupId>org.springframework</groupId><artifactId>spring-context</artifactId><version>4.3.10.RELEASE</version></dependency><dependency><groupId>org.springframework</groupId><artifactId>spring-orm</artifactId><version>4.3.10.RELEASE</version></dependency></dependencies> </project>新建bean Employee,屬于beans包
?
代碼:
package com.badao.beans;public class Employee {private Integer id;private String name;private String email;private Integer gender;private Integer age;public Integer getId() {return id;}public void setId(Integer id) {this.id = id;}public String getName() {return name;}public void setName(String name) {this.name = name;}public String getEmail() {return email;}public void setEmail(String email) {this.email = email;}public Integer getGender() {return gender;}public void setGender(Integer gender) {this.gender = gender;}public Integer getAge() {return age;}public void setAge(Integer age) {this.age = age;}}新建配置文件
db.ptoperties代碼:
jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/mp jdbc.username=root jdbc.password= 123log4j.xml代碼:
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE log4j:configuration SYSTEM "log4j.dtd"><log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/"><appender name="STDOUT" class="org.apache.log4j.ConsoleAppender"><param name="Encoding" value="UTF-8" /><layout class="org.apache.log4j.PatternLayout"><param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m? (%F:%L) \n" /></layout></appender><logger name="java.sql"><level value="debug" /></logger><logger name="org.apache.ibatis"><level value="info" /></logger><root><level value="debug" /><appender-ref ref="STDOUT" /></root> </log4j:configuration>mybatis-config.xml代碼:
<?xml version="1.0" encoding="UTF-8" ?> <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"> <configuration></configuration>applicationContext.xml
<?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"xmlns:tx="http://www.springframework.org/schema/tx"xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsdhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"><!-- 數(shù)據(jù)源 --><context:property-placeholder location="classpath:db.properties"/><bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"><property name="driverClass" value="${jdbc.driver}"></property><property name="jdbcUrl" value="${jdbc.url}"></property><property name="user" value="${jdbc.username}"></property><property name="password" value="${jdbc.password}"></property></bean><!-- 事務(wù)管理器 --><bean id="dataSourceTransactionManager"class="org.springframework.jdbc.datasource.DataSourceTransactionManager"><property name="dataSource" ref="dataSource"></property></bean><!-- 基于注解的事務(wù)管理 --><tx:annotation-driven transaction-manager="dataSourceTransactionManager"/><!--? 配置SqlSessionFactoryBeanMybatis提供的: org.mybatis.spring.SqlSessionFactoryBeanMP提供的:com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean--><bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><!-- 數(shù)據(jù)源 --><property name="dataSource" ref="dataSource"></property><property name="configLocation" value="classpath:mybatis-config.xml"></property><!-- 別名處理 --><property name="typeAliasesPackage" value="com.badao.beans"></property>??</bean><!--配置mybatis 掃描mapper接口的路徑--><bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"><property name="basePackage" value="com.badao.mapper"></property></bean></beans>進(jìn)行測(cè)試:
在src/test/java下新建Junit Test Case
?
?
編寫代碼如下,記得導(dǎo)包不要導(dǎo)錯(cuò)。
package com.badao.test; import java.sql.Connection;import javax.sql.DataSource;import org.junit.Test; import org.springframework.context.ApplicationContext;import org.springframework.context.support.ClassPathXmlApplicationContext;public class TestMp {private ApplicationContext ioc = new ClassPathXmlApplicationContext("applicationContext.xml");@Testpublic void testDataSource() throws Exception{DataSource ds = ioc.getBean("dataSource",DataSource.class);System.out.println("******************************************"+ds);Connection connection = ds.getConnection();System.out.println("******************************************"+connection);}}運(yùn)行測(cè)試效果:
至此測(cè)試成功說明環(huán)境搭建成功。
集成MybatisPlus
我們只需要把Mybatis自帶的SessionFactoryBean替換為MybatisPlus自帶的MybatisSqlSessionFactoryBean即可。
打開applicationContext.xml
找到
<!--? 配置SqlSessionFactoryBeanMybatis提供的: org.mybatis.spring.SqlSessionFactoryBeanMP提供的:com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean--><bean id="sqlSessionFactoryBean" class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean"><!-- 數(shù)據(jù)源 --><property name="dataSource" ref="dataSource"></property><property name="configLocation" value="classpath:mybatis-config.xml"></property><!-- 別名處理 --><property name="typeAliasesPackage" value="com.badao.beans"></property>???</bean>源碼下載
https://download.csdn.net/download/badao_liumang_qizhi/11123716
?
?
總結(jié)
以上是生活随笔為你收集整理的MyBatisPlus介绍入门以及项目集成MyBatisPlus的全部?jī)?nèi)容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: SpringBoot入门实战项目各阶段目
- 下一篇: MybatisPlus提示 Could