- 工具
- 1. 建立数据库
- 2. 建立项目结构,导入依赖包
- 3.设置log4j日志文件
- 4.创建数据源
- 5.编写实体类
- 6.编写接口
- 7.编写UserMapper.xml文件
- 8.编写测试类
- IDEA 2021.1.1
- mysql 8.0
- Maven
- 建立数据库
maven依赖
3.设置log4j日志文件4.0.0 org.example itcast-mybatis-plus 1.0-SNAPSHOT 8 8 com.baomidou mybatis-plus 3.5.1 mysql mysql-connector-java 8.0.29 com.alibaba druid 1.2.9 org.projectlombok lombok 1.18.24 junit junit 4.12 org.slf4j slf4j-log4j12 1.6.1 org.apache.maven.plugins maven-compiler-plugin 3.8.0 1.8 1.8
在resources目录下创建log4j.properties
log4j.rootLogger=DEBUG.AL log4j.appender.Al=org.apache.log4j.ConsoleAppender log4j.appender.Al.layout=org.apache.log4j.PatternLayout log4j.appender.Al.layout.ConversionPattern=[%t] [%t]-[%p] %m%n4.创建数据源
在resources目录下创建mybatis-config.xml文件
5.编写实体类
package com.zking.pojo;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data//生成get,set方法
@NoArgsConstructor//生成无参构造
@AllArgsConstructor//生成带参构造
public class User {
private Integer id;
private String name;//姓名
private String password;//密码
private String birthday;//生日
}
6.编写接口
package com.zking.mapper;
import com.zking.pojo.User;
import java.util.List;
public interface Usermapper {
List findAll();
}
7.编写UserMapper.xml文件
8.编写测试类select * from USER
public class MybatisTest {
public static void main(String[] args) throws Exception {
// 配置文件名
String config = "mybatis-config.xml";
InputStream resourceAsStream = Resources.getResourceAsStream(config);
// 创建SqlSessionFactory工厂
SqlSessionFactory build = new SqlSessionFactoryBuilder().build(resourceAsStream);
SqlSession sqlSession = build.openSession();
Usermapper mapper = sqlSession.getMapper(Usermapper.class);
List all = mapper.findAll();
for (User user : all) {
System.out.println(user);
}
}
}



