Advertisement
BlasToIce

Script_p7_MethodtampilMahasiswa

Dec 26th, 2018
243
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. @WebMethod(operationName = "tampilMahasiswa")
  2. public List tampilMahasiswa()
  3. {
  4. List daftar = new ArrayList();
  5. String sql_daftar = "select * from mahasiswa";
  6. try
  7. {
  8. Class.forName("com.mysql.jdbc.Driver");
  9. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/siakad", "root", "");
  10. Statement stmt = con.createStatement();
  11. ResultSet rs = stmt.executeQuery(sql_daftar);
  12. while (rs.next())
  13. {
  14. 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>");
  15. }
  16. con.close();
  17. }
  18. catch (Exception ex)
  19. {
  20. System.out.println(ex.getMessage());
  21. }
  22. return daftar;
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement