<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import = "java.sql.*" %>
<%
String id = request.getParameter("id");
String first = request.getParameter("first");
String last = request.getParameter("last");
String address = request.getParameter("address");
String email = request.getParameter("email");
String phone = request.getParameter("phone");
String profession = request.getParameter("profession");
String connectionURL = "jdbc:mysql://localhost/perusahaan";
Connection connection = null;
PreparedStatement statement = null;
try {
Class.forName("com.mysql.jdbc.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "");
String query = "UPDATE employee SET Firstname=?, Lastname=?, Address=?, Email=?, Phone=?, Profession=? WHERE ID=?";
statement = connection.prepareStatement(query);
statement.setString(1, first);
statement.setString(2, last);
statement.setString(3, address);
statement.setString(4, email);
statement.setString(5, phone);
statement.setString(6, profession);
statement.setString(7, id);
int updatedQuery = statement.executeUpdate();
if(updatedQuery != 0) {
response.sendRedirect("readUser.jsp");
} else {
response.sendRedirect("updateUser.jsp?id=" + id);
}
} catch (Exception e) {
response.sendRedirect("updateUser.jsp?id=" + id);
} finally {
if(statement != null) statement.close();
if(connec
tion != null) connection.close();
}
%>
