使用JSP+Servlet实现商品管理功能，后台为数据库，功能包括商品信息浏览、商品信息详情、商品信息删除及修改。

开发工具：IntelliJ IDEA 2019.2.4 x64 mysql-5.5.62-winx64 Navicat Premium_11.2.7简体中文版 Tomcat 8.5.571 1.在数据库中加入相应的表 2.修改DBUtils中的file.properties文件路径 File f = new File("D:\\ commercialinformationmanagementsystem\\src\\com\\blb\\file.properties"); 3.mysql查询语句： -- 商品管理功能-- -- 主管表 -- create TABLE charge( chargeNum int PRIMARY KEY, chargeName VARCHAR(100) ); INSERT into charge values (201,"赵云"); INSERT into charge values (202,"张飞"); INSERT into charge values (203,"黄忠"); SELECT * from charge -- -- 商品表 CREATE TABLE goods( goodsId int PRIMARY KEY auto_increment, barCode int, chargeNum int, goodsName VARCHAR(50), goodsPrice VARCHAR(50), purchaseId int, expirationDate VARCHAR(50), FOREIGN KEY(chargeNum) references charge(chargeNum) on delete cascade on update cascade ); insert into goods VALUES (null,902083,201,"脉动","5元",6,"一年"); insert into goods VALUES (null,902084,201,"纯牛奶","3元",4,"六个月"); insert into goods VALUES (null,902085,203,"面包","2元",3,"两个月"); insert into goods VALUES (null,902086,202,"毛巾","12元",8,"无"); insert into goods VALUES (null,902089,201,"脉动","5元",6,"一年"); SELECT * from goods WHERE goodsId=902083 DELETE from goods where goodsId=902083 update goods set chargeNum =1, goodsName="1",goodsPrice="1", purchaseId=1,expirationDate="1" WHERE goodsId=902083