嘻哈飞车族|SpringBoot:数据库访问之Mybatis


嘻哈飞车族|SpringBoot:数据库访问之Mybatis点击关注 , 后期更多精彩内容呈上!
在SpringBoot中使用mybatis非常简单 , 我们只需要引入依赖即可 。
1 创建SpringBoot项目并引入依赖
【嘻哈飞车族|SpringBoot:数据库访问之Mybatis】org.springframework.bootspring-boot-starter-weborg.mybatis.spring.bootmybatis-spring-boot-starter1.3.2mysqlmysql-connector-java5.1.472 创建数据库表及对应的实体类
# 创建表CREATE TABLE `t_demo` (`id` INT(11) NOT NULL AUTO_INCREMENT,`name` VARCHAR(50) NOT NULL,`telphone` VARCHAR(15) NOT NULL,PRIMARY KEY (`id`)) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8public class DemoEntity {private Integer id;private String name;private String telphone;@Overridepublic String toString() {return "DemoEntity[id="+this.id+", name="+this.name+", telphone="+this.telphone+"]";}//省略 getset 方法}3 定义mapper接口及创建对应的xml文件
package com.xw.base.manager.mapper;import com.xw.base.manager.entity.DemoEntity;public interface DemoMapper {DemoEntity selectById(Integer id);int save(DemoEntity entity);void updateDemo(DemoEntity entity);int deleteById(Integer id);}insert into t_demo (id, name, telphone)values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}, #{telphone,jdbcType=VARCHAR})SELECT * FROM t_demo WHERE id = #{id,jdbcType=INTEGER}delete FROM t_demo WHERE id = #{id,jdbcType=INTEGER}update t_demoset name = #{name}, telphone = #{telphone}where id = #{id}4 定义服务接口及对应的实现
public interface DemoService {DemoEntity selectById(Integer id);int save(DemoEntity entity);void updateDemoEntity(DemoEntity entity);int deleteById(Integer id);}@Servicepublic class DemoServiceImpl implements DemoService {@Autowiredprivate DemoMapper demoMapper;@Overridepublic DemoEntity selectById(Integer id) {return demoMapper.selectById(id);}@Overridepublic int save(DemoEntity entity) {return demoMapper.save(entity);}@Overridepublic void updateDemoEntity(DemoEntity entity) {demoMapper.updateDemo(entity);}@Overridepublic int deleteById(Integer id) {return demoMapper.deleteById(id);}}


推荐阅读