I have created a database with name, surname and check-in (Boolean) columns in MySQL and all I want is in the moment that I click the checkbox should be deleted the row selected. The code should be only in java because I am in an internship so I have created a jsp file. have no idea how to create the method .onclick="deleteRow(this)"emphasized text
<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@ page import="javax.servlet.jsp.JspWriter"%>
<%@ page
import="java.io.*,java.lang.*,java.util.*,java.net.*,java.util.*,java.text.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*"%>
<HTML>
<body>
<%
String id = request.getParameter("userId");
String driverName = "com.mysql.jdbc.Driver";
String userId = "root";
String password = "Kristard1";
Connection connection = null;
Statement statement = null;
ResultSet resultSet = null;
%>
<h2 align="center">
<font><strong>Retrieve data from database in jsp</strong></font>
</h2>
<table align="center" cellpadding="10" cellspacing="10" border="1">
<tr>
</tr>
<tr bgcolor="#A52A2A">
<td><b>Name</b></td>
<td><b>Surname</b></td>
<td><b>Check-in</b></td>
</tr>
<%
try {
Class.forName(driverName);
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/guest", userId, password);
statement = connection.createStatement();
String sql = "SELECT * FROM guest";
resultSet = statement.executeQuery(sql);
while (resultSet.next()) {
%>
<tr bgcolor="#DEB887">
<td><%=resultSet.getString("name")%></td>
<td><%=resultSet.getString("Surname")%></td>
<td><input type="checkbox" name="check"
value=<%=resultSet.getString("Check-in")%> onClick="deleteRow(this)">
<%
}
} catch (Exception e) {
}
%>
</table>
</body>
</HTML>
Aucun commentaire:
Enregistrer un commentaire