Spring篇--08 MyBatis的增删改查操作-CSDN博客

本文链接：https://blog.csdn.net/Mind_programmonkey/article/details/80141182

Spring篇--08 MyBatis的增删改查操作

一、MyBatis

1.mybatis

开源的持久层框架。

jdbc：代码繁琐，sql性能好

hibernate：代码简洁，不用写sql

2.mybatis的使用

step1：导包：

mybatis、mysql-connector、junit

pom.xml文件中：

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.lcz</groupId>
  <artifactId>mybatis_day01</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <dependencies>
  	<dependency>
	  <groupId>org.mybatis</groupId>
	  <artifactId>mybatis</artifactId>
	  <version>3.2.8</version>
	</dependency>
	<dependency>
   	 <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <version>5.1.25</version>
	</dependency> 
	<dependency>
	 	<groupId>junit</groupId>
	 	<artifactId>junit</artifactId>
	 	<version>3.8.1</version>
	 </dependency>
  </dependencies>
</project>

step2：添加mybatis配置文件

在src/main/resources中添加SqlMapConfig.xml文件中

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE configuration PUBLIC "-//ibatis.apache.org//DTD Config 3.0//EN" 
	"http://ibatis.apache.org/dtd/ibatis-3-config.dtd">
<configuration>
	<environments default="environment">
		<environment id="environment">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/netctoss" />
				<property name="username" value="root" />
				<property name="password" value="root" />
			</dataSource>
		</environment>
	</environments>
	<!-- 映射文件的位置 -->
	<mappers>
		<mapper resource="entity/EmpMapper.xml" />
	</mappers>
</configuration>

step3：写实体类

注意：实体类的属性名与表的字段表要求一样，大小写无所谓

在src/main/java中添加entity包建立Emp.java实体类文件

package entity;

public class Emp {
	private Integer id;
	private String name;
	private Integer age;
	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 Integer getAge() {
		return age;
	}
	public void setAge(Integer age) {
		this.age = age;
	}
	@Override
	public String toString() {
		return "Emp [id=" + id + ", name=" + name + ", age=" + age + "]";
	}
	
}

step4：写映射文件

注：修改配置文件，指定映射文件的位置

在entity包下建立EmpMapper.xml映射文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"      
 "http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="test">
	<insert id="save" parameterType="entity.Emp">
		insert into emp(name,age) values(#{name},#{age})
	</insert>
	<!-- id:要求唯一；resultType：返回的数据的类型  parameterType：参数类型 -->
	<select id="findAll" resultType="entity.Emp">
		select *from emp
	</select>
	<select id="findById" parameterType="int" resultType="entity.Emp">
		select *from emp where id=#{id1}
	</select>
	<update id="modify" parameterType="entity.Emp">
		update emp set name=#{name},age=#{age} where id=#{id}
	</update>
	<delete id="delete" parameterType="int">
		delete from emp where id=#{id1}
	</delete>
	<!-- 返回Map类型的结果 map是java.util.Map的简写形式 -->
	<select id="findById2" parameterType="int" resultType="map">
		select *from emp where id=#{id1}
	</select>
	<!-- 使用ResultMap解决表的字段名与实体类的属性名不一致的情况 -->
	<select id="findById3" parameterType="int" resultMap="emp2">
		select *from emp where id=#{id1}
	</select>
	<!-- 处理表的字段名与实体类的属性名的对应关系的
	注：把不一样的列出来即可 -->
	<resultMap type="entity.Emp2" id="emp2">
		<result property="ename" column="name"/>
		<result property="empNo" column="id"/>
	</resultMap>
</mapper>

step5：调用SqlSession提供的方法来访问数据库

在src/test/java下利用JUnit来测试

package test;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.jdbc.SQL;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.Before;
import org.junit.Test;

import entity.Emp;
import entity.Emp2;

public class TestCase {
	private SqlSession session;
	@Before
	public void init() {
		SqlSessionFactoryBuilder sessionFactory=new SqlSessionFactoryBuilder();
		SqlSessionFactory sqlSessionFactory=sessionFactory.build(TestCase.class.getClassLoader().getResourceAsStream("SqlMapConfig.xml"));
		session = sqlSessionFactory.openSession();
	}
	@Test
	public void test1() {
		Emp emp = new Emp();
		emp.setName("Maris");
		emp.setAge(22);
		session.insert("test.save",emp);
		session.commit();
		session.close();
	}
	@Test
	public void test2() {
		List<Emp> emps = session.selectList("test.findAll");
		System.out.println(emps);
		session.close();
	}
	@Test
	public void test3() {
		Emp emp = session.selectOne("test.findById",2);
		System.out.println(emp);
		session.close();
	}
	@Test
	public void test4() {
		Emp emp = session.selectOne("test.findById",2);
		emp.setAge(emp.getAge()+10);
		session.update("test.modify",emp);
		session.commit();
		session.close();
	}
	@Test
	public void test5() {
		session.delete("test.delete",4);
		session.commit();
		session.close();
	}
	@Test
	public void test6() {
		Map data = session.selectOne("test.findById2",2);
		System.out.println(data);
		System.out.println(data.get("name"));
		session.close();
	}
	@Test
	public void test7() {
		Emp2 emp = session.selectOne("test.findById3",2);
		System.out.println(emp);
		session.close();
	}
}

3.基本原理（了解）