本文共 2916 字，大约阅读时间需要 9 分钟。

思路：

创建一个Employee数据表

package com.atguigu.mybatis.bean;public class Employee {   		private Integer id;	private String lastName;	private String email;	private String gendar;			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 gendar;	}	public void setGender(String gender) {   		this.gendar = gender;	}	@Override	public String toString() {   		return "Employee [id=" + id + ", lastName=" + lastName + ", email="				+ email + ", gender=" + gendar + "]";	}}

按照思路我们来实现如下代码

1：在conf文件夹中写一个mybatis-config.xml全局配置文件，并在MyBatisTest测试类中创建一个SqlSessionFactory对象

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

2,3：写一个sql映射文件，并且要把该文件注入到全局配置文件（mybatis-config.xml）中

   
   
    	
    		select id,lastName,email,gendar from Employee where id = #{id}	
   

4：在MyBatisTest测试类中写演示代码

package com.atstudying.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.Test;import com.atstudying.mybatis.bean.Employee;import com.atstudying.mybatis.dao.EmployeeMapper;public class MyBatisTest {   		public SqlSessionFactory getSqlSessionFactory() throws IOException {   		String resource = "mybatis-config.xml";		InputStream inputStream = Resources.getResourceAsStream(resource);		return new SqlSessionFactoryBuilder().build(inputStream);	}	@Test	public void test() throws IOException {   		// 2、获取sqlSession实例，能直接执行已经映射的sql语句		// sql的唯一标识：statement Unique identifier matching the statement to use.		// 执行sql要用的参数：parameter A parameter object to pass to the statement.		SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();		SqlSession openSession = sqlSessionFactory.openSession();		try {   			Employee employee = openSession.selectOne(					"com.atguigu.mybatis.dao.EmployeeMapper.getEmpById", 1);			System.out.println(employee);		} finally {   			openSession.close();		}	}}

查询结果