JavaWeb实现商店管理系统

前言

介绍：本项目用于刚刚入门Javaweb人员学习使用，主要功能是通过Java连接jdbc MySQL在web页面实现增删改查效果

开发环境

开发工具：IDEA2023专业版，Tomcat9.0.62，navicat

jar包：mysql-connector-java-8.0.82.jar

语言:Java+SQL+HTML 

代码实现

1.环境搭建

使用Navicat建立数据库

 IDEA搭建：

项目基本类首先搭建好，前期还需要配置Tomcat服务器和web框架 

2.代码实现： 

首先连接数据库JDBC

// Dao.java
package Dao;

import popj.Goods;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;

public class Dao {

    static final String URL = "jdbc:mysql://localhost:3306/goods_db?serverTimezone=UTC";
   static final String USER = "root";
    static final String PWD = "1234";
    static Connection connection;
   static {
       try {
       Class.forName("com.mysql.cj.jdbc.Driver");
   }catch (ClassNotFoundException e){
       e.printStackTrace();
   }
   }
    // 连接数据库
    public static Connection getConnection() throws SQLException {
        // System.out.println("连接成功");
        return DriverManager.getConnection(URL, USER, PWD);
    }

    // 关闭连接 ，释放资源
    public static void close(ResultSet rs, Statement stat, Connection conn) throws SQLException {
        if (rs != null)
            rs.close();
        if (stat != null)
            stat.close();
        if (conn != null)
            conn.close();
    }
}

注意的是，这里需要根据个人来确定数据库名和用户名，密码

然后就需要写入方法（get和set，构造方法）

package popj;

public class Goods {
    private int  goodId;
    private String goodsName;
    private int num;
    private double price;

    public Goods() {
        super();
    }

    public Goods(int goodId, String goodsName, int num, double price) {
        this.goodId = goodId;
        this.goodsName = goodsName;
        this.num = num;
        this.price = price;
    }

    public int getGoodId() {
        return goodId;
    }

    public void setGoodId(int goodId) {
        this.goodId = goodId;
    }

    public String getGoodsName() {
        return goodsName;
    }

    public void setGoodsName(String goodsName) {
        this.goodsName = goodsName;
    }

    public int getNum() {
        return num;
    }

    public void setNum(int num) {
        this.num = num;
    }

    public double getPrice() {
        return price;
    }

    public void setPrice(double price) {
        this.price = price;
    }

    @Override
    public String toString() {
        return "Goods{" +
                "goodId=" + goodId +
                ", goodsName='" + goodsName + '\'' +
                ", num=" + num +
                ", price=" + price +
                '}';
    }
}

写入数据逻辑

package popj;

import Dao.Dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


public class SqlConn {
    //查询数据库中的数据显示
    public static List<Goods> GetSource(String sql){
        Connection coon = null;
        Prepa