用servlet校验密码2

登录页面

数据库字段

登录失败页面

登录成功页面

项目结构（这里的小红叉可以忽略，IDE反应问题）

 

 login.html

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
<style type="text/css">
	body{
		margin:0;
	}
	input{
		margin:30px auto;
		width:200px;
		height:28px;
	}
	.border{
		width:400px;
		height:300px;
		background:url(./img/bg.jpg) no-repeat;
		margin:200px auto;
	}
	.content{
		width:300px;
		height:58px;
		border-radius:4px;
		margin: 30px auto;
		color:#fff;
	}
	.commit{
		position:absolute;
		margin-top:30px;
		left:720px;
		background:#3385ff;
	}
	.btnSubmit{
		line-height:30px;
		font-size:16px;
		width:100px;
		background:#3385ff;
		border:0;
	}
</style>
</head>
<body>
	<div class="border">
		<form action="./login" method="POST">
			<div class="content">
				用户名：<input type="text" name="username" placeholder="请输入用户名"><br/>
			</div>
			<div class="content">
				密   码：<input type="password" name="password" placeholder="请输入密码"><br/>
			</div>
			<div class="commit">
				<button type="submit" class="btnSubmit" style="">提交</button>
			</div>
			
	</form>
	</div>
	
	
</body>
</html>

　LoginServlet.java

package com.my.deal;

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.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * 登录界面
 */
@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
	private String driverName="com.mysql.cj.jdbc.Driver";
	private String url="jdbc:mysql://localhost:3306/login?useSSL=false&serverTimezone=UTC";
	private String name="root";
	private String word="root";
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		String username = request.getParameter("username");
		String password = request.getParameter("password");
		//设置页面编码格式
		response.setContentType("text/html;charset=UTF-8");
		String sql="select * from user where username='"+username+"' and password='"+password+"'";
		Connection connection=null;
		Statement statement=null;
		ResultSet resultSet=null;
		try {
			Class.forName(driverName);//加载驱动
			connection = DriverManager.getConnection(url, name, word);//获取连接
			statement = connection.createStatement();
			resultSet = statement.executeQuery(sql);
			if(resultSet.next()) {
				response.setContentType("text/html;charset=UTF-8");
				response.getWriter().write("欢迎你："+username+"登录成功来到首页");
				response.getWriter().write("<br/>");
				response.getWriter().write("你的密码为："+password);
			}else {
				response.getWriter().write("用户名或者密码错误");
			}
		} catch (ClassNotFoundException | SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				//关闭连接
				resultSet.close();
				statement.close();
				connection.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
			
		}
	}

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

}

源码下载地址

链接：https://pan.baidu.com/s/1MjXb7nGpASnYjHStVjyBmA
提取码：dukt

　

posted @ 2019-03-30 11:42  QAQqiulin  阅读(165)  评论(0)    收藏  举报