Spring boot Rest Service Session Example using JDBC

https://javadeveloperzone.com/spring-boot/spring-boot-rest-service-session-example-using-jdbc/

• 1. Overview
• Key points of Spring boot Rest Service Session Example using JDBC
• 2. Example
  • 2.1 pom.xml
  • 2.2 HttpSessionConfig
  • 2.3 SpringBooJDBCSessionController
  • 2.4 pringBootConfig
  • 2.5 application.properties
  • 2.6 schema-mysql.sql
  • 2.7 Run Application
  • 2.8 Database:
• 3. References

1. Overview

Spring boot session persist is past of spring boot session management. Sprint boot provides ways to persist session in the database like session id, session creation time, last active time, max inactive interval (session timeout) and session attributes.

Key points of Spring boot Rest Service Session Example using JDBC

• Make sure that you have added @EnableJdbcHttpSession annotation at to enable JDBC Session
• Make sure that Database properties are current in application.properties files like spring.datasource.url, spring.datasource.username, spring.datasource.password,spring.datasource.driver-class-name.
• If do not want to write database-related properties then create bean @DataSource 
• Make sure that database drive has been added in classpath or POM
• HttpSessionStrategy bean requires maintaining session using header (Mostly request for Rest Services)
• spring-session-jdbc dependency must be available in classpath
• Copy table schema from org.springframework.session.jdbc.schema-[DATABASE].sql and create table manually. In this example, we have used schema-mysql.sql
• When any session create it will store session related information database tables by default table names are spring_session, spring_session_attributes.
• If do not like spring_session table name then specified a table in the property name spring.session.jdbc.table-name

   like  : spring.session.jdbc.table-name=your_table_spring_session

• For max_inactive_interval (session timeout) need to specified values in annotation attribute maxInactiveIntervalInSeconds so that values affect in the table.
• 1. @EnableJdbcHttpSession(maxInactiveIntervalInSeconds = 1500)
• Here are some useful other properties:
• 1. server.session.timeout= # Session timeout in seconds.
  2. spring.session.jdbc.initializer.enabled= # Create the required session tables on startup if necessary. Enabled automatically if the default table name is set or a custom schema is configured.
  3. spring.session.jdbc.schema=classpath:org/springframework/session/jdbc/schema-@@platform@@.sql # Path to the SQL file to use to initialize the database schema.
  4. spring.session.jdbc.table-name=SPRING_SESSION # Name of database table used to store sessions.

  NOTE : spring.session.jdbc.schema : It is not creating schema automatically. We need to create schema manually. 

2. Example

Spring boot Rest Service Session Example using JDBC

2.1 pom.xml

1. <?xml version="1.0" encoding="UTF-8"?>
2. <project xmlns="http://maven.apache.org/POM/4.0.0"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
4. xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
5. <modelVersion>4.0.0</modelVersion>
7. <groupId>spring-boot-example</groupId>
8. <artifactId>Spring-boot-session-example-using-jdbc</artifactId>
9. <version>1.0-SNAPSHOT</version>
10. <packaging>jar</packaging>
11. <description>Spring boot rest service session example using jdbc</description>
12. <!-- Inherit defaults from Spring Boot -->
13. <parent>
14. <groupId>org.springframework.boot</groupId>
15. <artifactId>spring-boot-starter-parent</artifactId>
16. <version>1.5.4.RELEASE</version>
17. </parent>
18. <properties>
19. <maven.compiler.source>1.8</maven.compiler.source>
20. <maven.compiler.target>1.8</maven.compiler.target>
21. </properties>
22. <dependencies>
23. <!-- Provided -->
24. <dependency>
25. <groupId>org.springframework.boot</groupId> <!-- for tomcat web container-->
26. <artifactId>spring-boot-starter-tomcat</artifactId>
27. </dependency>
28. <dependency>
29. <groupId>org.springframework.session</groupId> <!-- for spring boot jdbc session -->
30. <artifactId>spring-session-jdbc</artifactId>
31. <version>1.3.1.RELEASE</version>
32. </dependency>
33. <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
34. <dependency>
35. <groupId>mysql</groupId>
36. <artifactId>mysql-connector-java</artifactId>
37. <version>5.1.6</version>
38. </dependency>
39. <dependency>
40. <groupId>org.springframework.boot</groupId> <!--its for spring mvc related -->
41. <artifactId>spring-boot-starter-web</artifactId>
42. </dependency>
43. <dependency>
44. <groupId>org.springframework.boot</groupId>
45. <artifactId>spring-boot-starter-jdbc</artifactId>
46. </dependency>
47. </dependencies>
48. <build>
49. <plugins>
50. <plugin>
51. <groupId>org.springframework.boot</groupId>
52. <artifactId>spring-boot-maven-plugin</artifactId>
53. </plugin>
54. </plugins>
55. </build>
56. </project>

2.2 HttpSessionConfig

1. package com.javadeveloperzone;
4. import org.springframework.context.annotation.Bean;
5. import org.springframework.context.annotation.Configuration;
6. import org.springframework.session.jdbc.config.annotation.web.http.EnableJdbcHttpSession;
7. import org.springframework.session.web.context.AbstractHttpSessionApplicationInitializer;
8. import org.springframework.session.web.http.HeaderHttpSessionStrategy;
9. import org.springframework.session.web.http.HttpSessionStrategy;
13. /**
14. * Created by Java Developer Zone on 13-11-2017.
15. */
16. @Configuration
17. @EnableJdbcHttpSession
18. public class HttpSessionConfig extends AbstractHttpSessionApplicationInitializer {
20. @Bean
21. public HttpSessionStrategy httpSessionStrategy() { // maintain session using header (mostly for rest session management)
22. return new HeaderHttpSessionStrategy();
23. }
25. }

2.3 SpringBooJDBCSessionController

1. package com.javadeveloperzone.controller;
3. import org.springframework.stereotype.Controller;
4. import org.springframework.web.bind.annotation.GetMapping;
5. import org.springframework.web.bind.annotation.RestController;
7. import javax.servlet.http.HttpServlet;
8. import javax.servlet.http.HttpServletRequest;
9. import java.util.HashMap;
11. /**
12. * Created by JavaDeveloperZone on 19-07-2017.
13. */
14. @RestController
15. public class SpringBooJDBCSessionController{
17. @GetMapping("/viewSessionData") // it will handle all request for /welcome
18. public java.util.Map<String,Integer> start(HttpServletRequest request) {
19. Integer integer =(Integer) request.getSession().getAttribute("hitCounter"); it will read data from database tables
20. if(integer==null){
21. integer=new Integer(0);
22. integer++;
23. request.getSession().setAttribute("hitCounter",integer); // it will write data to tables
24. }else{
25. integer++;
26. request.getSession().setAttribute("hitCounter",integer); // it will write data to tables
27. }
28. java.util.Map<String,Integer> hitCounter=new HashMap<>();
29. hitCounter.put("Hit Counter",integer);
30. return hitCounter;
31. }
33. }

2.4 pringBootConfig

1. package com.javadeveloperzone;
3. import org.springframework.boot.SpringApplication;
4. import org.springframework.boot.autoconfigure.SpringBootApplication;
5. import org.springframework.context.annotation.ComponentScan;
7. /**
8. * Created by JavaDeveloperZone on 19-07-2017.
9. */
11. @SpringBootApplication
12. @ComponentScan
13. // Using a root package also allows the @ComponentScan annotation to be used without needing to specify a basePackage attribute
14. public class SpringBootConfig {
16. public static void main(String[] args) throws Exception {
17. SpringApplication.run(SpringBootConfig.class, args); // it wil start application
18. }
19. }

2.5 application.properties

1. spring.datasource.url=jdbc:mysql://localhost/demo_database
2. spring.datasource.username=root
3. spring.datasource.password=
4. spring.datasource.driver-class-name=com.mysql.jdbc.Driver

2.6 schema-mysql.sql

1. CREATE TABLE SPRING_SESSION (
2. SESSION_ID CHAR(36) NOT NULL,
3. CREATION_TIME BIGINT NOT NULL,
4. LAST_ACCESS_TIME BIGINT NOT NULL,
5. MAX_INACTIVE_INTERVAL INT NOT NULL,
6. PRINCIPAL_NAME VARCHAR(100),
7. CONSTRAINT SPRING_SESSION_PK PRIMARY KEY (SESSION_ID)
8. ) ENGINE=InnoDB;
10. CREATE INDEX SPRING_SESSION_IX1 ON SPRING_SESSION (LAST_ACCESS_TIME);
12. CREATE TABLE SPRING_SESSION_ATTRIBUTES (
13. SESSION_ID CHAR(36) NOT NULL,
14. ATTRIBUTE_NAME VARCHAR(200) NOT NULL,
15. ATTRIBUTE_BYTES BLOB NOT NULL,
16. CONSTRAINT SPRING_SESSION_ATTRIBUTES_PK PRIMARY KEY (SESSION_ID, ATTRIBUTE_NAME),
17. CONSTRAINT SPRING_SESSION_ATTRIBUTES_FK FOREIGN KEY (SESSION_ID) REFERENCES SPRING_SESSION(SESSION_ID) ON DELETE CASCADE
18. ) ENGINE=InnoDB;
20. CREATE INDEX SPRING_SESSION_ATTRIBUTES_IX1 ON SPRING_SESSION_ATTRIBUTES (SESSION_ID);

2.7 Run Application

mvn spring-boot:run

1. [INFO] Scanning for projects...
2. [INFO]
3. [INFO] ------------------------------------------------------------------------
4. [INFO] Building Spring-boot-session-example-using-jdbc 1.0-SNAPSHOT
5. [INFO] ------------------------------------------------------------------------
6. [INFO]
7. [INFO] >>> spring-boot-maven-plugin:1.5.4.RELEASE:run (default-cli) > test-compile @ Spring-boot-session-example-using-jdbc >>>
8. [INFO]
9. [INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ Spring-boot-session-example-using-jdbc ---
10. [INFO] Using 'UTF-8' encoding to copy filtered resources.
11. [INFO] Copying 1 resource
12. [INFO] Copying 0 resource
13. [INFO]
14. [INFO] --- maven-compiler-plugin:3.1:compile (default-compile) @ Spring-boot-session-example-using-jdbc ---
15. [INFO] Nothing to compile - all classes are up to date
16. [INFO]
17. [INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ Spring-boot-session-example-using-jdbc ---
18. [INFO] Using 'UTF-8' encoding to copy filtered resources.
19. [INFO] skip non existing resourceDirectory F:\extrawork\spring-boot\spring-boot-rest-service-session-jdbc-example\src\test\resources
20. [INFO]
21. [INFO] --- maven-compiler-plugin:3.1:testCompile (default-testCompile) @ Spring-boot-session-example-using-jdb
22. c ---
23. [INFO] No sources to compile
24. [INFO]
25. [INFO] <<< spring-boot-maven-plugin:1.5.4.RELEASE:run (default-cli) < test-compile @ Spring-boot-session-example-using-jdbc <<<
26. [INFO]
27. [INFO] --- spring-boot-maven-plugin:1.5.4.RELEASE:run (default-cli) @ Spring-boot-session-example-using-jdbc ---
29. . ____ _ __ _ _
30. /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
31. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
32. \\/ ___)| |_)| | | | | || (_| | ) ) ) )
33. ' |____| .__|_| |_|_| |_\__, | / / / /
34. =========|_|==============|___/=/_/_/_/
35. :: Spring Boot :: (v1.5.4.RELEASE)
37. 2017-11-25 09:49:51.741 INFO 34908 --- [ main] com.javadeveloperzone.SpringBootConfig : Starting
38. SpringBootConfig on Mahesh with PID 34908 (F:\extrawork\spring-boot\spring-boot-rest-service-session-jdbc-exam
39. ple\target\classes started by Lenovo in F:\extrawork\spring-boot\spring-boot-rest-service-session-jdbc-example
40. )
41. 2017-11-25 09:49:51.746 INFO 34908 --- [ main] com.javadeveloperzone.SpringBootConfig : No active

2.8 Database:

Table : spring_session

Spring Boot Rest Service Session Example – JDBC

Table : spring_session_attributes

Spring Boot Rest Service Session Example – JDBC – spring-session-attributes

Send First Request, It will create session and store session information in database and return x-auth-token in response header.

Spring Boot Rest Service Session Example – First Request

A further request, Pass header  x-auth-token in request so the server will consider the same session.

Spring Boot Rest Service Session Example – Pass Header Information

3. References

• Spring boot session management using jdbc document

转载于:https://www.cnblogs.com/davidwang456/articles/10362284.html