创建数据库不起作用Android/Android Studio[重复]

Question

刚刚开始使用android并尝试创建简单的数据库。

FoodMacrosTable.java
public class FoodMacrosTable {

public static final String DB_NAME = "FoodDatabase.db";
public static final int DB_VERSION = 1;

public class FoodMacros implements BaseColumns {

    public static final String TABLE_NAME = "FoodMacros";


    public static final String FOOD_NAME = "Food name";
    public static final String FOOD_PROTEIN = "Amount of protein in 100g";
    public static final String FOOD_CARBS = "Amount of carbs in 100g";
    public static final String FOOD_FATS = "Amount of fats in 100g";
    public static final String FOOD_CALORIES = "Amount of calories in 100g";
    public static final String FOOD_VIT_A = "% of daily needs in 100g";

    public final String[] TABLE_COLUMNS = {FOOD_NAME,FOOD_PROTEIN,FOOD_CARBS,FOOD_FATS,FOOD_CALORIES,
            FOOD_VIT_A};

}

HealthyDbHanbler.java

public class HealthyDbHandler extends SQLiteOpenHelper {

public HealthyDbHandler(Context context){
    super(context,FoodMacrosTable.DB_NAME,null,FoodMacrosTable.DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
    String createTable = "CREATE TABLE " + FoodMacrosTable.FoodMacros.TABLE_NAME + " ( " +
            FoodMacrosTable.FoodMacros._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " +
            FoodMacrosTable.FoodMacros.FOOD_NAME + " TEXT NOT NULL, " +
            FoodMacrosTable.FoodMacros.FOOD_PROTEIN + " TEXT NOT NULL, " +
            FoodMacrosTable.FoodMacros.FOOD_CARBS + " TEXT NOT NULL, " +
            FoodMacrosTable.FoodMacros.FOOD_FATS + " TEXT NOT NULL, " +
            FoodMacrosTable.FoodMacros.FOOD_CALORIES + " TEXT NOT NULL, " +
            FoodMacrosTable.FoodMacros.FOOD_VIT_A + " TEXT NOT NULL );";

    sqLiteDatabase.execSQL(createTable);


}

@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int i, int i1) {
    sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + FoodMacrosTable.FoodMacros.TABLE_NAME);
    onCreate(sqLiteDatabase);
}

public void addFood(Food food){
    SQLiteDatabase db = this.getWritableDatabase();

    ContentValues values =  new ContentValues();
    values.put(FoodMacrosTable.FoodMacros.FOOD_NAME,food.getFOOD_NAME());
    values.put(FoodMacrosTable.FoodMacros.FOOD_PROTEIN,food.getFOOD_PROTEIN());
    values.put(FoodMacrosTable.FoodMacros.FOOD_CARBS,food.getFOOD_CARBS());
    values.put(FoodMacrosTable.FoodMacros.FOOD_FATS,food.getFOOD_FATS());
    values.put(FoodMacrosTable.FoodMacros.FOOD_CALORIES,food.getFOOD_CALORIES());
    values.put(FoodMacrosTable.FoodMacros.FOOD_VIT_A,food.getFOOD_VIT_A());

    db.insert(FoodMacrosTable.FoodMacros.TABLE_NAME,null,values);

    db.close();
}

MainActivity.java
public class MainActivity extends AppCompatActivity {

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);

    HealthyDbHandler db = new HealthyDbHandler(this) ;
    Log.v("DBINFO","Database created");

}

}

以下是我得到的错误：1:42:56 PM无法绑定到本地8600用于调试器1:42:56 PM建立的连接被主机中的软件java.io.ioException：主机中的软件在sun.nio.ch.socketdispatcher.write0（本机方法）在sun.nio.ch.socketdispatcher.write(Socketdispatcher.java:51)在sun.nio.ch.ioutil.writeFromNativeBuffer（ioutil.java:93)在OID.DDMLIB.DeviceMonitor.ProcessIncomingJDWPData（DeviceMoni...（显示气球）

Answer 1

此错误与sqlite无关，甚至与您的应用程序无关。

尝试重新启动Android Studio、adb服务器、重新启用设备中的USB调试，或相关主题中的一些内容（如果没有帮助）Eclipse DDMS错误“无法绑定到本地8600进行调试器”（can't bindd to local 8600 for debugger）