如何使用mybatis框架

1、导入依赖

准备mybatis-x.x.x.jar，以及数据库驱动包。

2、准备测试用表

在Oracle数据库中创建下面的表并插入数据，SQL:

create table student(
    id number primary key,
    name varchar2(30),
    age number,
    gender varchar2(30)
);
insert into student values(1,'tom',22,'男');
insert into student values(2,'lucy',23,'女');
insert into student values(3,'jack',24,'男');
commit;

创建对应的Java类与其对应：

public class Student {
    private int id;
    private String name;
    private int age;
    private String gender;
    getters/setters...
}

3、准备MyBatis核心配置文件一枚

配置文件无需手动编写，使用模板修改即可：

<?xml version="1.0" encoding="UTF8"?> 
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
	<environments default="oracle_env">
		<environment id="oracle_env">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver" />
				<property name="url" value="jdbc:oracle:thin:@localhost:1521:xe" />
				<property name="username" value="briup" />
				<property name="password" value="briup" />
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
	
	</mappers>

</configuration> 

4、准备一个映射文件，用来保存需要执行的SQL命令

<?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.briup.mybatis.day01.StudentMapper">
	
	
			
	
		
</mapper>

5、准备一个Interface，充当映射接口

public interface StudentMapper {
	
}