MyBatis实现增删改查功能（总）

Shen-Childe

已于 2022-08-03 12:12:44 修改

阅读量318

点赞数

分类专栏： SSM 文章标签： mybatis java mysql

于 2022-08-01 17:19:18 首次发布

本文链接：https://blog.csdn.net/s17856147699/article/details/126089698

版权

SSM 专栏收录该内容

25 篇文章 0 订阅

订阅专栏

文章目录

MyBatis实现增删改查功能（总）

MyBatis实现增删改查功能（总）

单增加，且获取自增的主键
批量增加
单删除
批量删除
单修改
单查询
全部查询
一到八（MyBatis工程配置）

一、创建数据库、表、数据

CREATE DATABASE 

USE `ssm`;

DROP TABLE IF EXISTS `t_supermarket`;

CREATE TABLE `t_supermarket` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '商品id',
  `name` varchar(50) COMMENT '商品名称',
  `price` double  COMMENT '商品价格',
  `address` varchar(100) COMMENT '商品产地',
  `quality_guarantee_period` varchar(30) COMMENT '商品的保质期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

insert  into `t_supermarket`(`id`,`name`,`price`,`address`,`quality_guarantee_period`) values 
(1,'可乐',3,'合肥','6个月'),
(2,'雪碧',3,'合肥','6个月'),
(3,'巧克力',8,'南京','10个月'),
(4,'曲奇饼干',16,'北京','12个月'),
(5,'卫龙辣条',3,'上海','6个月'),
(6,'康师傅葱香排骨面',5,'上海','6个月'),
(7,'大鸡腿',8,'杭州','10个月'),
(8,'卤蛋',2,'深圳','6个月'),
(9,'泡椒凤爪',2,'合肥','6个月'),
(10,'火腿肠',1.5,'合肥','6个月');

在这里插入图片描述

二、MyBatis的Maven项目创建

在这里插入图片描述

三、MyBatis的Maven模块创建

在这里插入图片描述

四、配置jar包pom.xml

    <dependencies>
        <dependency>
            <!--junit测试-->
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.13.2</version>
        </dependency>
        <!--mysql-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.29</version>
        </dependency>
        <!--mybatis-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.10</version>
        </dependency>
    </dependencies>

五、MyBatis的项目结构

在这里插入图片描述

六、创建 jdbc.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssm?&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=111111

七、创建 mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>

    <!--
        MYBatis核心配置文件中的标签必须要按照指定的顺序去配置
        properties?,settings?,typeAliases?,typeHandlers?,
        objectFactory?,objectWrapperFactory?,reflectorFactory?,plugins?,
        environments?,databaseIdProvider?,mappers?
    -->

    <!--引入 properties 文件-->
    <properties resource="jdbc.properties"/>

    <!--全局设置-->
    <settings>
        <!--日志-->
        <setting name="logImpl" value="STDOUT_LOGGING"/>
        <!--将下划线映射为驼峰-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!--开启延迟加载-->
        <setting name="lazyLoadingEnabled" value="true"/>
        <!--按需加载，它要与延迟加载配合的，默认就是false，可以不写这段代码，但是最好写上-->
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>

    <!--设置类型别名-->
    <typeAliases>
        <!--通过包来设置类型别名，指定包下所有的类型，将全部拥有默认的别名-->
        <package name="com.sgz.mybatis.pojo"/>
    </typeAliases>

    <!--连接数据库-->
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url"
                          value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <!--引入mybatis的映射文件-->
    <mappers>
        <package name="com.sgz.mybatis.mapper"/>
    </mappers>

</configuration>

八、创建utils包 SqlSession工具类

public class SqlSessionUtil {

    public static SqlSession getSqlSession() {
        SqlSession sqlSession = null;
        try {
            InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
            SqlSessionFactoryBuilder builder = new SqlSessionFactoryBuilder();
            SqlSessionFactory build = builder.build(inputStream);
            sqlSession = build.openSession(true);
        } catch (IOException e) {
            e.printStackTrace();
        }
        return sqlSession;
    }
}

九、创建pojo包的Supermarket类

public class Supermarket {

    private Integer id;
    private String name;
    private Double price;
    private String address;
    private String quality_guarantee_period;

    public Supermarket() {
    }

    public Supermarket(Integer id, String name, Double price, String address, String quality_guarantee_period) {
        this.id = id;
        this.name = name;
        this.price = price;
        this.address = address;
        this.quality_guarantee_period = quality_guarantee_period;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Double getPrice() {
        return price;
    }

    public void setPrice(Double price) {
        this.price = price;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    public String getQuality_guarantee_period() {
        return quality_guarantee_period;
    }

    public void setQuality_guarantee_period(String quality_guarantee_period) {
        this.quality_guarantee_period = quality_guarantee_period;
    }

    @Override
    public String toString() {
        return "Supermarket{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", price=" + price +
                ", address='" + address + '\'' +
                ", quality_guarantee_period='" + quality_guarantee_period + '\'' +
                '}';
    }
}

十、创建mapper包接口方法 SupermarketMapper

public interface SupermarketMapper {

    /**
     * 通过实体类，并获取自增的主键，添加商品（单）
     *
     * @param supermarket
     */
    void insertGoods(Supermarket supermarket);

    /**
     * 通过id，删除商品（单）
     *
     * @param id
     */
    void deleteGoods(@Param("id") Integer id);


    /**
     * 通过实体类，修改商品（单）
     * @param supermarket
     */
   void updateGoods(Supermarket supermarket);

    /**
     * 通过id查询商品（单）
     * @param id
     * @return
     */
    Supermarket selectGoodsById(@Param("id") Integer id);

    /**
     * 查询全部商品（全部）
     * @return
     */
    List<Supermarket> selectAllGoods();

    /**
     * 批量删除商品（批量）
     * @param ids
     */
    void deleteMoreGoods(@Param("ids") Integer[] ids);

    /**
     * 批量添加商品（批量）
     * @param supermarketList
     */
    void insertMoreGoods(@Param("lists") List<Supermarket> supermarketList);

}

十一、创建mapper资源映射文件 SupermarketMapper

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--对应接口的全类名-->
<mapper namespace="com.sgz.mybatis.mapper.SupermarketMapper">

    <!--void insertGoods(Supermarket supermarket);-->
    <insert id="insertGoods" useGeneratedKeys="true" keyProperty="id">
        insert into t_supermarket
        values (null, #{name}, #{price}, #{address}, #{qualityGuaranteePeriod});
    </insert>

    <!--void deleteGoods(@Param("id") Integer id);-->
    <delete id="deleteGoods">
        delete
        from t_supermarket
        where id = ${id};
    </delete>

    <!-- void updateGoods(Supermarket supermarket);-->
    <update id="updateGoods">
        update t_supermarket
        set name                     = #{name},
            price                    = #{price},
            address                  = #{address},
            quality_guarantee_period = #{qualityGuaranteePeriod}
        where id = #{id}
    </update>

    <!--Supermarket selectGoodsById(@Param("id") Integer id);-->
    <select id="selectGoodsById" resultType="Supermarket">
        select *
        from t_supermarket
        where id = #{id}
    </select>

    <!--List<Supermarket> selectAllGoods();-->
    <select id="selectAllGoods" resultType="Supermarket">
        select *
        from t_supermarket
    </select>

    <!-- void deleteMoreGoods(@Param("ids") Integer[] ids);-->
    <delete id="deleteMoreGoods">
        delete from t_supermarket where id in(
        <foreach collection="ids" item="id" separator=",">
            #{id}
        </foreach>
        )
    </delete>

    <!--void insertMoreGoods(List<Supermarket> supermarketList);-->
    <insert id="insertMoreGoods">
        insert into t_supermarket
        values
        <foreach collection="lists" item="sup" separator=",">
            (null, #{sup.name}, #{sup.price}, #{sup.address}, #{sup.qualityGuaranteePeriod})
        </foreach>
    </insert>

</mapper>

十二、创建测试类

public class TestMybatis {

    /**
     * 通过实体类，并获取自增的主键，添加商品（单）
     */
    @Test
    public void testInsertGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        Supermarket supermarket = new Supermarket(null, "麻辣鸭脖", (double) 5, "合肥", "1个月");
        mapper.insertGoods(supermarket);
        System.out.println(supermarket);
    }

    /**
     * 通过id，删除商品（单）
     */
    @Test
    public void testDeleteGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        mapper.deleteGoods(15);
    }

    /**
     * 通过name，设置实体类，修改商品（单）
     */
    @Test
    public void testUpdateGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        Supermarket supermarket = new Supermarket(1, "可乐", 3.0, "合肥", "1个月");
        mapper.updateGoods(supermarket);
    }

    /**
     * 通过id查询商品（单）
     */
    @Test
    public void testSelectGoodsById() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        Supermarket supermarket = mapper.selectGoodsById(2);
        System.out.println(supermarket);
    }

    /**
     * 查询全部商品（全部）
     */
    @Test
    public void testSelectAllGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        List<Supermarket> supermarkets = mapper.selectAllGoods();
        supermarkets.forEach(System.out::println);
    }

    /**
     * 批量删除（批量）
     */
    @Test
    public void testDeleteMoreGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        Integer[] integers = new Integer[]{4, 5, 6, 8};
        mapper.deleteMoreGoods(integers);
    }

    /**
     * 批量添加（批量）
     */
    @Test
    public void testInsertMoreGoods() {
        SqlSession sqlSession = SqlSessionUtil.getSqlSession();
        SupermarketMapper mapper = sqlSession.getMapper(SupermarketMapper.class);
        Supermarket supermarket1 = new Supermarket(null,"康师傅葱香排骨面",5.0,"合肥","6个月");
        Supermarket supermarket2 = new Supermarket(null,"牛肉",10.0,"合肥","6个月");
        Supermarket supermarket3 = new Supermarket(null,"豆干",2.0,"合肥","6个月");
        Supermarket supermarket4 = new Supermarket(null,"香肠",5.0,"合肥","6个月");
        List<Supermarket> supermarkets = Arrays.asList(supermarket1, supermarket2, supermarket3, supermarket4);
        mapper.insertMoreGoods(supermarkets);
    }
    
}