1.数据库表格
pom.xml
4.0.0 org.example mybatis021.0-SNAPSHOT org.mybatis mybatis3.4.6 mysql mysql-connector-java8.0.28 org.projectlombok lombok1.18.24 junit junit4.12 test log4j log4j1.2.17
mybatis.xml
log4j.properties添加日志
log4j.rootLogger=DEBUG, Console #Console log4j.appender.Console=org.apache.log4j.ConsoleAppender log4j.appender.Console.layout=org.apache.log4j.PatternLayout log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n log4j.logger.java.sql.ResultSet=INFO log4j.logger.org.apache=INFO log4j.logger.java.sql.Connection=DEBUG log4j.logger.java.sql.Statement=DEBUG log4j.logger.java.sql.PreparedStatement=DEBUG
com.zsb.entity.student学生
Student 学生
package com.zsb.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Student {
private int id;
private String name;
private String age;
private String sex;
private Integer classId;
private Clazz clazz;
}
Clazz 教室
package com.zsb.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Clazz {
private Integer cid;
private String cname;
}
com.zsb.don
StudentDao
package com.zsb.dao;
import com.zsb.entity.Student;
public interface StudentDao {
public Student findStudentById(int id);
}
resources.mapper
StudentMapper.xml
select * from t_student s join c_class c on s.class_id=c.cid where stu_id=#{id}
测试
com.zsb.test
Test
package com.zsb.test;
import com.zsb.dao.StudentDao;
import com.zsb.entity.Student;
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 org.junit.Test;
import java.io.Reader;
public class Test03 {
@Test
public void testFindStudentById() throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
StudentDao studentDao = session.getMapper(StudentDao.class);
Student student = studentDao.findStudentById(1);
System.out.println(student);
session.commit();
session.close();
}
}



