CRUD Web Services dengan Bootstrap

 

  1. Bismillah, hari ini kita akan membuat projeck web service dengan bootstrap (server & client). Ada 2 projec yang akan di buat yaitu server = siakad & untuk client = ClientSiakad. Projeck ini memiliki kemampuan layanan pada CRUD (Create, Read, Update, Delete). Sebelum kita membuat project maka kita buat databasenya terlebih dahulu, dengan ketentuan sebagai berikut.
    Database name = siakad
    Table name = mahasiswa
  2.  

    Field

    Type

    Panjang

    nim

    Int                   (primary key)

    15

    nama

    varchar

    30

    jurusan

    varchar

    30

    email

    varchar

    20

    alamat

    varchar

    50


  3. Buka Netbeans 8.2, lalu buat project untuk server terlebih dahulu, Caranya : klik File -> New Project -> Java Web -> Web Application -> beri nama : Siakad, -> klik Next -> pilih Server GlassFish 4.1.1 -> klik Finish
  4. Selanjutnya kita buat web service didalam project server. Caranya : klik kanan pada project Siakad -> New -> Web Service -> lalu masukan nama : Mahasiswa, dan package : mahasiswa -> klik Finish
  5. Lalu kita buat koneksi ke MySQL. Caranya : klik kanan pada package mahasiswa -> New -> JavaClass -> lalu beri nama : koneksiMySQL -> klik Finish
  6. Kemudian kita masukan script koneksi dihalaman java berikut
  7. package siakad.mahasiswa;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;

    /**
    *
    * @author Muqorobin, S.Kom
    */
    public class koneksiMySQL {
    String driver = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/siakad";
    String usern = "root";
    String passw = "";
    Connection con;
    PreparedStatement ps;
    ResultSet rs;
    public Connection getCon(){
    try{
    Class.forName(driver);
    con = DriverManager.getConnection(url, usern, passw);
    }catch(Exception ex) {
    System.out.println(ex.getMessage());
    }
    return con;
    }
    }

  8. Setelah itu kita setting Library. Caranya : klik kanan pada project Siakad -> Properties -> Libraries -> Add Library -> MySQL JDBC Driver -> lalu klik Add, lalu klik OK
  9. Setelah itu kita cek didalam directory Library, sudah ada MySQL JDBC Driver apa belum. Caranya : klik folder/directory Library
  10. Agar data MySQL dapat dipanggil di Web Service, maka dibutuhkan Getter and Setter. Masing masing data. Kita akan buat file java class baru dengan nama : mhs
    Caranya : klik kanan pada package mahasiswa -> New -> Java Class -> beri nama mhs -> lalu klik Finish
  11. Kemudian masukan script pada halaman mhs.java berikut
    package siakad.mahasiswa;
    /**
    *
    *
    */
    public class mhs {
    private int nim;
    private String nama, jurusan, email, alamat;
    public int getNim() {
    return nim;
    }
    public void setNim(int nim) {
    this.nim = nim;
    }
    public String getNama() {
    return nama;
    }
    public String getJurusan() {
    return jurusan;
    }
    public void setJurusan(String jurusan) {
    this.jurusan = jurusan;
    }
    public String getEmail() {
    return email;
    }
    public void setEmail(String email) {
    this.email = email;
    }
    public String getAlamat() {
    return alamat;
    }
    public void setAlamat(String alamat) {
    this.alamat = alamat;
    }
    }
    =========Boleh tidak meng copy semua script diatas cukup ambil script inti saja yaitu :==========
    private int nim;
    private String nama, jurusan, email, alamat;

    Gunakan Getter and Setter untuk menampilkan script yang lain. Caranya : klik dihalaman kosong pada mhs.java / dibawah script private. Lalu klik Insert Code -> Getter and Setter -> Ada form centang semua -> klik Generate
  12. Setelah itu kita akan membuat method CRUD (Create, Read, Update, Delete) didalam web service pada halaman java
  13. Masukan script method CRUD dihalaman Mahasiswa.java sebagai berikut
  14. package siakad.mahasiswa;
    /**
    *
    *
    */
    public class mhs {
    private int nim;
    private String nama, jurusan, email, alamat;
    public int getNim() {
    return nim;
    }
    public void setNim(int nim) {
    this.nim = nim;
    }
    public String getNama() {
    return nama;
    }
    public String getJurusan() {
    return jurusan;
    }
    public void setJurusan(String jurusan) {
    this.jurusan = jurusan;
    }
    public String getEmail() {
    return email;
    }
    public void setEmail(String email) {
    this.email = email;
    }
    public String getAlamat() {
    return alamat;
    }
    public void setAlamat(String alamat) {
    this.alamat = alamat;
    }
    }
    =========Boleh tidak meng copy semua script diatas cukup ambil script inti saja yaitu :==========
    private int nim;
    private String nama, jurusan, email, alamat;
    package siakad.mahasiswa;
    import java.sql.Connection;
    import java.sql.DriverManager;
    import java.sql.PreparedStatement;
    import java.sql.ResultSet;
    import java.sql.Statement;
    import java.util.ArrayList;
    import java.util.List;
    import javax.jws.WebService;
    import javax.jws.WebMethod;
    import javax.jws.WebParam;
    /**
    *
    * @
    */
    @WebService(serviceName = "Mahasiswa")
    public class Mahasiswa {
    /*Panggil Koneksi MySQL*/
    koneksiMySQL kon = new koneksiMySQL();
    Connection con;
    PreparedStatement ps;
    ResultSet rs;
    /*Selesai Panggil Koneksi MySQL*/
    /*Get Mahasiswa*/
    @WebMethod(operationName = "getMahasiswa")
    public List getMahasiswa(
    @WebParam(name = "nim") int nim) {
    List mahasiswa = new ArrayList();
    try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
    Statement st = conn.createStatement();
    con = kon.getCon();
    ps = con.prepareStatement("select * from mahasiswa where nim=?");
    ps.setInt(1, nim);
    ResultSet rst = ps.executeQuery();
    while (rst.next()) {
    mahasiswa.add("<div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">NIM</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"nim\" value=\""+rst.getInt("nim")+"\" readonly=\"true\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Nama</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"nama\" value=\""+rst.getString("nama")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Jurusan</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"jurusan\" value=\""+rst.getString("jurusan")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Email</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"email\" value=\""+rst.getString("email")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Alamat</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"alamat\" value=\""+rst.getString("alamat")+"\">\n" +
    " </div>\n" +
    " </div>");
    }
    } catch (Exception ex) {
    System.out.println(ex.getMessage());
    }
    return mahasiswa;
    }
    /*Selesai Get Mahasiswa*/
    /*Selesai Tambah Mahasiswa*/
    @WebMethod(operationName = "addMahasiswa")
    public void addDosen(
    @WebParam(name = "nim") int nim,
    @WebParam(name = "nama") String nama,
    @WebParam(name = "jurusan") String jurusan,
    @WebParam(name = "email") String email,
    @WebParam(name = "alamat") String alamat
    ) {
    try {
    con = kon.getCon();
    ps = con.prepareStatement("insert into mahasiswa value (?,?,?,?,?)");
    ps.setInt(1, nim);
    ps.setString(2, nama);
    ps.setString(3, jurusan);
    ps.setString(4, email);
    ps.setString(5, alamat);
    ps.executeUpdate();
    } catch (Exception ex) {
    System.out.println(ex.getMessage());
    }
    }
    /*Selesai Tambah Mahasiswa*/
    /*Hapus Mahasiswa*/
    @WebMethod(operationName = "delMahasiswa")
    public void delMahasiswa(
    @WebParam(name = "nim") int nim) {
    try {
    con = kon.getCon();
    ps = con.prepareStatement("delete from mahasiswa where nim = ?");
    ps.setInt(1, nim);
    ps.executeUpdate();
    } catch (Exception e) {
    System.out.println("Failed to remove student because " + e.toString());
    }
    }
    /*Selesai Hapus Mahasiswa*/
    /*Edit Mahasiswa*/
    @WebMethod(operationName = "editMahasiswa")
    public void editMahasiswa(
    @WebParam(name = "nim") int nim,
    @WebParam(name = "nama") String nama,
    @WebParam(name = "jurusan") String jurusan,
    @WebParam(name = "email") String email,
    @WebParam(name = "alamat") String alamat){
    try {
    con = kon.getCon();
    ps = con.prepareStatement("update mahasiswa set nama=?,jurusan=?,email=?,alamat=? where nim=?");
    ps.setString(1, nama);
    ps.setString(2, jurusan);
    ps.setString(3, email);
    ps.setString(4, alamat);
    ps.setInt(5, nim);
    ps.executeUpdate();
    } catch (Exception e) {
    System.out.println("Failed to edit student because " + e.toString());
    }
    }
    /*Selesai Edit Mahasiswa*/
    @WebMethod(operationName = "tampilMahasiswa")
    public List tampilMahasiswa() {
    List daftar = new ArrayList();
    String sql_daftar = "select * from mahasiswa";
    try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery(sql_daftar);
    while (rs.next()) {
    daftar.add("<td>" + rs.getInt("nim") + "</td><td>" + rs.getString("nama") + "</td><td>" + rs.getString("jurusan") + "</td><td>" + rs.getString("email") + "</td><td>" + rs.getString("alamat") + "</td><td><a href=\"edit-mhs.jsp?nim=" + rs.getInt("nim") + "\"><span class=\"glyphicon glyphicon-edit\"></span></a><br><a href=\"hapus-mhs.jsp?nim=" + rs.getInt("nim") + "\"><span class=\"glyphicon glyphicon-remove\"></span></a></td><tr></tr>");
    }
    con.close();
    } catch (Exception ex) {
    System.out.println(ex.getMessage());
    }
    return daftar;
    }
    }
  15. Setelah seluruh method CRUD telah siap, maka kita buat ClientSiakad, Caranya : klik File -> New Project -> java Web -> Web Application -> beri nama : ClientSiakad -> Next -> pilih Server GlassFish 4.1.4 -> klik Finish
  16. Selanjutnya buat koneksi ke server dengan web service client, caranya : klik kanan pada ClientSiakad -> New -> Web Service Client -> pilih Project – Nrowse – Siakad – Mahasiswa -> klik OK, lalu isi package : client.siakad -> lalu klik Finish.
  17. Maka akan muncul web service references sebagai berikut
  18. Selanjutnya kita akan buat buat modivikasi ClientSiakad dengan bootstrap, maka silahkan copykan bahan-bahan pendukung di ClientSiakad/web
  19. Buat beberapa file baru dengan nama header.jsp dan index.jsp di Web Pages pada Project ClientSiakad
  20. Tapi hapus file index.html nya terlebih dahulu, klik kanan file index.html -> delete -> yes
  21. Cara untuk membuat file, klik kanan pada Web Pages -> New -> JSP -> masukan nama : header -> klik Finish
    Masukan script berikut di halaman header.jsp
    <%@page contentType="text/html" pageEncoding="UTF-8"%>
    <!DOCTYPE html>
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Siakad Mahasiswa</title>
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <!-- Bootstrap -->
    <link href="css/bootstrap.min.css" rel="stylesheet"/>
    </head>
    <body>
    <!--Kode Navbar-->
    <nav class="navbar navbar-default">
    <div class="container-fluid">
    <!-- Brand and toggle get grouped for better mobile display -->
    <div class="navbar-header">
    <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#bs-example-navbar-collapse-1" aria-expanded="false">
    <span class="sr-only">Toggle navigation</span>
    <span class="icon-bar"></span>
    <span class="icon-bar"></span>
    <span class="icon-bar"></span>
    </button>
    <a class="navbar-brand" href="#">Siakad Kampus</a>
    </div>
    <!-- Collect the nav links, forms, and other content for toggling -->
    <div class="collapse navbar-collapse" id="bs-example-navbar-collapse-1">
    <ul class="nav navbar-nav">
    <li class="active"><a href="index.jsp">Home<span class="sr-only">(current)</span></a></li>
    <li><a href="#">Profil</a></li>
    <li class="dropdown">
    <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Menu<span class="caret"></span></a>
    <ul class="dropdown-menu">
    <li><a href="index.jsp">Daftar Mahasiswa</a></li>
    <li><a href="tambah-mhs.jsp">Tambah Mahasiswa</a></li>
    <li><a href="edit-mhs.jsp">Edit Mahasiswa</a></li>
    <li><a href="hapus-mhs.jsp">Hapus Mahasiswa</a></li>
    <li role="separator" class="divider"></li>
    <li><a href="#">Separated link</a></li>
    <li role="separator" class="divider"></li>
    <li><a href="#">One more separated link</a></li>
    </ul>
    </li>
    </ul>
    <form class="navbar-form navbar-left">
    <div class="form-group">
    <input type="text" class="form-control" placeholder="Search">
    </div>
    <button type="submit" class="btn btn-default">Submit</button>
    </form>
    <ul class="nav navbar-nav navbar-right">
    <li><a href="#">Link</a></li>
    <li class="dropdown">
    <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">Dropdown <span class="caret"></span></a>
    <ul class="dropdown-menu">
    <li><a href="#">Action</a></li>
    <li><a href="#">Another action</a></li>
    <li><a href="#">Something else here</a></li>
    <li role="separator" class="divider"></li>
    <li><a href="#">Separated link</a></li>
    </ul>
    </li>
    </ul>
    </div><!-- /.navbar-collapse -->
    </div><!-- /.container-fluid -->
    </nav>
    <!--Akhir Navbar-->
    </body>
    </html>
    Masukan script berikut di halaman index.jsp
    <%@include file="header.jsp" %>
    <h1>Halaman Mahasiswa</h1>
    <%@include file="footer.jsp" %>
    Masukan script berikut di halaman footer.jsp
  22. <script src="https://code.jquery.com/jquery.js"></script>
    <script src="js/bootstrap.min.js"></script>
  23. Agar tampilan content atau isi halaman berupa table maka tambahkan script berikut dihalaman index.jsp
  24. <%@include file="header.jsp" %>
    <h3>Daftar Mahasiswa</h3>
    <table class="table">
    <thead>
    <tr>
    <th>NIM</th>
    <th>Nama</th>
    <th>Jurusan</th>
    <th>Email</th>
    <th>Alamat</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    </tr>
    </tbody>
    </table>
    <%@include file="footer.jsp" %>
  25. Untuk membuat tombol tambah data agar tampil di halaman utama, maka ubahlah script index.jsp sehingga menjadi script berikut
  26. <%@include file="header.jsp" %>
    <div class="container">
    <h3>Daftar Mahasiswa</h3>
    <a href="tambah-mhs.jsp"><button class="btn-success">Tambah Mahasiswa</button></a>
    <table class="table table-bordered">
    <thead>
    <tr>
    <th>NIM</th>
    <th>Nama</th>
    <th>Jurusan</th>
    <th>Email</th>
    <th>Alamat</th>
    <th>Aksi</th>
    </tr>
    </thead>
    <tbody>
    <tr>
    <%-- start web service invocation --%><hr/>
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    // TODO process result here
    java.util.List<java.lang.Object> resultMhs = port.tampilMahasiswa();
    for (int i = 0; i < resultMhs.size(); i++) {
    out.println(resultMhs.get(i));
    }
    } catch (Exception ex) {
    // TODO handle custom exceptions here
    }
    %>
    <%-- end web service invocation --%><hr/>
    </tr>
    </tbody>
    </table>
    </div>
    <%@include file="footer.jsp" %>

  27. Selanjutnya untuk membuat agar bisa di input data lewat client, dengan klik tombol tambah mahasiswa, maka perlu buat file baru dengan nama tambah-mhs.jsp
    Masukan Script Berikut
  28. <%@include file="header.jsp" %>
    <div class="container">
    <h3>Form Tambah Mahasiswa</h3>
    <form class="form-horizontal" method="post" action="proses-tambah-mhs.jsp">
    <div class="form-group">
    <label class="control-label col-sm-1">NIM</label>
    <div class="col-sm-2">
    <input type="text" class="form-control" name="nim">
    </div>
    </div>
    <div class="form-group">
    <label class="control-label col-sm-1">Nama</label>
    <div class="col-sm-2">
    <input type="text" class="form-control" name="nama">
    </div>
    </div>
    <div class="form-group">
    <label class="control-label col-sm-1">Jurusan</label>
    <div class="col-sm-2">
    <input type="text" class="form-control" name="jurusan">
    </div>
    </div>
    <div class="form-group">
    <label class="control-label col-sm-1">Email</label>
    <div class="col-sm-2">
    <input type="text" class="form-control" name="email">
    </div>
    </div>
    <div class="form-group">
    <label class="control-label col-sm-1">Alamat</label>
    <div class="col-sm-2">
    <input type="text" class="form-control" name="alamat">
    </div>
    </div>
    <button type="submit" class="btn btn-danger">Simpan</button>
    </form>
    </div>
    <%@include file="footer.jsp" %>


  29. Agar data bisa tersimpan didalam database, maka buat file baru dengan nama proses-tambah-mhs.jsp
    Masukan script berikut di halaman proses-tambah-mhs.jsp
  30. <%-- start web service invocation --%>
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    // TODO initialize WS operation arguments here
    int nim = 0;
    java.lang.String nama = "";
    java.lang.String jurusan = "";
    java.lang.String email = "";
    java.lang.String alamat = "";
    port.addMahasiswa(nim, nama, jurusan, email, alamat);
    } catch (Exception ex) {
    // TODO handle custom exceptions here
    }
    %>
    <%-- end web service invocation --%>


  31. Ubahlah sedikit scriptnya sehingga dapat menerima POST dari tambah-mhs.jsp dengan menambahkan script berikut
  32. int nim = Integer.valueOf(request.getParameter("nim"));
    java.lang.String nama = request.getParameter("nama");
    java.lang.String jurusan = request.getParameter("jurusan");
    java.lang.String email = request.getParameter("email");
    java.lang.String alamat = request.getParameter("alamat");
    port.addMahasiswa(nim, nama, jurusan, email, alamat);
    response.sendRedirect("index.jsp");
    } catch (Exception ex) {
    }
    %>



  33. Langkah selanjutnya kita akan buat tombol Edit dan Delete. Dalam hal ini Edit dan Delete itu terletak dalam sebuah table, sehingga dibuat dalam sebuah script.
  34. Masuk ke project Siakad, lalu masuk Class Mahasiswa.java lalu masukan script berikut dibawah script
  35. @WebMethod(operationName = "tampilMahasiswa")
    public List tampilMahasiswa() {
    List daftar = new ArrayList();
    String sql_daftar = "select * from mahasiswa";
    try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery(sql_daftar);
    while (rs.next()) {
    daftar.add("<td>" + rs.getInt("nim") + "</td><td>" + rs.getString("nama") + "</td><td>" + rs.getString("jurusan") + "</td><td>" + rs.getString("email") + "</td><td>" + rs.getString("alamat") + "</td><td><button class=\"btn-info\"><a href=\"edit-mhs.jsp?nim=" + rs.getString("nim") + "\">Edit</a></button><br><button class=\"btn-danger\"><a href=\"hapus-mhs.jsp?nim=" + rs.getString("nim") + "\">Hapus</a></button></td><tr></tr>");
    }
    con.close();
    } catch (Exception ex) {
    System.out.println(ex.getMessage());
    }
    return daftar;
    }
  36. Untuk membuat proses hapus, silahkan buat satu file baru dengan nama hapus-mhs.jsp
  37. Lalu Drag operator hapus dari Web Service Reference
  38. Tapi ubah scriptnya menjadi sebagai berikut
  39. <%-- start web service invocation --%>
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    // TODO initialize WS operation arguments here
    int nim = 0;
    port.delMahasiswa(nim);
    } catch (Exception ex) {
    // TODO handle custom exceptions here
    }
    %>
    <%-- end web service invocation --%>
  40. Ubah sedikit parameter int nim = 0, karena fungsi ini akan digunakan untuk menerima POST berupa hapus mahasiswa berdasarkan nim, sehingga script hapus-mhs.jsp berubah menjadi berikut
  41. <%-- start web service invocation --%>
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    // TODO initialize WS operation arguments here
    int nim = Integer.valueOf(request.getParameter("nim")); port.delMahasiswa(nim);
    response.sendRedirect("index.jsp");
    } catch (Exception ex) {
    }
    %>
    <%-- end web service invocation --%>
  42. Selanjutnya kita akan buat tombol edit dan update. Proses ini akan mengambil data mahasiswa dan menampilkannya di form untuk edit
  43. Sebelum membuat file edit, maka rubah dulu method getMahasiswa di ProjectSiakad -> Mahasiswa.java sehingga berubah menjadi berikut.
  44. /*Get Mahasiswa*/
    @WebMethod(operationName = "getMahasiswa")
    public List getMahasiswa(
    @WebParam(name = "nim") int nim) {
    List mahasiswa = new ArrayList();
    try {
    Class.forName("com.mysql.jdbc.Driver");
    Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
    Statement st = conn.createStatement();
    con = kon.getCon();
    ps = con.prepareStatement("select * from mahasiswa where nim=?");
    ps.setInt(1, nim);
    ResultSet rst = ps.executeQuery();
    while (rst.next()) {
    mahasiswa.add("<div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">NIM</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"nim\"value=\""+rst.getInt("nim")+"\" readonly=\"true\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Nama</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"nama\" value=\""+rst.getString("nama")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Jurusan</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"jurusan\" value=\""+rst.getString("jurusan")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Email</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"email\" value=\""+rst.getString("email")+"\">\n" +
    " </div>\n" +
    " </div>\n" +
    " \n" +
    " <div class=\"form-group\">\n" +
    " <label class=\"control-label col-sm-1\">Alamat</label>\n" +
    " <div class=\"col-sm-2\">\n" +
    " <input type=\"text\" class=\"form-control\" name=\"alamat\"value=\""+rst.getString("alamat")+"\">\n" +
    " </div>\n" +
    " </div>");
    }
    } catch (Exception ex) {
    System.out.println(ex.getMessage());
    }
    return mahasiswa;
    }
    /*Selesai Get Mahasiswa*/
  45. Buat file baru dengan nama edit-mhs.jsp
    Masukan Script berikut
  46. <%@include file="header.jsp" %>
    <div class="container">
    <h3>Form Edit Mahasiswa</h3>
    <form class="form-horizontal" method="post" action="proses-edit-mhs.jsp">
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    int nim = Integer.valueOf(request.getParameter("nim"));
    java.util.List<java.lang.Object> result = port.getMahasiswa(nim);
    for (int i = 0; i < result.size(); i++) {
    out.println(result.get(i));
    }
    } catch (Exception ex) {
    }
    %>
    <button type="submit" class="btn btn-danger">Edit</button>
    </form>
    </div>
    <%@include file="footer.jsp" %>
  47. Selanjutnya buat file baru dengan nama proses-edit-mhs.jsp
    Masukan script berikut
  48. <%-- start web service invocation --%>
    <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    // TODO initialize WS operation arguments here
    int nim = 0;
    java.lang.String nama = "";
    java.lang.String jurusan = "";
    java.lang.String email = "";
    java.lang.String alamat = "";
    port.editMahasiswa(nim, nama, jurusan, email, alamat);
    } catch (Exception ex) {
    // TODO handle custom exceptions here
    }
    %>
    <%-- end web service invocation --%>
  49. Lalu rubah scriptnya sehingga menjadi sebagai berikut
  50. <%
    try {
    client.siakad.Mahasiswa_Service service = new client.siakad.Mahasiswa_Service();
    client.siakad.Mahasiswa port = service.getMahasiswaPort();
    int nim = Integer.valueOf(request.getParameter("nim"));
    java.lang.String nama = request.getParameter("nama");;
    java.lang.String jurusan =
    request.getParameter("jurusan");;
    java.lang.String email = request.getParameter("email");;
    java.lang.String alamat = request.getParameter("alamat");;
    port.editMahasiswa(nim, nama, jurusan, email, alamat);
    response.sendRedirect("index.jsp");
    } catch (Exception ex) {
    }
    %>

Comments

Popular Posts