{"id":10006,"date":"2025-10-16T14:36:37","date_gmt":"2025-10-16T05:36:37","guid":{"rendered":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/?p=10006"},"modified":"2025-11-16T07:30:16","modified_gmt":"2025-11-15T22:30:16","slug":"spring-security%e3%82%92%e8%a9%a6%e3%81%99","status":"publish","type":"post","link":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/archives\/10006","title":{"rendered":"spring security\u3092\u8a66\u3059"},"content":{"rendered":"<div class=\"veu_autoEyeCatchBox\"><img loading=\"lazy\" decoding=\"async\" width=\"750\" height=\"639\" src=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u30b3\u30c6\u30c4.jpg\" class=\"attachment-large size-large wp-post-image\" alt=\"\u732b\u597d\u304d\u30ea\u30fc\u30de\u30f3\" srcset=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u30b3\u30c6\u30c4.jpg 996w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u30b3\u30c6\u30c4-300x255.jpg 300w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u30b3\u30c6\u30c4-768x654.jpg 768w\" sizes=\"auto, (max-width: 750px) 100vw, 750px\" \/><\/div>\n<p>\u3053\u3093\u306b\u3061\u308f\u3001\u732b\u597d\u304d\u30ea\u30fc\u30de\u30f3\u306e\u307b\u3052PG\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u30b3\u30c6\u30c4\uff08\u98fc\u3044\u732b\uff09\u304c\u65c5\u7acb\u3063\u3066\u3001\u3082\u3046\u3059\u3050\u4e00\u5e74\u306b\u306a\u308a\u307e\u3059\u3002\u6700\u8fd1\u3001\u5b50\u3069\u3082\u304c\u300e\u30b3\u30c6\u30c4\u306e\u97f3\u304c\u805e\u3053\u3048\u308b\u300f\u3068\u8a00\u3063\u3066\u3044\u3066\u2026\u3061\u3083\u3093\u3068\u899a\u3048\u3066\u3044\u3066\u304f\u308c\u308b\u306e\u306f\u5b09\u3057\u3044\u3067\u3059\u3002<\/p>\n\n\n\n<p>\u4eca\u56de\u306f\u4ee5\u4e0b\u306e\u69cb\u6210\u3092\u8a66\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>springboot 2.7 + spring security 5 + mybatis + logback<\/p>\n\n\n\n<p>springboot \u304c2\u306a\u306e\u306ftomcat9\u5411\u3051\u306e\u69cb\u6210\u3068\u3057\u3066\u3044\u308b\u305f\u3081\u3067\u3059\u3002<\/p>\n\n\n\n<p>JavaEE\u3068JakartaEE\u306e\u5883\u76ee\u306a\u306e\u3067springboot\u30923\u306b\u3059\u308b\u3068tomcat9\u3067\u306f\u52d5\u304b\u306a\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uff11 \u5168\u4f53<\/h2>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"589\" height=\"249\" src=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf1.png\" alt=\"\" class=\"wp-image-10009\" srcset=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf1.png 589w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf1-300x127.png 300w\" sizes=\"auto, (max-width: 589px) 100vw, 589px\" \/><\/figure>\n\n\n\n<p>1 \u30ea\u30af\u30a8\u30b9\u30c8<\/p>\n\n\n\n<p>1.1 spring-security\u306e\u8a2d\u5b9a\u306b\u57fa\u3065\u304dLoginController\u306e\/login\u3078<\/p>\n\n\n\n<p>1.2 \u30c6\u30f3\u30d7\u30ec\u30fc\u30c8auth.html\u304b\u3089html\u3092\u8fd4\u5374<\/p>\n\n\n\n<p>2 username, password\u3092\u9001\u4fe1<\/p>\n\n\n\n<p>2.1 LoginService.loadUserByUsername()\u304c\u547c\u3070\u308c\u308b<\/p>\n\n\n\n<p>2.2 UserRepository\u306eget\u3092\u547c\u3076<\/p>\n\n\n\n<p>2.3 UserMapper\u3092\u901a\u3057\u3066users\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u30c7\u30fc\u30bf\u53d6\u5f97<\/p>\n\n\n\n<p>2.4 spring-security\u3067\u30d1\u30b9\u30ef\u30fc\u30c9\u30c1\u30a7\u30c3\u30af\u3092\u884c\u3044\u3001\u4e0d\u4e00\u81f4\u306a\u3089ng\u3001\u4e00\u81f4\u306a\u3089ok\u3078<\/p>\n\n\n\n<p>2.5 \u8a8d\u8a3cOK\u6642\u306f1\u306e\u30ea\u30af\u30a8\u30b9\u30c8\u306b\u30ea\u30c0\u30a4\u30ec\u30af\u30c8<\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\uff12\u8a73\u7d30<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">spring-security\u5b9a\u7fa9<\/h3>\n\n\n\n<p>WebSecurityConfig.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>\n    @Bean\n    public SecurityFilterChain securityFilterChain(HttpSecurity http) throws Exception {\n        http\n                .authorizeHttpRequests(requests -&gt; requests\n                        .antMatchers(\"\/static\/**\", \"\/login*\", \"\/logout*\",\"\/hoge\").permitAll()\n                        .anyRequest().authenticated())\n                .formLogin(formLogin -&gt; formLogin\n                        .usernameParameter(\"username\")\n                        .passwordParameter(\"password\")\n                        .loginPage(\"\/login\")\n                        .successForwardUrl(\"\/login-success\")\n                        .failureForwardUrl(\"\/login-failure\")\n                        .permitAll())\n                .logout(logout -&gt; logout\n                        .deleteCookies()\n                        .invalidateHttpSession(true)\n                        .logoutUrl(\"\/logout\")\n                        .logoutSuccessUrl(\"\/login\")\n                        .permitAll())\n                .exceptionHandling(handling -&gt; handling\n                        .accessDeniedPage(\"\/error\/403\"));\n        return http.build();\n    }<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u8a8d\u8a3c\u95a2\u9023\u30ea\u30af\u30a8\u30b9\u30c8\u51e6\u7406<\/h3>\n\n\n\n<p>LoginController.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>@Controller\n@Slf4j\npublic class LoginController {\n\n    @Data\n    public static class LoginForm {\n        private String username;\n        private String password;\n    }\n\n    @ModelAttribute(\"loginForm\")\n    public LoginForm loginForm() {\n        return new LoginForm();\n    }\n\n    @GetMapping(\"\/login\")\n    public String login(Model model) {\n        log.debug(\"called.\");\n        return \"login\";\n    }\n\n    @PostMapping(\"\/login-failure\")\n    public String loginFailure(\n            HttpSession session,\n            HttpServletRequest request,\n            Model model,\n            @ModelAttribute(\"loginForm\") LoginForm form,\n            BindingResult result) {\n        log.debug(\"called. {}\", form);\n        AuthenticationException authExcp = (AuthenticationException) request.getAttribute(WebAttributes.AUTHENTICATION_EXCEPTION);\n        log.debug(\"cause: \" + authExcp);\n        if (authExcp instanceof InternalAuthenticationServiceException iase) {\n            result.rejectValue(\"username\", \"system.error\", new Object&#091;] {iase}, null);\n        } else {\n            result.rejectValue(\"username\", \"auth.failed\", new Object&#091;] {authExcp.getMessage()}, null);\n        }\n        return \"login\";\n    }\n\n    private RequestCache requestCache = new HttpSessionRequestCache();\n\n    @PostMapping(\"\/login-success\")\n    public String loginSuccess(\n            HttpServletRequest request,\n            HttpServletResponse response,\n            Model model, @AuthenticationPrincipal LoginUser user) {\n        SavedRequest savedRequest = requestCache.getRequest(request, response);\n        log.debug(\"called. {}, {}\", user, savedRequest);\n        if (savedRequest != null) {\n            String targetUrl = savedRequest.getRedirectUrl();\n            return \"redirect:\" + targetUrl;\n        } else {\n            return \"redirect:\/\";\n        }\n    }\n}<\/code><\/pre>\n\n\n\n<p>\u203b\u8a8d\u8a3c\u6210\u529f\u6642\u306b\u4f55\u304b\u51e6\u7406\u3092\u3057\u305f\u3044\u5834\u5408\u306floginSuccess \u306b\u7d44\u307f\u8fbc\u3081\u307e\u3059<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30ed\u30b0\u30a4\u30f3\u30e6\u30fc\u30b6\u306e\u53d6\u5f97<\/h3>\n\n\n\n<p>LoginService.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>@Service\n@Slf4j\n@RequiredArgsConstructor\npublic class LoginService implements UserDetailsService {\n\n    private final UserRepository userRepository;\n\n    @Override\n    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {\n        log.debug(\"called. {}\", username);\n        User user = userRepository.findByName(username);\n        if (user == null) {\n            throw new UsernameNotFoundException(username);\n        }\n        return LoginUser.create(user);\n    }\n}<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u30e6\u30fc\u30b6\u60c5\u5831\u306e\u53d6\u5f97<\/h3>\n\n\n\n<p>UserRepository.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>@Repository\n@Slf4j\n@RequiredArgsConstructor\npublic class UserRepository {\n\n    private final UsersMapper usersMapper;\n\n    @Transactional(readOnly = true)\n    public User findByName(String name) {\n        List&lt;User&gt; userList = usersMapper.select(name);\n        if (userList.isEmpty()) {\n            return null;\n        } else {\n            return userList.get(0);\n        }\n    }\n}<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">sql\u30de\u30c3\u30d1\u30fc<\/h3>\n\n\n\n<p>UsersMapper.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>@Mapper\npublic interface UsersMapper {\n    List&lt;User&gt; select(String name);\n}<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">Sql\u5b9a\u7fa9<\/h3>\n\n\n\n<p>UsersMapper.xml<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f4f1f1\"><code>&lt;?xml version=\"1.0\" encoding=\"UTF-8\"?&gt;\n&lt;!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\"&gt;\n&lt;mapper namespace=\"jp.co.ois.hoge.springsecurity.mapper.UsersMapper\"&gt;\n\n    &lt;select id=\"select\" resultType=\"jp.co.ois.hoge.springsecurity.model.User\"&gt;\n        SELECT\n            id, name, password, role\n        FROM\n            users\n        &lt;where&gt;            \n        \t&lt;if test=\"name != null\"&gt;\n                AND name = #{name}\n            &lt;\/if&gt;\n        &lt;\/where&gt;\n        ORDER BY\n            id DESC\n    &lt;\/select&gt;\n&lt;\/mapper&gt;<\/code><\/pre>\n\n\n\n<p>User.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f8f8f8\"><code>@Data\npublic class User {\n\tprivate int id;\n\tprivate String name;\n\tprivate String password;\n\tprivate String role;\n}<\/code><\/pre>\n\n\n\n<p>LoginUser.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f7f7f7\"><code>@ToString\npublic class LoginUser implements UserDetails, CredentialsContainer {\n    private String password;\n    private final String username;\n    private final Collection&lt;? extends GrantedAuthority&gt; authorities;\n    @Getter\n    private final int id;\n\n    public LoginUser(String username, String password, Collection&lt;? extends GrantedAuthority&gt; authorities, int id) {\n        this.username = username;\n        this.password = password;\n        this.authorities = authorities;\n        this.id = id;\n    }\n\n    @Override\n    public void eraseCredentials() {\n        this.password = null;\n    }\n\n    @Override\n    public Collection&lt;? extends GrantedAuthority&gt; getAuthorities() {\n        return authorities;\n    }\n\n    @Override\n    public String getPassword() {\n        return password;\n    }\n\n    @Override\n    public String getUsername() {\n        return username;\n    }\n\n    public static LoginUser create(User user) {\n        List&lt;GrantedAuthority&gt; authorities = new ArrayList&lt;&gt;(1);\n        authorities.add(new SimpleGrantedAuthority(\"ROLE_\" + user.getRole()));\n        return new LoginUser(user.getName(), user.getPassword(), authorities, user.getId());\n    }\n\n    @Override\n    public boolean isAccountNonExpired() {\n        return true;\n    }\n}<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u30ed\u30b0\u30a4\u30f3\u753b\u9762<\/h3>\n\n\n\n<p>login.html<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f2efef\"><code>&lt;!DOCTYPE html&gt;\n&lt;!--\/* \u30ed\u30b0\u30a4\u30f3 *\/--&gt;\n&lt;html xmlns:th=\"https:\/\/www.thymeleaf.org\"\n      xmlns:sec=\"https:\/\/www.thymeleaf.org\/thymeleaf-extras-springsecurity6\"\n      lang=\"ja\"&gt;\n&lt;head&gt;\n    &lt;meta th:replace=\"~{common::meta_header}\"\/&gt;\n&lt;\/head&gt;\n&lt;body&gt;\n    &lt;header th:replace=\"~{common::header}\"\/&gt;\n\n    &lt;main class=\"mx-lg-4\"&gt;\n        &lt;section id=\"content\" class=\"lh-1\"&gt;\n            &lt;div class=\"col-md-4\"&gt;\n            &lt;h3&gt;\u30ed\u30b0\u30a4\u30f3&lt;\/h3&gt;\n            &lt;form method=\"POST\" th:action=\"@{\/login}\" th:object=\"${loginForm}\" &gt;\n                &lt;div class=\"col-12  mt-3\"&gt;\n                    &lt;label for=\"username\" th:text=\"#{auth.username}\" class=\"form-label\"&gt;\u30e6\u30fc\u30b6\u540d&lt;\/label&gt;\n                    &lt;input type=\"text\" th:field=\"*{username}\" class=\"form-control\" required&gt;\n                    &lt;span th:if=\"${#fields.hasErrors('username')}\" class=\"text-danger\" role=\"alert\"&gt;\n                        &lt;strong th:errors=\"*{username}\"&gt;\u30a8\u30e9\u30fc\u30e6\u30fc\u30b6\u540d&lt;\/strong&gt;\n                    &lt;\/span&gt;\n                &lt;\/div&gt;\n                &lt;div class=\"col-12 mt-3\"&gt;\n                    &lt;label for=\"password\" th:text=\"#{auth.password}\" class=\"form-label\"&gt;\u30d1\u30b9\u30ef\u30fc\u30c9&lt;\/label&gt;\n                    &lt;input type=\"password\" th:field=\"*{password}\" class=\"form-control\" required&gt;\n                    &lt;span th:if=\"${#fields.hasErrors('password')}\" class=\"text-danger\" role=\"alert\"&gt;\n                        &lt;strong th:errors=\"*{password}\"&gt;\u30a8\u30e9\u30fc\u30d1\u30b9\u30ef\u30fc\u30c9&lt;\/strong&gt;\n                    &lt;\/span&gt;\n                &lt;\/div&gt;\n                &lt;button th:text=\"#{auth.login}\" class=\" w-100 btn btn-primary btn-lg mt-4\" type=\"submit\"&gt;\u30ed\u30b0\u30a4\u30f3&lt;\/button&gt;\n            &lt;\/form&gt;\n            &lt;\/div&gt;\n        &lt;\/section&gt;\n    &lt;\/main&gt;\n\n    &lt;footer th:replace=\"~{common::footer}\"\/&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\">\u5171\u901a\u30d8\u30c3\u30c0\u30fc\u306a\u3069<\/h3>\n\n\n\n<p>common.html<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f6f0f0\"><code>&lt;!DOCTYPE html&gt;\n&lt;!--\/* \u5171\u901a\u30d5\u30e9\u30b0\u30e1\u30f3\u30c8\u5b9a\u7fa9 *\/--&gt;\n&lt;html xmlns:th=\"https:\/\/www.thymeleaf.org\"\n      xmlns:sec=\"https:\/\/www.thymeleaf.org\/thymeleaf-extras-springsecurity5\"\n      lang=\"ja\"&gt;\n&lt;head&gt;\n&lt;!-- \u5171\u901a\u30e1\u30bf --&gt;\n&lt;th:block th:fragment=\"meta_header\"&gt;\n    &lt;meta charset=\"utf-8\"&gt;\n    &lt;meta name=\"viewport\" content=\"width=device-width, initial-scale=1\"&gt;\n    &lt;meta name=\"csrf-token\" th:content=\"${_csrf.token}\"\/&gt;\n    &lt;title th:text=\"#{app.name}\"&gt;\u30bf\u30a4\u30c8\u30eb&lt;\/title&gt;\n    &lt;link rel=\"stylesheet\" th:href=\"@{\/static\/css\/bootstrap.min.css}\"&gt;\n    &lt;script th:src=\"@{\/static\/js\/bootstrap.bundle.min.js}\"&gt;&lt;\/script&gt;\n    &lt;script th:src=\"@{\/static\/js\/jquery-3.7.1.min.js}\"&gt;&lt;\/script&gt;\n&lt;\/th:block&gt;\n&lt;\/head&gt;\n&lt;body&gt;\n    &lt;!-- \u5171\u901a\u30d8\u30c3\u30c0\u30fc --&gt;\n    &lt;header class=\"bd-header bg-dark py-3 d-flex align-items-stretch border-bottom border-dark\"&gt;\n      &lt;div class=\"container-fluid d-flex align-items-center\"&gt;\n        &lt;h1 class=\"d-flex align-items-center fs-4 text-white mb-0\"&gt;\n          &lt;a class=\"logo\" th:href=\"@{\/}\"&gt;&lt;img th:src=\"@{\/static\/images\/ois_logo.jpg}\" height=\"30px\"&gt;&lt;\/a&gt;\n          &lt;div th:text=\"#{app.name}\"&gt;hoge-springsecurity&lt;\/div&gt;\n        &lt;\/h1&gt;\n        &lt;form id=\"logout-form\" th:action=\"@{\/logout}\" method=\"post\" class=\"ms-auto link-light\"&gt;\n          &lt;a id=\"logout\" th:text=\"#{auth.logout}\"&gt;Logout&lt;\/a&gt;\n        &lt;\/form&gt;\n      &lt;\/div&gt;\n      &lt;script&gt;\n      $(window).on(\"load\", function() {\n        $(\"#logout\").on('click', function(e) {\n            $('#logout-form').submit();\n        });\n      });\n      &lt;\/script&gt;\n    &lt;\/header&gt;\n\n    &lt;main&gt;\n    &lt;div class=\"container\"&gt;\n    &lt;\/div&gt;\n    &lt;\/main&gt;\n\n    &lt;!-- \u5171\u901a\u30d5\u30c3\u30bf\u30fc --&gt;\n    &lt;footer th:fragment=\"footer\"&gt;\n    &lt;\/footer&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<p>HogeController.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f4f4f4\"><code>@Controller\n@Slf4j\npublic class HogeController {\n    @GetMapping(\"\/\")\n    public String home() {\n        log.debug(\"called.\");\n        return \"redirect:\/top\";\n    }\n\n    @GetMapping(\"\/top\")\n    public String top(@AuthenticationPrincipal LoginUser user) {\n        log.debug(\"called. {}\", user);\n        return \"top\";\n    }\n}<\/code><\/pre>\n\n\n\n<p>top.java<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f3f2f2\"><code>&lt;!DOCTYPE html&gt;\n&lt;!--\/* \u30c8\u30c3\u30d7 *\/--&gt;\n&lt;html xmlns:th=\"https:\/\/www.thymeleaf.org\"\n      xmlns:sec=\"https:\/\/www.thymeleaf.org\/thymeleaf-extras-springsecurity6\"\n      lang=\"ja\"&gt;\n&lt;head&gt;\n    &lt;meta th:replace=\"~{common::meta_header}\"\/&gt;\n&lt;\/head&gt;\n&lt;body&gt;\n    &lt;header th:replace=\"~{common::header}\"\/&gt;\n\n    &lt;main class=\"mx-lg-4\"&gt;\n        &lt;section id=\"content\" class=\"lh-1\"&gt;\n            &lt;div class=\"col-md-4\"&gt;\n            &lt;h3&gt;\u30c8\u30c3\u30d7&lt;\/h3&gt;\n            &lt;\/div&gt;\n        &lt;\/section&gt;\n    &lt;\/main&gt;\n\n    &lt;footer th:replace=\"~{common::footer}\"\/&gt;\n&lt;\/body&gt;\n&lt;\/html&gt;<\/code><\/pre>\n\n\n\n<p>DB\u5b9a\u7fa9<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f9f3f3\"><code>-- \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u8a2d\u5b9a\nUSE hoge_db;\n\nCREATE TABLE `users` (\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\n  `name` varchar(100) NOT NULL,\n  `password` varchar(255) DEFAULT NULL,\n  `role` varchar(100) NOT NULL,\n  `created` timestamp NOT NULL DEFAULT current_timestamp(),\n  `updated` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),\n  PRIMARY KEY (`id`),\n  UNIQUE KEY `users_name_unique` (`name`)\n) comment 'users' ;\n\n-- \u521d\u671f\u30c7\u30fc\u30bf\nINSERT INTO users ( name ,password ,role ,created ,updated ) VALUES ( 'ois' ,'{bcrypt}$2a$10$L9EzxwQQXT3vKNeGUGXLOeW30QmcbFiwNu7RnvAXdCc.rojQRSYbu' ,'ADMIN' ,now() ,now() );<\/code><\/pre>\n\n\n\n<p>pom.xml<\/p>\n\n\n\n<pre class=\"wp-block-code has-background\" style=\"background-color:#f2f2f2\"><code>&lt;project xmlns=\"http:\/\/maven.apache.org\/POM\/4.0.0\" xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\"\n  xsi:schemaLocation=\"http:\/\/maven.apache.org\/POM\/4.0.0 http:\/\/maven.apache.org\/maven-v4_0_0.xsd\"&gt;\n    &lt;modelVersion&gt;4.0.0&lt;\/modelVersion&gt;\n    &lt;groupId&gt;jp.co.ois&lt;\/groupId&gt;\n    &lt;artifactId&gt;hoge-springsecurity&lt;\/artifactId&gt;\n    &lt;packaging&gt;war&lt;\/packaging&gt;\n    &lt;version&gt;1.0.0-SNAPSHOT&lt;\/version&gt;\n    &lt;name&gt;hoge-springsecurity&lt;\/name&gt;\n    &lt;url&gt;http:\/\/maven.apache.org&lt;\/url&gt;\n\n    &lt;parent&gt;\n        &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n        &lt;artifactId&gt;spring-boot-starter-parent&lt;\/artifactId&gt;\n        &lt;version&gt;2.7.18&lt;\/version&gt;\n    &lt;\/parent&gt;\n\n    &lt;properties&gt;\n        &lt;java.version&gt;17&lt;\/java.version&gt;\n        &lt;tomcat.version&gt;9.0.108&lt;\/tomcat.version&gt;\n    &lt;\/properties&gt;\n\n    &lt;dependencies&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-boot-starter-thymeleaf&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-boot-starter-web&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-boot-starter-security&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-boot-starter-validation&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.security&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-security-core&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.thymeleaf.extras&lt;\/groupId&gt;\n            &lt;artifactId&gt;thymeleaf-extras-springsecurity5&lt;\/artifactId&gt;\n        &lt;\/dependency&gt;\n\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.mybatis.spring.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;mybatis-spring-boot-starter&lt;\/artifactId&gt;\n            &lt;version&gt;2.3.2&lt;\/version&gt;\n        &lt;\/dependency&gt;\n\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.mariadb.jdbc&lt;\/groupId&gt;\n            &lt;artifactId&gt;mariadb-java-client&lt;\/artifactId&gt;\n            &lt;scope&gt;runtime&lt;\/scope&gt;\n        &lt;\/dependency&gt;\n\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.projectlombok&lt;\/groupId&gt;\n            &lt;artifactId&gt;lombok&lt;\/artifactId&gt;\n            &lt;scope&gt;provided&lt;\/scope&gt;\n        &lt;\/dependency&gt;\n\n        &lt;dependency&gt;\n            &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n            &lt;artifactId&gt;spring-boot-devtools&lt;\/artifactId&gt;\n            &lt;scope&gt;runtime&lt;\/scope&gt;\n            &lt;optional&gt;true&lt;\/optional&gt;\n        &lt;\/dependency&gt;\n    &lt;\/dependencies&gt;\n\n    &lt;build&gt;\n        &lt;finalName&gt;${artifactId}&lt;\/finalName&gt;\n        &lt;plugins&gt;\n            &lt;plugin&gt;\n                &lt;groupId&gt;org.springframework.boot&lt;\/groupId&gt;\n                &lt;artifactId&gt;spring-boot-maven-plugin&lt;\/artifactId&gt;\n            &lt;\/plugin&gt;\n        &lt;\/plugins&gt;\n    &lt;\/build&gt;\n&lt;\/project&gt;<\/code><\/pre>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">\uff13\u52d5\u4f5c\u78ba\u8a8d<\/h2>\n\n\n\n<p>\u8d77\u52d5\u3055\u305b\u305f\u5f8c\u3001\u4ee5\u4e0bURL\u3092\u958b\u304f<\/p>\n\n\n\n<p>http:\/\/localhost:9080\/hoge-springsecurity<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"404\" src=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf2-1024x404.png\" alt=\"\" class=\"wp-image-10011\" srcset=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf2-1024x404.png 1024w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf2-300x118.png 300w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf2-768x303.png 768w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf2.png 1076w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>\u30e6\u30fc\u30b6\u540d\uff1aois\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\uff1ayokohama \u3092\u5165\u529b\u3057\u3001\u30ea\u30bf\u30fc\u30f3\u30ad\u30fc\u62bc\u4e0b<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"251\" src=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf3-1024x251.png\" alt=\"\" class=\"wp-image-10012\" srcset=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf3-1024x251.png 1024w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf3-300x74.png 300w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf3-768x189.png 768w, https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u753b\u50cf3.png 1067w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<div style=\"height:100px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u4e00\u5f0f\u3092\u6dfb\u4ed8\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-thumbnail\"><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-content\/uploads\/2025\/10\/\u30b3\u30c6\u30c4-150x150.jpg\" alt=\"\u732b\u597d\u304d\u30ea\u30fc\u30de\u30f3\" class=\"wp-image-10023\"\/><figcaption class=\"wp-element-caption\"><a href=\"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/file\/hoge-springsecurity.zip\" title=\"\">hoge-springsecurity.zip<\/a><\/figcaption><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u3093\u306b\u3061\u308f\u3001\u732b\u597d\u304d\u30ea\u30fc\u30de\u30f3\u306e\u307b\u3052PG\u3067\u3059\u3002 \u30b3\u30c6\u30c4\uff08\u98fc\u3044\u732b\uff09\u304c\u65c5\u7acb\u3063\u3066\u3001\u3082\u3046\u3059\u3050\u4e00\u5e74\u306b\u306a\u308a\u307e\u3059\u3002\u6700\u8fd1\u3001\u5b50\u3069\u3082\u304c\u300e\u30b3\u30c6\u30c4\u306e\u97f3\u304c\u805e\u3053\u3048\u308b\u300f\u3068\u8a00\u3063\u3066\u3044\u3066\u2026\u3061\u3083\u3093\u3068\u899a\u3048\u3066\u3044\u3066\u304f\u308c\u308b\u306e\u306f\u5b09\u3057\u3044\u3067\u3059\u3002 \u4eca\u56de\u306f\u4ee5\u4e0b\u306e\u69cb\u6210\u3092\u8a66\u3057\u307e\u3059\u3002  [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10023,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"vkexunit_cta_each_option":"","footnotes":""},"categories":[6],"tags":[28,1169,1167,29,1166,1165,1168,1170],"class_list":["post-10006","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-engineer","tag-hoge","tag-java17","tag-logback","tag-mybatis","tag-spring-security-5","tag-springboot-2-7","tag-tomcat-9","tag-1170"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/10006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/comments?post=10006"}],"version-history":[{"count":8,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/10006\/revisions"}],"predecessor-version":[{"id":10024,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/posts\/10006\/revisions\/10024"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/media\/10023"}],"wp:attachment":[{"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/media?parent=10006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/categories?post=10006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ois-yokohama.co.jp\/oisblog2018\/wp-json\/wp\/v2\/tags?post=10006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}