一,首页login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%
//定义一个用于获取本项目根路径的一个地址
String path = request.getContextPath();
%>
<!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>Insert title here</title>
</head>
<body>
<form action="<%=path %>/StuLoginServlet" method="post">
请输入用户名:<input type="text" name="name"><br/>
请输入密码:<input type="password" name="pwd"><br/>
<input type="submit" value="登录">
</form>
<form action="<%=path %>/StuLogupServlet" method="post">
请输入注册信息
用户名:<input type="text" name="name"><br/>
密码: <input type="password" name="pwd"><br/>
<input type="submit" value="注册">
</form >
<form action="<%=path %>/StuUpdateServlet" method="post">
用户名:<input type="text" name="name"><br/>
新密码:<input type="password" name="pwd"><br/>
<input type="submit" value="更新密码">
</form>
<form action="<%=path %>/StuDeleteServlet" method="post">
请输入需要删除的用户名:<input type="text" name="name"><br/>
<input type="submit" value="注销">
</form>
</body>
</html>
二,登录功能StuLoginServlet.java
package com.stu.servlet;
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.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/StuLoginServlet")
public class StuLoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//解决乱码
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
//打印
System.out.println(name);
System.out.println(pwd);
//发送请求
try{
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//连接数据库
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/1909"
,"root"
,"629629");
//查询数据库消息
String sql="select * from test2 where name=? and pwd=?";
conn.prepareStatement(sql);
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, name);
ps.setString(2, pwd);
//处理操作
ResultSet rs = ps.executeQuery();
boolean flag = false;
while(rs.next()){
flag = true;
}
if(flag){
System.out.println("登录成功!!");
}else{
System.out.println("登录失败!!");
}
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
}
三,注册功能StuLogupServlet.java
package com.stu.servlet;
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 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("/StuLogupServlet")
public class StuLogupServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//1.解决乱码
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
System.out.println(name);
System.out.println(pwd);
//发送请求
try{
//驱动
Class.forName("com.mysql.jdbc.Driver");
//连接
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/1909"
,"root"
,"629629");
//添加(注册)操作
String sql="insert into test2(name,pwd) values(?,?)";
// 获取PreparedStatement
PreparedStatement ps = conn.prepareStatement(sql);
// 对SQL语句中的第一个占位符赋值
ps.setString(1, name);
// 对SQL语句中的第二个占位符赋值
ps.setString(2, pwd);
// 执行更新操作
ps.executeUpdate();
//显示
System.out.println("注册成功!!!");
// 关闭PreparedStatement
ps.close();
// 关闭Connection
conn.close();
}catch (ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
}
四,更新密码功能StuUpdateServlet.java
package com.stu.servlet;
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.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/StuUpdateServlet")
public class StuUpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//解决乱码
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
//打印
System.out.println(name);
System.out.println(pwd);
//发送请求
try{
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//连接数据库
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/1909"
,"root"
,"629629");
// 更新SQL语句
String sql="update test2 set pwd=? where name=?";
// 获取PreparedStatement
PreparedStatement ps = conn.prepareStatement(sql);
// 对SQL语句中的第一个参数赋值
ps.setString(1, pwd);
// 对SQL语句中的第二个参数赋值
ps.setString(2, name);
// 执行更新操作
ps.executeUpdate();
//提示
System.out.println("更新成功");
// 关闭PreparedStatement
ps.close();
// 关闭Connection
conn.close();
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
}
五,注销功能StuDeleteServlet.java
package com.stu.servlet;
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.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet("/StuDeleteServlet")
public class StuDeleteServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//解决乱码
request.setCharacterEncoding("utf-8");
String name = request.getParameter("name");
String pwd = request.getParameter("pwd");
//打印
System.out.println(name);
//发送请求
try{
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
//连接数据库
Connection conn =DriverManager.getConnection("jdbc:mysql://localhost:3306/1909"
,"root"
,"629629");
//查询数据库消息
String sql="delete from test2 where name=?";
// 获取PreparedStatement
PreparedStatement ps = conn.prepareStatement(sql);
// 对SQL语句中的第一个占位符赋值
ps.setString(1, name);
// 执行更新操作
ps.executeUpdate();
//显示
System.out.println("注销成功!!!");
// 关闭PreparedStatement
ps.close();
// 关闭Connection
conn.close();
}catch(ClassNotFoundException e){
e.printStackTrace();
}catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request,response);
}
}