SRemoveGoodServlet

package org.example.controllor;
import org.apache.catalina.session.StandardSession;
import org.example.api.IGoodService;
import org.example.service.impl.GoodServiceImpl;
import org.example.api.entity.Good;
import org.example.api.entity.GoodList;
import org.example.api.utils.JavaDateConnectionUtils;
import org.example.service.impl.GoodServiceImpl;
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.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
@WebServlet("/SRemoveGood")
public class SRemoveGoodServlet extends HttpServlet {
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // 防止乱码
        response.setContentType("text/html;charset=UTF-8");
        request.setCharacterEncoding("UTF-8");
        String id = request.getParameter("id");
        String userName = request.getParameter("userName");
        IGoodService iGoodService = new GoodServiceImpl();
        GoodList goodList = new GoodList();
        boolean judgment = false;
        try {
            judgment = iGoodService.select(id);
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        if (judgment == true && userName.equals("侯凯")) {
            JavaDateConnectionUtils javaDateConnection = new JavaDateConnectionUtils();
            PreparedStatement preparedStatement = null;
            Connection connection = null;
            try {
                connection = javaDateConnection.getConn();
                String sql = "delete from t_good where goodId=?";
                preparedStatement = connection.prepareStatement(sql);
                preparedStatement.setString(1, id);
                int rs = preparedStatement.executeUpdate();
                if (rs == 1) {
                    HttpSession httpSession = request.getSession();
                    request.setAttribute("ji","商品删除成功！！！");
                    request.getRequestDispatcher("showgoods.jsp").forward(request, response);
                }
                else {
                    request.getRequestDispatcher("showgoods.jsp").forward(request,response);
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            } finally {
                try {
                    connection.close();
                    preparedStatement.close();
                } catch (SQLException throwables) {
                    throwables.printStackTrace();
                }
            }
        }
        else {
            HttpSession httpSession = request.getSession();
            request.setAttribute("ji","商品删除失败！！！您无删除商品的权限,");
            request.getRequestDispatcher("showgoods.jsp").forward(request,response);
        }
    }
}

#  web层
```java
```java
```java
```clike
<%@ page language="java" contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>账号注册</title>
</head>
<style>
    #a {
        width:50%;
        height:50%;
        border: 1px dashed ;
        background-color: #90eee3;
        text-align:center;
    }
    body{
        background-color: #e0f9ff;
    }
</style>
<body>
<div id="a">
    <h1>注销账号</h1>
    <form action="/DeleteUser"  method="post">
        用&nbsp;户&nbsp;名:
        <input type="text" name="userName">
        <br>
        密&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码:
        <input type="password" name="userPassword">
        <br>
        手&nbsp;机&nbsp;号:
        <input type="text" name="telephone">
        <br>
        <input type="submit" value="注销">
    </form>
</div>
<h3 align="center" ><%=request.getAttribute("msg")%></h3>
<h2 align="center"><a href="register.jsp">点击重新注册账号</a></h2>
</body>
</html>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html" charset="UTF-8">
    <title>黑市商城首页</title>
</head>
<%response.setContentType("text/html;charset=UTF-8");
request.setCharacterEncoding("UTF-8");%>
<body bgcolor="#add8e6">
<table width="100%">
    <tr>
        <td>
            <table width="100%">
                <tr>
                    <td>
                        <a href="register.jsp">注册</a>
                        <a href="login.jsp">登录</a>
                        <a href="delete.jsp">注销</a>
                        <a href="showcar.jsp">订单</a>
                        <a href="#">帮助</a>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
    <!--第二部分-->
    <tr bgcolor="black">
        <td height="50px">
            <a href="#"><font color="white">首页</font></a>
            <a href="#"><font color="white">碳酸饮料</font></a>
            <a href="#"><font color="white">乳饮</font></a>
            <a href="#"><font color="white">果茶</font></a>
            <a href="#"><font color="white">其他饮料</font></a>
        </td>
    </tr>
    <tr>
        <td>
            <img src="https://n.sinaimg.cn/spider2020420/133/w600h333/20200420/4c7d-iskepxt7981236.png" height="300px" width="100%" />
        </td>
    </tr>
    <tr>
        <td>
            <table>
                <tr>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                </tr>
                <tr>
                    <td>
                        <img src="https://cbu01.alicdn.com/img/ibank/2019/935/265/11703562539_780901980.jpg" height="200px" width="200px"/>
                        <p><a>旺仔牛奶（一排）</a></p>
                        <p><font color="red">$20</font></p>
                    </td>
                    <td>
                        <img src="https://tse3-mm.cn.bing.net/th/id/OIP.kz-2OVuNiFTQrYHAD7jP2AAAAA?pid=ImgDet&rs=1" height="200px" width="200px"/>
                        <p><a>脉动</a></p>
                        <p><font color="red">$5</font></p>
                    </td>
                    <td>
                    <img src="https://th.bing.com/th/id/R48187afbfb548050648990f0dd7a3fe0?rik=cXl%2bo9kjuPe5YA&riu=http%3a%2f%2fwww.shikefood.com%2fimages%2f201706%2fsource_img%2f10502_P_1497391133066.jpg&ehk=4xKqaMC%2fueYJILKz3HynqZJ25tDpC2%2bZf5YKEAkPfTA%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                    <p><a>乌龙茶</a></p>
                    <p><font color="red">$1</font></p>
                    </td>
                    <td>
                    <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                    <p><a>可口可乐</a></p>
                    <p><font color="red">$3</font></p>
                </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rdb7c7cba11e8e880930a480ff0db0c87?rik=cTjPOJPJyoleSA&riu=http%3a%2f%2fpic109.nipic.com%2ffile%2f20160916%2f6062299_163706413000_2.jpg&ehk=1nPt6VryGF2MlNMFi8ChxJ1PhlVp1k1%2fKnz2bLkL6VQ%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>可口可乐</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                </tr>
                <tr>
                    <td>
                        <img src="https://th.bing.com/th/id/Rbf660f71a587e9c365139518e7b084b1?rik=O1SdZo5%2f8tmEpQ&riu=http%3a%2f%2fpic299.nipic.com%2ffile%2f20200611%2f19051700_194646446000_2.jpg&ehk=GDt8l%2bRaESjBBHz%2bfP5TVTqjtCGNHypsIubHbRgbsSs%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>果茶</a></p>
                        <p><font color="red">$15</font></p>
                    </td>
                    <td>
                        <img src="https://tse1-mm.cn.bing.net/th/id/OIP.WzXja99RFLlHs4LreoO3GQHaGq?pid=ImgDet&rs=1" height="200px" width="200px"/>
                        <p><a>七喜</a></p>
                        <p><font color="red">$7</font></p>
                    </td>
                    <td>
                        <img src="https://imgservice4.suning.cn/uimg1/b2c/image/gs0RyM76yxGFGVefFTHpAg==.jpg_400w_400h_4e" height="200px" width="200px"/>
                        <p><a>水晶葡萄</a></p>
                        <p><font color="red">$4.5</font></p>
                    </td>
                    <td>
                        <img src="https://tse3-mm.cn.bing.net/th/id/OIP.U6N6vZvwHFWmqFq8Pk8tPQHaKE?pid=ImgDet&rs=1" height="200px" width="200px"/>
                        <p><a>美年达</a></p>
                        <p><font color="red">$3</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rc68719c95e68240324bad6459d625675?rik=1SpDWN3ULeZtsQ&riu=http%3a%2f%2fimages.zon100.com%2fimg%2f10000518%2f1100141218%2f1100206232_1000.jpg&ehk=DcWYen6bIosj%2f4LJlX0g1xbitDegc7ga78tDMlubvo4%3d&risl=&pid=ImgRaw" height="200px" width="200px"/>
                        <p><a>绿茶</a></p>
                        <p><font color="red">$5</font></p>
                    </td>
                    <td>
                        <img src="https://th.bing.com/th/id/Rbc672bbf2693119837a8d3f5df6e2fbd?rik=KpfIwTaSBYPgdw&riu=http%3a%2f%2fwx1.sinaimg.cn%2flarge%2f006APoFYly1ga7ynozy6eg308c069dg7.gif&ehk=raDwaMUtQHU1LIZCkiu2tn91MXGEsd1k5uqrK7hXh7I%3d&risl=&pid=ImgRaw" height="200px" width="220px"/>
                        <p><a>营养快线</a></p>
                        <p><font color="red">$998</font></p>
                    </td>
                </tr>
            </table>
        </td>
    </tr>
    <tr>
        <td>
            <img src="picture/banner.jpg" height="5%" width="100%"/>
        </td>
    </tr>
    <tr>
        <td align="center">
            <a href="#">服务保障</a>
            <a href="#">联系我们</a>
            <a href="#">关于我们</a>
            <a href="#">投诉建议</a>
            <br />
            <p>HK黑市商城&copy;2021-4.18火爆开启</p>
        </td>
    </tr>
</table>
</body>
</html>
<%@ page language="java" contentType="text/html;
charset=utf-8"
         pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type"
          content="text/html; charset=utf-8">
    <title>用户登录</title>
    <style>
        #a {
            width:50%;
            height:200px;
            border: 1px dashed ;
            background-color: #e0fff4;
            text-align:center;
        }
        body{
            background-color:lightblue;
        }
    </style>
</head>
<body>
<div id="a">
    <h1>登录界面</h1>
    <form action="/loginUser" method="post">
        账号:<input type="text" name="userName"/>
        <br>
        密码:<input type="password" name="userPassword"/>
        <br>
        <input type="submit" value="登录"/>
        没有账号？<a href ="register.jsp">注册账号</a><br>
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;多余账号？<a href="delete.jsp">注销账号</a>
    </form>
</div>
<h3 align="center" ><%=request.getAttribute("msg")%></h3>
<h2 align="center"><a href="showgoods.jsp">点击进入商品界面</a></h2>
</body>
</html>
<%@ page language="java" contentType="text/html;charset=utf-8" pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>账号注册</title>
</head>
<style>
    #a {
        width:50%;
        height:50%;
        border: 1px dashed ;
        background-color: #90eee6;
        text-align:center;
    }
    body{
        background-color: #e0f9ff;
    }
</style>
<body>
<div id="a">
    <h1>注册账号</h1>
    <form action="/InsertUser"  method="post">
        用&nbsp;户&nbsp;名:
        <input type="text" name="userName">
        <br>
        密&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;码:
        <input type="password" name="userPassword">
        <br>
        性&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;别:
        <input type="text" name="sex">
        <br>
        年&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;龄:
        <input type="text" name="age">
        <br>
        手&nbsp;机&nbsp;号:
        <input type="text" name="telephone">
        <br>
        <input type="submit" value="注册">
        已有账号？<a href ="login.jsp">点击登录</a><br>
    </form>
</div>
<h3 align="center" ><%=request.getAttribute("msg")%></h3>
</body>
</html>
<%@ page language="java" contentType="text/html;
charset=utf-8"
         pageEncoding="utf-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD
HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type"
          content="text/html; charset=utf-8">
    <title>添加商品</title>
    <style>
        #a {
            width:50%;
            height:200px;
            border: 1px dashed ;
            background-color: #e0fff4;
            text-align:center;
        }
        <%
        String userName = request.getParameter("userName");
        response.setContentType("text/html;charset=UTF-8");
    request.setCharacterEncoding("UTF-8");
        %>
        body{
            background-color:lightblue;
        }
    </style>
</head>
<body>
<div id="a">
    <h1>添加商品界面</h1>
    <form action="/SAddGood?userName=<%=userName%>" method="post">
        商品名称:<input type="text" name="goodName"/>
        <br>
        商品价格:<input type="text" name="goodValue"/>
        <br>
        &nbsp;&nbsp;商品ID:<input type="text" name="goodId"/>
        <br>
        <input type="submit" value="添加"/>
    </form>
</div>
<h3 align="center" ><%=request.getAttribute("msg")%></h3>
<h2 align="center"><a href="showgoods.jsp">点击进入商品界面</a></h2>
</body>
</html>
<%@page import="java.util.ArrayList"%>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="org.example.api.entity.Good" %>
<%@ page import="org.example.api.entity.GoodList" %>
<%@ page import="org.example.api.utils.MyTools" %>
<%@ page import="org.example.api.entity.OrderList" %>
<%
    float total = 0;
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html" charset="UTF-8">
    <link href="styles.css" type="text/css" rel="stylesheet" />
    <title>黑市订单</title>
</head>
<body>
<%
    response.setContentType("text/html;charset=UTF-8");
    request.setCharacterEncoding("UTF-8");
    HttpSession httpSession = request.getSession();
    String userName = (String) httpSession.getAttribute("userName");
%>
<h3 align="left"><a href="/SelectOrder?userName=<%=userName%>">点击刷新订单</a></h3>
<h3 align="right"><a href="index.jsp">返回主页面</a></h3>
<%
    ArrayList <Good> buyList = null;
    buyList = (ArrayList<Good>) request.getAttribute("Array1");
%>
<table>
    <tr height="50">
        <td colspan="3" align="center" ><h1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;订单</h1></td>
    </tr>
    <tr align="center" height="30" bgcolor="lightgrey">
        <td>名称</td>
        <td>价格</td>
        <td>数量</td>
        <td>移除</td>
    </tr>
    <% if(buyList == null || buyList.size() == 0){ %>
    <tr height="100">
        <td colspan="3" align="center">您的订单还未添加任何商品！<br>
        请尝试刷新您的订单！</td>
    </tr>
    <%
    }else{
        for(int i = 0; i < buyList.size(); i++){
            Good single = buyList.get(i);
            float money = MyTools.strToInt(single.getGoodValue())*MyTools.strToInt(single.getGoodNum());
            total += money;
    %>
    <tr align="center" height="50">
        <td><%= single.getGoodName() %></td>
        <td><%= single.getGoodValue() %></td>
        <td>
            <a href="/AddGood?id=<%=single.getGoodId()%>&userName=<%=userName%>">
                <img src="https://img.51miz.com/Element/00/79/78/04/372c7712_E797804_81ee5239.png" width="20" height="20"/>
            </a>
            <strong><%=single.getGoodNum()%></strong>
            <a href="/RemoveGood?id=<%=single.getGoodId()%>&userName=<%=userName%>">
                <img src="https://th.bing.com/th/id/Rcde7b52d6b859e47df4f30a4980b9463?rik=AcAi8g%2bYJfQoDA&riu=http%3a%2f%2fbpic.588ku.com%2felement_pic%2f01%2f35%2f82%2f18573bf7012f19d.jpg&ehk=VxpGi3%2fpJexj4F4DOLo6a5gL1h6XaX%2b%2b51f6TPL7iGI%3d&risl=&pid=ImgRaw" width="20" height="20"/>
            </a>
        </td>
        <td><a href="/RemoveOrder?id=<%=single.getGoodId()%>&userName=<%=userName%>">移除</a></td>
    </tr>
    <%
            }
        }
    %>
    <tr height="50">
        <td colspan="3" align="left" ><h4>应付金额：<%= total %></h4></td>
        <br>
    </tr>
    <tr align="center" height="50">
        <td align="left" colspan="3"><a href="showgoods.jsp">继续购物</a></td>
        <td align="right" colspan="3"><a href="/RemoveAllGood?userName=<%=userName%>">清除订单</a></td>
    </tr>
</table>
</body>
</html>
<%@page import="java.util.ArrayList"%>
<%@page import="org.example.controllor.SelectGoodServlet" %>
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="org.example.api.entity.Good" %>
<%@ page import="org.example.api.entity.GoodList" %>
<%@ page import="java.security.Principal" %>
<jsp:useBean id="goodList" class="org.example.api.entity.GoodList" scope="session"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>黑市</title>
    <link href="styles.css" type="text/css" rel="stylesheet" />
</head>
<body>
<%
    response.setContentType("text/html;charset=UTF-8");
    request.setCharacterEncoding("UTF-8");
%>
<%
    HttpSession httpSession = request.getSession();
    ArrayList <Good> goodsList = new ArrayList<Good>();
    String userName = (String) httpSession.getAttribute("userName");
    goodsList = (ArrayList<Good>) httpSession.getAttribute("Array");
    String  ji = request.getAttribute("ji") + "请重新刷新商品页面以查看全部商品";
%>
<a href="/SelectGood">点击刷新商品</a>
<script>alert("<%=ji%>")</script>
<table>
    <tr height="50">
        <td colspan="3" align="center" ><h1>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;黑市商城</h1></td>
    </tr>
    <tr align="center" height="30" bgcolor="lightgrey">
        <td></td>
        <td>名称</td>
        <td>价格</td>
        <td>购买</td>
    </tr>
    <% if(goodsList == null || goodsList.size() == 0){ %>
    <tr height="100">
        <td colspan="3" align="center">没有商品可以显示！<br>
        请尝试刷新商品！</td>
    </tr>
    <%
    }else{
        for(int i = 0; i < goodsList.size(); i++){
            Good single =goodsList.get(i);
    %>
    <tr align="center" height="50">
        <td>
            <a href="/SRemoveGood?userName=<%=userName%>&id=<%=single.getGoodId()%>">
            <img src="https://img.51miz.com/Element/00/77/34/97/c78a8ea1_E773497_8e853fd8.png" width="30" height="30"/>
        </a>
        </td>
        <td><%= single.getGoodName() %></td>
        <td><%= single.getGoodValue() %></td>
        <td>
        <a href="/InsertGood?id=<%=single.getGoodId()%>&name=<%=single.getGoodName()%>&value=<%=single.getGoodValue()%>&userName=<%=userName%>">购买</a>
        </td>
    </tr>
    <%
            }
        }
    %>
    <tr align="center" height="50">
        <td align="left" colspan="3">
            <a href="/SAddGood.jsp?userName=<%=userName%>">
                添加商品
            </a>
        </td>
        <td align="right" colspan="3"><a href="showcar.jsp">查看订单</a></td>
    </tr>
</table>
</body>
</html>
@charset "UTF-8";
table{
  border: 1px;
  width: 500px;
  rules: none;
  cellspacing:0px;
  cellpadding:0px;
}
tr{
  height: 50px;
}
td{
  width:100px;
}
a:link {
 text-decoration: none;
}
a:visited {
 text-decoration: none;
}
a:hover {
 text-decoration: none;
}
a:active {
 text-decoration: none;
}

dao层

selectGood

```clike
package org.example.dao;
import java.sql.SQLException;
public interface IGoodDao {
  /**
   * 查询全部商品
   * @return
   * @throws SQLException
   */
  boolean selectGood() throws SQLException;
  /**
   * 根据商品id查询特定商品
   * @param id
   * @return
   * @throws SQLException
   */
  boolean select(String id) throws  SQLException;
}
package org.example.dao;
import java.sql.SQLException;
public interface IOrderDao {
    /**
     * 根据订单id及所传的userName查询订单
     * @param orderId
     * @param userName
     * @return
     * @throws SQLException
     */
       boolean selectOrder(String orderId , String userName) throws SQLException;
    /**
     * 查询全部订单
     * @return
     * @throws SQLException
     */
    boolean select() throws SQLException;
}
package org.example.dao;
import java.sql.SQLException;
public interface IUserDao {
    /**
     * 根据用户账号查询用户
     * @param userName
     * @return
     * @throws SQLException
     */
    boolean loginUser(String userName) throws SQLException;
    /**
     * 根据用户名及密码查询特定用户
     * @param userName
     * @param userPassword
     * @return
     * @throws SQLException
     */
    boolean loginUser1(String userName,String userPassword)throws SQLException;
}

selectGood

package org.example.dao.impl;
import org.example.dao.IUserDao;
import org.example.api.utils.JavaDateConnectionUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class selectGood implements IUserDao {
    int a=0;
    JavaDateConnectionUtils javaDateConnectionUtils = new JavaDateConnectionUtils();
    Connection connection = javaDateConnectionUtils.getConn();
    @Override
    public boolean loginUser(String userName) throws SQLException {
        String iSql = "select * from t_user where userName=?";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
preparedStatement.setString(1,userName);
         ResultSet re=   preparedStatement.executeQuery();
        while (re.next()){
            a++;
            System.out.println(re.getString("userName")+""+re.getString("userPassword"));
        }if (a!=0){
        System.out.println("查询成功");
        preparedStatement.close();
        connection.close();
        return true;}
        else {preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
    @Override
    public boolean loginUser1(String userName, String userPassword) throws SQLException {
        String iSql = "select * from t_user where userName=? and userPassword=?";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
        preparedStatement.setString(1,userName);
        preparedStatement.setString(2,userPassword);
        ResultSet re=   preparedStatement.executeQuery();
        while (re.next()){
            a++;
            System.out.println(re.getString("userName")+""+re.getString("userPassword"));
        }if (a!=0){
            System.out.println("查询成功");
            preparedStatement.close();
            connection.close();
            return true;}
        else {preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
}

impl.OrderDaoImpl

package org.example.dao.impl;
import org.example.dao.IOrderDao;
import org.example.api.utils.JavaDateConnectionUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class OrderDaoImpl implements IOrderDao {
    int a = 0;
    JavaDateConnectionUtils javaDateConnectionUtils = new JavaDateConnectionUtils();
    Connection connection = javaDateConnectionUtils.getConn();
    @Override
    public boolean selectOrder(String orderId , String userName) throws SQLException {
        String iSql = "select * from t_order where orderId=? and userName=?";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
        preparedStatement.setString(1, orderId);
        preparedStatement.setString(2,userName);
        ResultSet re = preparedStatement.executeQuery();
        while (re.next()) {
            a++;
            System.out.println(re.getString("orderId")+re.getString("userName"));
        }
        if (a != 0) {
            System.out.println("查询成功");
            preparedStatement.close();
            connection.close();
            return true;
        } else {
            preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
    public boolean select () throws SQLException {
        String iSql = "select * from t_order ";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
        ResultSet re = preparedStatement.executeQuery();
        while (re.next()) {
            a++;
            System.out.println(re.getString("orderId"));
        }
        if (a != 0) {
            System.out.println("查询成功");
            preparedStatement.close();
            connection.close();
            return true;
        } else {
            preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
}

impl.GoodDaoImpl

package org.example.dao.impl;
import org.example.api.utils.JavaDateConnectionUtils;
import org.example.dao.IGoodDao;
import org.example.api.utils.JavaDateConnectionUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class GoodDaoImpl implements IGoodDao {
    int a=0;
    JavaDateConnectionUtils javaDateConnectionUtils = new JavaDateConnectionUtils();
    Connection connection = javaDateConnectionUtils.getConn();
    @Override
    public boolean selectGood() throws SQLException {
        String iSql = "select * from t_good ";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
        ResultSet re=   preparedStatement.executeQuery();
        while (re.next()){
            a++;
            System.out.println(re.getString("goodId")+""+re.getString("goodName"));
        }if (a!=0){
            System.out.println("查询成功");
            preparedStatement.close();
            connection.close();
            return true;}
        else {preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
    public boolean select(String id) throws SQLException {
        String iSql = "select * from t_good where goodId=?";
        PreparedStatement preparedStatement = null;
        preparedStatement = connection.prepareStatement(iSql);
        preparedStatement.setString(1,id);
        ResultSet re=   preparedStatement.executeQuery();
        while (re.next()){
            a++;
            System.out.println(re.getString("goodId")+""+re.getString("goodName"));
        }if (a!=0){
            System.out.println("查询成功");
            preparedStatement.close();
            connection.close();
            return true;}
        else {preparedStatement.close();
            connection.close();
            System.out.println("查询失败");
            return false;
        }
    }
}

service层

IUserService

```clike
package org.example.api;
import java.sql.SQLException;
public interface IUserService {
    /**
     * 用户增加接口
     * @param
     * @return boolean
     */
    boolean insertUser(String userName,String userPassword) throws SQLException;
    /**
     * 用户登录接口
     * @param userName
     * @return
     */
    boolean loginUser(String userName) throws SQLException;
}
package org.example.api;
import java.sql.SQLException;
public interface IOrderService {
     /**
      *根据订单id 及 登录的userName来查询订单
      * @param orderId
      * @param userName
      * @return
      * @throws SQLException
      */
     boolean selectOrder(String orderId , String userName) throws SQLException;
     /**
      * 查询全部订单
      * @return
      * @throws SQLException
      */
     boolean select() throws SQLException;
}

IGoodService

package org.example.api;
import java.sql.SQLException;
public interface IGoodService {
    /**
     * 查询全部商品
      * @return
     * @throws SQLException
     */
    boolean selectGood () throws SQLException;
    /**
     * 根据商品id查询特定商品
     * @param id
     * @return
     * @throws SQLException
     */
    boolean select(String id) throws SQLException;
}

UserServiceImpl

package org.example.service.impl;
import org.example.api.IUserService;
import org.example.dao.IUserDao;
import org.example.dao.impl.UserDaoImpl;
import java.sql.SQLException;
import java.sql.SQLRecoverableException;
public class UserServiceImpl implements IUserService {
    IUserDao iUserDao = new UserDaoImpl();
    public boolean insertUser(String userName,String userPasswprd) throws SQLException {
        return iUserDao.loginUser1(userName,userPasswprd);
    }
    @Override
    public boolean loginUser(String userName) throws SQLException {
        return iUserDao.loginUser(userName);
    }
}

OrderServiceImpl

package org.example.service.impl;
import org.example.api.IOrderService;
import org.example.dao.IOrderDao;
import org.example.dao.impl.OrderDaoImpl;
import java.sql.SQLException;
public class OrderServiceImpl implements IOrderService {
    IOrderDao iOrderDao = new OrderDaoImpl();
    public boolean selectOrder(String orderId , String userName) throws SQLException {
        return iOrderDao.selectOrder(orderId,userName) ;
    }
    public boolean select() throws SQLException {
        return iOrderDao.select();
    }
}

GoodServiceImpl

package org.example.service.impl;
import org.example.dao.impl.GoodDaoImpl;
import org.example.api.IGoodService;
import org.example.api.IGoodService;
import org.example.dao.IGoodDao;
import java.sql.SQLException;
public class GoodServiceImpl implements IGoodService {
    IGoodDao iGoodDao = new GoodDaoImpl();
    @Override
    public boolean selectGood() throws SQLException {
        return iGoodDao.selectGood();
    }
    @Override
    public boolean select(String id) throws SQLException {
        return iGoodDao.select(id);
    }
}

utils层

JavaDateConnectionUtils

```java
package org.example.api.utils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class JavaDateConnectionUtils {
    /**
     * 获取数据库连接
     *
     * @return Connection
     */
    public Connection getConn() {
        String url = "jdbc:mysql://localhost:3306/project?serverTimezone=UTC";
        String username = "root";
        String password = "Hyk59308";
        Connection conn = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //classLoader,加载对应驱动
            conn = DriverManager.getConnection(url, username, password);
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return conn;
    }
}

MyTools

package org.example.api.utils;
import java.io.UnsupportedEncodingException;
public class MyTools {
    public static String toChinese(String str) {
        if(str == null) {
            str="";
        }
        try {
            str = new String(str.getBytes("ISO-8859-1"),"gb2312");
        }catch(UnsupportedEncodingException e) {
            str="";
            e.printStackTrace();
        }
        return str;
    }
    public static int strToInt(String str) {
        if(str == null || str.equals("")) {
            str = "0";
        }
        int i = 0;
        try {
            i = Integer.parseInt(str);
        }catch(NumberFormatException e) {
            i = 0;
            e.printStackTrace();
        }
        return i;
    }
}

日志配置

<?xml version="1.0" encoding="UTF-8"?>
<!--日志级别以及优先级排序: OFF > FATAL > ERROR > WARN > INFO > DEBUG > TRACE > ALL-->
<!--Configuration后面的status，这个用于设置log4j2自身内部的信息输出，可以不设置，当设置成trace时，你会看到log4j2内部各种详细输出-->
<!--monitorInterval：Log4j能够自动检测修改配置 文件和重新配置本身，设置间隔秒数-->
<configuration status="INFO" monitorInterval="30">
    <!--先定义所有的appender-->
    <appenders>
        <!--这个输出控制台的配置-->
        <console name="Console" target="SYSTEM_OUT">
            <!--输出日志的格式-->
            <PatternLayout pattern="[%d{HH:mm:ss:SSS}] [%p] - %l - %m%n"/>
        </console>
        <!--文件会打印出所有信息，这个log每次运行程序会自动清空，由append属性决定，这个也挺有用的，适合临时测试用-->
        <File name="log" fileName="${sys:user.home}/logs/test.log" append="false">
            <PatternLayout pattern="%d{HH:mm:ss.SSS} %-5level %class{36} %L %M - %msg%xEx%n"/>
        </File>
        <!-- 这个会打印出所有的info及以下级别的信息，每次大小超过size，则这size大小的日志会自动存入按年份-月份建立的文件夹下面并进行压缩，作为存档-->
        <RollingFile name="RollingFileInfo" fileName="${sys:user.home}/logs/info.log"
                     filePattern="${sys:user.home}/logs/$${date:yyyy-MM}/info-%d{yyyy-MM-dd}-%i.log">
            <!--控制台只输出level及以上级别的信息（onMatch），其他的直接拒绝（onMismatch）-->
            <ThresholdFilter level="info" onMatch="ACCEPT" onMismatch="DENY"/>
            <PatternLayout pattern="[%d{HH:mm:ss:SSS}] [%p] - %l - %m%n"/>
            <Policies>
                <TimeBasedTriggeringPolicy/>
                <SizeBasedTriggeringPolicy size="100 MB"/>
            </Policies>
        </RollingFile>
        <RollingFile name="RollingFileWarn" fileName="${sys:user.home}/logs/warn.log"
                     filePattern="${sys:user.home}/logs/$${date:yyyy-MM}/warn-%d{yyyy-MM-dd}-%i.log">
            <ThresholdFilter level="warn" onMatch="ACCEPT" onMismatch="DENY"/>
            <PatternLayout pattern="[%d{HH:mm:ss:SSS}] [%p] - %l - %m%n"/>
            <Policies>
                <TimeBasedTriggeringPolicy/>
                <SizeBasedTriggeringPolicy size="100 MB"/>
            </Policies>
            <!-- DefaultRolloverStrategy属性如不设置，则默认为最多同一文件夹下7个文件，这里设置了20 -->
            <DefaultRolloverStrategy max="20"/>
        </RollingFile>
        <RollingFile name="RollingFileError" fileName="${sys:user.home}/logs/error.log"
                     filePattern="${sys:user.home}/logs/$${date:yyyy-MM}/error-%d{yyyy-MM-dd}-%i.log">
            <ThresholdFilter level="error" onMatch="ACCEPT" onMismatch="DENY"/>
            <PatternLayout pattern="[%d{HH:mm:ss:SSS}] [%p] - %l - %m%n"/>
            <Policies>
                <TimeBasedTriggeringPolicy/>
                <SizeBasedTriggeringPolicy size="100 MB"/>
            </Policies>
        </RollingFile>
    </appenders>
    <!--然后定义logger，只有定义了logger并引入的appender，appender才会生效-->
    <loggers>
        <!--        &lt;!&ndash;过滤掉spring和mybatis的一些无用的DEBUG信息&ndash;&gt;-->
        <!--        <logger name="org.springframework" level="INFO"></logger>-->
        <!--        <logger name="org.mybatis" level="INFO"></logger>-->
        <root level="INFO">
            <appender-ref ref="Console"/>
            <appender-ref ref="RollingFileInfo"/>
            <appender-ref ref="RollingFileWarn"/>
            <appender-ref ref="RollingFileError"/>
        </root>
    </loggers>
</configuration>

jsp+servlet+tomcat实现网上商城（下）

SRemoveGoodServlet

dao层

selectGood

selectGood

impl.OrderDaoImpl

impl.GoodDaoImpl

service层

IUserService

IGoodService

UserServiceImpl

OrderServiceImpl

GoodServiceImpl

utils层

JavaDateConnectionUtils

MyTools

日志配置

热门文章

最新文章

相关课程

相关电子书

热门

活动广场

任务中心

开发者评测

高校计划

乘风者计划

训练营

阿里云MVP

话题

直播

下载

镜像站

技术资料

插件

jsp+servlet+tomcat实现网上商城（下）

SRemoveGoodServlet

dao层

selectGood

selectGood

impl.OrderDaoImpl

impl.GoodDaoImpl

service层

IUserService

IGoodService

UserServiceImpl

OrderServiceImpl

GoodServiceImpl

utils层

JavaDateConnectionUtils

MyTools

日志配置

热门文章

最新文章

相关课程

相关电子书