Advertisement
BlasToIce

Script_P7_MethodgetMahasiswa

Dec 26th, 2018
196
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.13 KB | None | 0 0
  1. /*Get Mahasiswa*/
  2. @WebMethod(operationName = "getMahasiswa")
  3. public List getMahasiswa(
  4. @WebParam(name = "nim") int nim)
  5. {
  6. List mahasiswa = new ArrayList();
  7. try
  8. {
  9. Class.forName("com.mysql.jdbc.Driver");
  10. Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
  11. Statement st = conn.createStatement();
  12. con = kon.getCon();
  13. ps = con.prepareStatement("select * from mahasiswa where nim=?");
  14. ps.setInt(1, nim);
  15. ResultSet rst = ps.executeQuery();
  16. while (rst.next())
  17. {
  18. mahasiswa.add("<div class=\"form-group\">\n" +
  19. " <label class=\"control-label col-sm-1\">NIM</label>\n" +
  20. " <div class=\"col-sm-2\">\n" +
  21. " <input type=\"text\" class=\"form-control\" name=\"nim\
  22. "value=\""+rst.getInt("nim")+"\" readonly=\"true\">\n" +
  23. " </div>\n" +
  24. " </div>\n" +
  25. " \n" +
  26. " <div class=\"form-group\">\n" +
  27. " <label class=\"control-label col-sm-1\">Nama</label>\n" +
  28. " <div class=\"col-sm-2\">\n" +
  29. " <input type=\"text\" class=\"form-control\" name=\"nama\
  30. " value=\""+rst.getString("nama")+"\">\n" +
  31. " </div>\n" +
  32. " </div>\n" +
  33. " \n" +
  34. " <div class=\"form-group\">\n" +
  35. " <label class=\"control-label col-sm-1\">Jurusan</label>\n" +
  36. " <div class=\"col-sm-2\">\n" +
  37. " <input type=\"text\" class=\"form-control\" name=\"jurusan\
  38. " value=\""+rst.getString("jurusan")+"\">\n" +
  39. " </div>\n" +
  40. " </div>\n" +
  41. " \n" +
  42. " <div class=\"form-group\">\n" +
  43. " <label class=\"control-label col-sm-1\">Email</label>\n" +
  44. " <div class=\"col-sm-2\">\n" +
  45. " <input type=\"text\" class=\"form-control\" name=\"email\
  46. " value=\""+rst.getString("email")+"\">\n" +
  47. " </div>\n" +
  48. " </div>\n" +
  49. " \n" +
  50. " <div class=\"form-group\">\n" +
  51. " <label class=\"control-label col-sm-1\">Alamat</label>\n" +
  52. " <div class=\"col-sm-2\">\n" +
  53. " <input type=\"text\" class=\"form-control\ "name=\"alamat\"value=\""+rst.getString("alamat")+"\">\n" +
  54. " </div>\n" +
  55. " </div>");
  56. }
  57. }
  58. catch (Exception ex)
  59. {
  60. System.out.println(ex.getMessage());
  61. }
  62. return mahasiswa;
  63. }
  64. /*Selesai Get Mahasiswa*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement