java sqlite删除某一条数据_Java中的SQLITE删除方法

我有一个方法应该从我的数据库中删除一个Person(一行) . 我收到了我在catch中创建的错误消息 . 我刚刚开始使用数据库，我大多数都在拼凑不同的技术 . 我不知道该怎么做

public static void deletePerson(String firstNameOfPersonToDelete，String lastNameOfPersonToDelete){Statement stmt = null;

try {

// Create database connection

Connection c = DriverManager.getConnection("jdbc:sqlite:PERSON.db");

// Create Statement object

stmt = c.createStatement();

// Get person we're about to delete

String getPersonQuery = "SELECT SSN FIRSTNAME, LASTNAME, AGE, CREDITCARD FROM PERSON WHERE FIRSTNAME = '"

+ firstNameOfPersonToDelete + "' AND LASTNAME = '" + lastNameOfPersonToDelete + "'";

ResultSet rs = stmt.executeQuery(getPersonQuery);

String ssn = rs.getString("SSN");

String firstName = rs.getString("FIRSTNAME");

String lastName = rs.getString("LASTNAME");

String age = rs.getString("AGE");

String creditCard = rs.getString("CREDITCARD");

String deletePersonStatement = "DELETE FROM PERSON WHERE FIRSTNAME = '" + firstName + "' AND LASTNAME = '"

+ lastName + "'";

stmt.executeUpdate(deletePersonStatement);

System.out.println("The following record was deleted:\n" + ssn + "\n" + firstName + " " + lastName + "\n"

+ age + "\n" + creditCard);

System.out.println("\nThe database contains the following records: ");

ArrayList myPeople = findAllPeople();

for (Object element : myPeople) {

System.out.println(element.toString());

}

} catch (SQLException e) {

e.printStackTrace(System.err);

System.out.println("Error: The person: \"" + firstNameOfPersonToDelete + " " + lastNameOfPersonToDelete

+ "\" was not found. No records were deleted.");

System.out.println("\nThe database contains the following records: ");

ArrayList myPeople = findAllPeople();

for (Object element : myPeople) {

System.out.println(element.toString());

}

}

}

java.sql.SQLException：没有这样的列：'SSN'错误：该人：“Fitzgerald Grant”未找到 . 没有记录被删除 . 在org.sqlite.jdbc3.JDBC3ResultSet.findColumn(JDBC3ResultSet.java:48)org.sqlite.jdbc3.JDBC3ResultSet.getString(JDBC3ResultSet.java:443)位于Test.main的Test.deletePerson(Test.java:181)处( Test.java:65)