servle实现登录和注册功能

最新推荐文章于 2024-07-31 11:41:46 发布

余生漫

最新推荐文章于 2024-07-31 11:41:46 发布

阅读量1.3k

点赞数 3

本文链接：https://blog.csdn.net/weixin_48743403/article/details/121579686

版权

通过servlet实现登录和注册功能，代码如下

</body>

package service;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;

public class login extends HttpServlet {

   public static final String url ="jdbc:mysql://localhost:3306/TestDao";
   Connection conn = null ;
   Statement stmt = null ;
   ResultSet rs = null ;
   boolean flag = false ;

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

       response.setContentType("text/html");
       PrintWriter out = response.getWriter();

   }

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

       String userid = request.getParameter("id");   // 接收表单参数
       String password = request.getParameter("name") ;// 接收表单参数
       System.out.println("userid="+userid+"password="+password);

       boolean flag = false;
       try{
           Class.forName("com.mysql.jdbc.Driver");
           conn = DriverManager.getConnection(url,"root","root");
           String sql = "SELECT * FROM student";

           stmt = conn.createStatement() ;
           rs = stmt.executeQuery(sql) ;

           while(rs.next()){
               // 如果有内容，则此处执行，表示查询出来，合法用户
               System.out.println("userid="+rs.getString("stuid")+"password="+rs.getString("password"));
               String ziduan1=rs.getString("stuid");
               String ziduan2=rs.getString("password");
               //System.out.println(ziduan1);
               if(userid.equals(ziduan1)&& password.equals(ziduan2))
               { flag = true; }
           }
       }
       catch(Exception e){}
       finally{
               try{
                   rs.close();
                   stmt.close();
                   conn.close();
               }catch(Exception e){}

       }

       if(flag==true){   // 登陆成功，应该跳转到success.jsp
           response.sendRedirect("/myhope/success.jsp");
       }else{// 登陆失败，跳转到failure.jsp
           response.sendRedirect("/myhope/register.jsp");
   }
}
}
register.jsp

package service;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;

public class register extends HttpServlet {

public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

       response.setContentType("text/html");
       PrintWriter out = response.getWriter();
       out
               .println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
       out.println("<HTML>");
       out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
       out.println(" <BODY>");
       out.print(" This is ");
       out.print(this.getClass());
       out.println(", using the GET method");
       out.println(" </BODY>");
       out.println("</HTML>");
       out.flush();
       out.close();
   }

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

       String userid = request.getParameter("userid") ;// 接收表单参数
       String username = request.getParameter("username");//接收表单参数
       String password = request.getParameter("password");//接收表单参数
       System.out.println("userid="+userid+"username="+username+"password="+password);
       PreparedStatement preparedStatement = null;
   Connection connection=null;
   boolean flag=false;
       try{
           Class.forName("com.mysql.jdbc.Driver");
String url="jdbc:mysql://localhost:3306/TestDao";
connection = DriverManager.getConnection(url,"root","root");
String sql="insert into student(stuid,username,password) values(?,?,?)";
preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,userid);
preparedStatement.setString(2,username);
preparedStatement.setString(3,password);
preparedStatement.executeUpdate();
flag=true;

       }
       catch(Exception e){}
       finally{
               try{
                   preparedStatement.close();
       connection.close();

               }catch(Exception e){} // 连接一关闭，所有的操作都将关闭

       }
       if(flag==true){   // 登陆成功，应该跳转到success.jsp
               response.sendRedirect("/myhope/login.jsp");
   }

   }
}