servlet+jsp+mysql+jdbc实现注册登录

hexionly

已于 2023-01-30 14:36:53 修改

阅读量2.1k

点赞数 9

分类专栏： servlet 文章标签： java servlet mysql

于 2019-12-08 15:18:41 首次发布

本文链接：https://blog.csdn.net/hsx18787462705/article/details/103444953

版权

servlet 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

此处我就只贴出java代码和jsp代码，数据库表自己根据Regist.java去创建

1、首先，我先把前端代码贴出来，这个比较简单，没什么

注册（regist.jsp）

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>注册界面</title>

<link rel="icon" type="image/x-icon" href="images/logo01.jpg">
<link rel="stylesheet" type="text/css" href="css/regist.css">

<script type="text/javascript" src="/js/regist.js"></script>

</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
	<form action="sign" method="post" onsubmit="return check(this)">
	<img src="images/logo01.jpg">
	<p>新用户请注册</p>

	<hr size="3px" color="#666666">
	
	<div id="div01">
		<table id="tab">
			<tr>
				<td><input type="text" name="username" id="username" placeholder="请输入用户名（字母）"></td>
			</tr>
			<tr>
				<td><input type="password" name="password" id="password1" placeholder="请输入密码"></td>
			</tr>
			<tr>
				<td><input type="password" name="password" id="password2" placeholder="请再次输入密码"></td>
			</tr>
			<tr>
				<td><input type="radio" name="gender" value="man"/>男&nbsp;&nbsp;&nbsp;&nbsp;
					<input type="radio" name="gender" value="woman"/>女</td>
			</tr>
			<tr>
				<td><input type="email" name="email" id="email" placeholder="请输入email"></td>
			</tr>
			<tr>
				<td><input type="radio" name="type" value="user"/>用户&nbsp;&nbsp;&nbsp;&nbsp;
					<input type="radio" name="type" value="admin"/>管理员</td>
			</tr>
			<tr>
				<td><input type="text" name="phone" id="phone" placeholder="请输入电话"></td>
			</tr>
		</table>
		<input type="submit" name="submit" id="submit" value="注册">
		&nbsp;&nbsp;&nbsp;&nbsp;<a href="login.jsp">已有账号></a>
	</div>
	</form>
</body>
</html>

登录（login.jsp）

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>登录界面</title>

<link rel="icon" type="image/x-icon" href="images/logo01.jpg">

<link rel="stylesheet" href="css/login.css">

<script type="text/javascript" src="/js/login.js"></script>

</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
	<form action="login" method="post" onsubmit="return check(this)">
	<img src="images/logo01.jpg">
	<p>欢迎登录</p>


	<hr size="3px" color="#666666">	
		<div id="div02">
			<table id="tab">
				<tr>
					<td><input type="text" name="username" id="username" placeholder="用户名" value=""
					 onfocus="if(this.value=='Your name') this.value='';"></td>
				</tr>
				<tr>
					<td><input type="password" name="password" id="password" placeholder="密码" value=""
					onfocus="if(this.value=='Your Password') this.value='';"></td>
				</tr>
			</table>
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<input type="checkbox" name="checkbox" value="checkbox"/>记住用户密码
			&nbsp;&nbsp;&nbsp;
			<input type="checkbox" name="checkbox" value="checkbox"/>自动登录&nbsp; <br/>
			<input type="submit" name="submit" id="submit" value="登录"><br>
			<input type="button" name="but" id="but" value="返回" onclick="javascript:window.location.href='index.jsp'">
			<br><a id="aa" href="regist.jsp">请注册</a>
		</div>
	</form>
</body>
</html>

主意：登录功能中的记住密码功能尚未投入使用

2、接下来的就是java代码

首先来个Regist.java

public class Regist {

	private String username;
	private String password;
	private String gender;
	private String email;
	private String type;
	private String phone;
	
	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 getGender() {
		return gender;
	}
	public void setGender(String gender) {
		this.gender = gender;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	
	public String getType() {
		return type;
	}
	public void setType(String type) {
		this.type = type;
	}
	public String getPhone() {
		return phone;
	}
	public void setPhone(String phone) {
		this.phone = phone;
	}
}

接下来就是登录和注册的Servlet代码

RegistServlet.java

package com.hsx.servlet;

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

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class RegistServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;
	
	public RegistServlet() {
		super();
	}
	
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {	
		doPost(req, resp);
	}
	
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		resp.setContentType("text/html;charset=UTF-8");
		
//		req.getRequestDispatcher("regist_insert.jsp").forward(req, resp);
		
		String username = req.getParameter("username");
		String password = req.getParameter("password");
		String gender = req.getParameter("gender");
		String email = req.getParameter("email");
		String type = req.getParameter("type");
		String phone = req.getParameter("phone");
		
		Connection connection = null;
		PreparedStatement ps = null;
		try{
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			connection = DriverManager.getConnection("jdbc:mysql://localhost/(改为自己的数据库名)?user=（自己的数据库用户名）&password=（自己数据库密码）");
	
			String sql = "insert into user(username,password,gender,email,type,phone) values(?,?,?,?,?,?)";
			ps = connection.prepareStatement(sql);
			ps.setString(1, username);
			ps.setString(2, password);
			ps.setString(3,gender);
			ps.setString(4,email);
			ps.setString(5,type);
			ps.setString(6, phone);
			int count = ps.executeUpdate();
			
			if(count != 0){
				req.getRequestDispatcher("login.jsp").forward(req, resp);
				
			}else{
				req.getRequestDispatcher("regist_fail.jsp").forward(req, resp);
				
			}
		}catch(Exception e){
			e.printStackTrace();
		}finally{
			if(connection != null){
				try {
					connection.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
			if(ps != null){
				try {
					ps.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}	
	}
}

LoginServlet.java

package com.hsx.servlet;

import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

public class LoginServlet extends HttpServlet {

	private static final long serialVersionUID = 1L;
	
	public LoginServlet() {
		super();
	}
	
	protected void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		doPost(req, resp);
	}
	
	protected void doPost(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		req.setCharacterEncoding("UTF-8");
		resp.setContentType("text/html;charset=UTF-8");
		
//		String result = "";
		
		//从前端页面获取用户名和密码
		String username = req.getParameter("username");
		String password = req.getParameter("password");
		
		/*
		 * //判断用户名是否为空 if (username == "" || username == null) { try { result =
		 * "请输入用户名"; req.setAttribute("message", result);
		 * resp.sendRedirect("login.jsp"); return;
		 * 
		 * }catch (Exception e) { e.printStackTrace(); } }
		 * 
		 * //判断密码是否为空 if(password == "" || password == null) { try { result = "请输入密码";
		 * req.setAttribute("message", result); resp.sendRedirect("login.jsp"); return;
		 * }catch (Exception e) { e.printStackTrace(); } }
		 */
		
		//登记jdbc驱动
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			System.out.println("驱动启动失败");
			e.printStackTrace();
		}
		
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		//连接数据库
		try {
			conn = DriverManager.getConnection("jdbc:mysql://localhost/xxxx?user=root&password=12xxxx");
			stmt = conn.createStatement();
			
			String sql = "select * from user where username = '"+username+"' and password = '"+password+"'";
			rs = stmt.executeQuery(sql);
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		HttpSession session = req.getSession();
		session.setAttribute("username", username);
		
		try {
			if (rs.next()) {
				session.setAttribute("gender", rs.getString("gender"));
				session.setAttribute("email", rs.getObject("email"));
				session.setAttribute("type", rs.getObject("type"));
				session.setAttribute("phone", rs.getObject("phone"));
				
				resp.sendRedirect("index.jsp");
				return;
			}else {
				session.setAttribute("message", "用户名和密码不匹配");
				resp.sendRedirect("login_fail.jsp");
				return;
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}

最后在贴出web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 		 xmlns="http://xmlns.jcp.org/xml/ns/javaee"
         xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee
                             http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
         id="WebApp_ID"
         version="4.0">
         
  <display-name>HsxWorkSystem</display-name>
  <welcome-file-list>
    <welcome-file>login.jsp</welcome-file>
  </welcome-file-list>
  
  <servlet>
  	<servlet-name>sign</servlet-name>
  	<servlet-class>com.hsx.servlet.RegistServlet</servlet-class>
  </servlet>
  <servlet-mapping>
   <servlet-name>sign</servlet-name>
   <url-pattern>/sign</url-pattern>
  </servlet-mapping>
  
    <servlet>
  	<servlet-name>login</servlet-name>
  	<servlet-class>com.hsx.servlet.LoginServlet</servlet-class>
  </servlet>
  <servlet-mapping>
  	<servlet-name>login</servlet-name>
  	<url-pattern>/login</url-pattern>
  </servlet-mapping>
</web-app>

基本的代码就是这样，不是很完美，前端的修饰根据你自己的喜好去弄，这里我就不贴出来了

3、看看成品展示

运行进来就是要求你登录，你可以选择登录，没有注册过选择注册

如若注册成功跳到登录界面，失败就跳到另一注册失败界面

下边我把主页面代码贴出来（index.jsp）

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>商城主页</title>

<link rel="icon" type="image/x-icon" href="images/logo01.jpg">
<!-- 这个是商城进去的主页面，你可以在这个页面看到商品，搜索，登录注册，查看订单信息 -->

<link rel="stylesheet" href="css/main_type.css"> 
<link rel="stylesheet" href="css/main_head.css">
<link rel="stylesheet" href="css/show.css">

<script type="text/javascript" src="js/main_type.js"></script>
<script type="text/javascript" src="js/show.js"></script>
</head>
<body style="background:url(images/p02.jpg); background-size: cover;">
	<%@ include file="main_head.jsp" %>
	<%@ include file="main_type.jsp" %>
	<%@ include file="show.jsp" %>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<div id="main_head">
	<div id="main_head_02"><marquee drection="left"><b>欢迎光临hexionly网上书城</b></marquee></div>
	<!-- 点击分别跳转到相应的页面 -->
	<a href="order.jsp">查看订单</a>
	<a href="user.jsp">管理员操作</a>
	<a id="type01">查看书类型</a>
	<a>你好，<font color="red">${username }</font></a>
</div>

这个是main_head.jsp

不喜勿喷，新手上路，同时学习阶段，有什么新的东西可以互相交流

hexionly

关注

9
点赞
踩
42

收藏

觉得还不错? 一键收藏
9
评论
servlet+jsp+mysql+jdbc实现注册登录

此处我就只贴出java代码和jsp代码，数据库表自己根据Regist.java去创建1、首先，我先把前端代码贴出来，这个比较简单，没什么注册（regist.jsp）<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE...
复制链接

扫一扫