如何在IDEA里通过MyBatis实现数据库的读写

一、简单版

1.在数据库中创建一张测试表

USE mybatis;

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

INSERT INTO tbl_employee(id,last_name,gender,email) VALUES('2','tom','0','tom@atguigu.com');

2.工程中创建对应的javaBean对象

package com.atguigu.mybatis.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 + "]";
	}
	
	

}

3.创建mybatis配置文件，sql映射文件

mybatis_config: