第五阶段淘宝项目java+html+mysql(二)

本文涉及的产品
云数据库 RDS MySQL,集群系列 2核4GB
推荐场景:
搭建个人博客
RDS MySQL Serverless 基础系列,0.5-2RCU 50GB
云数据库 RDS MySQL,高可用系列 2核4GB
简介: 第五阶段淘宝项目java+html+mysql

RegisterServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IUserService;
import org.lyl.taobao.api.entity.User;
import org.lyl.taobao.service.UserServiceImpl;
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 javax.servlet.http.HttpSession;
import java.io.IOException;
@WebServlet("/enter")
public class RegisterServlet extends HttpServlet {
    static boolean x;
    public static String name1;
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        HttpSession session = req.getSession();
        String name = req.getParameter("uname");
        String paw = req.getParameter("upaw");
        if (name==""||paw==""){
            req.setAttribute("msg","输入的值不能为空!!!");
            req.getRequestDispatcher("enter.jsp").forward(req,resp);
        }else {
            session.setAttribute("uname",name);
            name1 = name;
            User user2 = new User(name,paw);
            IUserService iUserService = new UserServiceImpl();
            x = iUserService.register(user2);
            resp.sendRedirect("panduan.jsp");
        }
    }
    public static boolean rgs(){
        return x;
    }
}

UpdatenumServlet


package org.lyl.taobao.controller;
import org.lyl.taobao.api.IShoppingService;
import org.lyl.taobao.api.entity.Shoping;
import org.lyl.taobao.service.ShoppingServiceImpl;
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 javax.servlet.http.HttpSession;
import java.io.IOException;
import java.util.List;
@WebServlet("/update")
public class UpdatenumServlet extends HttpServlet {
    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("UTF-8");
        resp.setContentType("text/html;utf-8");
        IShoppingService iShoppingService = new ShoppingServiceImpl();
        int id = Integer.parseInt(req.getParameter("id"));
        Shoping shoping = new Shoping(id);
       boolean x= iShoppingService.update(shoping);
       if (x){
           HttpSession session = req.getSession();
           List<Shoping> shopings = iShoppingService.query();
           session.setAttribute("shop",shopings);
           resp.sendRedirect("shopping.jsp");
       }else {
           iShoppingService.delet(shoping);
           HttpSession session = req.getSession();
           List<Shoping> shopings = iShoppingService.query();
           session.setAttribute("shop",shopings);
           resp.sendRedirect("shopping.jsp");
       }
    }
}

前端html


change.jsp


<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>更改信息</title>
</head>
<body>
<h2>欢迎来到更改用户密码页面</h2>
<form action="/change" method="post">
    请输入用户名:<input type="text" name="uname"><br>
    请输入注册手机号:<input type="text" name="phone"><br>
    请输入新密码:<input type="password" name="upaw"><br>
    <button>确定修改</button>
</form>
<form action="enter.jsp" method="post">
    <button>取消修改</button>
</form>
${msg}
</body>
</html>

commod.jsp


<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
    <link rel="stylesheet" href="commodity.css">
</head>
<body>
<h2>欢迎来到购物页面</h2>
<div class="bax w" id="5">
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/O1CN010yGEVn1vtqXpTwABQ_!!6000000006231-2-yinhe.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">三只松鼠手撕面包1kg整箱网红零食礼包早餐休闲食品蛋糕点心吐司</div>
        <div class="floor-price">¥29</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="三只松鼠手撕面包" name="names">
            <input type="hidden" value="1kg整箱网红零食礼包早餐休闲食品蛋糕点心吐司" name="informations">
            <input type="hidden" value="29" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/O1CN01slUasP1gTzxMU8bId_!!6000000004144-2-yinhe.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">可优比儿童滑板车1-3-6岁宝宝踏板12岁小孩单脚滑滑车2宽轮溜溜车</div>
        <div class="floor-price">¥238.0</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="可优比儿童滑板车" name="names">
            <input type="hidden" value="1-3-6岁宝宝踏板12岁小孩单脚滑滑车2宽轮溜溜车" name="informations">
            <input type="hidden" value="238" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/i1/725677994/O1CN01WMINGM28vImwvic51_!!2-item_pic.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">威露士除菌内衣洗衣液300g专业洗内裤除螨抑菌 去血渍去异味亮白</div>
        <div class="floor-price">¥37</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="威露士除菌内衣洗衣液" name="names">
            <input type="hidden" value="300g专业洗内裤除螨抑菌 去血渍去异味亮白" name="informations">
            <input type="hidden" value="37" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/i4/392147177/O1CN015TRyuD22t7E49AkSs_!!2-item_pic.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">预售【周黑鸭_锁鲜】盒装卤鸭脖鸭锁骨鸭翅鸭掌素食 多口味任选装</div>
        <div class="floor-price">¥34</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="鸭脖鸭锁骨鸭翅鸭掌" name="names">
            <input type="hidden" value="盒装卤鸭脖鸭锁骨鸭翅鸭掌素食 多口味任选装" name="informations">
            <input type="hidden" value="34" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/TB18OBMjIKfxu4jSZPfXXb3dXXa.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">维达手帕纸超韧4层8张18包卫生纸巾 自然无香面巾纸 新旧交替发货</div>
        <div class="floor-price">¥11</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value=">维达手帕纸" name="names">
            <input type="hidden" value="超韧4层8张18包卫生纸巾 自然无香面巾纸 新旧交替发货" name="informations">
            <input type="hidden" value="11" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu2">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/O1CN01uCASei1EomgiiUqJB_!!6000000000399-2-yinhe.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">良品铺子坚果零食大礼包送礼混合坚果小包装干果食品坚果礼盒整箱</div>
        <div class="floor-price">¥108.0</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="良品铺子坚果零食大礼包" name="names">
            <input type="hidden" value="送礼混合坚果小包装干果食品坚果礼盒整箱" name="informations">
            <input type="hidden" value="108" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/O1CN01mVxyRv1KShHqCAbfp_!!6000000001163-2-yinhe.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">百草味-零食大礼包 网红爆款休闲充饥夜宵小吃饼干组合一整箱送礼</div>
        <div class="floor-price">¥49</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="百草味-零食大礼包" name="names">
            <input type="hidden" value="网红爆款休闲充饥夜宵小吃饼干组合一整箱送礼" name="informations">
            <input type="hidden" value="49" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/TB1YmPsH1L2gK0jSZPhXXahvXXa.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">维达无芯卷纸超韧4层78克10卷(中棒)卫生纸巾 厕纸手纸家用实惠装</div>
        <div class="floor-price">¥39</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="维达无芯卷纸" name="names">
            <input type="hidden" value="4层78克10卷(中棒)卫生纸巾 厕纸手纸家用实惠装" name="informations">
            <input type="hidden" value="39" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu1">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/TB1_gzhHYr1gK0jSZR0XXbP8XXa.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">Walch/威露士倍护滋润抑菌洗手液525ml抵御干燥 怡人清香清香型</div>
        <div class="floor-price">¥20.0</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="威露士倍护滋润抑菌洗手液" name="names">
            <input type="hidden" value="525ml抵御干燥 怡人清香清香型" name="informations">
            <input type="hidden" value="20" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
    <div class="gowu2">
        <div class="wupin">
            <img src="//img.alicdn.com/bao/uploaded/bao/upload/O1CN01qwpuRZ1msAYGtSH9P_!!6000000005009-2-yinhe.png_400x400q60.jpg" alt="">
        </div>
        <div class="floor-item-title">三只松鼠芒果干88g零食蜜饯果脯果干网红休闲办公室零食小吃特产</div>
        <div class="floor-price">¥20.0</div>
        <form class="zong" action="com" method="post">
            <input type="hidden" value="三只松鼠芒果干" name="names">
            <input type="hidden" value="88g零食蜜饯果脯果干网红休闲办公室零食小吃特产" name="informations">
            <input type="hidden" value="20" name="prices">
            <input type="hidden" value="1" name="num">
            <button>确定购买</button>
        </form>
    </div>
</div>
<form action="/que" method="post">
    <button>查看购物车</button>
</form>
<form action="enter.jsp" method="post">
    <button>切换登录</button>
</form>
<form action="logout.jsp" method="post">
    <button>注销账户</button>
</form>
</body>
</html>

delete.jsp


<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>删除订单</title>
</head>
<body>
<form action="del" method="post">
    请输入要删除订单id:<input type="text" name="id">
    <button>确定删除</button>
</form>
<form action="enter.jsp" method="post">
    <button>切换登录</button>
</form>
</body>
</html>

enter.jsp


<%@ page import="org.lyl.taobao.controller.RegisterServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 9:05
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>登录页面</title>
</head>
<body>
<h2>欢迎来到登录页面!!!</h2>
<form action="enter" method="post">
    请输入用户名:<input type="text" name="uname"> <br>
    请输入密码:<input type="password" name="upaw">
    <button>登录</button>
</form>
<form action="change.jsp" method="post">
    <button>修改密码</button>
</form>
<form action="login.jsp" method="post">
    <button>注册账号</button>
</form>
${msg}
</body>
</html>

index.jsp


<%@ page import="org.lyl.taobao.controller.LogoutServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/10
  Time: 15:23
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>主页面</title>
</head>
<body>
<%
    if (LogoutServlet.x == false){
    }else {
        out.print("<script>alert(\"注销成功,请重新登录\")</script>");
    }
%>
<h2>欢迎来到主页!!!</h2>
<h4>请选择服务!!!</h4>
<form action="login.jsp" method="post">
    <button>注册</button>
</form>
<form action="enter.jsp" method="post">
    <button>登录</button>
</form>
</body>
</html>

login.jsp


<html>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<body>
<header>
</header>
<h2>欢迎来到注册页面!!!</h2>
<form action="/insertUser" method="post">
    用户名:<input type="text" name="names">
    密码:<input type="password" name="paw">
    手机号:<input type="text" name="num">
    <button>注册</button>
</form>
${msg}
</body>
</html>

logout.jsp


<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>Title</title>
</head>
<body>
<form action="/lout" method="post">
    请输入密码:<input type="password" name="password">
    <button>确定注销</button>
</form>
${msg}
</body>
</html>

panduan.jsp


<%@ page import="org.lyl.taobao.controller.RegisterServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 16:33
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    if (RegisterServlet.rgs() ==true){
        response.sendRedirect("commodity.jsp");
    }else {
        out.print("<script>alert(\"您输入的用户名或密码有误请重新输入!!!\")</script>");
    }
%>
<form action="enter.jsp" method="post">
    <button>重新登录</button>
</form>
</body>
</html>

panduan1.jsp


<%@ page import="org.lyl.taobao.controller.ChangeServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 18:46
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    if (ChangeServlet.x() ==true){
        out.print("<script>alert(\"修改成功!!!\")</script>");
    }else {
        out.print("<script>alert(\"您输入的用户名或手机号有误请重新输入!!!\")</script>");
    }
%>
<form action="enter.jsp" method="post">
    <button>登录</button>
</form>
<form action="change.jsp" method="post">
    <button>继续修改</button>
</form>
<form action="login.jsp" method="post">
    <button>重新注册</button>
</form>
</body>
</html>

panduan2.jsp


<%@ page import="org.lyl.taobao.controller.DeletServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 18:53
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>判断</title>
</head>
<body>
<%
    if (DeletServlet.x() ==true){
        out.print("<script>alert(\"删除成功\")</script>");
    }else {
        out.print("<script>alert(\"删除失败\")</script>");
    }
%>
<form action="/que" method="post">
    <button>查看购物车</button>
</form>
<form action="commodity.jsp" method="post">
    <button>继续购物</button>
</form>
<form action="enter.jsp" method="post">
    <button>切换登录</button>
</form>
</body>
</html>

panduan3.jsp


<%@ page import="org.lyl.taobao.controller.CommodityServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 18:56
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    if (CommodityServlet.x() ==true){
        out.print("<script>alert(\"购买成功\")</script>");
    }else {
        out.print("<script>alert(\"因部分原因购买失败\")</script>");
    }
%>
<form action="commodity.jsp" method="post">
    <button>继续购物</button>
</form>
<form action="/que" method="post">
    <button>查看购物车</button>
</form>
<form action="enter.jsp" method="post">
    <button>切换登录</button>
</form>
</body>
</html>

panduan4.jsp


<%@ page import="org.lyl.taobao.controller.InsertUserServlet" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 19:30
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<%
    if (InsertUserServlet.x() ==true){
        out.print("<script>alert(\"注册成功!!!\")</script>");
    }else {
        out.print("<script>alert(\"注册账号已存在!!!\")</script>");
    }
%>
<form action="login.jsp" method="post">
    <button>重新注册</button>
</form>
<form action="enter.jsp" method="post">
    <button>登录</button>
</form>
<form action="change.jsp" method="post">
    <button>修改密码</button>
</form>
</body>
</html>

shopping.jsp


<%@ page import="org.lyl.taobao.dao.impl.ShoppingDaoImpl" %>
<%@ page import="org.lyl.taobao.controller.ClearServlet" %>
<%@ page import="org.lyl.taobao.api.entity.Shoping" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: jijunxiang
  Date: 2021/4/14
  Time: 16:25
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<html>
<head>
    <title>购物车</title>
</head>
<body>
<%--<%--%>
<%--    IShoppingDao iShoppingDao = new ShoppingDaoImpl();--%>
<%--    List list1 = iShoppingDao.queryid();--%>
<%--    int i = 0;--%>
<%--    for (Object list : QueryServlet.list()){--%>
<%--        out.print(list);--%>
<%--        request.setAttribute("list",list1.get(i));--%>
<%--        i++;--%>
<%--%>--%>
<%--<form action="del" method="post">--%>
<%--    <input type="hidden" value="${list}" name="id">--%>
<%--    <button>删除订单</button>--%>
<%--</form>--%>
<%--<form action="/update" method="post">--%>
<%--    <input type="hidden" value="${list}" name="id">--%>
<%--    <button>-</button>--%>
<%--</form>--%>
<%--<br>--%>
<%--<%--%>
<%--    }--%>
<%--    i = 0;--%>
<%--%>--%>
<%
    List<Shoping> list = (List<Shoping>) session.getAttribute("shop");
    request.setAttribute("shopList",list);
%>
<c:if test="${!empty shopList}">
<table align="center" width="800" border="1" style="border-collapse: collapse">
    <tr>
        <th>商品名称</th>
        <th>商品信息</th>
        <th>商品价格</th>
        <th>商品数量</th>
        <th>选择服务</th>
    </tr>
    <c:forEach items="${shopList}" var="shop1">
    <tr>
        <td>${shop1.name}</td>
        <td>${shop1.information}</td>
        <td>${shop1.price}</td>
        <td>${shop1.num}</td>
        <td><form action="del" method="post">
            <input type="hidden" value="${shop1.id}" name="id">
            <button>删除订单</button>
        </form>
            <form action="/update" method="post">
                <input type="hidden" value="${shop1.id}" name="id">
                <button>-</button>
            </form></td>
    </tr>
    </c:forEach>
</c:if>
<h1>
    总价格为 :<%
    out.println(ShoppingDaoImpl.x);
    ShoppingDaoImpl.x = 0;
%>
</h1>
<form action="commodity.jsp" method="post">
    <button>继续购物</button>
</form>
<form action="/clear" method="post">
    <button>清空订单</button>
</form>
<form action="enter.jsp" method="post">
    <button>切换登录</button>
</form>
<%
    if (ClearServlet.x ==true){
        out.print("<script>alert(\"清除成功\")</script>");
        ClearServlet.x=false;
    }
%>
</body>
</html>

css


.gowu1 {
    background-color: #fff;
    width: 234px;
    height: 300px;
    float: left;
    margin-right: 14px;
    margin-bottom: 14px;
}
.gowu1:hover {
    box-shadow: 10px 10px 10px -4px rgba(0,0,0,0.3);
}
.wupin {
    margin-top: 12px;
    text-align: center;
}
.wupin img {
    width: 185px;
    height: 185px;
}
.bax {
    background-color: #f5f5f5;
    margin-top: 50px;
    width: 1226px;
    height: 615px;
}
.floor-item-title {
    width: 135px;
    height: 40px;
    font-size: 14px;
    color: #333;
    line-height: 20px;
    overflow: hidden;
    margin: 8px auto;
}
.floor-price {
    font-size: 18px;
    color: #FF0036;
    line-height: 18px;
    text-align: center;
    margin-top: 10px;
}
.zong {
    text-align: center;
}
.w {
    width: 1226px;
    margin: 0 auto;
}
.gowu2 {
    background-color: #fff;
    width: 234px;
    height: 300px;
    float: left;
    margin-bottom: 14px;
}
.gowu2:hover {
    box-shadow: 10px 10px 10px -4px rgba(0,0,0,0.3);
}


相关实践学习
如何快速连接云数据库RDS MySQL
本场景介绍如何通过阿里云数据管理服务DMS快速连接云数据库RDS MySQL,然后进行数据表的CRUD操作。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心,利用清洁计算为万物互联的新世界提供源源不断的能源动力,目前开服的区域包括中国(华北、华东、华南、香港)、新加坡、美国(美东、美西)、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程,来了解阿里云能够为你的业务带来哪些帮助 &nbsp; &nbsp; 相关的阿里云产品:云服务器ECS 云服务器 ECS(Elastic Compute Service)是一种弹性可伸缩的计算服务,助您降低 IT 成本,提升运维效率,使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
相关文章
|
27天前
|
NoSQL Java 关系型数据库
Liunx部署java项目Tomcat、Redis、Mysql教程
本文详细介绍了如何在 Linux 服务器上安装和配置 Tomcat、MySQL 和 Redis,并部署 Java 项目。通过这些步骤,您可以搭建一个高效稳定的 Java 应用运行环境。希望本文能为您在实际操作中提供有价值的参考。
119 26
|
30天前
|
JavaScript 安全 Java
java版药品不良反应智能监测系统源码,采用SpringBoot、Vue、MySQL技术开发
基于B/S架构,采用Java、SpringBoot、Vue、MySQL等技术自主研发的ADR智能监测系统,适用于三甲医院,支持二次开发。该系统能自动监测全院患者药物不良反应,通过移动端和PC端实时反馈,提升用药安全。系统涵盖规则管理、监测报告、系统管理三大模块,确保精准、高效地处理ADR事件。
|
2月前
|
关系型数据库 MySQL Java
MySQL索引优化与Java应用实践
【11月更文挑战第25天】在大数据量和高并发的业务场景下,MySQL数据库的索引优化是提升查询性能的关键。本文将深入探讨MySQL索引的多种类型、优化策略及其在Java应用中的实践,通过历史背景、业务场景、底层原理的介绍,并结合Java示例代码,帮助Java架构师更好地理解并应用这些技术。
57 2
|
2月前
|
监控 前端开发 Java
【技术开发】接口管理平台要用什么技术栈?推荐:Java+Vue3+Docker+MySQL
该文档介绍了基于Java后端和Vue3前端构建的管理系统的技术栈及功能模块,涵盖管理后台的访问、登录、首页概览、API接口管理、接口权限设置、接口监控、计费管理、账号管理、应用管理、数据库配置、站点配置及管理员个人设置等内容,并提供了访问地址及操作指南。
|
2月前
|
分布式计算 关系型数据库 MySQL
SpringBoot项目中mysql字段映射使用JSONObject和JSONArray类型
SpringBoot项目中mysql字段映射使用JSONObject和JSONArray类型 图像处理 光通信 分布式计算 算法语言 信息技术 计算机应用
62 8
|
3月前
|
SQL Java 关系型数据库
java连接mysql查询数据(基础版,无框架)
【10月更文挑战第12天】该示例展示了如何使用Java通过JDBC连接MySQL数据库并查询数据。首先在项目中引入`mysql-connector-java`依赖,然后通过`JdbcUtil`类中的`main`方法实现数据库连接、执行SQL查询及结果处理,最后关闭相关资源。
253 6
|
3月前
|
SQL JavaScript 关系型数据库
node博客小项目:接口开发、连接mysql数据库
【10月更文挑战第14天】node博客小项目:接口开发、连接mysql数据库
|
2月前
|
关系型数据库 MySQL Java
SpringBoot项目中mysql字段映射使用JSONObject和JSONArray类型
SpringBoot项目中mysql字段映射使用JSONObject和JSONArray类型
38 0
|
14天前
|
存储 Oracle 关系型数据库
数据库传奇:MySQL创世之父的两千金My、Maria
《数据库传奇:MySQL创世之父的两千金My、Maria》介绍了MySQL的发展历程及其分支MariaDB。MySQL由Michael Widenius等人于1994年创建,现归Oracle所有,广泛应用于阿里巴巴、腾讯等企业。2009年,Widenius因担心Oracle收购影响MySQL的开源性,创建了MariaDB,提供额外功能和改进。维基百科、Google等已逐步替换为MariaDB,以确保更好的性能和社区支持。掌握MariaDB作为备用方案,对未来发展至关重要。
39 3
|
14天前
|
安全 关系型数据库 MySQL
MySQL崩溃保险箱:探秘Redo/Undo日志确保数据库安全无忧!
《MySQL崩溃保险箱:探秘Redo/Undo日志确保数据库安全无忧!》介绍了MySQL中的三种关键日志:二进制日志(Binary Log)、重做日志(Redo Log)和撤销日志(Undo Log)。这些日志确保了数据库的ACID特性,即原子性、一致性、隔离性和持久性。Redo Log记录数据页的物理修改,保证事务持久性;Undo Log记录事务的逆操作,支持回滚和多版本并发控制(MVCC)。文章还详细对比了InnoDB和MyISAM存储引擎在事务支持、锁定机制、并发性等方面的差异,强调了InnoDB在高并发和事务处理中的优势。通过这些机制,MySQL能够在事务执行、崩溃和恢复过程中保持
42 3

热门文章

最新文章