按下BackSpace按钮会导致格式编号异常

Question

当我按下backspace按钮时，我的功能会抛出以下异常：

as format number exception as(java.lang.NumberFormatException: For input string:)

这是我的代码...

private void searchKeyReleased(java.awt.event.KeyEvent evt) {
    try {
        String sql = "SELECT * FROM SEARCH Where ID=" + Integer.parseInt(search.getText()) + "";
        stmt = conn.createStatement();
        rs = stmt.executeQuery(sql);
        while (rs.next()) {
            int id1 = rs.getInt("ID");
            id.setText("" + id1);
            String name1 = rs.getString("NAME");
            name.setText(name1);
            String surname1 = rs.getString("SURNAME");
            surname.setText(surname1);
        }
    }
    catch (Exception ex){
        System.out.print(ex);
    }
}         

您能帮您告诉我为什么我会遇到这个错误。

Answer 1

String sql = "SELECT * FROM SEARCH Where ID=" + Integer.parseInt(search.getText()) + "";

在上面的行中，Where应在大写字母WHERE

中

String sql ="SELECT * FROM SEARCH WHERE ID=" + Integer.parseInt(search.getText())+"";