1.13

package com.example.mesweb;


import com.example.mesweb.utils.DatabaseConnection;

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 java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;

@WebServlet("/GeneratePlan")
public class GeneratePlanServlet extends HttpServlet {
    @Override
    protected void doPost(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {
        request.setCharacterEncoding("UTF-8");

        // 接收参数
        String contractId = request.getParameter("contractId");
        String productId = request.getParameter("productId");
        String productName = request.getParameter("productName");
        String productQuantity = request.getParameter("productQuantity");

        // 参数校验
        if (contractId == null || productId == null || productName == null || productQuantity == null) {
            request.setAttribute("error", "参数缺失，请检查数据！");
            request.getRequestDispatcher("/Mes_Web_war_exploded/utils/error.jsp").forward(request, response);
            return;
        }
        // 获取当前日期和时间
        LocalDateTime now = LocalDateTime.now();

        // 格式化为 "ddHHmmss" 格式
        DateTimeFormatter formatter = DateTimeFormatter.ofPattern("ddHHmmss");
        String generatedNumber = now.format(formatter);
        System.out.println(generatedNumber);

        // 数据库操作逻辑（示例逻辑）
        try (Connection conn = DatabaseConnection.getConnection()) {
            String sql = "INSERT INTO production_plan (contract_id, product_id, product_name, production_quantity,assigned_workshop,plan_status,plan_id) " +
                    "VALUES (?, ?, ?, ? ,?, ?, ?)";
            try (PreparedStatement ps = conn.prepareStatement(sql)) {
                ps.setString(1, contractId);
                ps.setString(2, productId);
                ps.setString(3, productName);
                ps.setString(4, productQuantity);
                ps.setString(5,"后处理车间");
                ps.setString(6,"未分配");
                ps.setString(7,generatedNumber);
                int rows = ps.executeUpdate();

                if (rows > 0) {
                    // 成功重定向到结果页面
                    response.sendRedirect("/Mes_Web_war_exploded/utils/success.jsp");
                } else {
                    request.setAttribute("/Mes_Web_war_exploded/utils/error", "生成生产计划失败，请重试！");
                    request.getRequestDispatcher("/Mes_Web_war_exploded/utils/error.jsp").forward(request, response);
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
            request.setAttribute("/Mes_Web_war_exploded/utils/error", "系统错误，请稍后再试！");
            request.getRequestDispatcher("/Mes_Web_war_exploded/utils/error.jsp").forward(request, response);
        } catch (ClassNotFoundException e) {
            throw new RuntimeException(e);
        }
    }
}