Untitled

 avatar
unknown
plain_text
3 years ago
2.2 kB
5
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...