Employee-Management/update-record.jsp at main · DavoudMolaei/Employee-Management · 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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<%@ include file="navbar.jsp" %>
<!DOCTYPE html>
<html>
<head>
    <style>
        body {
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
            background-color: #f4f4f9;
            color: #333;
        }
        table {
            margin: 50px auto;
            border-collapse: collapse;
            width: 70%;
            background: #ffffff;
            box-shadow: 0px 4px 8px rgba(0, 0, 0, 0.1);
            border-radius: 8px;
            overflow: hidden;
        }
        th, td {
            padding: 15px 20px;
            text-align: left;
            border-bottom: 1px solid #ddd;
        }
        th {
            background-color: #007BFF;
            color: white;
            text-align: center;
            font-size: 1.2em;
        }
        tr:hover {
            background-color: #f1f1f1;
        }
        button {
            background-color: #007BFF;
            color: white;
            padding: 10px 20px;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            font-size: 1em;
        }
        button:hover {
            background-color: #0056b3;
        }
        .dvv {
            margin: 20px auto;
            width: 70%;
            text-align: center;
            padding: 10px;
            background: #fff3f3;
            border: 1px solid #f5c6cb;
            color: #721c24;
            font-size: 1.2em;
            border-radius: 5px;
        }
        .dv {
        display: flex;
        justify-content: center;
        align-items: center;
        height: 100vh;
        background-color: #f0f8f5;
        font-size:20px;
    }
    .message {
        color: #28a745;
        font-size: 1.8rem;
        font-weight: bold;
        text-align: center;
        padding: 20px 40px;
        border: 2px solid #28a745;
        border-radius: 15px;
        background-color: #eaffea;
        box-shadow: 0 8px 15px rgba(0, 0, 0, 0.15);
        transition: transform 0.3s ease, box-shadow 0.3s ease;
    }
    .message:hover {
        transform: scale(1.05);
        box-shadow: 0 12px 20px rgba(0, 0, 0, 0.2);
    }
    </style>
</head>
<body onload="makeActive('edit')">
    <%
    String eid = request.getParameter("eid");

    Class.forName("com.mysql.cj.jdbc.Driver");
    Connection cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp10", "root", "mysqlkiran011");

    // Update the employee details in the database
    PreparedStatement ps = cn.prepareStatement("UPDATE employeeinfo SET firstname = ?, lastname = ?, phone = ?, emailid = ?, department = ?, salary = ? WHERE eid = ?");
    ps.setString(7,eid);
    ps.setString(1,request.getParameter("firstname"));
    ps.setString(2,request.getParameter("lastname"));
    ps.setString(3,request.getParameter("phone"));
    ps.setString(4,request.getParameter("emailid"));
    ps.setString(5,request.getParameter("department"));
    ps.setString(6,request.getParameter("salary"));
    ps.executeUpdate();// Execute the update query

    %>
    <div class=dv>
    <label class=message> Employee record has been updated successfully</label>
    </div>


</body>
</html>