2022-4-11


账号登陆


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>账号登陆</title>
    <style>
        form {
            margin-bottom: 50px;
            width: 500px;
            background-color: #eeeff2;
            border-radius: 8px;
        }

        button {
            background-color: #4e6ef2;
            color: #ffffff;
            width: 380px;
            height: 47px;
            border-radius: 8px;
            border: 0px;
            margin: 0 auto 50px 60px;
        }

        button:hover {
            background-color: #4662d9;
        }

        input {
            display: block;
            width: 336px;
            height: 20px;
            margin: 0 auto;
            border-radius: 8px;
            border: 1px solid #b8b8b8;
            padding: 10px 20px;
        }

        input:focus {
            outline: none;
            border: 1px solid #8db9f1;
        }

        #t {
            color: #4e6ef2;
            margin: 0 auto 50px 360px;
        }

        #t1 {
            font-weight: bold;
            color: black;
            margin: 0 auto 50px 60px;
            border-bottom: 3px solid #91a5f7;
            padding-bottom: 6px;
        }
    </style>
</head>

<body background="https://passport.baidu.com/static/passpc-account/img/reg_bg_min.jpg">

    <form action="#">
        <a style="text-decoration: none;" href="file:///F:/web/day01/HW.html?username=&password=#">
            <font id="t1" face="微软雅黑" size="5">账号登陆</font><br><br>
        </a>
        <input type="text" name="username" placeholder="手机号/用户名/邮箱"><br>
        <input type="password" name="password" placeholder="密码"><br>
        <a style="text-decoration: none;" href="file:///F:/web/day01/HW02.html">
            <font id="t" size="3">忘记密码?</font><br><br>
        </a>
        <button>登录</button>
    </form>

</body>

</html>

在这里插入图片描述


注册


<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>账号登陆和注册</title>
    <style>
        form {
            margin-bottom: 50px;
            width: 500px;
            background-color: #eeeff2;
            border-radius: 8px;
            padding-left: 20px;
        }

        button {
            width: 100px;
            height: 50px;
            font-size: 15px;
            background-color: #ffffff;
            color: black;
            border: 0px;
            border-radius: 5px;
        }

        button:hover {

            color: blue;
            border: 0.5px solid blue;
        }

        #b {
            background-color: #bdcefc;
            color: #ffffff;
            width: 450px;
            height: 47px;
            border-radius: 8px;
            border: 0px;
            margin: 0 auto 50px;
        }

        #b:hover {
            background-color: #4662d9;
        }

        input {
            width: 336px;
            height: 20px;
            margin-bottom: 10px;
            border-radius: 5px;
            border: 1px solid #b8b8b8;
            padding: 10px 20px;
        }

        input:focus {
            outline: none;
            border: 1px solid blue;
        }

        #t2 {
            font-weight: bold;
            color: black;
            margin: 0 auto 50px 60px;
        }

        #t3 {
            font-weight: bold;
            color: #a7a7a7;
            margin: 0 auto 50px 60px;
        }
    </style>
</head>

<body background="https://passport.baidu.com/static/passpc-account/img/reg_bg_min.jpg">


    <form action="#">
        <font id="t2" face="微软雅黑" size="5">欢迎注册</font><br><br>
        <font id="t3" face="微软雅黑" size="2">已有帐号?<a style="text-decoration: none;color: blue;"
                href="file:///F:/web/day01/HW.html?username=&password=#">登录</a></font><br>
        <p>用户名&nbsp;
            <input type="text" name="username" maxlength="8" placeholder="请设置用户名">
        </p>
        <p>手机号&nbsp;
            <input type="text" name="ph" maxlength="11" placeholder="可用于登录和找回密码">
        </p>
        <p>&nbsp;&nbsp;&nbsp;&nbsp;
            <input type="password" name="password" placeholder="请设置登录密码">
        </p>
        <p>验证码&nbsp;
            <input type="text" name="username" placeholder="请输入验证码">
        </p>
<button>获取验证码</button>
        <button id="b">注册</button>
    </form>
</body>
</html>

在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
优化代码SELECT SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN 1 ELSE 0 END) AS new_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN 1 ELSE 0 END) AS old_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 1 THEN payment_amount ELSE 0 END) AS new_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' AND is_new_customer = 0 THEN payment_amount ELSE 0 END) AS old_customer_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN 1 ELSE 0 END ELSE 0 END) AS category_A_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'A' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_A_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN 1 ELSE 0 END ELSE 0 END) AS category_B_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN category = 'B' THEN payment_amount ELSE 0 END ELSE 0 END) AS category_B_payment_amount, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN 1 ELSE 0 END ELSE 0 END) AS product_P1_customer_count, SUM(CASE WHEN order_date BETWEEN '2022-10-31' AND '2022-11-11' THEN CASE WHEN product_id = 'P1' THEN payment_amount ELSE 0 END ELSE 0 END) AS product_P1_payment_amount FROM orders WHERE (order_date BETWEEN '2022-10-31' AND '2022-11-11') OR (order_date BETWEEN '2021-10-31' AND '2022-10-30' AND order_date NOT IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11')) OR (order_date BETWEEN '2021-11-12' AND '2022-10-30' AND order_date IN (SELECT order_date FROM orders WHERE order_date BETWEEN '2022-10-31' AND '2022-11-11'))
05-25

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值