SpringMVC实验一：简单查询：一对一、一对多查询

1.首先在src上创建po，database,mapper三个包。

在database包下面创建一个DataConnection类，代码如下：

public class DataConnection {
    private String resource="SqlMapConfig.xml";
    private SqlSessionFactory sqlSessionFactory;
    private SqlSession sqlSession;

    public SqlSession getSqlSession() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream(resource);
        sqlSessionFactory=new SqlSessionFactoryBuilder().build(inputStream);
        sqlSession=sqlSessionFactory.openSession();
        return sqlSession;
    }
}

2.同时，我们需要在xml导入相关依赖。

        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.5.13</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.25</version>
        </dependency>

然后我们需要创建一个config目录来存放核心配置文件SqlMapConfig.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- 和spring整合后 environments配置将废除-->
    <environments default="mysql">
        <environment id="mysql">
            <!-- 使用jdbc事务管理-->
            <transactionManager type="JDBC"/>
            <!-- 数据库连接池-->
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/ssm_db?characterEncoding=utf-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <mapper resource="sqlmap/UserInfoMapper.xml"/>
    </mappers>
</configuration>

<mapper resource="sqlmap/UserInfoMapper.xml"/>

注意：第一次写入

"http://mybatis.org/dtd/mybatis-3-config.dtd">

以上代码会报错：解决方法：https://blog.csdn.net/bb_111/article/details/127220665?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522171064143616800213033494%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=171064143616800213033494&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2~all~first_rank_ecpm_v1~rank_v31_ecpm-1-127220665-null-null.142^v99^pc_search_result_base3&utm_term=%20%20http%3A%2F%2Fmybatis.org%2Fdtd%2Fmybatis-3-config.dtd%3E%20%E6%8A%A5%E9%94%99%EF%BC%9AURI%E6%9C%AA%E6%B3%A8%E5%86%8C%28%E8%AE%BE%E7%BD%AE%7C%E8%AF%AD%E8%A8%80%E5%92%8C%E6%A1%86%E6%9E%B6%7C%E6%9E%B6%E6%9E%84%E5%92%8CDTD%29&spm=1018.2226.3001.4187

3.连接数据库，在po层里面创建相关实列。

注意，一定要将config标志为路径，操作方法为：https://blog.csdn.net/bb_111/article/details/127220665

4.根据教材相关实列，向userInferMapper中写入sql语句，在test中写入测试方法。