Maven+Spring Boot：一站式教程：从零开始注册登录功能-优快云博客

一. 创建maven工程选择通过maven-archetype-webapp骨架创建工程

二. 给工程添加java和resources文件夹

三. 配置Tomcat 点击绿色扳手旁边Add Config.... 点击灯泡

四. 在工程设置页面中的facets里面打钩 ,在工程设置页面的models->dependencies添加Tomcat相关jar包

1.Ctrl + Alt + Shift + S 打开Project Structure... (或者点击 File ->Project Structure... )

五. 在webapp下面创建注册页面 reg.html 在页面中准备form表单提交地址为reg 请求方式改成post , 两个文本输入框和一个提交按钮

HTML页面代码段

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="UTF-8">
        <title>注册</title>
    </head>
    <body>
    <form action="reg" method="post">
        <input type="text" name="username">
        <input type="password" name="password">
        <input type="submit" value="注册">
    </form>
    </body>
</html>

六. 创建ServletReg, 拦截路径为 /reg 在doPost里面先设置字符集获取传递过来的用户名和密码

也可在域名包下快捷键 Alt + insert 直接拼写 Servlet

七.将 MySQL坐标和数据库连接池坐标复制到新工程的pom.xml里面

     <!-- 连接MySQL数据库的依赖 -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.15</version>
    </dependency>
    <!-- 数据库连接池 -->
    <dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>druid</artifactId>
      <version>1.1.21</version>
    </dependency>

添加完成后点击右上角更新maven

八. 在域名包下添加DBUtils.java文件内容如下并将下载好的jdbc.properties的压缩包解压后粘贴到resources文件夹下

package com.baidu;

import com.alibaba.druid.pool.DruidDataSource;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;

public class DBUtils {
    private static DruidDataSource druidDataSource;
    static{
        //通过属性对象读取配置文件数据 替换掉下面写死的内容
        Properties properties = new Properties();
        InputStream inputStream = cn.tedu.DBUtils.class.getClassLoader().getResourceAsStream("jdbc.properties");
        try {
            properties.load(inputStream);
        } catch (IOException e) {
            e.printStackTrace();
        }
        String driver = properties.getProperty("db.driver");
        String url = properties.getProperty("db.url");
        String username = properties.getProperty("db.username");
        String password = properties.getProperty("db.password");
        String maxActive = properties.getProperty("db.maxActive");
        String initialSize = properties.getProperty("db.initialSize");
        //创建数据库连接池
       druidDataSource = new DruidDataSource();
        //设置数据库连接信息
        druidDataSource.setDriverClassName(driver);
        druidDataSource.setUrl(url);
        druidDataSource.setUsername(username);
        druidDataSource.setPassword(password);
        druidDataSource.setMaxActive(Integer.parseInt(maxActive));//设置最大连接数量
        druidDataSource.setInitialSize(Integer.parseInt(initialSize));//设置初始连接数量
    }
    public static Connection getconnection() throws Exception {
        Connection connection = druidDataSource.getConnection();//获取链接 异常抛出
        return connection;
    }
}

九. 创建ServletReg, 拦截路径为 /reg 在doPost里面先设置字符集获取传递过来的用户名和密码

package com.tedu;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;


@WebServlet(name = "ServletReg",urlPatterns = "/reg")
public class ServletReg extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //设置字符集格式
        request.setCharacterEncoding("utf-8");
        //获取参数
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        response.setContentType("text/html;charset=utf-8");
        //获取链接
        try(Connection connection = DBUtils.getconnection()){
            String sql = "insert into user values(null,?,?)";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,username);
            preparedStatement.setString(2,password);
            preparedStatement.executeUpdate();
            //给浏览器返回数据
            response.setContentType("text/html;charset=utf-8");
            PrintWriter printWriter = response.getWriter();
            printWriter.println("注册成功!");
            printWriter.close();
        }catch (Exception e){
            e.printStackTrace();
        }
    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

    }
}