<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Update User</title>
<!-- Link to Bootstrap CSS -->
<link href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
<h1 class="mt-5">Update User</h1>
<form action="processUpdateUser.jsp" method="post" class="mt-3">
<%
String id = request.getParameter("id");
Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
try {
String connectionURL = "jdbc:mysql://localhost/perusahaan";
String userName = "root";
String passWord = "";
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, userName, passWord);
String query = "SELECT * FROM employee WHERE ID = ?";
preparedStatement = connection.prepareStatement(query);
preparedStatement.setString(1, id);
resultSet = preparedStatement.executeQuery();
if(resultSet.next()) {
%>
<input type="hidden" name="id" value="<%= resultSet.getString("ID") %>">
<div class="form-group">
<label>First Name
<input type="text" name="first" value="<%= resultSet.getString("Firstname") %>" class="form-control">
</label>
</div>
<div class="form-group">
<label>Last Name
<input type="text" name="last" value="<%= resultSet.getString("Lastname") %>" class="form-control">
</label>
</div>
<div class="form-group">
<label>Address
<input type="text" name="address" value="<%= resultSet.getString("Address") %>" class="form-control">
</label>
</div>
<div class="form-group">
<label>Email
<input type="email" name="email" value="<%= resultSet.getString("Email") %>" class="form-control">
</label>
</div>
<div class="form-group">
<label>Phone
<input type="text" name="phone" value="<%= resultSet.getString("Phone") %>" class="form-control">
</label>
</div>
<div class="form-group">
<label>Profession
<input type="text" name="profession" value="<%= resultSet.getString("Profession") %>" class="form-control">
</label>
</div>
<input type="submit" name="updateUser" class="btn btn-primary">
<%
}
resultSet.close();
preparedStatement.close();
connection.close();
} catch(Exception e) {
out.println(e.ge
tMessage());
}
%>
</form>
</div>
</body>
</html>
