mybatis-210716-01---入门---hello

mybatis-210716-01—入门—hello

• 准备数据库
• 创建Java工程以及对象，需要的资源
• 我的工程目录
• Employee.java
• mybatis-config.xml
• log4j.xml
• EmployeeMapper.xml
• MyBatisTest.java

---

mybatis文档-入门，官网网址：
	https://mybatis.org/mybatis-3/zh/getting-started.html

准备数据库

tbl_employee

CREATE TABLE tbl_employee(
	id INT(11) PRIMARY KEY AUTO_INCREMENT,
	last_name VARCHAR(255),
	gender CHAR(1),
	email VARCHAR(255)
)

---

创建Java工程以及对象，需要的资源

---

我的工程目录

---

Employee.java

package com.bgy.bean;

public class Employee {
	
	private Integer id;
	private String lastName;
	private String email;
	private String gender;
	
	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getLastName() {
		return lastName;
	}
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public String getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	@Override
	public String toString() {
		return "Employee [id=" + id + ", lastName=" + lastName + ", email=" + email + ", gender=" + gender + "]";
	}
}

---

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>
	 <environments default="development">
		 <environment id="development">
		 <transactionManager type="JDBC"/>
		 <dataSource type="POOLED">
			 <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
			 <property name="url" value="jdbc:mysql://localhost:3306/mybatis_test_210716_01?serverTimezone=UTC&amp;useSSL=false"/>
			 <property name="username" value="root"/>
			 <property name="password" value="admin"/>
		 </dataSource>
		 </environment>
	 </environments>
	 
	 <!--
	 	将我们写好的sql映射文件（EmployeeMapper.xml）注册到全局配置文件（mybatis-config.xml）中 
	 -->
	 <mappers>
	 	<mapper resource="EmployeeMapper.xml"/>
	 </mappers>
</configuration>

---

log4j.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
 
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/">
 <appender name="STDOUT" class="org.apache.log4j.ConsoleAppender">
   <param name="Encoding" value="UTF-8" />
   <layout class="org.apache.log4j.PatternLayout">
    <param name="ConversionPattern" value="%-5p %d{MM-dd HH:mm:ss,SSS} %m  (%F:%L) \n" />
   </layout>
 </appender>
 <logger name="java.sql">
   <level value="debug" />
 </logger>
 <logger name="org.apache.ibatis">
   <level value="info" />
 </logger>
 <root>
   <level value="debug" />
   <appender-ref ref="STDOUT" />
 </root>
</log4j:configuration>

---

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">
<!-- 
	namespace：名称空间
-->
<mapper namespace="com.bgy.EmployeeMapper">

	<!-- 
		id：唯一标识
		resultType：返回值对象
		#{id}：从传递过来的参数中取出id值
	-->
	<!--
		数据库中tbl_employee中字段是		id，last_name,gender,email
		而JavaBean中的Employee.java是	id,lastName，gender，email
		所以要起别名。
	-->
  <select id="selectEmployee" resultType="com.bgy.bean.Employee">
    select 
    	id,last_name as lastName,gender,email
    from 
    	tbl_employee 
    where 
    	id = #{id}
  </select>
</mapper>

---

MyBatisTest.java

package com.bgy.bean.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.bean.Employee;

class MyBatisTest {

	/**
	 * 1. 根据xml位置文件（全局配置文件）创建一个SQLSessionFactory对象
	 * 	 让数据源有运行环境信息
	 * 2. sql映射文件；配置了每一个sql，以及sql的封装规则等
	 * 3. sql映射文件注册到全局配置文件中
	 * 4. 写代码
	 * 	 	1）根据全局配置文件得到SqlSessionFactory
	 * 		2）使用sqlSession工厂，获取到sqlSession对象，使用它来执行增删改查。
	 * 		      一个sqlSession就是代表和数据库的一次会话，用完关闭。
	 * 		3）使用sql的唯一标识来告诉mybatis执行那个sql。sql都是保存在sql映射文件中。
	 * @throws IOException
	 */
	@Test
	void test() throws IOException {
        
		String resource = "mybatis-config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		
		// 2. 获取sqlSession实例，能直接执行已经映射的sql语句。
		SqlSession session = sqlSessionFactory.openSession();
		try {
			// session.selectOne(statement, parameter)
			// statement	sql的唯一标识，使用  名称空间+唯一标识  的形式 
			// parameter	执行sql要用的参数
			Employee employee =(Employee) session.selectOne("com.bgy.EmployeeMapper.selectEmployee", 1);
			System.out.println(employee);
		} finally {
			session.close();
		}
	}

}