Untitled
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...