千锋逆战班,登录案例

学习java的第51天
我命由我不由天!!!

下面为一个非常简单的登录案例

package com.qf.Job;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;


@WebServlet(name = "job",urlPatterns = "/job")
public class job extends HttpServlet {

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;charset=UTF-8");
        String username = req.getParameter("username");
        String password = req.getParameter("password");
        Connection connection = DButil.getConnection();

//        System.out.println(connection);
        PreparedStatement preparedStatement = null;
        ResultSet resultSet = null;
        String sql = "select * from un";
        try {
            preparedStatement = connection.prepareStatement(sql);

            resultSet = preparedStatement.executeQuery();
            while(resultSet.next()){
                String uname = resultSet.getString(1);
                String psw = resultSet.getString(2);
                if(uname.equals(username) && psw.equals(password)){
                    System.out.println("登陆成功");
                    resp.sendRedirect("/day11/html/win.html");
                    break;
                }


            }

        } catch (SQLException e) {
            e.printStackTrace();
        } finally {

            DButil.closeAll(connection,preparedStatement,resultSet);
        }



    }

    @Override
    protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        doGet(req, resp);
    }
}


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>登录</title>
</head>
<body>
<form action="../job" method="post">
    <input type="text" name="username" placeholder="请输入账号"></br>
    <input type="password" name="password" placeholder="请输入密码"></br>
    <input type="submit" value="登录">



</form>
</body>
</html>
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值