mybatis——增删改

一、插入数据

1.源码

mapper.xml

<?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.company.mapper.FlowerMapper3">
    <!--添加操作
    int insert(Flower flower);
    返回值省略,没有返回值-->
    <insert id="insert" parameterType="flower">
        insert into flower values (default,#{name},#{price},#{production})
    </insert>

    <select id="selectAll" resultType="flower">
        select * from flower
    </select>
</mapper>

test.java

package com.company.test;

import com.company.entity.Flower;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.omg.CORBA.UserException;

import java.io.IOException;
import java.io.InputStream;
import java.nio.channels.FileLock;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class testC {
    public static void main(String[] args) throws IOException {

        //解析mybatis.xml文件
        InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");

        //获得session工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

        //获得session对象
        SqlSession session = factory.openSession();

        //调用方法
        Flower flower = new Flower();
        flower.setName("四季春");
        flower.setPrice(5);
        flower.setProduction("中国");
        session.insert("com.company.mapper.FlowerMapper3.insert",flower);

        List<Flower> list = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list){
            System.out.println(flower1);
        }
        //关闭资源
        session.close();
    }
}

2.结果

在这里插入图片描述

二、删除数据

1.源码

mapper.xml

<?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.company.mapper.FlowerMapper3">
    <!--添加操作
    int insert(Flower flower);
    返回值省略,没有返回值-->
    <insert id="insert" parameterType="flower">
        insert into flower values (default,#{name},#{price},#{production})
    </insert>

    <select id="selectAll" resultType="flower">
        select * from flower
    </select>

    <delete id="delete" >
        delete from flower where id = 2
    </delete>
</mapper>

test.java

package com.company.test;

import com.company.entity.Flower;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.omg.CORBA.UserException;

import java.io.IOException;
import java.io.InputStream;
import java.nio.channels.FileLock;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class testC {
    public static void main(String[] args) throws IOException {

        //解析mybatis.xml文件
        InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");

        //获得session工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

        //获得session对象
        SqlSession session = factory.openSession();

        //调用方法
        System.out.println("---------------------插入操作------------------------");
        Flower flower = new Flower();
        flower.setName("四季春");
        flower.setPrice(5);
        flower.setProduction("中国");
        session.insert("com.company.mapper.FlowerMapper3.insert",flower);

        List<Flower> list = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list){
            System.out.println(flower1);
        }

        System.out.println("---------------------删除操作------------------------");
        session.delete("com.company.mapper.FlowerMapper3.delete");

        List<Flower> list2 = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list2){
            System.out.println(flower1);
        }
        //关闭资源
        session.close();
    }
}

2.结果

在这里插入图片描述

三、修改数据

1.源码

mapper.xml

<?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.company.mapper.FlowerMapper3">
    <!--添加操作
    int insert(Flower flower);
    返回值省略,没有返回值-->
    <insert id="insert" parameterType="flower">
        insert into flower values (default,#{name},#{price},#{production})
    </insert>

    <select id="selectAll" resultType="flower">
        select * from flower
    </select>

    <delete id="delete" >
        delete from flower where id = 2
    </delete>

    <update id="update" parameterType="flower">
        update flower set name = "菊花" where id = 1
    </update>
</mapper>

test.java

package com.company.test;

import com.company.entity.Flower;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.omg.CORBA.UserException;

import java.io.IOException;
import java.io.InputStream;
import java.nio.channels.FileLock;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class testC {
    public static void main(String[] args) throws IOException {

        //解析mybatis.xml文件
        InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");

        //获得session工厂
        SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(inputStream);

        //获得session对象
        SqlSession session = factory.openSession();

        //调用方法
        System.out.println("---------------------插入操作------------------------");
        Flower flower = new Flower();
        flower.setName("四季春");
        flower.setPrice(5);
        flower.setProduction("中国");
        session.insert("com.company.mapper.FlowerMapper3.insert",flower);

        List<Flower> list = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list){
            System.out.println(flower1);
        }

        System.out.println("---------------------删除操作------------------------");
        session.delete("com.company.mapper.FlowerMapper3.delete");

        List<Flower> list2 = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list2){
            System.out.println(flower1);
        }

        System.out.println("---------------------修改操作------------------------");
        session.update("com.company.mapper.FlowerMapper3.update");

        List<Flower> list3 = session.selectList("com.company.mapper.FlowerMapper3.selectAll");
        for(Flower flower1:list3){
            System.out.println(flower1);
        }

        //关闭资源
        session.close();
    }
}

2.结果

在这里插入图片描述
但是在idea中进行数据库的操作之后进行数据库查询可以看到数据库已经发生变化,但是通过可视化工具数据库会发现数据库并没有发生变化,因为mybatis默认是不提交事务的,数据存储在内存中,当事务提交之后,数据才会存储到真正的数据库中

在这里插入图片描述
像要将数据保存在数据库硬盘中,需要进行事务提交

//进行事务提交
        session.commit();

数据库发生改变
事务提交在数据操作之后和资源关闭之前
在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值