快速學習-MyBatis入門

• 2020 年 2 月 17 日
• 筆記

第2章 MyBatis HelloWorld

2.1 開發環境的準備

1. 導入MyBatis框架的jar包、Mysql驅動包、log4j的jar包

myBatis-3.4.1.jar  mysql-connector-java-5.1.37-bin.jar  log4j.jar

1. 導入log4j 的配置文件

<?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>

2.2 創建測試表

-- 創建庫  CREATE DATABASE test_mybatis;  -- 使用庫  USE test_mybatis;  -- 創建表  CREATE TABLE tbl_employee(     id INT(11) PRIMARY KEY AUTO_INCREMENT,     last_name VARCHAR(50),     email VARCHAR(50),     gender CHAR(1)  );

2.3 創建javaBean

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 + "]";  	}

2.3 創建MyBatis的全局配置文件

1. 參考MyBatis的官網手冊

<?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.jdbc.Driver" />  				<property name="url" value="jdbc:mysql://localhost:3306/mybatis_1129" />  				<property name="username" value="root" />  				<property name="password" value="1234" />  			</dataSource>  		</environment>  	</environments>  	<!-- 引入SQL映射文件,Mapper映射文件 	-->  	<mappers>  		<mapper resource="EmployeeMapper.xml" />  	</mappers>  </configuration>

2.4 創建Mybatis的sql映射文件

1. 參考MyBatis的官方手冊

<?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="suibian">  	<select id="selectEmployee" resultType="com.atguigu.myabtis.helloWorld.Employee">  		select id ,last_name lastName ,email ,gender from tbl_employee where id = #{id}  		<!-- select * from tbl_employee  where id = #{id} -->  	</select>  </mapper>

2.5 測試

1. 參考MyBatis的官方手冊

	@Test  	public void test() throws Exception {  		String resource = "mybatis-config.xml";  		InputStream inputStream = Resources.getResourceAsStream(resource);  		SqlSessionFactory sqlSessionFactory =  					new SqlSessionFactoryBuilder().build(inputStream);  		System.out.println(sqlSessionFactory);    		SqlSession session  = sqlSessionFactory.openSession();  		try {  			Employee employee =  					session.selectOne("suibian.selectEmployee", 1001);  			System.out.println(employee);  		} finally {  			session.close();  		}  	}

2.6 Mapper接口開發MyBatis HelloWorld

1. 編寫Mapper接口

public interface EmployeeMapper {    	public Employee getEmployeeById(Integer id );    }

1. 完成兩個綁定

• ①Mapper接口與Mapper映射文件的綁定在Mppper映射文件中的標籤中的namespace中必須指定Mapper接口的全類名
• ②Mapper映射文件中的增刪改查標籤的id必須指定成Mapper接口中的方法名.

1. 獲取Mapper接口的代理實現類對象

	@Test  	public void test()  throws Exception{  		String resource = "mybatis-config.xml";  		InputStream inputStream =                   Resources.getResourceAsStream(resource);  		SqlSessionFactory sqlSessionFactory =  				new SqlSessionFactoryBuilder()                .build(inputStream);  		SqlSession session =                           sqlSessionFactory.openSession();    		try {  			//Mapper接口:獲取Mapper接口的 代理實現類對象  			EmployeeMapper mapper =                   session.getMapper(EmployeeMapper.class);  			Employee employee =                    mapper.getEmployeeById(1006);  			System.out.println(employee);  		} finally {  			session.close();  		}  	}