怎样可以实现登录和注册

Question

package com.controller;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedSt
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
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 javax.servlet.http.HttpSession;

import com.Model.User;

/**

• Servlet implementation class User_Control

• /
  @WebServlet("/User_Control")
  public class User_Control extends HttpServlet {
  private static final long serialVersionUID = 1L;

  /**

  • @see HttpServlet#HttpServlet()
  • /
    public User_Control() {
    super();
    // TODO Auto-generated constructor stub
    }

  /**

  • @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  • /
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    response.setCharacterEncoding("utf-8");
    response.setContentType("text/html;charset=gb2312");
    PrintWriter out =response.getWriter();
    HttpSession session=request.getSession();
    String user=request.getParameter("user");
    String password=request.getParameter("password");
    try {

      Class.forName("com.mysql.jdbc.Driver");
      Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/shangcheng","root","");
      PreparedStatement stsm=conn.prepareStatement("select * from user where user=? and password=?");
      stsm.setString(1,user);
      stsm.setString(2,password);
      ResultSet rs =stsm.executeQuery();
      if(rs.next()) {
          User realUser =new User(user,password);
          session.setAttribute("user",realUser);
          RequestDispatcher req=request.getRequestDispatcher("a.jsp");
          req.forward(request,response);
          }
      else
          response.sendRedirect("Login.jsp");
    

    }catch(ClassNotFoundException | SQLException e){

      out.println(e);
    

    }
    }

  /**

  • @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  • /
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    doGet(request, response);
    }

}

package com.controller;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.servlet.RequestDispatcher;
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 javax.servlet.http.HttpSession;

import com.Model.User;

/**

• Servlet implementation class User_Register

• /
  @WebServlet("/User_Register")
  public class User_Register extends HttpServlet {
  private static final long serialVersionUID = 1L;

  /**

  • @see HttpServlet#HttpServlet()
  • /
    public User_Register() {
    super();
    // TODO Auto-generated constructor stub
    }

  /**

  • @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
  • /
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    response.setCharacterEncoding("utf-8");
    response.setContentType("text/html;charSet=utf-8");
    PrintWriter out = response.getWriter();
    HttpSession session = request.getSession();
    String user =request.getParameter("user1");
    String psd =request.getParameter("password1");
    String id=request.getParameter("ID");
    try { Class.forName("com.mysql.jdbc.Driver");

      Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/supermarket","root","");
      PreparedStatement pstmt =  conn.prepareStatement("insert into user(user,password,id) values(?,?,?)");
      pstmt.setString(1, user);
      pstmt.setString(2, psd);
      pstmt.setString(3, id);
      int rs = pstmt.executeUpdate();
      if(rs>0){
          User rUser =new User(user,psd,id);
          session.setAttribute("register", rUser);
          RequestDispatcher req = request.getRequestDispatcher("Login.jsp");
          req.forward(request, response);
      }else{
          response.sendRedirect("register.jsp");
      }
    

    } catch (ClassNotFoundException e) {

      // TODO Auto-generated catch block
      e.printStackTrace();
    

    } catch (SQLException e) {

      // TODO Auto-generated catch block
      e.printStackTrace();
    

    }

  }

  /**

  • @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
  • /
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    // TODO Auto-generated method stub
    doGet(request, response);
    }

}

Answer 1

参考

java通过mysql验证登录注册范例_51CTO博客_mysql用户登录 java通过mysql验证登录注册范例，packagec.test;importjava.awt.Container;importjava.sql.*;importjava.util.*;importjavax.swing.RootPaneContainer;publicclassClient{/***用以实现用户的注册和登录*/privatestaticStringusern https://blog.51cto.com/u_15473875/4919343