java - 如何使用ID从db删除数据-generate_key

请帮助我解决相同的问题：我不知道如何通过mysql中自动生成的ID从表中删除数据，我认为可以使用JBDC中的GENERATED_KEY解决此问题，总之我不知道，帮助我与信息如何通过表ID删除。

表“注释”：

CREATE TABLE `note` (
`id` MEDIUMINT NOT NULL AUTO_INCREMENT,
`noteName` VARCHAR(100) NOT NULL ,
`note` VARCHAR(1000) NOT NULL ,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

我现在在这里得到的值是-'noteName'，但这是不正确的，我需要获取表中每一行的ID

Statement st = con.createStatement();
ResultSet rs;
ResultSet resultSet;
rs = st.executeQuery("SELECT * FROM note");
while (rs.next()) {
%>
    <tr>
        <td><input type="checkbox"></td>
        <td id="noteName"><%=rs.getString(1) %></td>
        <td><%=rs.getString(2) %></td>
        <td>time</td>
        <td id="close">
            <a href=deleteData?id=<%=rs.getString(1) %>><button onclick="deleteRow()" type="button" class="close" data-dismiss="modal">&times;</button></a>
        </td>
    </tr>
<% }
    rs.close();
    st.close();
    con.close();
%>

我在这里删除数据：

public class deleteData extends HttpServlet {

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int value = Integer.parseInt(request.getParameter("id"));
    try {
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/evernoteDB",
                "evernoteDB", "0633739768z");

        String query = "DELETE FROM note WHERE noteName = ?";
        PreparedStatement statement = conn.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
        statement.setInt(1, value);
        statement.executeUpdate();

        response.sendRedirect("/userNotes.jsp");

        conn.close();
    } catch (Exception e) {
        e.printStackTrace();
    }
}
}

最佳答案

您将能够从表中获取所有数据。

<tr>
    <td><%= rs.getInt("id") %></td> returns id
    <td><%= rs.getString("notename") %></td> returns noteName
    <td><%= rs.getString("note") %></td> returns note
</tr>

并改变

<a href=deleteData?id=<%=rs.getString(1) %>>...</a>

至

<a href=deleteData?id=<%= rs.getInt("id") %>>...</a>

并在servlet中将查询更改为

"DELETE FROM note WHERE id = ?"