Untitled
unknown
plain_text
3 years ago
2.2 kB
9
Indexable
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
/**
*
* @author Fadly
*/
@WebServlet(name = "EditKaryawanController", urlPatterns = {"/EditKaryawanController"})
public class EditKaryawanController extends HttpServlet {
DatabaseConnection dcon = new DatabaseConnection();
PreparedStatement pst = dcon.getPst();
Connection con = dcon.getCon();
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
try {
String nama = request.getParameter("nama");
String nim = request.getParameter("nim");
String jenis_kelamin = request.getParameter("jenis_kelamin");
String alamat = request.getParameter("nim");
String kelurahan = request.getParameter("nim");
String kecamatan = request.getParameter("nim");
String kabupaten = request.getParameter("nim");
String provinsi = request.getParameter("nim");
String[] data = {nama, nim, jenis_kelamin, alamat, kelurahan, kecamatan, kabupaten,
provinsi};
pst = con.prepareStatement(
"UPDATE karyawan SET nama = ?, nim = ?, jenis_kelamin = ?, alamat = ?, kelurahan = ?,
kecamatan = ?, kabupaten = ?, provinsi = ? WHERE id = ?"
);
pst.setString(1, (String)data[0]);
pst.setString(2, (String)data[1]);
pst.setString(3, (String)data[2]);
pst.setString(4, (String)data[3]);
pst.setString(5, (String)data[4]);
pst.setString(6, (String)data[5]);
pst.setString(7, (String)data[6]);
pst.setString(8, (String)data[7]);
pst.setInt(9, 1);
pst.executeUpdate();
request.setAttribute("data", null);
RequestDispatcher rd = request.getRequestDispatcher("/KaryawanController");
rd.forward(request, response);
} catch (SQLException ex) {
Logger.getLogger(EditKaryawanController.class.getName()).log(Level.SEVERE, null, ex);
}
}
}Editor is loading...