ICS-Cyber-Invasion-Accident-Response-Program/scenarioEvaDelete.jsp at master · HelloSecurity/ICS-Cyber-Invasion-Accident-Response-Program · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<%@ page language="java" import="java.sql.*, java.lang.*, java.util.*" contentType="text/html; charset=EUC-KR"
    pageEncoding="utf-8" %>
<%@page import="java.lang.reflect.Type"%>
<%@page import = "java.io.PrintWriter" %>
<%@ page import="scenario.ScenarioItem" %>
<%@ page import="scenario.ScenarioDAO" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

<%
    request.setCharacterEncoding("EUC-KR");
%>

<!DOCTYPE html>
<html>
<head>
  <meta http-quiv="Content-Type" content="text/html; charset=UTF-8">
  <meta name="viewport" content="width=device-width", initial-scale="1">
  <link rel="stylesheet" href="css/bootstrap.css">
<title>취약점 진단 프로그램</title>
</head>
<body>

<%
int id = Integer.parseInt(request.getParameter("id"));

//평가 결과가 DB에 들어가는 코드
Connection conn;
PreparedStatement pstmt;

try {
   String dbURL ="jdbc:mysql://icsdatabase.csqmh3rbxyia.ap-northeast-2.rds.amazonaws.com/icsdatabase?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC";
    String dbID = "icsdatabase";
    String dbPassword = "icsdatabase";
    Class.forName("com.mysql.cj.jdbc.Driver");
    conn= DriverManager.getConnection(dbURL, dbID, dbPassword);
    String SQL = "UPDATE scenarioitem SET accuracy=?, feasibility=?, efficiency=?, complete=?, visibility=? where id =?";
    //"UPDATE scenarioitem SET accurate=" + "''" + ", feasibility=" + "''" + ", efficiency=" + "''" + ", complete=" + "''" + ", visibility=" + "''" + " where id =?";
    pstmt = conn.prepareStatement(SQL);

    pstmt.setString(1, null);
    pstmt.setString(2, "");
    pstmt.setString(3, "");
    pstmt.setString(4, "");
    pstmt.setString(5, "");
    pstmt.setInt(6, id);
    pstmt.executeUpdate();

    PrintWriter script=response.getWriter();
   script.println("<script>");
   script.println("alert('삭제되었습니다.')");
   script.println("location.href='scenario_eva.jsp'");
   script.println("</script>");
   script.close();


} catch (Exception e) {
   PrintWriter script=response.getWriter();
   script.println("<script>");
   script.println("alert('삭제에 실패하였습니다.')");
   script.println("location.href='history.back()'");
   script.println("</script>");
   script.close();
   e.printStackTrace();
}


//pageContext.forward(".jsp"); //eva_action.jsp에서 모든 과정을 처리하면  _eva.jsp로 화면 포워딩 꼭 필요!


%>


</body>
</html>