mybatis-210721-08---动态sql-sql标签抽取可重用的sql

mybatis-210721-08—动态sql-sql标签抽取可重用的sql

• EmployeeMapper.java
• EmployeeMapper.xml(笔记在这儿哦)
• MybatisTest.java

---

EmployeeMapper.java

package com.bgy.mybatis.dao;
import com.bgy.mybatis.bean.Employee;

public interface EmployeeMapper {
	
	public void insertEmps(Employee employee);
}

EmployeeMapper.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.bgy.mybatis.dao.EmployeeMapper">
	
	
	<!-- 
		抽取可重用的sql片段，方便以后引用
		
		1、将经常要查询的列明，或者插入用的列明，抽取出来，方便引用。
		2、include标签用来引用已经抽取的sql
		3、include可以自定义一些property，sql标签就能使用，以下举例
		   使用  ${property}  取值
			<sql id="inserColumn">
				<if test="_databaseId=='mysql'">
					last_name,gender,email,d_id,${realname}
				</if>
				<if test="_databaseId=='oracle'">
					last_name,gender,email,d_id
				</if>
			</sql>
			
			<include refid="inserColumn">
				<property name="realname" value="myname"/>
			</include>
		
		
		sql标签里面同样可以写动态标签
	-->
	<sql id="inserColumn">
		<if test="_databaseId=='mysql'">
			last_name,gender,email,d_id
		</if>
		<if test="_databaseId=='oracle'">
			last_name,gender,email,d_id
		</if>
	</sql>
	
	<insert id="insertEmps">
		insert into
			tbl_employee(
				<!-- include 标签就是引用外部定义的sql -->
				<include refid="inserColumn">
				</include>
			)
		values(#{lastName},#{gender},#{email},#{dept.id})
	</insert>
</mapper>

MybatisTest.java

package com.bgy.mybatis.test;

import java.io.IOException;
import java.io.InputStream;

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.junit.jupiter.api.Test;

import com.bgy.mybatis.bean.Department;
import com.bgy.mybatis.bean.Employee;
import com.bgy.mybatis.dao.EmployeeMapper;

class MybatisTest {
	
	public SqlSessionFactory getSqlSessionFactory() throws IOException {
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		return new SqlSessionFactoryBuilder().build(inputStream);
	}

	
	/**·
	 * 测试sql——sql标签-抽取可充的sql片段
	 * @throws IOException
	 */
	@Test
	public void test() throws IOException{
		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
		SqlSession sqlSession = sqlSessionFactory.openSession();
		
		try {
			EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
			
			mapper.insertEmps(new Employee(null,"yuji","yuji@qq.com","0",new Department(1)));
			
			sqlSession.commit();
		} finally {
			sqlSession.close();
		}
	}
	
}