美文网首页MyBatis
Mybatis-Plus之入门小例子

Mybatis-Plus之入门小例子

作者: Colors_boy | 来源:发表于2020-08-30 17:12 被阅读0次

    1. 新建spring boot项目

    2. maven导入依赖

    
    <!--连接池-->
    
    <dependency>
    
                <groupId>com.alibaba</groupId>
    
                <artifactId>druid-spring-boot-starter</artifactId>
    
                <version>1.1.10</version>
    
            </dependency>
    
            <!--mysql-->
    
            <dependency>
    
                <groupId>mysql</groupId>
    
                <artifactId>mysql-connector-java</artifactId>
    
                <version>8.0.13</version>
    
            </dependency>
    
            <!--Mybatis-Plus-->
    
            <dependency>
    
                <groupId>com.baomidou</groupId>
    
                <artifactId>mybatis-plus-boot-starter</artifactId>
    
                <version>3.4.0</version>
    
            </dependency>
    
    

    4.创建表

    CREATE TABLE `employee` (
      `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '员工编号',
      `name` varchar(10) DEFAULT NULL COMMENT '员工姓名',
      `gender` char(4) DEFAULT NULL COMMENT '性别',
      PRIMARY KEY (`id`),
    ) ENGINE=InnoDB AUTO_INCREMENT=1945 DEFAULT CHARSET=utf8;
    
    
    

    5. 配置数据库连接

    
    spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
    
    spring.datasource.username=账号
    
    spring.datasource.password=密码
    
    spring.datasource.url=jdbc:mysql://localhost:3306/school?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    
    logging.level.root = info
    
    

    6.配置 MapperScan 注解

    
    @MapperScan(basePackages = {"com.mp.demo.mapper"})
    
    

    7.编写entry类

    
    @Data
    
    public class Employee{
    
        //主键
    
        private int id;
    
        //姓名
    
        private String name;
    
        //性别
    
        private String gender;
    
    }
    
    

    8. mapper接口继承BaseMapper

    
    public interface EmployeeMapper extends BaseMapper<Employee> {
    
    }
    
    

    9. 编写方法

    
    @SpringBootApplication
    
    @MapperScan(basePackages = {"com.mp.demo.mapper"})
    
    class DemoApplication {
    
        @Autowired
    
        private StudentMapper EmployeeMapper;
    
    
    
        public void insert(){
            Employee employee = new Employee();
            employee.setId(57);
            employee.setGender("男");
            employee.setName("好男人");
            employeeMapper.insert(employee);
    
        }
    
    }
    
    

    10. 输出结果

    image.png

    相关文章

      网友评论

        本文标题:Mybatis-Plus之入门小例子

        本文链接:https://www.haomeiwen.com/subject/jddssktx.html