以下教程参考黑马程序员的JavaEE企业级应用开发教程
1. 创建数据表
CREATE DATABASE mybatis CHARACTER SET utf8;
USE mybatis;
CREATE TABLE t_customer(
id INT(32) PRIMARY KEY AUTO_INCREMENT,
username VARCHAR(50),
jobs VARCHAR(50),
phone VARCHAR(16)
)
DROP TABLE t_customer;
INSERT INTO t_customer VALUES(1,'joy','doctor','13745874578');
INSERT INTO t_customer VALUES(2,'jack','teacher','1374576413');
INSERT INTO t_customer VALUES(3,'tom','worker','1374940916');
INSERT INTO t_customer VALUES(4,'小米','软件工程师','1355556916');
2. 下载mybatis依赖包
下载地址: https://github.com/mybatis/mybatis-3/releases
3. 导入包
(1)引入MyBatis的核心包和lib目录中的依赖包即可,以及mysql数据库的驱动jar包
(2)在idea中创建一个JavaWeb项目,在WEB-INF导入上面jar包
(3)选中所有jar包,右键选择add as Library
4. 编写log4j.properties文件
在mybatis使用手册8.1.1.2小节中寻找代码
5. 编写客户持久类
package com.itheima.po;
/**
* 客户持久化类
* */
public class Customer {
private Integer id;
private String username;
private String jobs;
private String phone;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getJobs() {
return jobs;
}
public void setJobs(String jobs) {
this.jobs = jobs;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
@Override
public String toString() {
return "Customer [id="+id+",username="+username+",jobs="+jobs+",phone="+phone+"]";
}
}
(1)写完所有属性可以选择所有属性,右键
(2)自动生成setter和getter方法
6. 在src目录下,建立com.itheima.mapper包,并在包中创建映射文件CustomerMapper.xml
7. 在src目录下建立mybatis-config.xml文件
8. src目录下,创建一个com.itheima.test包,创建测试类MybatisTest
9. 运行结果