一、插入数据
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();
数据库发生改变
事务提交在数据操作之后和资源关闭之前