mysql数据库名user
表格为user
字段为name和pwd
login.html布局文件
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登入页面</title>
</head>
<body>
<form action="LoginDemo" method="post">
请输入用户名:<input type="text" name="username"><br>
请输入密码 :<input type="password" name="password"><br>
<input type="submit" value="登入">
<input type="reset" value="清空">
</form>
</body>
</html>
success.html布局文件
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登入成功</title>
</head>
<body>
<p>登入成功</p>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登入失败</title>
</head>
<body>
<p>登入失败</p>
</body>
</html>
LoginServlet.java (servlet文件)
package com.servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
//import java.io.IOException;
//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.ServletConfig;
//import javax.servlet.ServletException;
//import javax.servlet.annotation.WebServlet;
//import javax.servlet.http.HttpServlet;
//import javax.servlet.http.HttpServletRequest;
//import javax.servlet.http.HttpServletResponse;
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected Connection conn = null;
// private static String DB_Driver = "com.mysql.jdbc.Driver";
// private static String DB_URL = "jdbc:mysql://localhost/user?useSSL=false";
// private static String DB_USER = "root";
// private static String DB_PASSWORD ="";
public LoginServlet() {
super();
}
public void init(ServletConfig config) throws ServletException {
super.init(config);
String driver = config.getInitParameter("driver");
String url = config.getInitParameter("url");
String username = config.getInitParameter("username");
String pwd = config.getInitParameter("pwd");
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,username,pwd);
System.out.println("Connected successful..");
} catch (SQLException e) {
System.out.println(e);
}catch (Exception e) {
e.printStackTrace();
}
}
public void destroy() {
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String username = request.getParameter("username");
String pwd = request.getParameter("password");
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "select * from user where name = ? and pwd = ?";
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, username);
pstmt.setString(2, pwd);
rs = pstmt.executeQuery();
if (rs.next()) {
System.out.println("登入成功");
response.sendRedirect("success.html");
}
else {
System.out.println("登入失败");
RequestDispatcher rd = request.getRequestDispatcher("fail.html");
rd.forward(request, response);
}
} catch (SQLException e) {
System.out.println(e);
}finally {
try {
rs.close();
pstmt.close();
} catch (SQLException e2) {
e2.printStackTrace();
}
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
引用mysql驱动mysql-connector-java-5.1.42-bin.jar
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_3_1.xsd" id="WebApp_ID" version="3.1">
<display-name>LoginDemo</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>Login</servlet-name>
<servlet-class>com.servlet.LoginServlet</servlet-class>
<init-param>
<param-name>driver</param-name>
<param-value>com.mysql.jdbc.Driver</param-value>
</init-param>
<init-param>
<param-name>url</param-name>
<param-value>jdbc:mysql://localhost/user?useSSL=false</param-value>
</init-param>
<init-param>
<param-name>username</param-name>
<param-value>此处填mysql账号</param-value>
</init-param>
<init-param>
<param-name>pwd</param-name>
<param-value>此处填入mysql密码</param-value>
</init-param>
</servlet>
<servlet-mapping>
<servlet-name>Login</servlet-name>
<url-pattern>/LoginDemo</url-pattern>
</servlet-mapping>
</web-app>