\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d: tweeter
\n\u30d1\u30c3\u30b1\u30fc\u30b8\u540d: jp.abc<\/p>\n
pom.xml\u306bTymeleaf\u3068JPA\u3068HSQLDB\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0\u3059\u308b\u3002
\nSpring Boot \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30922.1.4\u306b\u3059\u308b\u3002<\/p>\n
\r\n<?xml version="1.0" encoding="UTF-8"?>\r\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0" xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\r\n\txsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">\r\n\t<modelVersion>4.0.0<\/modelVersion>\r\n\t<parent>\r\n\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t<artifactId>spring-boot-starter-parent<\/artifactId>\r\n\t\t<version>2.1.4.RELEASE<\/version>\r\n\t\t<relativePath\/> <!-- lookup parent from repository -->\r\n\t<\/parent>\r\n\t<groupId>jp.abc<\/groupId>\r\n\t<artifactId>tweeter<\/artifactId>\r\n\t<version>0.0.1-SNAPSHOT<\/version>\r\n\t<name>tweeter<\/name>\r\n\t<description>Tweeter<\/description>\r\n\r\n\t<properties>\r\n\t\t<java.version>1.8<\/java.version>\r\n\t<\/properties>\r\n\r\n\t<dependencies>\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t<artifactId>spring-boot-starter-web<\/artifactId>\r\n\t\t<\/dependency>\r\n\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t<artifactId>spring-boot-starter-test<\/artifactId>\r\n\t\t\t<scope>test<\/scope>\r\n\t\t<\/dependency>\r\n\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t<artifactId>spring-boot-starter-thymeleaf<\/artifactId>\r\n\t\t<\/dependency>\r\n\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t<artifactId>spring-boot-starter-data-jpa<\/artifactId>\r\n\t\t<\/dependency>\r\n\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t<artifactId>spring-boot-starter-security<\/artifactId>\r\n\t\t<\/dependency>\r\n\r\n\t\t<dependency>\r\n\t\t\t<groupId>org.hsqldb<\/groupId>\r\n\t\t\t<artifactId>hsqldb<\/artifactId>\r\n\t\t<\/dependency>\r\n\r\n\t<\/dependencies>\r\n\r\n\t<build>\r\n\t\t<plugins>\r\n\t\t\t<plugin>\r\n\t\t\t\t<groupId>org.springframework.boot<\/groupId>\r\n\t\t\t\t<artifactId>spring-boot-maven-plugin<\/artifactId>\r\n\t\t\t<\/plugin>\r\n\t\t<\/plugins>\r\n\t<\/build>\r\n\r\n<\/project>\r\n<\/pre>\nHSQLDB\u3092\u8d77\u52d5\u3059\u308bBAT\u30d5\u30a1\u30a4\u30eb\u3092\u4fee\u6b63\u3059\u308b\u3002tweeter \u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
\r\ncd C:\\pleiades\\hsqldb-2.4.1\\hsqldb\\lib\r\njava -cp hsqldb.jar org.hsqldb.Server --database.0 db\/tweeter --dbname.0 tweeter\r\n<\/pre>\napplication.properties \u306bHSQLDB\u306e\u8a2d\u5b9a\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
\r\nspring.datasource.url=jdbc:hsqldb:hsql:\/\/localhost\/tweeter\r\nspring.datasource.username=sa\r\nspring.datasource.password=\r\nspring.datasource.driver-class-name=org.hsqldb.jdbc.JDBCDriver\r\nspring.jpa.properties.hibernate.dialect=org.hibernate.dialect.HSQLDialect\r\nspring.jpa.hibernate.ddl-auto=update\r\n<\/pre>\nSpring Boot \u3067JDBC\u3092\u4f7f\u3063\u3066\u30e6\u30fc\u30b6\u30fc\u767b\u9332\u30fb\u30e6\u30fc\u30b6\u30fc\u8a8d\u8a3c\u3059\u308b\u65b9\u6cd5<\/a><\/p>\n
4\u3064\u306eHTML\u30c6\u30f3\u30d7\u30ec\u30fc\u30c8\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
index.html<\/p>\n
\r\n<!DOCTYPE html>\r\n<html>\r\n<head>\r\n<meta charset="UTF-8">\r\n<title>\u30c8\u30c3\u30d7\u30da\u30fc\u30b8<\/title>\r\n<\/head>\r\n<body>\r\n <h1>\u30c8\u30c3\u30d7\u30da\u30fc\u30b8<\/h1>\r\n <a href="\/mypage">\u30de\u30a4\u30da\u30fc\u30b8<\/a>\r\n<\/body>\r\n<\/html>\r\n<\/pre>\nmypage.html<\/p>\n
\r\n<!DOCTYPE html>\r\n<html xmlns:th="http:\/\/www.thymeleaf.org">\r\n<head>\r\n <meta charset="UTF-8" \/>\r\n <title>login<\/title>\r\n<\/head>\r\n<body>\r\n <h1>\u30de\u30a4\u30da\u30fc\u30b8<\/h1>\r\n <form th:action="@{\/logout}" method="post">\r\n <input type="submit" value="\u30ed\u30b0\u30a2\u30a6\u30c8" \/>\r\n <\/form>\r\n<\/body>\r\n<\/html>\r\n<\/pre>\nlogin.html<\/p>\n
\r\n<!DOCTYPE html>\r\n<html xmlns:th="http:\/\/www.thymeleaf.org">\r\n<head>\r\n <meta charset="UTF-8" \/>\r\n <title>login<\/title>\r\n<\/head>\r\n<body>\r\n <div th:if="${param.error}">\r\n \u30a8\u30e9\u30fc: \u30e6\u30fc\u30b6\u540d\u30fb\u30d1\u30b9\u30ef\u30fc\u30c9\u304c\u9055\u3044\u307e\u3059\u3002\r\n <\/div>\r\n <form th:action="@{\/login}" method="post">\r\n <div><label>\u30e6\u30fc\u30b6\u540d: <input type="text" name="username"\/> <\/label><\/div>\r\n <div><label>\u30d1\u30b9\u30ef\u30fc\u30c9: <input type="password" name="password"\/> <\/label><\/div>\r\n <div><input type="submit" value="\u30ed\u30b0\u30a4\u30f3"\/><\/div>\r\n <\/form>\r\n <div><a href="\/newuser">\u65b0\u898f\u30e6\u30fc\u30b6\u30fc\u767b\u9332<\/a><\/div>\r\n <a href="\/">\u623b\u308b<\/a>\r\n<\/body>\r\n<\/html>\r\n<\/pre>\nnewuser.html<\/p>\n
\r\n<!DOCTYPE html>\r\n<html xmlns:th="http:\/\/www.thymeleaf.org">\r\n<head>\r\n <meta charset="UTF-8" \/>\r\n <title>\u65b0\u898f\u30e6\u30fc\u30b6\u30fc\u767b\u9332<\/title>\r\n<\/head>\r\n<body>\r\n <h1>\u65b0\u898f\u30e6\u30fc\u30b6\u30fc\u767b\u9332<\/h1>\r\n <form th:action="@{\/newuser}" method="post">\r\n <div><label>\u30e6\u30fc\u30b6\u540d: <input type="text" name="username"\/> <\/label><\/div>\r\n <div><label>\u30d1\u30b9\u30ef\u30fc\u30c9: <input type="password" name="password"\/> <\/label><\/div>\r\n <div><label>\u30d1\u30b9\u30ef\u30fc\u30c9\u518d\u5165\u529b: <input type="password" name="password2"\/> <\/label><\/div>\r\n <div><input type="submit" value="\u767b\u9332"\/><\/div>\r\n <\/form>\r\n <a href="\/">\u623b\u308b<\/a>\r\n<\/body>\r\n<\/html>\r\n<\/pre>\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u3092\u4f5c\u6210\u3059\u308b\u3002
\nMyController.java<\/p>\n\r\npackage jp.abc;\r\n\r\nimport org.springframework.stereotype.Controller;\r\nimport org.springframework.web.bind.annotation.RequestMapping;\r\n\r\n@Controller\r\npublic class MyController {\r\n @RequestMapping(value = "\/")\r\n public String index() {\r\n return "index";\r\n }\r\n\r\n @RequestMapping(value = "\/login")\r\n public String login() {\r\n return "login";\r\n }\r\n\r\n @RequestMapping(value = "\/newuser")\r\n public String newuser() {\r\n return "newuser";\r\n }\r\n\r\n @RequestMapping(value = "\/mypage")\r\n public String top() {\r\n return "mypage";\r\n }\r\n}\r\n<\/pre>\nWebSecurityConfig \u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3002<\/p>\n
\r\npackage jp.abc;\r\n\r\nimport org.springframework.context.annotation.Configuration;\r\nimport org.springframework.security.config.annotation.web.builders.HttpSecurity;\r\nimport org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;\r\nimport org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;\r\n\r\n@Configuration\r\n@EnableWebSecurity\r\npublic class WebSecurityConfig extends WebSecurityConfigurerAdapter{\r\n @Override\r\n protected void configure(HttpSecurity http) throws Exception {\r\n http.authorizeRequests()\r\n .antMatchers("\/", "\/newuser").permitAll()\r\n .anyRequest().authenticated()\r\n .and()\r\n .formLogin()\r\n .loginPage("\/login")\r\n .permitAll()\r\n .and()\r\n .logout()\r\n .permitAll();\r\n }\r\n}\r\n<\/pre>\nWebSecurityConfig \u306b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a8d\u8a3c\u306e\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
\r\npackage jp.abc;\r\n\r\nimport javax.sql.DataSource;\r\n\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.context.annotation.Configuration;\r\nimport org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder;\r\nimport org.springframework.security.config.annotation.web.builders.HttpSecurity;\r\nimport org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;\r\nimport org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;\r\nimport org.springframework.security.core.userdetails.User;\r\nimport org.springframework.security.core.userdetails.User.UserBuilder;\r\n\r\n@Configuration\r\n@EnableWebSecurity\r\npublic class WebSecurityConfig extends WebSecurityConfigurerAdapter{\r\n\t@Autowired\r\n\tprivate DataSource dataSource;\r\n\r\n\t@Autowired\r\n\tpublic void configureGlobal(AuthenticationManagerBuilder auth) throws Exception {\r\n\t\tUserBuilder users = User.withDefaultPasswordEncoder();\r\n\t\tauth\r\n\t\t.jdbcAuthentication()\r\n\t\t.dataSource(dataSource)\r\n\t\t.withDefaultSchema()\r\n\t\t.withUser(users.username("user").password("password").roles("USER"));\r\n\t}\r\n\r\n\t@Override\r\n\tprotected void configure(HttpSecurity http) throws Exception {\r\n\t\thttp.authorizeRequests()\r\n\t\t.antMatchers("\/", "\/newuser").permitAll()\r\n\t\t.anyRequest().authenticated()\r\n\t\t.and()\r\n\t\t.formLogin()\r\n\t\t.loginPage("\/login")\r\n\t\t.permitAll()\r\n\t\t.and()\r\n\t\t.logout()\r\n\t\t.permitAll();\r\n\t}\r\n}\r\n<\/pre>\n\u3053\u306e\u30b3\u30fc\u30c9\u3067\u8d77\u52d5\u3059\u308b\u3068\u30011\u5ea6\u76ee\u306f\u6b63\u5e38\u306b\u8d77\u52d5\u3059\u308b\u304c\u3001\u518d\u8d77\u52d5\u3059\u308b\u3068\u4f8b\u5916\u304c\u767a\u751f\u3057\u3066\u8d77\u52d5\u3067\u304d\u306a\u304f\u306a\u308b\u3002
\n\u4f8b\u5916\u306e\u539f\u56e0\u304c withDefaultScheme() \u3068 withUser() \u306a\u306e\u3067\u3001\u305d\u306e\u90e8\u5206\u3092\u524a\u9664\u3059\u308b\u3002<\/p>\nWebSecurityConfig.java<\/p>\n
\r\n\t@Autowired\r\n\tpublic void configureGlobal(AuthenticationManagerBuilder auth) throws Exception {\r\n\t\tauth\r\n\t\t.jdbcAuthentication()\r\n\t\t.dataSource(dataSource);\r\n\t}\r\n<\/pre>\n\u30b3\u30f3\u30c8\u30ed\u30fc\u30e9\u3067\u65b0\u898f\u30e6\u30fc\u30b6\u30fc\u767b\u9332\u306ePOST\u30e1\u30bd\u30c3\u30c9\u3092\u53d7\u3051\u4ed8\u3051\u308b\u3088\u3046\u306b\u3059\u308b\u3002<\/p>\n
\r\npackage jp.abc;\r\n\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.security.core.userdetails.User;\r\nimport org.springframework.security.core.userdetails.User.UserBuilder;\r\nimport org.springframework.security.provisioning.JdbcUserDetailsManager;\r\nimport org.springframework.stereotype.Controller;\r\nimport org.springframework.web.bind.annotation.RequestMapping;\r\nimport org.springframework.web.bind.annotation.RequestMethod;\r\nimport org.springframework.web.bind.annotation.RequestParam;\r\n\r\n@Controller\r\npublic class MyController {\r\n\t@Autowired\r\n\tprivate JdbcUserDetailsManager userManager;\r\n\r\n\t@RequestMapping(value = "\/")\r\n\tpublic String index() {\r\n\t\treturn "index";\r\n\t}\r\n\r\n\t@RequestMapping(value = "\/login")\r\n\tpublic String login() {\r\n\t\treturn "login";\r\n\t}\r\n\r\n\t@RequestMapping(value = "\/newuser", method = RequestMethod.GET)\r\n\tpublic String newuser() {\r\n\t\treturn "newuser";\r\n\t}\r\n\r\n\t@RequestMapping(value = "\/newuser", method = RequestMethod.POST)\r\n\tpublic String register(@RequestParam("username") String username,\r\n\t\t\t@RequestParam("password") String password) {\r\n\t\tUserBuilder users = User.withDefaultPasswordEncoder();\r\n\t\tuserManager.createUser(users.username(username).password(password).roles("USER").build());\r\n\t\treturn "login";\r\n\t}\r\n\r\n\t@RequestMapping(value = "\/mypage")\r\n\tpublic String top() {\r\n\t\treturn "mypage";\r\n\t}\r\n}\r\n<\/pre>\n\u3053\u306e\u72b6\u614b\u3067\u8d77\u52d5\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u3066\u8d77\u52d5\u306b\u5931\u6557\u3059\u308b\u3002<\/p>\n
\r\n***************************\r\nAPPLICATION FAILED TO START\r\n***************************\r\n\r\nDescription:\r\n\r\nField userManager in jp.abc.MyController required a bean of type 'org.springframework.security.provisioning.JdbcUserDetailsManager' that could not be found.\r\n\r\nThe injection point has the following annotations:\r\n\t- @org.springframework.beans.factory.annotation.Autowired(required=true)\r\n\r\n\r\nAction:\r\n\r\nConsider defining a bean of type 'org.springframework.security.provisioning.JdbcUserDetailsManager' in your configuration.\r\n\r\n<\/pre>\nJdbcUserDetailManager \u306e\u30d3\u30fc\u30f3\u3092\u8a2d\u5b9a\u306b\u7528\u610f\u3057\u308d\u3068\u8a00\u308f\u308c\u3066\u3044\u308b\u306e\u3067\u3001\u305d\u306e\u8a2d\u5b9a\u3092\u8ffd\u52a0\u3059\u308b\u3002<\/p>\n
WebSecurityConfig.java<\/p>\n
\r\n\t@Bean\r\n\tpublic JdbcUserDetailsManager jdbcUserDetailsManager() throws Exception {\r\n\t\tJdbcUserDetailsManager jdbcUserDetailsManager = new JdbcUserDetailsManager();\r\n\t\tjdbcUserDetailsManager.setDataSource(dataSource);\r\n\t\treturn jdbcUserDetailsManager;\r\n\t}\r\n<\/pre>\n\u8a2d\u5b9a\u3092\u8ffd\u52a0\u3057\u305f\u5f8c\u306b\u518d\u8d77\u52d5\u3059\u308b\u3068\u3001\u30a8\u30e9\u30fc\u306a\u304f\u8d77\u52d5\u3067\u304d\u308b\u3002
\n\u30e6\u30fc\u30b6\u30fc\u767b\u9332\u3068\u30ed\u30b0\u30a4\u30f3\u3082\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u3066\u3001\u30ed\u30b0\u30a4\u30f3\u3059\u308c\u3070\u30de\u30a4\u30da\u30fc\u30b8\u306b\u30a2\u30af\u30bb\u30b9\u3067\u304d\u308b\u3002<\/p>\n\n<\/div>","protected":false},"excerpt":{"rendered":"\u30ed\u30b0\u30a4\u30f3\u8a8d\u8a3c \u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u540d: tweeter \u30d1\u30c3\u30b1\u30fc\u30b8\u540d: jp.abc pom.xml\u306bTymeleaf\u3068JPA\u3068HSQLDB\u306e\u4f9d\u5b58\u95a2\u4fc2\u3092\u8ffd\u52a0\u3059\u308b\u3002 Spring Boot \u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u30922.1.4\u306b\u3059\u308b\u3002 HSQ … “9\u67082\u65e5” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[],"_links":{"self":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/291"}],"collection":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=291"}],"version-history":[{"count":20,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":311,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=\/wp\/v2\/posts\/291\/revisions\/311"}],"wp:attachment":[{"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/2019se3.satoshis.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}