servlet注册与登录

最新推荐文章于 2022-01-28 19:26:15 发布

weixin_45812685

最新推荐文章于 2022-01-28 19:26:15 发布

阅读量261

点赞数

文章标签： jsp

本文链接：https://blog.csdn.net/weixin_45812685/article/details/108853101

版权

先写个注册页面

package org.cgq;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
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;
import org.snn.util.DBHelper;
public class RegServelt extends HttpServlet {
 public void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  doPost(request, response);
 }
 public void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  // 1，设置编码
  request.setCharacterEncoding("UTF-8");
  response.setCharacterEncoding("UTF-8");
  // 设置响应格式
  response.setContentType("text/html");
  // 2，接收请求中的参数
  String name = request.getParameter("name");
  String paw = request.getParameter("paw");
  boolean isTrue = false;
  // 3,写注册相关的逻辑，jdbc代码
  Connection conn = DBHelper.getConn();
  // 准备sql语句
  String sql = "insert into student (name,paw) values(?,?)";
  System.out.println("mmmm");
  // 与数据库做交互
  PreparedStatement ps = null;
  try {
   ps = conn.prepareStatement(sql);
   ps.setString(1, name);
   ps.setString(2, paw);
   int count = ps.executeUpdate();
   if (count > 0) {
    isTrue = true;
   } else {
    isTrue = false;
   }
  } catch (SQLException e) {
   e.printStackTrace();
  }
  DBHelper.colse(conn, ps, null);
  // 4 发送响应
  PrintWriter out = response.getWriter();
  if (isTrue == true) {
   response.sendRedirect("login.jsp");
   // out.print("<h1 style='color:red'/>注册成功！</h1>");
  } else {
   response.sendRedirect("index.jsp");
   // out.print("<h1 style='color:green'/>注册失败！</h1>");
  }
  out.flush();
  out.close();
 }
}

注册页面JSP代码

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
   <body>
   <form action="regServlet" method="post"> 
   	用户名：<input type="text" name ="userName"><br/>
  	密码：<input type="password" name ="pwd"><br/>
  	确认密码：<input type="password" name ="pwd"><br/>
   <input type="submit" value="注册">
   </form>
  </body>
</html>
;

登录页面

package org.cgq;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.snn.util.DBHelper;
public class LoginServelt extends HttpServlet{
 @Override
 protected void doGet(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {
  doPost(request, response);
 }
 @Override
 protected void doPost(HttpServletRequest request, HttpServletResponse response)
   throws ServletException, IOException {  
  //设置字符编码：
  request.setCharacterEncoding("UTF-8");//地址栏
  response.setCharacterEncoding("UTF-8");//浏览器的显示 
  //设置浏览器的响应格式
  response.setContentType("text/html"); 
  //接收请求中的参数
  String name=request.getParameter("name");
  String paw=request.getParameter("paw");
  //设置boolean 类型的数据验证是否登录成功
  boolean is=false;
  //jdbc代码，调用DBHelper 中的方法
  Connection conn=DBHelper.getConn(); 
  //准备sql语句
  String sql="select * from student where name=? and paw=?"; 
  //和数据库中做交互
  PreparedStatement ps=null;
   ResultSet rs=null;
  try {
    ps=conn.prepareStatement(sql);
    ps.setString(1, name);
    ps.setString(2, paw);   
    //用ResultSet接收
     rs=ps.executeQuery();
     //判断
     if(rs.next()){
      is=true;
     }else{
      is=false;
     } 
  } catch (SQLException e) {
   e.printStackTrace();
  } 
  //关闭
  DBHelper.colse(conn, ps, rs); 
  //发送响应
  PrintWriter out=response.getWriter();
  if(is==true){
   //跳转到查询到的数据库的内容  从 ListServlet 中调过来
   response.sendRedirect("listServlet");
  }else{
   //登陆失败跳转到注册页面
   response.sendRedirect("index.jsp"); 
   //out.print("<h1 style='color:green'></h1>登陆失败");
  }
  out.flush();
  out.close();
 }
}

登录页面JSP代码

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    <title>My JSP 'index.jsp' starting page</title>
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->
  </head>
   <body>
   <form action="RegLogin" method="post"> 
   	用户名：<input type="text" name ="userName"><br/>
  	密码：<input type="password" name ="pwd"><br/>
   <input type="submit" value="登录">
   </form>
  </body>
</html>

最后启动服务器运行即可

weixin_45812685

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
servlet注册与登录

先写个注册页面package org.cgq;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;imp
复制链接

扫一扫