spring boot整合mybatis

逃离我推掉我的手 2022-06-12 08:59 116阅读 0赞

咳咳,之前的目录结构还在吧?不在了?尴尬那你自己的创建吧,继续spring boot整合mybatis!

按照一般SSM标准项目,项目结构如下,比较正规的项目,可能还会将实体和业务层接口独立出来作为一个服务jar包,此处省略,效果是一样的,有不懂的可以私聊我

Center

数据库怎么创建我就不教了,此处省略数据库(Mysql)安装,链接

SQL语句:

  1. CREATE TABLE `tb_favorite` (
  2.   `id` bigint(16) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  3.   `product_id` bigint(16) unsigned DEFAULT NULL COMMENT '商品编号',
  4.   `merchant_id` int(16) unsigned DEFAULT NULL COMMENT '商户编号',
  5.   `status` int(1) DEFAULT NULL COMMENT '状态：1-收藏，2-取消收藏',
  6.   `creator` varchar(32) DEFAULT NULL COMMENT '创建人',
  7.   `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  8.   PRIMARY KEY (`id`),
  9.   UNIQUE KEY `merchant_id` (`merchant_id`,`product_id`)
  10. ) ENGINE=InnoDB AUTO_INCREMENT=46714 DEFAULT CHARSET=utf8 COMMENT='个人收藏';

model:实体

  1. package com.xyy.model;
  3. import java.io.Serializable;
  4. import java.util.Date;
  6. public class Favorite implements Serializable {
  7.     private static final long serialVersionUID = 1L;
  9.     /** 主键 */
  10.     private Long id;
  12.     /** 商品编号 */
  13.     private Long productId;
  15.     /** 商户编号 */
  16.     private Integer merchantId;
  18.     /** 状态：1-收藏，2-取消收藏 */
  19.     private Integer status;
  21.     /** 创建人 */
  22.     private String creator;
  24.     /** 创建时间 */
  25.     private Date createTime;
  27.     /**
  28.      *
  29.      * @return 返回数据库表tb_favorite的id字段值
  30.      */
  31.     public Long getId() {
  32.         return id;
  33.     }
  35.     /**
  36.      * @param id 对应数据库表tb_favorite的id字段
  37.      */
  38.     public void setId(Long id) {
  39.         this.id = id;
  40.     }
  42.     /**
  43.      *
  44.      * @return 返回数据库表tb_favorite的product_id字段值
  45.      */
  46.     public Long getProductId() {
  47.         return productId;
  48.     }
  50.     /**
  51.      * @param productId 对应数据库表tb_favorite的product_id字段
  52.      */
  53.     public void setProductId(Long productId) {
  54.         this.productId = productId;
  55.     }
  57.     /**
  58.      *
  59.      * @return 返回数据库表tb_favorite的merchant_id字段值
  60.      */
  61.     public Integer getMerchantId() {
  62.         return merchantId;
  63.     }
  65.     /**
  66.      * @param merchantId 对应数据库表tb_favorite的merchant_id字段
  67.      */
  68.     public void setMerchantId(Integer merchantId) {
  69.         this.merchantId = merchantId;
  70.     }
  72.     /**
  73.      *
  74.      * @return 返回数据库表tb_favorite的status字段值
  75.      */
  76.     public Integer getStatus() {
  77.         return status;
  78.     }
  80.     /**
  81.      * @param status 对应数据库表tb_favorite的status字段
  82.      */
  83.     public void setStatus(Integer status) {
  84.         this.status = status;
  85.     }
  87.     /**
  88.      *
  89.      * @return 返回数据库表tb_favorite的creator字段值
  90.      */
  91.     public String getCreator() {
  92.         return creator;
  93.     }
  95.     /**
  96.      * @param creator 对应数据库表tb_favorite的creator字段
  97.      */
  98.     public void setCreator(String creator) {
  99.         this.creator = creator;
  100.     }
  102.     /**
  103.      *
  104.      * @return 返回数据库表tb_favorite的create_time字段值
  105.      */
  106.     public Date getCreateTime() {
  107.         return createTime;
  108.     }
  110.     /**
  111.      * @param createTime 对应数据库表tb_favorite的create_time字段
  112.      */
  113.     public void setCreateTime(Date createTime) {
  114.         this.createTime = createTime;
  115.     }
  116. }

dao:持久化层接口

  1. package com.xyy.dao;
  3. import org.apache.ibatis.annotations.Mapper;
  5. import com.xyy.model.Favorite;
  7. /**
  8.  * Favorite持久化层接口
  9.  * @ClassName: FavoriteMapper 
  10.  * @author wujing
  11.  * @date 2017-07-13 15:09:50
  12.  */
  13. @Mapper
  14. public interface FavoriteMapper{
  15.     Favorite selectByPrimaryKey(Long id);
  16. }

mapper:持久化层映射文件

  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
  3. <mapper namespace="com.xyy.dao.FavoriteMapper" >
  4.   <resultMap id="BaseResultMap" type="com.xyy.model.Favorite" >
  5.     <id column="id" property="id" jdbcType="BIGINT" />
  6.     <result column="product_id" property="productId" jdbcType="BIGINT" />
  7.     <result column="merchant_id" property="merchantId" jdbcType="INTEGER" />
  8.     <result column="status" property="status" jdbcType="INTEGER" />
  9.     <result column="creator" property="creator" jdbcType="VARCHAR" />
  10.     <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
  11.   </resultMap>
  12.   <sql id="Base_Column_List" >
  13.     id, product_id, merchant_id, status, creator, create_time
  14.   </sql>
  15.   <sql id="Alias_Column_List" >
  16.     f.id, f.product_id, f.merchant_id, f.status, f.creator, f.create_time
  17.   </sql>
  18.   <insert id="insertSelective" parameterType="com.xyy.model.Favorite" useGeneratedKeys="true" keyProperty="id" keyColumn="id" >
  19.     insert into tb_favorite
  20.     <trim prefix="(" suffix=")" suffixOverrides="," >
  21.       <if test="productId != null" >
  22.         product_id,
  23.       </if>
  24.       <if test="merchantId != null" >
  25.         merchant_id,
  26.       </if>
  27.       <if test="status != null" >
  28.         status,
  29.       </if>
  30.       <if test="creator != null" >
  31.         creator,
  32.       </if>
  33.       <if test="createTime != null" >
  34.         create_time,
  35.       </if>
  36.     </trim>
  37.     <trim prefix="values (" suffix=")" suffixOverrides="," >
  38.       <if test="productId != null" >
  39.         #{productId,jdbcType=BIGINT},
  40.       </if>
  41.       <if test="merchantId != null" >
  42.         #{merchantId,jdbcType=INTEGER},
  43.       </if>
  44.       <if test="status != null" >
  45.         #{status,jdbcType=INTEGER},
  46.       </if>
  47.       <if test="creator != null" >
  48.         #{creator,jdbcType=VARCHAR},
  49.       </if>
  50.       <if test="createTime != null" >
  51.         #{createTime,jdbcType=TIMESTAMP},
  52.       </if>
  53.     </trim>
  54.   </insert>
  55.   <delete id="deleteByPrimaryKey" parameterType="java.lang.Long" >
  56.     delete from tb_favorite
  57.     where id = #{id,jdbcType=BIGINT}
  58.   </delete>
  59.   <delete id="batchDeleteByIds" parameterType="java.util.List" >
  60.     delete from tb_favorite
  61.     where id in 
  62.     <foreach item="id" collection="list" open="(" separator="," close=")" >
  63.       #{id}
  64.     </foreach>
  65.   </delete>
  66.   <update id="updateByPrimaryKeySelective" parameterType="com.xyy.model.Favorite" >
  67.     update tb_favorite
  68.     <set >
  69.       <if test="productId != null" >
  70.         product_id = #{productId,jdbcType=BIGINT},
  71.       </if>
  72.       <if test="merchantId != null" >
  73.         merchant_id = #{merchantId,jdbcType=INTEGER},
  74.       </if>
  75.       <if test="status != null" >
  76.         status = #{status,jdbcType=INTEGER},
  77.       </if>
  78.       <if test="creator != null" >
  79.         creator = #{creator,jdbcType=VARCHAR},
  80.       </if>
  81.       <if test="createTime != null" >
  82.         create_time = #{createTime,jdbcType=TIMESTAMP},
  83.       </if>
  84.     </set>
  85.     where id = #{id,jdbcType=BIGINT}
  86.   </update>
  87.   <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.Long" >
  88.     select 
  89.     <include refid="Base_Column_List" />
  90.     from tb_favorite
  91.     where id = #{id,jdbcType=BIGINT}
  92.   </select>
  93.   <select id="selectList" resultMap="BaseResultMap" parameterType="java.util.Map" >
  94.     select 
  95.     <include refid="Base_Column_List" />
  96.     from tb_favorite
  97.     <where >
  98.       <if test="id != null" >
  99.          and id = #{id,jdbcType=BIGINT}
  100.       </if>
  101.       <if test="productId != null" >
  102.          and product_id = #{productId,jdbcType=BIGINT}
  103.       </if>
  104.       <if test="merchantId != null" >
  105.          and merchant_id = #{merchantId,jdbcType=INTEGER}
  106.       </if>
  107.       <if test="status != null" >
  108.          and status = #{status,jdbcType=INTEGER}
  109.       </if>
  110.       <if test="creator != null and creator != ''" >
  111.          and creator = #{creator,jdbcType=VARCHAR}
  112.       </if>
  113.       <if test="createTime != null" >
  114.          and create_time = #{createTime,jdbcType=TIMESTAMP}
  115.       </if>
  116.     </where>
  117.     <if test="property != null and property !=''" >
  118.       order by ${property} ${direction}
  119.     </if>
  120.   </select>
  121.   <select id="selectCount" resultType="java.lang.Integer" parameterType="java.util.Map" >
  122.     select count(1)
  123.     from tb_favorite
  124.     <where >
  125.       <if test="id != null" >
  126.          and id = #{id,jdbcType=BIGINT}
  127.       </if>
  128.       <if test="productId != null" >
  129.          and product_id = #{productId,jdbcType=BIGINT}
  130.       </if>
  131.       <if test="merchantId != null" >
  132.          and merchant_id = #{merchantId,jdbcType=INTEGER}
  133.       </if>
  134.       <if test="status != null" >
  135.          and status = #{status,jdbcType=INTEGER}
  136.       </if>
  137.       <if test="creator != null and creator != ''" >
  138.          and creator = #{creator,jdbcType=VARCHAR}
  139.       </if>
  140.       <if test="createTime != null" >
  141.          and create_time = #{createTime,jdbcType=TIMESTAMP}
  142.       </if>
  143.     </where>
  144.   </select>
  145. </mapper>

service:业务层接口

  1. package com.xyy.service;
  3. import com.xyy.model.Favorite;
  5. /**
  6.  * Favorite业务层接口
  7.  * @ClassName: FavoriteService 
  8.  * @author wujing
  9.  * @date 2017-07-13 15:09:50
  10.  */
  11. public interface FavoriteService{
  12.     Favorite selectByPrimaryKey(Long id);
  13. }

impl:业务层接口实现类

  1. package com.xyy.service.impl;
  3. import org.springframework.beans.factory.annotation.Autowired;
  4. import org.springframework.stereotype.Service;
  5. import org.springframework.transaction.annotation.Transactional;
  7. import com.xyy.dao.FavoriteMapper;
  8. import com.xyy.model.Favorite;
  9. import com.xyy.service.FavoriteService;
  11. /**
  12.  * Favorite业务层实现类
  13.  * @ClassName: FavoriteServiceImpl 
  14.  * @author wujing
  15.  * @date 2017-07-13 15:09:50
  16.  */
  17. @Transactional
  18. @Service("favoriteService")
  19. public class FavoriteServiceImpl implements FavoriteService {
  20.     @Autowired
  21.     private FavoriteMapper favoriteMapper;
  23.     public Favorite selectByPrimaryKey(Long id) {
  24.         return favoriteMapper.selectByPrimaryKey(id);
  25.     }
  26. }

controller:控制层

  1. package com.xyy.controller;
  3. import java.util.HashMap;
  4. import java.util.Map;
  6. import org.slf4j.Logger;
  7. import org.slf4j.LoggerFactory;
  8. import org.springframework.beans.factory.annotation.Autowired;
  9. import org.springframework.ui.ModelMap;
  10. import org.springframework.web.bind.annotation.PathVariable;
  11. import org.springframework.web.bind.annotation.RequestMapping;
  12. import org.springframework.web.bind.annotation.RestController;
  13. import org.springframework.web.servlet.ModelAndView;
  15. import com.xyy.model.Favorite;
  16. import com.xyy.service.FavoriteService;
  18. /**
  19.  * Favorite控制层
  20.  * @ClassName: FavoriteController 
  21.  * @author wujing
  22.  * @date 2017-07-13 15:09:50
  23.  */
  24. @RestController
  25. @RequestMapping("/favorite")
  26. public class FavoriteController{
  27.     private static final Logger LOGGER = LoggerFactory.getLogger(FavoriteController.class);
  29.     @Autowired
  30.     private FavoriteService favoriteService;
  32.     /**
  33.      * Favorite编辑
  34.      * @Title: update
  35.      * @param favorite 修改对象
  36.      * @return Object
  37.      * @author wujing 
  38.      * @date 2017-07-13 15:09:50
  39.      */
  40.     @RequestMapping("/detail/{id}")
  41.     public Object detail(@PathVariable Long id,ModelMap modelMap) {
  42.         Map<String,Object> resultMap = new HashMap<String,Object>();
  43.         try {
  44.             Favorite tempFavorite = favoriteService.selectByPrimaryKey(id);
  45.             resultMap.put("status", "success");
  46.             resultMap.put("data", tempFavorite);
  47.         } catch (Exception e) {
  48.             resultMap.put("status", "error");
  49.             resultMap.put("errorMsg", "系统异常");
  50.             LOGGER.error("Favorite添加异常", e);
  51.         }
  52.         return resultMap;
  53.     }
  54. }

每个代码的具体实现和普通的spring项目代码没有区别,唯一的区别

1:pom.xml文件,需要加入依赖,具体如下:

  1. <dependency>
  2.             <groupId>org.mybatis.spring.boot</groupId>
  3.             <artifactId>mybatis-spring-boot-starter</artifactId>
  4.             <version>1.1.1</version>
  5.         </dependency>
  6. <dependency>
  7.             <groupId>mysql</groupId>
  8.             <artifactId>mysql-connector-java</artifactId>
  9.         </dependency>

mybatis-spring-boot-starter:mybatis与spring boot的依赖包

mysql-connector-java:数据库驱动

2:src/main/resources/application.properties需要加入数据库以及mybatis相关的配置,我比较中意key-value的方式,符合我们之前的习惯,yml的方式,就此忽略掉了,有需要了解的另行百度

注:一下配置根据自行情况更改,如跟着我做的,只需要更改datasource相关即可 

  1. #数据库配置文件
  2. spring.datasource.url=jdbc:mysql://localhost:3306/xyy_v2?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true
  3. spring.datasource.username=admin
  4. spring.datasource.password=admin
  5. spring.datasource.driver-class-name=com.mysql.jdbc.Driver
  6. #mybatis配置文件
  7. mybatis.mapperLocations=classpath:com/xyy/mapper/*Mapper.xml
  8. mybatis.type-aliases-package=com.xyy.model

同样右键运行main主入口,浏览器访问
Center 1

自此第三节结束,第四节:spring boot整合freemark

发表评论

表情：
评论列表 （有 0 条评论，116人围观）

还没有评论，来说两句吧...

相关阅读

    相关 Spring boot整合Mybatis

    时隔两个月的再来写博客的感觉怎么样呢，只能用“棒”来形容了。闲话少说，直接入正题，之前的博客中有说过，将spring与mybatis整个后开发会更爽，基于现在springboo

    谁践踏了优雅谁践踏了优雅/ 0 赞/ 356 阅读

    相关 Spring boot整合Mybatis

    ​ 抽空写个小demo，顺便温习下知识，自从用了Spring boot之后，怎一个爽字了得，开发起来太舒服了，目前Springboot已经成为了开发界的主流框架了，在此就将Sp

    Myth丶恋晨Myth丶恋晨/ 0 赞/ 602 阅读