SpringBoot2.1.X 整合Mybatis3.x注解 CURD

淡淡的烟草味﹌ 2024-04-19 08:05 81阅读 0赞

## SpringBoot2.1.X整合Mybatis3.x注解配置实战 ##

**工程结构图**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70][]

**mysql数据表**

DROP TABLE IF EXISTS `users`;
    CREATE TABLE `users` (
      `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
      `userCode` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户编码',
      `userName` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户名称',
      `userPassword` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '用户密码',
      `gender` int(10) DEFAULT NULL COMMENT '性别（1:女、 2:男）',
      `create_time` date DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    
    -- ----------------------------
    -- Records of users
    -- ----------------------------
    INSERT INTO `users` VALUES ('1', 'admin', '系统管理员', '1234567', '1', null);
    INSERT INTO `users` VALUES ('2', 'liming', '李明', '0000000', '2', null);
    INSERT INTO `users` VALUES ('5', 'hanlubiao', '韩路彪', '0000000', '2', null);
    INSERT INTO `users` VALUES ('6', 'zhanghua', '张华', '0000000', '1', null);
    INSERT INTO `users` VALUES ('7', 'wangyang', '王洋', '0000000', '2', null);
    INSERT INTO `users` VALUES ('8', 'zhaoyan', '赵燕', '0000000', '1', null);
    INSERT INTO `users` VALUES ('10', 'sunlei', '孙磊', '0000000', '2', null);
    INSERT INTO `users` VALUES ('11', 'sunxing', '孙兴', '0000000', '2', null);
    INSERT INTO `users` VALUES ('12', 'zhangchen', '张晨', '0000000', '1', null);
    INSERT INTO `users` VALUES ('13', 'dengchao', '邓超', '0000000', '2', null);
    INSERT INTO `users` VALUES ('14', 'yangguo', '杨过', '0000000', '2', null);
    INSERT INTO `users` VALUES ('15', 'bboy', '陆飞', null, '1', null);
    INSERT INTO `users` VALUES ('16', 'assassinate', 'banana', '1234556', '2', null);
    INSERT INTO `users` VALUES ('18', 'fei', 'onion', '786543', '1', '2019-09-15');
    INSERT INTO `users` VALUES ('21', 'eraers', '橡皮', '1234556', '2', null);

操作步骤：

**1.在pom.xml中添加依赖包**

使用starter, maven仓库地址：http://mvnrepository.com/artifact/org.mybatis.spring.boot/mybatis-spring-boot-starter

也使用http://start.spring.io/ 下载

<dependency>
    					    <groupId>org.mybatis.spring.boot</groupId>
    					    <artifactId>mybatis-spring-boot-starter</artifactId>
    					    <version>1.3.2</version>
    					    <scope>runtime</scope>			    
    					</dependency>
    		 			
    		 		
    		 			<dependency>
    						<groupId>mysql</groupId>
    						<artifactId>mysql-connector-java</artifactId>
    						<scope>runtime</scope>
    					</dependency> 
    					
    					<dependency>
    						<groupId>com.alibaba</groupId>
    						<artifactId>druid</artifactId>
    						<version>1.1.6</version>
    					</dependency>

**2、在application.properties下加入配置文件**

#mybatis数据源
    spring.datasource.driver-class-name =com.mysql.jdbc.Driver
    spring.datasource.url=jdbc:mysql://localhost:3306/smbms?useUnicode=true&characterEncoding=utf-8
    spring.datasource.username =root
    spring.datasource.password =root
    
    #如果不使用默认的数据源 （com.zaxxer.hikari.HikariDataSource）
    spring.datasource.type =com.alibaba.druid.pool.DruidDataSource
    #增加打印sql语句，一般用于本地开发测试
    mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

**使用默认的数据源**![20190915161411750.png][]

**使用阿里巴巴的数据源**

![20190915161447602.png][]

**3、UserMapper类**

**参考语法 http://www.mybatis.org/mybatis-3/zh/java-api.html**

import net.hlx.myspringboot.crud_demo.entity.User;
    import org.apache.ibatis.annotations.*;
    
    import java.util.List;
    
    /**
     * 底层数据的注解
     */
    @Mapper
    public interface UserMapper {
    
        //推荐使用#{}取值，不要用${},因为存在注入的风险
        @Insert("insert into users(userCode,userName,userPassword,gender,create_time) values(#{userCode},#{userName},#{userPassword},#{gender}, #{createTime})")
        @Options(useGeneratedKeys=true, keyProperty="id", keyColumn="id")   //keyProperty java对象的属性；keyColumn表示数据库的字段
        int save(User user);
    
    
       //删除
        @Delete("delete from users where id=#{id}")
        int delete(int id);
    
        //更新
        @Update("UPDATE users SET userName=#{userName},userPassword=#{userPassword} WHERE id =#{id}")
        int update(User user);
    
        //查询所有数据
        @Select("select * from users")
        @Results({
                @Result(column = "create_time",property = "createTime")
        })
        //javaType = java.util.Date.class
        List<User> all();
    
    
        //根据ID查询数据
        @Select("select * from users where id=#{id}")
        @Results({
                @Result(column = "create_time",property = "createTime")
        })
         User findId(int id);
    }

**4、User实体类**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 1][]

**5、业务类实现接口**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 2][]

**6、控制类**

/**
     * 控制器
     */
    @RestController
    @RequestMapping("/crud/user")  //访问路径
    public class UserController {
    
        //注入业务对象
        @Autowired
        private UserService userService;
    
        @GetMapping("add")
        public Object add(User user){
            //调用业务
            int id=userService.add(user);
    
            //返回JSON状态
            return JsonData.buildSuccess(id);
        }
    
    
        @GetMapping("del/{id}")
        public Object del(@PathVariable("id") int id){
            //用户对象
            User user =new User(id);
            //调用业务
            int count=userService.del(id);
    
            //返回JSON状态
            return JsonData.buildSuccess(count);
        }
    
    
    
        @GetMapping("update")
        public Object update(User user){
            //调用业务
            int id=userService.update(user);
    
            //返回JSON状态
            return JsonData.buildSuccess(id);
        }
    
    
        @GetMapping("all")
        public Object all(){
    
            //调用业务
            List<User> list= userService.getAll();
    
            //返回JSON
            return JsonData.buildSuccess(list);
        }
    
        @GetMapping("findById")
        public Object findById(int id){
    
            //调用业务
            User user= userService.findById(id);
    
            //返回JSON
            return JsonData.buildSuccess(user);
        }
    
    }

效果：

原数据：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 3][]

**添加一条信息（注意参数名与属性名相同哦！）**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 4][]

![20190915160639717.png][]

**修改**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 5][]

![20190915160810961.png][]

**删除**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 6][]

![20190915160936627.png][]

**查询一条数据**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 7][]

**查询所有数据**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 8][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/ced4611eddb9482aabce6e2f8cb8ae71.png
[20190915161411750.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/b076141f4dd94884beec533370bee719.png
[20190915161447602.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/d7fd8f2f43b8464085d6052543d57d03.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 1]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/f289c1e3bafc4bda85011d7ec3fa9a51.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 2]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/e008e5e4312649b48b965aa8643c4a1c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 3]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/5230e485e4804f1998eff17c70421d2d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 4]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/8d04591ffb4742afa07f8f204c215ff1.png
[20190915160639717.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/bec13c432468486884d876606966b449.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 5]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/03417468d1a84f9286029ebecffe27b9.png
[20190915160810961.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/b3305d54c9854a05a35c8b1c8b9795c3.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 6]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/9c9981ff3c564cc3b35826559ebd64b2.png
[20190915160936627.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/e382b16024134d93b6550581ca96b726.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 7]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/33dfe22b3bde46a2897bc27d7113cd0c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2hseDIwMDgwODA4_size_16_color_FFFFFF_t_70 8]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/18/1f263d57c42e471eb9faa2231e502226.png