SpringBoot简单登录注册

       1.创建工程 选择Spring Initalizr

 2.勾选SpringWeb

        
            org.springframework.boot
            spring-boot-starter-web
        
        
        
            mysql
            mysql-connector-java
            8.0.15
        
        
        
            com.alibaba
            druid
            1.1.21
        
    

create database demo charset=utf8;
create table student
(
    id       int auto_increment
        primary key,
    name     varchar(20) not null,
    password varchar(10) not null,
    age      int         not null,
    sex      char        not null,
    address  varchar(10) null
);
 INSERT INTO `student`(`id`, `name`, `password`, `age`, `sex`, `address`) VALUES (1, '陶喆', '', 20, '男', '陕西省西安市');
INSERT INTO `student`(`id`, `name`, `password`, `age`, `sex`, `address`) VALUES (2, '张三', '123456', 20, '男', '陕西省咸阳市');

• index.html

    
    


  注册页面
  注册
  登录界面
  登录

• reg.html

    
    


注册页面

    
    
    
    
    
    

• login.html

    
    


登录页面

    
    
    

package com.scy.boot111.domain;



public class Student {
    // 成员变量
    private Integer id;
    private String name;
    private String password;
    private Integer age;
    private String sex;
    private String address;

    // get、set
    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }
    // toString

    @Override
    public String toString() {
        return "Student{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", password='" + password + ''' +
                ", age=" + age +
                ", sex='" + sex + ''' +
                ", address='" + address + ''' +
                '}';
    }
}

package com.scy.boot111.utils;

import com.alibaba.druid.pool.DruidDataSource;

import java.sql.Connection;
import java.sql.SQLException;


public class DBUtils {
    private static DruidDataSource ds;
    static {
        //创建表示连接池的对象
        ds = new DruidDataSource();
        //设置链接数据库的信息
        ds.setUrl("jdbc:mysql://localhost:3306/empdb?characterEncoding=utf8&serverTimezone=Asia/Shanghai&useSSL=false");
        ds.setUsername("root");
        ds.setPassword("xxxxxxxx");//写自己的密码
        //设置初始连接数量
        ds.setInitialSize(3);
        //设置最大连接数量
        ds.setMaxActive(5);
    }
    public static Connection getConn() throws SQLException {
        //从连接池中获取链接  异常抛出
        Connection conn = ds.getConnection();
        return conn;
    }
}

package com.scy.boot111.controller;

import com.scy.boot111.domain.Student;
import com.scy.boot111.utils.DBUtils;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


@Controller
public class StuController {
    @RequestMapping("/student/reg")
    @ResponseBody
    public String reg(Student student) {
        System.out.println("student = " + student);
        // 获取连接
        try {
            Connection conn = DBUtils.getConn();
            String sql = "insert into student values(null,?,?,?,?,?)";
            PreparedStatement ps = conn.prepareStatement(sql);
            // 替换？
            ps.setString(1, student.getName());
            ps.setString(2, student.getPassword());
            ps.setInt(3, student.getAge());
            ps.setString(4, student.getSex());
            ps.setString(5, student.getAddress());
            ps.executeUpdate();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return "注册成功！！！";
    }

    @RequestMapping("/student/login")
    @ResponseBody
    public String login(Student student) {
        System.out.println("student = " + student);
        // 获取连接
        try {
            Connection conn = DBUtils.getConn();
            String sql = "select password from student where name=?";
            PreparedStatement ps = conn.prepareStatement(sql);
            // 替换？
            ps.setString(1, student.getName());
            ResultSet resultSet = ps.executeQuery();
            if (resultSet.next()) {
                // 获取数据库中的密码
                String password = resultSet.getString(1);
                if (student.getPassword().equals(password)) {
                    return "登录成功！！！";
                }
                    return "密码错误";
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return "用户不存在";
    }
}