DELETE


<%@ page import ="java.sql.*"%>
<form method = "POST">
Input ID Transaksi yang ingin di hapus</br>
<input type = "text" name = "idtrans"></br>
<input type="Submit" name="submit" value="hapus">
<%

String idtrans = request.getParameter("idtrans");
if(idtrans==null){
	out.println("ID Transaksi harus benar");
}else{
try{

    Class.forName("com.mysql.jdbc.Driver");
    Connection koneksi = null;
    koneksi = DriverManager.getConnection(
        "jdbc:mysql://localhost/Transaksi",
	"root",
	""
    );
    out.println("koneksi berhasil <br />");

	Statement perintah = koneksi.createStatement();
	int hasil = perintah.executeUpdate("delete from view where id_transaksi='"+idtrans+"'");
	out.println(hasil);

	koneksi.close();
	out.println("Koneksi ditutup <br />");
}
catch(Exception e)
{
	out.println(e);
}
}
%>
<a href= "view.jsp">Lihat Tabel</a>