软件工程日报（ai编程课堂练习） - 吖呵

一、自然语言描述
采用java写一个网页版的仓储管理系统原型系统，不要使用mybatis和vue技术和util，使用mysql和jdbc等技术，采用前端，servlet，dao层来进行。一共包含三个数据表：仓库表，物资台账明细表和物资类别表，仓库表（支持多个仓库，每个仓库具有唯一编码）；三个表有数据的关联，比如物资是存放在仓库的，；物资台账需包含物资编码、物资名称、规格、材质、供应商、品牌、物资分类，用户可以自定义物资的物资分类，要求不同的物资名称、规格、材质的物资不能设立相同的物资编码。物资台账明细表（除了需求描述的要求外，需要有台账编号（唯一标识，四位年两位月两位日+顺序号（四位）例如：202402210022），操作类别（入库或者出库）数量，计量单位，存放地点（仓库号）等基本信息）；物资类别表：需要满足不同的物资名称、规格、材质的物资不能设立相同的物资编码，还要有相关数量和存放在哪个仓库的位置信息；要求有登录页面，管理员、仓库管理人员统一登录界面登录后，显示各自不同的菜单项。管理员功能页：管理员可以实现仓库表的增删改，但是只有物资表中没有物资存放的仓库才可以进行删除和修改，可以实现对物资表内数据的新增、删除、修改，物资表中某项物资数量默认为0，进行出库入库的操作时数量会进行变动，物资数量为0时才可以进行删除和修改；仓库管理人员：入库操作，出库操作，统计查询功能。要求出库物资少于仓库物资无法出库，请给出详细源代码和精简的中文注释，前端页面要求中文
二、存在问题
1、AI生成的代码缺乏优化，存在冗余或不必要的复杂性。
2、AI生成的代码难以理解，尤其是对于没有经验的开发者
三、代码
项目结构
复制
WarehouseManagementSystem/
│
├── src/
│ ├── com.warehouse.dao/
│ │ ├── WarehouseDAO.java
│ │ ├── MaterialLedgerDAO.java
│ │ └── MaterialCategoryDAO.java
│ ├── com.warehouse.servlet/
│ │ ├── LoginServlet.java
│ │ ├── WarehouseServlet.java
│ │ ├── MaterialLedgerServlet.java
│ │ └── MaterialCategoryServlet.java
│ └── com.warehouse.model/
│ ├── Warehouse.java
│ ├── MaterialLedger.java
│ └── MaterialCategory.java
│
├── WebContent/
│ ├── WEB-INF/
│ │ └── web.xml
│ ├── login.jsp
│ ├── warehouse.jsp
│ ├── materialLedger.jsp
│ ├── materialCategory.jsp
│ └── style.css
│
└── lib/
└── mysql-connector-java-x.x.x.jar
3. 代码实现
3.1 数据库连接工具类
java
复制
package com.warehouse.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBUtil {
private static final String URL = "jdbc:mysql://localhost:3306/warehouse_db";
private static final String USER = "root";
private static final String PASSWORD = "password";

public static Connection getConnection() throws SQLException {
    return DriverManager.getConnection(URL, USER, PASSWORD);
}

}
3.2 DAO层实现
3.2.1 WarehouseDAO.java
java
复制
package com.warehouse.dao;

import com.warehouse.model.Warehouse;
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 WarehouseDAO {
public List getAllWarehouses() throws SQLException {
List warehouses = new ArrayList<>();
String sql = "SELECT * FROM Warehouse";
try (Connection conn = DBUtil.getConnection();
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
Warehouse warehouse = new Warehouse();
warehouse.setWarehouseId(rs.getString("warehouse_id"));
warehouse.setName(rs.getString("name"));
warehouse.setLocation(rs.getString("location"));
warehouses.add(warehouse);
}
}
return warehouses;
}

public void addWarehouse(Warehouse warehouse) throws SQLException {
    String sql = "INSERT INTO Warehouse (warehouse_id, name, location) VALUES (?, ?, ?)";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, warehouse.getWarehouseId());
        stmt.setString(2, warehouse.getName());
        stmt.setString(3, warehouse.getLocation());
        stmt.executeUpdate();
    }
}

public void deleteWarehouse(String warehouseId) throws SQLException {
    String sql = "DELETE FROM Warehouse WHERE warehouse_id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, warehouseId);
        stmt.executeUpdate();
    }
}

public void updateWarehouse(Warehouse warehouse) throws SQLException {
    String sql = "UPDATE Warehouse SET name = ?, location = ? WHERE warehouse_id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, warehouse.getName());
        stmt.setString(2, warehouse.getLocation());
        stmt.setString(3, warehouse.getWarehouseId());
        stmt.executeUpdate();
    }
}

}
3.2.2 MaterialLedgerDAO.java
java
复制
package com.warehouse.dao;

import com.warehouse.model.MaterialLedger;
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 MaterialLedgerDAO {
public List getAllMaterialLedgers() throws SQLException {
List ledgers = new ArrayList<>();
String sql = "SELECT * FROM MaterialLedger";
try (Connection conn = DBUtil.getConnection();
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
MaterialLedger ledger = new MaterialLedger();
ledger.setLedgerId(rs.getString("ledger_id"));
ledger.setMaterialId(rs.getString("material_id"));
ledger.setOperationType(rs.getString("operation_type"));
ledger.setQuantity(rs.getInt("quantity"));
ledger.setUnit(rs.getString("unit"));
ledger.setWarehouseId(rs.getString("warehouse_id"));
ledgers.add(ledger);
}
}
return ledgers;
}

public void addMaterialLedger(MaterialLedger ledger) throws SQLException {
    String sql = "INSERT INTO MaterialLedger (ledger_id, material_id, operation_type, quantity, unit, warehouse_id) VALUES (?, ?, ?, ?, ?, ?)";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, ledger.getLedgerId());
        stmt.setString(2, ledger.getMaterialId());
        stmt.setString(3, ledger.getOperationType());
        stmt.setInt(4, ledger.getQuantity());
        stmt.setString(5, ledger.getUnit());
        stmt.setString(6, ledger.getWarehouseId());
        stmt.executeUpdate();
    }
}

public void deleteMaterialLedger(String ledgerId) throws SQLException {
    String sql = "DELETE FROM MaterialLedger WHERE ledger_id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, ledgerId);
        stmt.executeUpdate();
    }
}

public void updateMaterialLedger(MaterialLedger ledger) throws SQLException {
    String sql = "UPDATE MaterialLedger SET material_id = ?, operation_type = ?, quantity = ?, unit = ?, warehouse_id = ? WHERE ledger_id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, ledger.getMaterialId());
        stmt.setString(2, ledger.getOperationType());
        stmt.setInt(3, ledger.getQuantity());
        stmt.setString(4, ledger.getUnit());
        stmt.setString(5, ledger.getWarehouseId());
        stmt.setString(6, ledger.getLedgerId());
        stmt.executeUpdate();
    }
}

}
3.2.3 MaterialCategoryDAO.java
java
复制
package com.warehouse.dao;

import com.warehouse.model.MaterialCategory;
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 MaterialCategoryDAO {
public List getAllMaterialCategories() throws SQLException {
List categories = new ArrayList<>();
String sql = "SELECT * FROM MaterialCategory";
try (Connection conn = DBUtil.getConnection();
PreparedStatement stmt = conn.prepareStatement(sql);
ResultSet rs = stmt.executeQuery()) {
while (rs.next()) {
MaterialCategory category = new MaterialCategory();
category.setMaterialId(rs.getString("material_id"));
category.setName(rs.getString("name"));
category.setSpecification(rs.getString("specification"));
category.setMaterialType(rs.getString("material_type"));
category.setSupplier(rs.getString("supplier"));
category.setBrand(rs.getString("brand"));
category.setCategory(rs.getString("category"));
category.setQuantity(rs.getInt("quantity"));
category.setWarehouseId(rs.getString("warehouse_id"));
categories.add(category);
}
}
return categories;
}

public void addMaterialCategory(MaterialCategory category) throws SQLException {
    String sql = "INSERT INTO MaterialCategory (material_id, name, specification, material_type, supplier, brand, category, quantity, warehouse_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, category.getMaterialId());
        stmt.setString(2, category.getName());
        stmt.setString(3, category.getSpecification());
        stmt.setString(4, category.getMaterialType());
        stmt.setString(5, category.getSupplier());
        stmt.setString(6, category.getBrand());
        stmt.setString(7, category.getCategory());
        stmt.setInt(8, category.getQuantity());
        stmt.setString(9, category.getWarehouseId());
        stmt.executeUpdate();
    }
}

public void deleteMaterialCategory(String materialId) throws SQLException {
    String sql = "DELETE FROM MaterialCategory WHERE material_id = ?";
    try (Connection conn = DBUtil.getConnection();
         PreparedStatement stmt = conn.prepareStatement(sql)) {
        stmt.setString(1, materialId);
        stmt.executeUpdate();
    }
}

public void updateMaterialCategory(MaterialCategory category) throws SQLException {
    String sql = "UPDATE MaterialCategory SET name = ?, specification = ?, material_type = ?, supplier = ?, brand = ?, category = ?, quantity = ?, warehouse_id = ? WHERE material_id = ?";
    try

发表于 2025-03-05 19:25 吖呵阅读(19) 评论(0) 收藏举报