JavaWeb-SpringBoot_使用MySQL数据库实现用户管理_demo

　　使用Gradle编译项目　　传送门

　　项目已托管到Github上　　传送门　

SpringBoot使用MySQL实现

　　实现功能：普通用户注册、普通用户登录、管理员通过edit-user页面和show-all-user页面对用户信息的修改

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout">

<head>
<meta charset="utf-8">

<link rel="stylesheet" href="bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="css/login.css" />
<script src="js/jquery.min.js"></script>
<script src="bootstrap/js/bootstrap.min.js"></script>

<script>
    $(document).ready(function() {
        //打开会员登录 
        $("#Login_start_").click(function() {
            $("#regist_container").hide();
            $("#_close").show();
            $("#_start").animate({
                left : '350px',
                height : '520px',
                width : '400px'
            }, 500, function() {
                $("#login_container").show(500);
                $("#_close").animate({
                    height : '40px',
                    width : '40px'
                }, 500);
            });
        });
        //打开会员注册
        $("#Regist_start_").click(function() {
            $("#login_container").hide();
            $("#_close").show();
            $("#_start").animate({
                left : '350px',
                height : '520px',
                width : '400px'
            }, 500, function() {
                $("#regist_container").show(500);
                $("#_close").animate({
                    height : '40px',
                    width : '40px'
                }, 500);
            });
        });
        //关闭
        $("#_close").click(function() {

            $("#_close").animate({
                height : '0px',
                width : '0px'
            }, 500, function() {
                $("#_close").hide(500);
                $("#login_container").hide(500);
                $("#regist_container").hide(500);
                $("#_start").animate({
                    left : '0px',
                    height : '0px',
                    width : '0px'
                }, 500);
            });
        });
        //去 注册
        $("#toRegist").click(function() {
            $("#login_container").hide(500);
            $("#regist_container").show(500);
        });
        //去 登录
        $("#toLogin").click(function() {
            $("#regist_container").hide(500);
            $("#login_container").show(500);
        });
    });
</script>
</head>

<body style="background-color: #DCDCDC;">

    <a id="Login_start_" class="btn btn-danger" style=" 100px; height: 40px; border-radius: 0;">登陆</a>
    <a id="Regist_start_" class="btn btn-success" style=" 100px; height: 40px; border-radius: 0;">注册</a>

    <!-- 会员登录  -->
    <!--<div id='Login_start' style="position: absolute;" >-->
    <div id='_start'>
        <div id='_close' style="display: none;">
            <span class="glyphicon glyphicon-remove"></span>
        </div>
        <br />
        <!--登录框-->
        <div id="login_container">
            <div id="lab1">
                <span id="lab_login">会员登录</span>
                <span id="lab_toRegist">
                    &emsp;还没有账号&nbsp;
                    <span id='toRegist' style="color: #EB9316; cursor: pointer;">立即注册</span>
                </span>
            </div>
            <div style=" 330px;">
                <span id="lab_type1">手机号/账号登陆</span>
            </div>
            <div id="form_container1">
                <br />
                <form action="" th:action="@{~/login.action}">
                    <input type="text" class="form-control" placeholder="手机号/用户名" id="login_number" value="Gary" name="username"/>
                    <input type="password" class="form-control" placeholder="密码" id="login_password" name="password" />
                    <input type="submit" value="登录" class="btn btn-success" id="login_btn" />
                </form>
                <span id="rememberOrfindPwd">
                    <span>
                        <input id="remember" type="checkbox" style="margin-bottom: -1.5px;" />
                    </span>
                    <span style="color: #000000"> 记住密码&emsp;&emsp;&emsp;&emsp; </span>
                    <span style="color: #000000"> 忘记密码 </span>
                </span>
            </div>

            <div style="display: block;  330px;">
                <span id="lab_type2">使用第三方直接登陆</span>
            </div>
            <div style=" 330px; height: 100px; border-bottom: 1px solid #FFFFFF;">
                <br />
                <button id="login_QQ" type="button" class="btn btn-info">
                    <img src="img/qq32.png" style=" 20px; margin-top: -4px;" />
                    &emsp;QQ登录
                </button>
                <button id="login_WB" type="button" class="btn btn-danger">
                    <img src="img/sina32.png" style=" 20px; margin-top: -4px;" />
                    &emsp;微博登录
                </button>
            </div>
        </div>
        <!-- 会员注册 -->
        <div id='regist_container' style="display: none;">
            <div id="lab1">
                <span id="lab_login">会员注册</span>
                <span id="lab_toLogin">
                    &emsp;已有账号&nbsp;
                    <span id='toLogin' style="color: #EB9316; cursor: pointer;">立即登录</span>
                </span>
            </div>

            <form action="" th:action="@{~/register.action}">
                <div id="form_container2" style="padding-top: 25px;">

                    <input type="text" class="form-control" value="Gary" placeholder="用户名" id="regist_account" name="username" />
                    <input type="password" class="form-control" placeholder="密码" id="regist_password1" name="password" />
                    <input type="password" class="form-control" placeholder="确认密码" id="regist_password2" />
                    <input type="text" class="form-control" placeholder="手机号" id="regist_phone" name="telephone" />
                    <input type="text" class="form-control" placeholder="验证码" id="regist_vcode" />
                    <!--<button id="getVCode" type="button" class="btn btn-success" >获取验证码</button>-->
                    <input id="getVCode" type="button" class="btn btn-success" value="点击发送验证码" onclick="sendCode(this)" />

                </div>
                <input type="submit" value="注册" class="btn btn-success" id="regist_btn" />
            </form>
        </div>
    </div>

</body>
<script type="text/javascript">
    var clock = '';
    var nums = 30;
    var btn;
    function sendCode(thisBtn) {
        btn = thisBtn;
        btn.disabled = true; //将按钮置为不可点击
        btn.value = '重新获取（' + nums + '）';
        clock = setInterval(doLoop, 1000); //一秒执行一次
    }

    function doLoop() {
        nums--;
        if (nums > 0) {
            btn.value = '重新获取（' + nums + '）';
        } else {
            clearInterval(clock); //清除js定时器
            btn.disabled = false;
            btn.value = '点击发送验证码';
            nums = 10; //重置时间
        }
    }

    $(document).ready(function() {
        $("#login_QQ").click(function() {
            alert("暂停使用！");
        });
        $("#login_WB").click(function() {
            alert("暂停使用！");
        });
    });
</script>

</html>

index.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>Hello Gary!</h1>
</body>
</html>

welcome.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout">

<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

    <form action="" th:action="@{~/edit.action}" method="post">
        
        <input name="id" type="hidden" th:value="${user.id}">
        用户名：
        <input name="username" type="text" th:value="${user.username}">
        密码：
        <input name="password" type="text" th:value="${user.password}">
        电话：
        <input name="telephone" type="text" th:value="${user.telephone}">
        
        <input type="submit" value="提交">
        
    </form>
</body>
</html>

edit-user.html

<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org" xmlns:layout="http://www.ultraq.net.nz/thymeleaf/layout">

<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>

    <table border="1px">
        <tr>
            <th>用户名</th>
            <th>密码</th>
            <th>电话</th>
            <th>编辑</th>
        </tr>

        <tr th:each="user : ${userList}">
            <th th:text="${user.username}">132</th>
            <th th:text="${user.password}">123</th>
            <th th:text="${user.telephone}">123</th>
            <th>
                <a th:href="@{'~/toEdit/'+${user.id}}">修改</a>
            </th>
        </tr>

    </table>


</body>
</html>

show-all-user.html

#Thymeleaf的编码
spring.thymeleaf.encoding=UTF-8

#热部署静态文件
spring.thymeleaf.cache=false

#使用HTML5的标准
spring.thymeleaf.mode=HTML5

#使用h2的控制台
spring.h2.console.enable=true

#DataSource
spring.datasource.url=jdbc:mysql:///garyuser
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#配置JPA
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update

application.properties

package com.Gary.GaryuserDemo;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class GaryuserDemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(GaryuserDemoApplication.class, args);
    }

}

GaryuserDemoApplication.java

package com.Gary.GaryuserDemo.controller;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import com.Gary.GaryuserDemo.domain.User;
import com.Gary.GaryuserDemo.service.UserServiceImpl;

@RestController
public class UserController {

    @Autowired
    private UserServiceImpl userServiceImpl;
    
    @RequestMapping("/")
    public ModelAndView index() {
        return new ModelAndView("/index.html");
    }
    
    @RequestMapping("/register.action")
    public ModelAndView register(User user) {
        userServiceImpl.save(user);
        return new ModelAndView("redirect:/");
    }
    
    @RequestMapping("/login.action")
    public ModelAndView login(User user) {
        boolean success = userServiceImpl.login(user);
        if(success) {
            return new ModelAndView("/welcome.html");
        }else {
            return new ModelAndView("redirect:/");
        }
    }
    
    @RequestMapping("/show.action")
    public ModelAndView show(Model model) {
        
        List<User> userList = userServiceImpl.findAll();
        //把userList放入到模型中
        model.addAttribute("userList",userList);
        return new ModelAndView("/show-all-user.html","userModel",model);
    }
    
    @RequestMapping("/toEdit/{id}")
    public ModelAndView toEdit(@PathVariable("id")Long id,Model model) {
        //根据ID得到用户
        User user = userServiceImpl.findById(id);
        //将用户放入到model中
        model.addAttribute("user",user);
        return new ModelAndView("/edit-user.html","userModel",model);
    }
    
    @RequestMapping("/edit.action")
    public ModelAndView Edit(User user) {
        userServiceImpl.save(user);
        return new ModelAndView("redirect:/show.action");
    }
    
}

UserController.java

package com.Gary.GaryuserDemo.domain;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {
    
    
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String password;
    private String telephone;
    
    protected User() {
        
    }
    
    public User(Long id,String username,String password,String telephone) {
        this.id=id;
        this.username=username;
        this.password=password;
        this.telephone=telephone;
    }
    
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getTelephone() {
        return telephone;
    }
    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

}

User.java

package com.Gary.GaryuserDemo.repository;

import org.springframework.data.repository.CrudRepository;

import com.Gary.GaryuserDemo.domain.User;

public interface UserRepository extends CrudRepository<User,Long>{

    User findByUsernameAndPassword(String username, String password);

}

UserRepository.java

package com.Gary.GaryuserDemo.service;

import java.util.List;

import com.Gary.GaryuserDemo.domain.User;


public interface UserService {
    void save(User user);
    boolean login(User user);
    List<User> findAll();
    User findById(Long id);
}

UserService.java

package com.Gary.GaryuserDemo.service;

import java.util.List;
import java.util.Optional;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.Gary.GaryuserDemo.domain.User;
import com.Gary.GaryuserDemo.repository.UserRepository;


@Service
public class UserServiceImpl implements UserService{

    @Autowired
    private UserRepository userRepository;
    
    
    @Override
    public void save(User user) {
        userRepository.save(user);
        
    }

    @Override
    public boolean login(User user) {
        User loginUser = userRepository.findByUsernameAndPassword(user.getUsername(),user.getPassword());
        
        return loginUser==null?false:true;
    }

    @Override
    public List<User> findAll() {
        Iterable<User> list = userRepository.findAll();
        return (List<User>)list;
    }

    @Override
    public User findById(Long id) {
         Optional<User> user = userRepository.findById(id);
        return user.get();
    }




}

UserServiceImpl.java

　　目录结构

　　各个功能模块的默认配置文件application.properties

#Thymeleaf的编码
spring.thymeleaf.encoding=UTF-8

#热部署静态文件
spring.thymeleaf.cache=false

#使用HTML5的标准
spring.thymeleaf.mode=HTML5

#使用h2的控制台
spring.h2.console.enable=true

#DataSource
spring.datasource.url=jdbc:mysql:///garyuser
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

#配置JPA
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update

实现过程分五步

　　1、用户注册功能
　　2、用户登录功能
　　3、管理员查询用户界面功能
　　4、用户信息回显功能
　　5、管理员修改用户信息功能

　　controller控制层

　　service业务逻辑层

　　repository持久层

　　User实体　　设置主键ID自增

    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String password;
    private String telephone;

package com.Gary.GaryuserDemo.domain;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;

@Entity
public class User {
    
    
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Long id;
    private String username;
    private String password;
    private String telephone;
    
    protected User() {
        
    }
    
    public User(Long id,String username,String password,String telephone) {
        this.id=id;
        this.username=username;
        this.password=password;
        this.telephone=telephone;
    }
    
    public Long getId() {
        return id;
    }
    public void setId(Long id) {
        this.id = id;
    }
    public String getUsername() {
        return username;
    }
    public void setUsername(String username) {
        this.username = username;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getTelephone() {
        return telephone;
    }
    public void setTelephone(String telephone) {
        this.telephone = telephone;
    }

}

User.java

　　controller层获接收用户和管理员请求并做相应的回应

    //访问首页面
    @RequestMapping("/")
    public ModelAndView index()

    //用户注册
    @RequestMapping("/register.action")
    public ModelAndView register(User user)

    //用户登录
    @RequestMapping("/login.action")
    public ModelAndView login(User user)

    //展示用户信息
    @RequestMapping("/show.action")
    public ModelAndView show(Model model)

    //管理员修改用户的信息
    @RequestMapping("/toEdit/{id}")
    public ModelAndView toEdit(@PathVariable("id")Long id,Model model)

    //将修改的用户信息重新存储到数据库中
    @RequestMapping("/edit.action")
    public ModelAndView Edit(User user)

1、用户注册功能

　　注册表单：用户点击注册后发送请求到"@{~/register.action}"

<form action="" th:action="@{~/register.action}">
                <div id="form_container2" style="padding-top: 25px;">

                    <input type="text" class="form-control" value="Gary" placeholder="用户名" id="regist_account" name="username" />
                    <input type="password" class="form-control" placeholder="密码" id="regist_password1" name="password" />
                    <input type="password" class="form-control" placeholder="确认密码" id="regist_password2" />
                    <input type="text" class="form-control" placeholder="手机号" id="regist_phone" name="telephone" />
                    <input type="text" class="form-control" placeholder="验证码" id="regist_vcode" />
                    <!--<button id="getVCode" type="button" class="btn btn-success" >获取验证码</button>-->
                    <input id="getVCode" type="button" class="btn btn-success" value="点击发送验证码" onclick="sendCode(this)" />

                </div>
                <input type="submit" value="注册" class="btn btn-success" id="regist_btn" />
            </form>

　　用户提交表单后，请求提交到controller层去接收"@{~/register.action}"请求

    @RequestMapping("/register.action")
    public ModelAndView register(User user) {
        userServiceImpl.save(user);
        return new ModelAndView("redirect:/");
    }

　　controller层接收到请求后由service去调用save()方法

    @Autowired
    private UserRepository userRepository;
    
    
    @Override
    public void save(User user) {
        userRepository.save(user);    
    }

　　service层去调用repository层save()方法

　　save()方法由CrudRepository()接口自动封装好(本身提供增删改查功能)

2、用户登录功能

　　登录表单：用户点击登录后发送请求到"@{~/register.action}"

    <form action="" th:action="@{~/register.action}">
                <div id="form_container2" style="padding-top: 25px;">

                    <input type="text" class="form-control" value="Gary" placeholder="用户名" id="regist_account" name="username" />
                    <input type="password" class="form-control" placeholder="密码" id="regist_password1" name="password" />
                    <input type="password" class="form-control" placeholder="确认密码" id="regist_password2" />
                    <input type="text" class="form-control" placeholder="手机号" id="regist_phone" name="telephone" />
                    <input type="text" class="form-control" placeholder="验证码" id="regist_vcode" />
                    <!--<button id="getVCode" type="button" class="btn btn-success" >获取验证码</button>-->
                    <input id="getVCode" type="button" class="btn btn-success" value="点击发送验证码" onclick="sendCode(this)" />

                </div>
                <input type="submit" value="注册" class="btn btn-success" id="regist_btn" />
            </form>

　　Controller层处理用户的登录逻辑，判断用户输入账号密码是否正确，输入正确则跳转到welcome.html页面，否则重定向到index.html页面

    @RequestMapping("/login.action")
    public ModelAndView login(User user) {
        boolean success = userServiceImpl.login(user);
        if(success) {
            return new ModelAndView("/welcome.html");
        }else {
            return new ModelAndView("redirect:/");
        }
    }

　　controller层接收到请求后由service去调用login()方法

    @Override
    public boolean login(User user) {
        User loginUser = userRepository.findByUsernameAndPassword(user.getUsername(),user.getPassword());
        
        return loginUser==null?false:true;
    }

　　service层去调用repository层findByUsernameAndPassword()方法,findByUsernameAndPassword()方法继承CrudRepository()接口

ublic interface UserRepository extends CrudRepository<User,Long>{

    User findByUsernameAndPassword(String username, String password);

}

3、管理员查询用户界面功能

　　管理员想要查看数据库中的信息得去发送show.action请求，userList得到数据库中用户的信息后跳转至show-all-user.html页面

    @RequestMapping("/show.action")
    public ModelAndView show(Model model) {
        
        List<User> userList = userServiceImpl.findAll();
        //把userList放入到模型中
        model.addAttribute("userList",userList);
        return new ModelAndView("/show-all-user.html","userModel",model);
    }

    <table border="1px">
        <tr>
            <th>用户名</th>
            <th>密码</th>
            <th>电话</th>
            <th>编辑</th>
        </tr>

        <tr th:each="user : ${userList}">
            <th th:text="${user.username}">132</th>
            <th th:text="${user.password}">123</th>
            <th th:text="${user.telephone}">123</th>
            <th>
                <a th:href="@{'~/toEdit/'+${user.id}}">修改</a>
            </th>
        </tr>

4、用户信息回显功能

　　controller层接收管理员toEdit请求

@RequestMapping("/toEdit/{id}")
    public ModelAndView toEdit(@PathVariable("id")Long id,Model model) {
        //根据ID得到用户
        User user = userServiceImpl.findById(id);
        //将用户放入到model中
        model.addAttribute("user",user);
        return new ModelAndView("/edit-user.html","userModel",model);
    }

　　Optional 用来作为用户存储的容器　　传送门

    @Override
    public List<User> findAll() {
        Iterable<User> list = userRepository.findAll();
        return (List<User>)list;
    }

    @Override
    public User findById(Long id) {
         Optional<User> user = userRepository.findById(id);
        return user.get();
    }

5、管理员修改用户信息功能

　　controller层去修改用户信息并重新刷新数据库中User信息

    @RequestMapping("/edit.action")
    public ModelAndView Edit(User user) {
        userServiceImpl.save(user);
        return new ModelAndView("redirect:/show.action");
    }

　　edit-user.html去修改用户页面信息

<form action="" th:action="@{~/edit.action}" method="post">
        
        <input name="id" type="hidden" th:value="${user.id}">
        用户名：
        <input name="username" type="text" th:value="${user.username}">
        密码：
        <input name="password" type="text" th:value="${user.password}">
        电话：
        <input name="telephone" type="text" th:value="${user.telephone}">
        
        <input type="submit" value="提交">
        
    </form>

(如需转载学习，请标明出处)

相关阅读:
GD32E507移植FreeRTOS
FreeRTOS学习笔记——任务基础知识
 FreeRTOS学习笔记——系统配置
 am335x WG209 wifi模块自动配置的脚本
 树莓派学习笔记——Systemd进程启动
 am335x WG209 wifi模块驱动移植
 树莓派学习笔记——搭建Samba服务端
 树莓派学习笔记——内核编译
 一个复制文件的Shell脚本
 Makefile学习笔记——Makefile通配符的使用
原文地址：https://www.cnblogs.com/1138720556Gary/p/10329753.html