devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

Tomcat+Servlet+mysql登录注册_streamlit编写登录界面

作者：盐析白兔 | 2024-03-01 15:49:53

赞

踩

streamlit编写登录界面

1:先写登录的jsp文件  ,文件名叫做index.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: Acer
  4.   Date: 2022/9/28
  5.   Time: 21:45
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10.   <head>
  11.     <title>登录</title>
  12.   </head>
  13.   <body>
  14.   <a href="Register.jsp">注册</a>
  15.   <form  action="LogoServet" method="post">
  16.     账号:<input type="text" name="id" ><br>
  17.  
  18.     密码: <input type="password"  name="pwd"><br>
  19.  
  20.     <input type="submit" value="登录"><input type="reset" value="重新输入">
  21.   </form>
  22.   </body>
  23. </html>

2.再写注册的jsp文件,文件名叫Register.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: Acer
  4.   Date: 2022/9/28
  5.   Time: 21:45
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10.   <head>
  11.     <title>注册</title>
  12.   </head>
  13.  
  14.   <body>
  15.   <form  action="RegisterServet" method="post">
  16.     用户名:<input type="text" name="name" ><br>
  17.  
  18.     密&nbsp&nbsp码: <input type="password"  name="pwd"><br>
  19.     确认密码: <input type="password"  name="pwd2"><br>
  20.  
  21.     <input type="submit" value="注册"><input type="reset" value="重新输入">
  22.   </form>
  23.   </body>
  24. </html>

3:再写转跳3秒钟,文件名叫jump.jsp

  1. <%--
  2.   Created by IntelliJ IDEA.
  3.   User: Acer
  4.   Date: 2022/9/24
  5.   Time: 17:36
  6.   To change this template use File | Settings | File Templates.
  7. --%>
  8. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
  9. <html>
  10. <head>
  11.     <title>跳转页面</title>
  12.     <script type="text/javascript">
  13.         function fun1(){
  14.             var span1 = document.getElementById("span1");
  15.             var count = span1.innerText;
  16.             if (count>0){
  17.                 count--;
  18.                 span1.innerText=count;
  19.             }
  20.         }
  21.     window.onload= function(){
  22.         window.setInterval("fun1()",1000);
  23.     }
  24.  
  25.     </script>
  26.  
  27. </head>
  28. <body>
  29. 登录成功.<span id="span1" style="color:red">3</span>秒钟自动跳转.如果没有跳转,请<a href="main.jsp">点击</a>
  30.  
  31. <%
  32. response.setHeader("refresh","3;url=main.jsp");
  33. %>
  34.  
  35. </body>
  36. </html>

4:main的页面可以是你的网页主页,我只写了个登录成功

 

5在项目中的src,新建一个叫com的软件包,然后再里面新建一个controller的软件包

 

6.在controller中写登录的Select,文件名叫做LogoServet

  1. package com.controller;
  2.  
  3. import com.db.Database;
  4. import com.model.Userdata;
  5.  
  6. import javax.servlet.*;
  7. import javax.servlet.http.*;
  8. import javax.servlet.annotation.*;
  9. import java.io.IOException;
  10. import java.io.PrintWriter;
  11. import java.sql.SQLException;
  12.  
  13. @WebServlet("/LogoServet")
  14. public class LogoServet extends HttpServlet {
  15.     @Override
  16.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  17.        request.setCharacterEncoding("utf-8");
  18.         response.setContentType("text/html;charset=utf-8");
  19.        int id=Integer.parseInt(request.getParameter("id"));
  20.         String pwd=request.getParameter("pwd");
  21.        PrintWriter out=response.getWriter();
  22.        //out.println("你的账号:"+id+"你的密码:"+pwd);
  23.  
  24.         try {
  25.             Database database = new Database();
  26.             Userdata userdata = database.login(id,pwd);
  27.             if (userdata == null) {
  28.             out.println("该用户不存在或者密码错误"+"<a href=\"index.jsp\"> 返回登录</a>");
  29.             }else {
  30.                out.println("欢迎登录"+userdata.getName()+"点击转跳-->"+"<a href=\"jump.jsp\"> 进入网页</a>");
  31.             }
  32.         } catch (ClassNotFoundException | SQLException e) {
  33.             e.printStackTrace();
  34.             out.println("注册失败");
  35.         }
  36.  
  37.     }
  38.  
  39.     @Override
  40.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41.       doGet(request, response);
  42.     }
  43. }

7:在controller中写注册的Servlet,文件名叫RegisterServet

  1. package com.controller;
  2.  
  3. import com.db.Database;
  4. import com.model.Userdata;
  5.  
  6. import javax.servlet.*;
  7. import javax.servlet.http.*;
  8. import javax.servlet.annotation.*;
  9. import java.io.IOException;
  10. import java.io.PrintWriter;
  11. import java.sql.SQLException;
  12.  
  13. @WebServlet("/LogoServet")
  14. public class LogoServet extends HttpServlet {
  15.     @Override
  16.     protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  17.        request.setCharacterEncoding("utf-8");
  18.         response.setContentType("text/html;charset=utf-8");
  19.        int id=Integer.parseInt(request.getParameter("id"));
  20.         String pwd=request.getParameter("pwd");
  21.        PrintWriter out=response.getWriter();
  22.        //out.println("你的账号:"+id+"你的密码:"+pwd);
  23.  
  24.         try {
  25.             Database database = new Database();
  26.             Userdata userdata = database.login(id,pwd);
  27.             if (userdata == null) {
  28.             out.println("该用户不存在或者密码错误"+"<a href=\"index.jsp\"> 返回登录</a>");
  29.             }else {
  30.                out.println("欢迎登录"+userdata.getName()+"点击转跳-->"+"<a href=\"jump.jsp\"> 进入网页</a>");
  31.             }
  32.         } catch (ClassNotFoundException | SQLException e) {
  33.             e.printStackTrace();
  34.             out.println("注册失败");
  35.         }
  36.  
  37.     }
  38.  
  39.     @Override
  40.     protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  41.       doGet(request, response);
  42.     }
  43. }

8:在com的软件包下新建一个加db的软件包,在包里新建一个叫Database文件,这个文件有连接数据库和查询数据和添加数据,我自己的数据库名叫web001,记住一定要用MySQL的jar包

  1. package com.db;
  2.  
  3. import com.model.Userdata;
  4.  
  5. import java.sql.*;
  6. import java.util.ArrayList;
  7.  
  8. public class Database {
  9.     Connection conn=null;
  10.     public  Database() throws ClassNotFoundException {
  11.  
  12.         Class.forName("com.mysql.jdbc.Driver");
  13.  
  14.  
  15.         try {
  16.             this.conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/web001?serverTimeZone=GMT%288","root","123456");
  17.         } catch (SQLException e) {
  18.             e.printStackTrace();
  19.         }
  20.        // System.out.println(conn);
  21.     }
  22.     public  void  showConnect(){
  23.         if (conn==null){
  24.             System.out.println("数据库连接失败");
  25.         }else {
  26.             System.out.println("数据库连接成功");
  27.         }
  28.  
  29.     }
  30.     //关闭链接
  31.     public  void close() throws SQLException {
  32.         conn.close();
  33.     }
  34.     //在login表里添加数据
  35.     public  void inser(String name,String pwd) throws SQLException {
  36.         PreparedStatement prep = conn.prepareStatement("insert into web001.login value(null,?,?) ");
  37.         prep.setString(1,name);
  38.         prep.setString(2,pwd);
  39.         prep.execute();
  40.     }
  41.     public ArrayList<Userdata> getAllUser() throws SQLException {
  42.         ArrayList<Userdata> uselist = new ArrayList<>();
  43.         PreparedStatement prep = conn.prepareStatement("select * from web001.login");
  44.         prep.execute();
  45.         ResultSet resultSet=prep.executeQuery();
  46.         while (resultSet.next()){
  47.             int myid=resultSet.getInt("id");
  48.             String myname=resultSet.getString("name");
  49.             String mypwd=resultSet.getString("pwd");
  50.             uselist.add(new Userdata(myid,myname,mypwd));
  51.         }
  52.         return uselist;
  53.     }
  54.     //在表里查询数据
  55.     public  Userdata getUser(int id) throws SQLException {
  56.  
  57.             PreparedStatement prep = conn.prepareStatement("select * from web001.login where id=?");
  58.             prep.setInt(1,id);
  59.             prep.execute();
  60.             ResultSet resultSet=prep.executeQuery();
  61.             if (resultSet.next()){
  62.                 int myid=resultSet.getInt("id");
  63.                 String myname=resultSet.getString("Name");
  64.                 String mypwd=resultSet.getString("passwrod");
  65.                 return  new Userdata(myid,myname,mypwd);
  66.             }
  67.  
  68.  
  69.         return null;
  70.     }
  71.     public  Userdata login(int id,String pwd) throws SQLException {
  72.         PreparedStatement prep = conn.prepareStatement("select  web001.login.passwrod from web001.login where id=? ");
  73.         prep.setInt(1,id);
  74.         prep.execute();
  75.         ResultSet resultSet = prep.executeQuery();
  76.         if (resultSet.next()) {
  77.             String mypwd=resultSet.getString("passwrod");
  78.             if (pwd.equals(mypwd)) {
  79.             return getUser(id);
  80.             }else {
  81.                 return null;
  82.             }
  83.         }else {
  84.             return null;
  85.         }
  86.     }
  87. }

9:新建一个叫做web001的数据库

 10.在web001的数据库中新建一个叫做login的表内容如下

 然后一个简单的登录注册转跳主页就做好了

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/175114
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号