【例题】Mybatis，延迟加载，log4j日志查看

目录

1. 创建表

2. Student类和Classroom类

 3. StudentMapper.xml

 3. ClassroomMapper.xml

 4. 填写select、column

 5. mybatis-config.xml配置日志log4j、开启延迟加载，关闭立即加载

 6. StudentTest.java测试类

 7. 日志如下

---

1. 创建表

创建表student和表classroom（这里我先建了student表，应该先建主表classroom才对，下次注意

USE ssmnew;
#创建Student表
CREATE TABLE Student(
	stuId INT AUTO_INCREMENT PRIMARY KEY,
	grade VARCHAR(10),
	stuName VARCHAR(10)
);
#创建Classroom表
CREATE TABLE Classroom(
	classid INT AUTO_INCREMENT PRIMARY KEY,
	className VARCHAR(10),
	classAddress VARCHAR(20)
);
#给Student表增加classId字段
ALTER TABLE student ADD classId INT;

#为Student表的classId添加外键约束
ALTER TABLE student ADD CONSTRAINT fk_s_c 
FOREIGN KEY(classId) 
REFERENCES classroom(classId);
#给两个表添加数据
INSERT INTO classroom(classid,className,classAddress) VALUES(2,'201','dongBuilding');
INSERT INTO classroom(classid,className,classAddress) VALUES(3,'301','dongBuilding');
INSERT INTO classroom(classid,className,classAddress) VALUES(4,'401','dongBuilding');
INSERT INTO classroom(classid,className,classAddress) VALUES(5,'501','dongBuilding');
INSERT INTO classroom(classid,className,classAddress) VALUES(6,'601','dongBuilding');
INSERT INTO student(grade,stuName,classId) VALUES('g2','wer33',2);
INSERT INTO student(grade,stuName,classId) VALUES('g2','sdfed',2);

2. Student类和Classroom类

由于1对1查询，所以要为Student类添加Classroom classroom属性，然后配置resultMap的association属性

 

 3. StudentMapper.xml

1. 注意association要填4 个属性，property为Student的classroom属性名，javaType为classroom的类型，select和column先空着

 3. ClassroomMapper.xml

 4. 填写select、column

 5. mybatis-config.xml配置日志log4j、开启延迟加载，关闭立即加载

log4j.rootLogger=DEBUG,stdout
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

 

 6. StudentTest.java测试类

 7. 日志如下