java - 如何删除 [SQLITE_ERROR] SQL 错误或丢失数据库(6 列 1 个值)

Question

  String nam = name.getText();
    String bloodgrp = bgroup.getText();
    String addre = address.getText();
    String phn = phone.getText();
    String ref = refrence.getText();
    String will = willing.getText();

    String query ="insert into Blooddoner(Name,Bgroup,Address,Phone,Refrence,Willing) "
            + "values('"+nam+"''"+bloodgrp+"''"+addre+"''"+phn+"''"+ref+"''"+will+"')";

在此代码中我收到错误。我无法理解这个错误的含义

java.sql.SQLException: [SQLITE_ERROR] SQL error or missing database (1 values for 6 columns)

Answer 1

您插入的方式错误，值必须以逗号分隔，请在值之间添加逗号。