MyBatis入门项目

首先，新建maven项目，在pom.xml文件中加载以下需要的依赖信息。
本项目使用的MySQL数据库版本为8.0，注意导入的数据库连接的jar包需与MySQL数据库版本对应。

	<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
	<dependency>
	    <groupId>mysql</groupId>
	    <artifactId>mysql-connector-java</artifactId>
	    <version>8.0.21</version>
	</dependency>
	
    <!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
	<dependency>
	    <groupId>org.mybatis</groupId>
	    <artifactId>mybatis</artifactId>
	    <version>3.4.6</version>
	</dependency>

新建MyBatis项目的配置文件，以下是整个的项目结构。
在 mybatis-config.xml 配置文件中主要就是写入数据库的连接信息。
此外，有关于mapper的配置信息，可以放到后面再说。

以下是我的 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>
	<!-- 配置 mybatis 环境 -->
	<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://127.0.0.1:3306/DBTest"/>
					<property name="username" value="root"/>
					<property name="password" value="123456"/>
				</dataSource>
		</environment>
	</environments>
	
	<!-- 注册 UserMapper.xml -->
	<mappers>
		<mapper resource="repository/UserRepository.xml"></mapper>
	</mappers>
	
</configuration>

编写实体类，实体类与数据库中的表相对应。

package entity;

public class User {
	private int id;
	private String email;
	private String pwd;
	private int type;
	private String name;
	
	public User() {}
	public User(String email , String pwd , String name , int type) {
		this.email = email;
		this.pwd = pwd;
		this.name = name;
		this.type = type;
	}
	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getPwd() {
		return pwd;
	}

	public void setPwd(String pwd) {
		this.pwd = pwd;
	}

	public int getType() {
		return type;
	}

	public void setType(int type) {
		this.type = type;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}
	public String toString() {
		return "编号："+this.id+"\t姓名："+this.name+"\t邮箱："+this.email;
	}
}

编写mapper文件，该文件中可以写入需要的sql语句了。
注意这个文件需要在前面的 mybatis-config.xml 配置文件中声明。

<!DOCTYPE mapper
		PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
		"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="repository.UserRepository">
	<insert id="save" parameterType="entity.User">
		insert into user(email,pwd,type,name) values(#{email},#{pwd},#{type},#{name})
	</insert>
	<update id="update" parameterType="entity.User">
		update user set name=#{name}, pwd=#{pwd}, email=#{email} where id=#{id}
	</update>
	<delete id="deleteById" parameterType="Long">
		delete from user where id = #{id}
	</delete>
				<!-- 不写 resultType="java.util.List"，写里面的泛型-->
	<select id="findAll" resultType="entity.User">
		select * from user
	</select>
	<select id="findById" parameterType="Long" resultType="entity.User">
		select * from user where id = #{id}
	</select>
	<!-- 调用存储过程getUserById -->
	<select id="getUserById" parameterType="Integer" resultType="entity.User" statementType="CALLABLE">
		{call getUserById(#{id,mode=IN})}
	</select>
</mapper>

对应上述 UserRepository.xml 文件的接口定义。

package repository;

import entity.User;
import java.util.List;

public interface UserRepository {
	// 定义 CRUD 的各个方法
	public int save(User user);
	public int update(User user);
	public int deleteById(Long id);
	public List<User> findAll();
	public User findById(Long id);
	public User getUserById(int id);
}

编写与实体类相对应的 Userdao类。

package dao;

import java.io.InputStream;
import java.util.List;

import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import entity.User;
import repository.UserRepository;
import test.Test;

public class Userdao {
	
	public List<User> findAllUsers() {
		//加载 mybatis 配置文件 mybatis-config.xml
		InputStream inputStream = Test.class.getClassLoader().getResourceAsStream("mybatis-config.xml");
		//创建 sqlSession 对象
//		SqlSessionFactoryBuilder sqlSessionFactoryBuilder = new SqlSessionFactoryBuilder();
//		SqlSessionFactory build = sqlSessionFactoryBuilder.build(inputStream);
//		SqlSession sqlSession = build.openSession();
		SqlSession sqlSession = new SqlSessionFactoryBuilder().build(inputStream).openSession();
		
		//获取 实现接口的代理对象
		UserRepository mapper = sqlSession.getMapper(UserRepository.class);
		
		//查询全部对象 方法 findAll
		List<User> all = mapper.findAll();
		
		//关闭连接
		sqlSession.close();
		return all;
	}
	public void addNewUser(User user) {
		//加载 mybatis 配置文件 mybatis-config.xml
		InputStream inputStream = Test.class.getClassLoader().getResourceAsStream("mybatis-config.xml");
		//创建 sqlSession 对象
		SqlSession sqlSession = new SqlSessionFactoryBuilder().build(inputStream).openSession();
		
		//获取 实现接口的代理对象
		UserRepository mapper = sqlSession.getMapper(UserRepository.class);
		//添加对象
		mapper.save(new User(user.getEmail(),user.getPwd(),user.getName(),user.getType()));
		//提交事务，如果数据库数据有变化的话
		sqlSession.commit();
		
		//关闭连接
		sqlSession.close();
	}
	public User getUserById(int id) {
		//加载 mybatis 配置文件 mybatis-config.xml
		InputStream inputStream = Test.class.getClassLoader().getResourceAsStream("mybatis-config.xml");
		//创建 sqlSession 对象
		SqlSession sqlSession = new SqlSessionFactoryBuilder().build(inputStream).openSession();
		
		//获取 实现接口的代理对象
		UserRepository mapper = sqlSession.getMapper(UserRepository.class);
		//查询对象
		User user = mapper.getUserById(id);
		
		//关闭连接
		sqlSession.close();
		return user;
	}
}

测试类——主函数如下。

package test;

import java.util.List;

import dao.Userdao;
import entity.User;

public class Test {
	
	public static void main(String[] args) {
		Userdao userdao = new Userdao();
		List<User> users = userdao.findAllUsers();
		for(User user : users)
			System.out.println(user.toString());
		
		System.out.println("-------------------------------------------------");
		
		User user = userdao.getUserById(10);
		System.out.println(user.toString());
	}
}

至此，一个简单的MyBatis项目就完成了。