Spring集成MyBatisPlus（1）-【官方】百战程序员_IT在线教育培训机构


x
DROP DATABASE IF EXISTS `school`;
CREATE DATABASE `school`;
USE `school`;

DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
    `gender` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO `student` VALUES ('1', '百战', 'bz@itbaizhan.com', 'm', '22');
INSERT INTO `student` VALUES ('2', '尚学堂', 'sxt@itbaizhan.com', 'f', '25');
INSERT INTO `student` VALUES ('3', '小张', 'zhang@itbaizhan.com', 'm', '30');
INSERT INTO `student` VALUES ('4', '小王', 'wang@itbaizhan.com', 'f', '35');
INSERT INTO `student` VALUES ('5', '小李', 'li@itbaizhan.com', 'm', '32');
INSERT INTO `student` VALUES ('6', '小赵', 'zhao@itbaizhan.com', 'm', '32');

创建Maven项目，引入依赖


xxxxxxxxxx
<!-- MyBatisPlus -->
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus</artifactId>
    <version>3.4.2</version>
</dependency>
<!-- mysql驱动 -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.26</version>
</dependency>
<!-- junit -->
<dependency>
    <groupId>junit</groupId>
    <artifactId>junit</artifactId>
    <version>4.12</version>
    <scope>test</scope>
</dependency>
<!-- druid -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.6</version>
</dependency>
<!-- spring -->
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-context</artifactId>
    <version>5.3.9</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-orm</artifactId>
    <version>5.3.9</version>
</dependency>
<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-test</artifactId>
    <version>5.3.9</version>
</dependency>
<!-- lombok   -->
<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.22</version>
</dependency>

创建实体类


xxxxxxxxxx
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
    private Integer id;
    private String name;
    private String email;
    private String gender;
    private Integer age;
}

创建Mapper接口。
使用MyBatis时，在编写Mapper接口后，需要手动编写CRUD方法，并需要在Mapper映射文件中手动编写每个方法对应的SQL语句。而在MyBatisPlus中，只需要创建Mapper接口并继承BaseMapper，此时该接口获得常用增删改查功能，不需要自己手动编写Mapper配置文件
```
xxxxxxxxxx
public interface StudentMapper extends BaseMapper<Student> {
}
```

创建Spring配置文件applicationContext.xml


xxxxxxxxxx
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:p="http://www.springframework.org/schema/p"
       xsi:schemaLocation="
                    http://www.springframework.org/schema/context
                    http://www.springframework.org/schema/context/spring-context.xsd
                    http://www.springframework.org/schema/beans
                    http://www.springframework.org/schema/beans/spring-beans.xsd">

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql:///school"/>
        <property name="username" value="root"/>
        <property name="password" value="root"/>
    </bean>

    <!-- MyBatisPlus提供的session工厂对象-->
    <bean id="sqlSessionFactory"
          class="com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- 自动扫描所有mapper ,将mapper接口生成代理注入到Spring-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"
          p:basePackage="com.itbaizhan.mapper"
          p:sqlSessionFactoryBeanName="sqlSessionFactory"/>
</beans>

测试Mapper方法


xxxxxxxxxx
@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class StudentMapperTest {
    @Autowired
    private StudentMapper studentMapper;

    @Test
    public void testFindById(){
        Student student = studentMapper.selectById(1);
        System.out.println(student);
    }
}

MyBatisPlus概述 Spring集成MyBatisPlus（2）

北京市昌平区回龙观镇南店村综合商业楼2楼226室