fork download

copy

package com.sandy.mylittleprincess2;
import java.io.File;
 
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
 
public class CreatDB extends SQLiteOpenHelper{
	private static final String DICTIONARY_TABLE_NAME = "Place";
	private static final String DICTIONARY_TABLE_CREATE =
            "CREATE TABLE " + DICTIONARY_TABLE_NAME + " (" +
            "_id" + "  INTEGER PRIMARY KEY AUTOINCREMENT, " +
            "Finish_date" + " TEXT , "+
            "HyperLink" + " TEXT, " +
            "Main" + " TEXT, " +
            "Context"+" TEXT, "+
            "Address"+" TEXT "+
            " );";
 
	private static final int VERSION=3;
	public CreatDB(Context context) {
		super(context, "Princess", null, VERSION);
		// TODO 自動產生的建構子 Stub
	}
 
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO 自動產生的方法 Stub
		db.execSQL(DICTIONARY_TABLE_CREATE);
 
	}
 
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO 自動產生的方法 Stub
		System.out.println("old"+oldVersion+"new"+newVersion);
		if(oldVersion<2){
		String sql=" ALTER TABLE "+DICTIONARY_TABLE_NAME+" ADD COLUMN Address TEXT";
        db.execSQL(sql);
        oldVersion++;
		}else{
        //onCreate(db);
		}
		}
 
	@Override
	public synchronized void close() {
		// TODO 自動產生的方法 Stub
		super.close();
	}
 
}
 

Main.java:9: error: class CreatDB is public, should be declared in a file named CreatDB.java
public class CreatDB extends SQLiteOpenHelper{
       ^
Main.java:4: error: package android.content does not exist
import android.content.Context;
                      ^
Main.java:5: error: package android.database.sqlite does not exist
import android.database.sqlite.SQLiteDatabase;
                              ^
Main.java:6: error: package android.database.sqlite.SQLiteDatabase does not exist
import android.database.sqlite.SQLiteDatabase.CursorFactory;
                                             ^
Main.java:7: error: package android.database.sqlite does not exist
import android.database.sqlite.SQLiteOpenHelper;
                              ^
Main.java:9: error: cannot find symbol
public class CreatDB extends SQLiteOpenHelper{
                             ^
  symbol: class SQLiteOpenHelper
Main.java:22: error: cannot find symbol
	public CreatDB(Context context) {
	               ^
  symbol:   class Context
  location: class CreatDB
Main.java:28: error: cannot find symbol
	public void onCreate(SQLiteDatabase db) {
	                     ^
  symbol:   class SQLiteDatabase
  location: class CreatDB
Main.java:35: error: cannot find symbol
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
	                      ^
  symbol:   class SQLiteDatabase
  location: class CreatDB
Main.java:27: error: method does not override or implement a method from a supertype
	@Override
	^
Main.java:34: error: method does not override or implement a method from a supertype
	@Override
	^
Main.java:47: error: method does not override or implement a method from a supertype
	@Override
	^
Main.java:50: error: cannot find symbol
		super.close();
		^
  symbol:   variable super
  location: class CreatDB
13 errors

Standard output is empty