Mybatis复杂查询环境搭建

创建Student Teacher两张表

CREATE TABLE `teacher`(
`id` INT(10) NOT NULL,
`name` VARCHAR(30) DEFAULT NULL,
PRIMARY KEY(`id`)
)ENGINE=INNODB DEFAULT CHARSET=utf8

INSERT INTO teacher(`id`,`name`) VALUES(1,'王老师');

CREATE TABLE `student`(
`id` INT(10) NOT NULL,
`name` VARCHAR(20) DEFAULT NULL,
`tid` INT(30) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `fktid` (`tid`),
CONSTRAINT `fktid` FOREIGN KEY (`tid`) REFERENCES `teacher`(`id`)
) ENGINE =INNODB DEFAULT CHARSET=utf8

INSERT INTO `student`(`id`,`name`,`tid`) VALUES(1,'张三',1);
INSERT INTO `student`(`id`,`name`,`tid`) VALUES(2,'李四',1);
INSERT INTO `student`(`id`,`name`,`tid`) VALUES(3,'王五',1);
INSERT INTO `student`(`id`,`name`,`tid`) VALUES(4,'田六',1);
INSERT INTO `student`(`id`,`name`,`tid`) VALUES(5,'孙七',1);

Maven新建空项目

为减少实体类的手动编写，引入lombox插件，在pom.xml引入依赖：

 <!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
       <dependency>
           <groupId>org.projectlombok</groupId>
           <artifactId>lombok</artifactId>
           <version>1.18.20</version>
       </dependency>

(详细安装过程：链接: Lombok详细安装教程.)

完善项目包结构

核心配置文件mybatis-config.xml

<?xml version="1.0" encoding="UTF8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">

<!--核心配置文件-->
<configuration>
<!--    引入外部配置文件-->
    <properties resource="db.properties"/>

<!--    标准日志工厂-->
    <settings>
        <setting name="logImpl" value="STDOUT_LOGGING"/>
    </settings>
    
    
<!--    别名优化-->
    <typeAliases>
    <typeAlias type="com.tt.pojo.Student" alias="Student"/>
    </typeAliases>

    <environments default="development">

        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>
    </environments>

<!--    注册mapper-->
    <mappers>
        <mapper class="com.tt.dao.TeacherMapper"/>
        <mapper class="com.tt.dao.StudentMapper"/>
    </mappers>
    
</configuration>

执行一个小测试：

public class Test {
   public static void main(String[] args) {
       SqlSession sqlSession = MybatisUtils.getSqlSession();
       TeacherMapper mapper = sqlSession.getMapper(TeacherMapper.class);
       Teacher teacher = mapper.getTeacher(1);
       System.out.println(teacher);
       sqlSession.close();
   }
}

结果查询成功，环境搭建到此为止