期末考试题解4

合集 - 2024寒假(22)

1.2024秋期末考试02-182.《构建之法》阅读笔记——102-183.期末考试题解102-184.期末考试题解202-185.期末考试题解302-18

6.期末考试题解402-18

7.期末考试题解502-188.期末考试题解602-189.期末考试题解702-1810.期末考试题解802-1811.期末考试题解9（总结）02-1812.《构建之法》阅读笔记——202-1813.寒假web开发102-1814.寒假web开发202-1815.寒假web开发302-1816.寒假web开发402-1817.寒假web开发502-1818.寒假web开发602-1819.寒假web开发702-1820.寒假web开发802-1821.《构建之法》阅读笔记——302-1822.jsp+Mybatis+Mysql web开发制作模板02-20

收起

util设置
SqlSessionFactoryUtils

点击查看代码

package com.QixunQiu.util;

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;

import java.io.IOException;
import java.io.InputStream;

public class SqlSessionFactoryUtils {

    private static SqlSessionFactory sqlSessionFactory;

    static {
        //静态代码块会随着类的加载而自动执行，且执行一次
        try {
            String resource = "mybatis-config.xml";
            InputStream inputStream = Resources.getResourceAsStream(resource);
            sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }
    }

    public static SqlSessionFactory getSqlSessionFactory() {
        return sqlSessionFactory;
    }
}

mybatis-config.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>

    <typeAliases>
<!--        记得修改名称-->
        <package name="com.QixunQiu.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<!--                数据库名称-->
                <property name="url" value="jdbc:mysql:///endtest?useSSL=false&amp;serverTimezone=Hongkong&amp;characterEncoding=utf-8&amp;autoReconnect=true&amp;userServerPreStmts=true"/>
                <property name="username" value="root"/>
                <property name="password" value="1234"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--扫描mapper-->
        <package name="com.QixunQiu.mapper"/>
    </mappers>
</configuration><?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>

    <typeAliases>
<!--        记得修改名称-->
        <package name="com.QixunQiu.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
<!--                数据库名称-->
                <property name="url" value="jdbc:mysql:///endtest?useSSL=false&amp;serverTimezone=Hongkong&amp;characterEncoding=utf-8&amp;autoReconnect=true&amp;userServerPreStmts=true"/>
                <property name="username" value="root"/>
                <property name="password" value="1234"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--扫描mapper-->
        <package name="com.QixunQiu.mapper"/>
    </mappers>
</configuration>