列位置“ 1”超出范围。此ResultSet的列数为'0'。在这方面需要帮助

列位置“ 1”超出范围。此ResultSet的列数为'0'。在这方面需要帮助

try {
    String host = "jdbc:derby://localhost:1527/Patients";

    String uname =  "admin123";
    String uPass = "admin123";`
    Connection con = DriverManager.getConnection(host, uname, uPass );

    String sql = "insert into patient(ID,NAME,AGE,GENDER,BTYPE,PARENT,CN)"
      + "VALUES('"+field1.getText()+"','"+field2.getText()+"','"+
      field3.getText()+"','"+field4.getText()+"','"+field5.getText()+"','"+
      field6.getText()+"','"+field7.getText()+"')";


    PreparedStatement preStatement = con.prepareStatement(sql);

    preStatement.setString(1,field1.getText());
    preStatement.setString(2,field2.getText());
    preStatement.setString(3,field3.getText());
    preStatement.setString(4,field4.getText());
    preStatement.setString(5,field5.getText());
    preStatement.setString(6,field6.getText());
    preStatement.setString(7,field7.getText());

    preStatement.execute();   
} catch(SQLException err) {
    System.out.println(err.getMessage());
}