- Mybatis中文网：https://mybatis.net.cn/
SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROp TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '密码', `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '昵称', `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '邮箱', `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '手机号', `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '头像', `role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址', `age` int NULL DEFAULT NULL COMMENT '年龄', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` VALUES (1, 'admin', 'admin', '管理员', '111124444', '13978786565', '1622537239707', '[1]', '北京', NULL); INSERT INTO `t_user` VALUES (2, 'zhang', '123456', '张三', 'zhang@qq.com', '13089897878', NULL, '[2]', '北京', 24); INSERT INTO `t_user` VALUES (3, 'li', '123456', '李四', 'li@qq.com', '13989897898', NULL, '[2]', '南京', 22); SET FOREIGN_KEY_CHECKS = 1;2.导入依赖
- 在pom.xml中添加以下依赖项（如果没有标签需要自己手动添加一对标签）,注意这里的版本可以在https://mvnrepository.com/官网进行查找替换，导入mybatis在官网的入门当中也有
org.mybatis mybatis 3.5.5 mysql mysql-connector-java 8.0.29 junit junit 4.13.2 test org.slf4j slf4j-api 1.7.20 ch.qos.logback logback-classic 1.2.3 ch.qos.logback logback-core 1.2.3
- 添加日志配置文件,在src/main/resources下创建一个logback.xml文件
3.配置文件[%level] %cyan([%thread]) %boldGreen(%logger{15}) - %msg %n
- 在src/main/resources下创建一个mybatis-config.xml文件，注意修改自己的数据库密码
- 创建sql映射文件：UserMapper.xml，这里的命名规范是表名+Mapper.xml,之前创建表t_user,所以在此使用UserMapper.xml，这里会报红，主要是IDEA没有配置数据库，在社区版好像不能配置，忽略，可以不解决或者用IDEA连接上数据源
-
在src/java目录下创建软件包com.itheima.pojo，然后在pojo目录下创建一个User类
-
回去修改mybatis-config.xml文件，将sql映射文件改为同级目录下的UserMapper.xml文件
-
其他：创建目录如果不能平展将树形那里取消勾选
package com.itheima.pojo;
public class User {
private Integer id;
private String username;
private String password;
private String nickName;
private String email;
private String phone;
private String avatar;
private String role;
private String address;
private Integer age;
public User() {
}
public User(Integer id, String username, String password, String nickName, String email, String phone, String avatar, String role, String address, Integer age) {
this.id = id;
this.username = username;
this.password = password;
this.nickName = nickName;
this.email = email;
this.phone = phone;
this.avatar = avatar;
this.role = role;
this.address = address;
this.age = age;
}
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 getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getNickName() {
return nickName;
}
public void setNickName(String nickName) {
this.nickName = nickName;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAvatar() {
return avatar;
}
public void setAvatar(String avatar) {
this.avatar = avatar;
}
public String getRole() {
return role;
}
public void setRole(String role) {
this.role = role;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public Integer getAge() {
return age;
}
public void setAge(Integer age) {
this.age = age;
}
@Override
public String toString() {
return "User{" +
"id=" + id +
", username='" + username + ''' +
", password='" + password + ''' +
", nickName='" + nickName + ''' +
", email='" + email + ''' +
", phone='" + phone + ''' +
", avatar='" + avatar + ''' +
", role='" + role + ''' +
", address='" + address + ''' +
", age=" + age +
'}';
}
}
2.在itheima下创建测试类MyBatisDemo.java
- copy完以下代码直接运行
package com.itheima;
import com.itheima.pojo.User;
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 java.io.IOException;
import java.io.InputStream;
import java.util.List;
public class MyBatisDemo {
public static void main(String[] args) throws IOException {
//1.加载Mybatis的核心配置文件，获取SqlSessionFactory
String resource = "mybatis-config.xml";
InputStream inputStream = Resources.getResourceAsStream(resource);
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//2.获取对应的SqlSession对象，用它来执行sql
SqlSession sqlSession = sqlSessionFactory.openSession();
//3.执行sql
//查询结果是List集合,参数是名称空间.id
List users = sqlSession.selectList("test.selectAll");
//查询单个对象
// sqlSession.selectOne()
System.out.println(users);
sqlSession.close();
}
}
