拓展知识

会话持久化

持久化到本地

path\to\apache-tomcat-9.0.100\conf\context.xml

    <!-- 持久化到本地文件系统 -->
    <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="true">
        <Store className="org.apache.catalina.session.FileStore" directory="D:/Program/Environment/apache-tomcat-9.0.100/global_sessions"/>
    </Manager>

持久化到数据库

驱动下载安装

操作系统 选择 平台独立，下载zip或tar.gz均可，解压复制jar包到path\to\apache-tomcat-9.0.100\lib目录下即可

MySQL :: Download Connector/J

path\to\apache-tomcat-9.0.100\conf\context.xml

    <!-- 持久化到mysql数据库 -->
    <Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="true">
        <Store className="org.apache.catalina.session.JDBCStore"
               driverName="com.mysql.jdbc.Driver"
               connectionURL="jdbc:mysql://localhost:3306/javaweb?user=ssydx"
               sessionTable="tomcat_sessions"
               sessionIdCol="session_id"
               sessionDataCol="session_data"
               sessionValidCol="valid_session"
               sessionLastAccessedCol="last_access"
               sessionMaxInactiveCol="max_inactive"
               sessionAppCol="app_name"/>
    </Manager>

mysql

CREATE DATABASE javaweb;
CREATE TABLE tomcat_sessions (
    session_id VARCHAR(100) NOT NULL PRIMARY KEY,
    valid_session CHAR(1) NOT NULL,
    max_inactive INT NOT NULL,
    last_access BIGINT NOT NULL,
    app_name VARCHAR(255),
    session_data MEDIUMBLOB,
    KEY kapp_name(app_name)
);

持久化到redis数据库

TODO