JAVA小程序:库存的更新与交易额(商品总额)的回显

1.创建pom



mysql
mysql-connector-java
5.1.26



javax.servlet
javax.servlet-api
3.1.0
provided

2.product.html

3.500.jsp
<%@ page contentType=“text/html;charset=UTF-8” language=“java” %>

库存不足

我是一个新的500页面

4.web.xml

Archetype Created Web Application 500 /500.jsp

5.ProductServlet
package com.youfeng.servlet;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

@WebServlet(urlPatterns = “/product”)
public class ProductServlet extends HttpServlet {

protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws IOException, ServletException {
    Integer fuzhuangNumber = Integer.valueOf(request.getParameter("fuzhuangNumber"));
    Integer jiadianNumber = Integer.valueOf(request.getParameter("jiadianNumber"));
    int fuzhuangkucun = 0;
    int jiadiankucun = 0;
    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aaaaa", "root", "root");
        Statement statement = conn.createStatement();
        String select1 = "select number from product3 where id =1";
        ResultSet rs = statement.executeQuery(select1);
        if (rs.next()) {
            fuzhuangkucun = rs.getInt("number");
        }
        String select2 = "select number from product3 where id =2";
        ResultSet rs2 = statement.executeQuery(select2);
        if (rs2.next()) {
            jiadiankucun = rs2.getInt("number");
        }
        statement.close();
        conn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
    System.out.println(fuzhuangNumber);
    System.out.println(fuzhuangkucun);
    System.out.println(jiadianNumber);
    System.out.println(jiadiankucun);


    if ( fuzhuangNumber<0 && Math.abs(fuzhuangNumber)>fuzhuangkucun ||jiadianNumber<0&& Math.abs(jiadianNumber)>jiadiankucun) {
            throw new Error();
    } else {
        try {
            Class.forName("com.mysql.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/aaaaa", "root", "root");
            Statement statement = conn.createStatement();
            String update1 = "UPDATE  product3 set number = number + " + fuzhuangNumber + " where id =1";
            String update2 = "UPDATE product3 set number = number + " + jiadianNumber + " where id =2";
            statement.executeUpdate(update1);
            statement.executeUpdate(update2);
            statement.close();
            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

        request.getRequestDispatcher("/product2").forward(request,response);
    }
}

}

6.ProductServlet2
package com.youfeng.servlet;

import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

@WebServlet(urlPatterns = “/product2”)
public class ProductServlet2 extends HttpServlet{
protected void doGet(javax.servlet.http.HttpServletRequest request, javax.servlet.http.HttpServletResponse response) throws IOException {
Integer fuzhuangNumber = Integer.valueOf(request.getParameter(“fuzhuangNumber”));
Integer jiadianNumber = Integer.valueOf(request.getParameter(“jiadianNumber”));
int fuzhuangkucun = 0;
int jiadiankucun = 0;
int fuzhuangjine=0;
int jiadianjine=0;
try {
Class.forName(“com.mysql.jdbc.Driver”);
Connection conn = DriverManager.getConnection(“jdbc:mysql://localhost:3306/aaaaa”, “root”, “root”);
Statement statement = conn.createStatement();
String select1 = “select * from product3 where id =1”;
ResultSet rs = statement.executeQuery(select1);
if (rs.next()) {
fuzhuangkucun = rs.getInt(“number”);
fuzhuangjine=rs.getInt(“money”);
}
String select2 = “select * from product3 where id =2”;
ResultSet rs2 = statement.executeQuery(select2);
if (rs2.next()) {
jiadiankucun = rs2.getInt(“number”);
jiadianjine =rs2.getInt(“money”);
}
statement.close();
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
System.out.println(“服装数量:”+fuzhuangNumber);
System.out.println(“服装库存:”+fuzhuangkucun);
System.out.println(“服装价钱:”+fuzhuangjine);
System.out.println(“家电数量:”+jiadianNumber);
System.out.println(“家电库存:”+jiadiankucun);
System.out.println(“家电价钱:”+jiadianjine);
response.setContentType(“text/html; Charset=utf-8”);
response.getWriter().println(“服装:”+“交易额”+fuzhuangNumberfuzhuangjine+",库存总金额"+fuzhuangkucunfuzhuangjine);

    response.getWriter().print("家电:"+"交易额"+jiadianNumber*jiadianjine+",库存总金额"+jiadiankucun*jiadianjine);

}

}

7.图片