JAVAWEB学习记录之登录系统(代码)

一,首页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);
	}

}

 

  • 0
    点赞
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

L烧鱼

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值