个人开发10

上传紧急方案模块的代码
package emtemplate;

import java.io.IOException;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.UUID;
import emtemplate.EmTemplate;
import DBUtil.DBUtil;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@WebServlet("/emTemplate")
public class EmTemplateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    request.setCharacterEncoding("UTF-8");
    response.setContentType("text/html; charset=UTF-8");
    String action = request.getParameter("action");
    if ("delete".equals(action)) {
        deleteTemplate(request, response);
    } else {
        listTemplates(request, response);
    }
}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    request.setCharacterEncoding("UTF-8");
    response.setContentType("text/html; charset=UTF-8");
    String action = request.getParameter("action");
    if ("add".equals(action)) {
        addTemplate(request, response);
    } else if ("update".equals(action)) {
        updateTemplate(request, response);
    }
}

private void listTemplates(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    List<EmTemplate> templates = new ArrayList<>();
    try (Connection connection = DBUtil.getConnection();
         Statement statement = connection.createStatement();
         ResultSet resultSet = statement.executeQuery("SELECT * FROM em_template")) {

        while (resultSet.next()) {
            EmTemplate template = new EmTemplate();
            template.setId(resultSet.getLong("id"));
            template.setTemplateNo(resultSet.getString("template_no"));
            template.setName(resultSet.getString("name"));
            template.setType(resultSet.getString("type"));
            template.setLevel(resultSet.getString("level"));
            template.setContent(resultSet.getString("content"));
            template.setFilePath(resultSet.getString("file_path"));
            template.setRelatedProjects(resultSet.getString("related_projects"));
            template.setVersion(resultSet.getString("version"));
            template.setStatus(resultSet.getString("status"));
            template.setCreateBy(resultSet.getLong("create_by"));
            template.setCreateTime(resultSet.getTimestamp("create_time"));
            templates.add(template);
        }

        request.setAttribute("templates", templates);
        request.getRequestDispatcher("/templates.jsp").forward(request, response);
    } catch (SQLException e) {
        e.printStackTrace();
        response.sendError(500, "Internal Server Error");
    }
}

private void deleteTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
    Long id = Long.parseLong(request.getParameter("id"));
    try (Connection connection = DBUtil.getConnection();
         PreparedStatement preparedStatement = connection.prepareStatement("DELETE FROM em_template WHERE id = ?")) {

        preparedStatement.setLong(1, id);
        preparedStatement.executeUpdate();
        response.sendRedirect("emTemplate");
    } catch (SQLException e) {
        e.printStackTrace();
        response.sendError(500, "Internal Server Error");
    }
}

private void addTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
    String templateNo = request.getParameter("templateNo");
    String name = request.getParameter("name");
    String type = request.getParameter("type");
    String level = request.getParameter("level");
    String content = request.getParameter("content");
    String filePath = request.getParameter("filePath");
    String relatedProjects = request.getParameter("relatedProjects");
    String version = request.getParameter("version");
    String status = request.getParameter("status");
    Long createBy = Long.parseLong(request.getParameter("createBy"));

    try (Connection connection = DBUtil.getConnection();
         PreparedStatement preparedStatement = connection.prepareStatement(
                 "INSERT INTO em_template (template_no, name, type, level, content, file_path, related_projects, version, status,create_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {

        preparedStatement.setString(1, templateNo);
        preparedStatement.setString(2, name);
        preparedStatement.setString(3, type);
        preparedStatement.setString(4, level);
        preparedStatement.setString(5, content);
        preparedStatement.setString(6, filePath);
        preparedStatement.setString(7, relatedProjects);
        preparedStatement.setString(8, version);
        preparedStatement.setString(9, status);
        preparedStatement.setLong(10, createBy);
        preparedStatement.executeUpdate();
        response.sendRedirect("emTemplate");
    } catch (SQLException e) {
        e.printStackTrace();
        response.sendError(500, "Internal Server Error");
    }
}

private void updateTemplate(HttpServletRequest request, HttpServletResponse response) throws IOException {
    Long id = Long.parseLong(request.getParameter("id"));
    String templateNo = request.getParameter("templateNo");
    String name = request.getParameter("name");
    String type = request.getParameter("type");
    String level = request.getParameter("level");
    String content = request.getParameter("content");
    String filePath = request.getParameter("filePath");
    String relatedProjects = request.getParameter("relatedProjects");
    String version = request.getParameter("version");
    String status = request.getParameter("status");
    Long createBy = Long.parseLong(request.getParameter("createBy"));

    try (Connection connection = DBUtil.getConnection();
         PreparedStatement preparedStatement = connection.prepareStatement(
                 "UPDATE em_template SET template_no = ?, name = ?, type = ?, level = ?, content = ?, file_path = ?, related_projects = ?, version = ?, status = ?, create_by = ? WHERE id = ?")) {

        preparedStatement.setString(1, templateNo);
        preparedStatement.setString(2, name);
        preparedStatement.setString(3, type);
        preparedStatement.setString(4, level);
        preparedStatement.setString(5, content);
        preparedStatement.setString(6, filePath);
        preparedStatement.setString(7, relatedProjects);
        preparedStatement.setString(8, version);
        preparedStatement.setString(9, status);
        preparedStatement.setLong(10, createBy);
        preparedStatement.setLong(11, id);
        preparedStatement.executeUpdate();
        response.sendRedirect("emTemplate");
    } catch (SQLException e) {
        e.printStackTrace();
        response.sendError(500,",Internal Server Error");
    }
}

}
我对文件处理的知识更加的熟练了。