fork(1) download

copy

package com.example.webparser;
 
import android.annotation.SuppressLint;
import android.content.Context;
import android.database.DatabaseErrorHandler;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.provider.BaseColumns;
import android.util.Log;
 
public class GSQL extends SQLiteOpenHelper implements BaseColumns {
 
	public static GSQL DBHelper = new GSQL((Context)(new Object()) , "GraphSQL.db", null, 1);
	public static SQLiteDatabase SDB = DBHelper.getWritableDatabase();
 
	private static final String DATABASE_NAME = "GraphSQL.db";
	private static final String DATABASE_TABLE = "Graph_Table";
	public static final String HOSTNAME = "HostName";
	public static final String NAMEONMAP = "NameOnMap";
	public static final String MAPNAME = "MapName";
	public static final String TYPEOFCHECK = "TypeOfCheck";
	public static final String STATE = "State";
	public static final String STATUS = "Status";
	public static final String RESPONSETIME = "ResponseTime";
	public static final String LASTMESSAGE = "LastMessage";
 
	@SuppressLint("NewApi")
	public GSQL(Context context, String name, CursorFactory factory,
			int version, DatabaseErrorHandler errorHandler) {
		super(context, name, factory, version, errorHandler);
		// TODO Auto-generated constructor stub
	}
 
	public GSQL(Context context, String name, CursorFactory factory, int version) {
		super(context, name, factory, version);
		// TODO Auto-generated constructor stub
	}
 
	private static final String DATABASE_CREATE_SCRIPT = "create table "
			+ DATABASE_TABLE + " ("  
			+ HOSTNAME + " text not null, " 
			+ NAMEONMAP  + " text not null, " 
			+ MAPNAME + " text not null, " 
			+ TYPEOFCHECK + " text not null, " 
			+ STATE + " text not null, " 
			+ STATUS + " integer, " 
			+ RESPONSETIME + " text not null, " 
			+ LASTMESSAGE + " text not null);";
 
	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
		db.execSQL(DATABASE_CREATE_SCRIPT);
	}
 
	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub
 
		Log.w("SQLite", "Updated version " + oldVersion + " on version " + newVersion);
 
 
		db.execSQL("DROP TABLE IF IT EXIST " + DATABASE_TABLE);
 
		onCreate(db);
 
	}
 
}

Main.java:12: error: class GSQL is public, should be declared in a file named GSQL.java
public class GSQL extends SQLiteOpenHelper implements BaseColumns {
       ^
Main.java:3: error: package android.annotation does not exist
import android.annotation.SuppressLint;
                         ^
Main.java:4: error: package android.content does not exist
import android.content.Context;
                      ^
Main.java:5: error: package android.database does not exist
import android.database.DatabaseErrorHandler;
                       ^
Main.java:6: error: package android.database.sqlite does not exist
import android.database.sqlite.SQLiteDatabase;
                              ^
Main.java:7: error: package android.database.sqlite.SQLiteDatabase does not exist
import android.database.sqlite.SQLiteDatabase.CursorFactory;
                                             ^
Main.java:8: error: package android.database.sqlite does not exist
import android.database.sqlite.SQLiteOpenHelper;
                              ^
Main.java:9: error: package android.provider does not exist
import android.provider.BaseColumns;
                       ^
Main.java:10: error: package android.util does not exist
import android.util.Log;
                   ^
Main.java:12: error: cannot find symbol
public class GSQL extends SQLiteOpenHelper implements BaseColumns {
                          ^
  symbol: class SQLiteOpenHelper
Main.java:12: error: cannot find symbol
public class GSQL extends SQLiteOpenHelper implements BaseColumns {
                                                      ^
  symbol: class BaseColumns
Main.java:15: error: cannot find symbol
	public static SQLiteDatabase SDB = DBHelper.getWritableDatabase();
	              ^
  symbol:   class SQLiteDatabase
  location: class GSQL
Main.java:29: error: cannot find symbol
	public GSQL(Context context, String name, CursorFactory factory,
	            ^
  symbol:   class Context
  location: class GSQL
Main.java:29: error: cannot find symbol
	public GSQL(Context context, String name, CursorFactory factory,
	                                          ^
  symbol:   class CursorFactory
  location: class GSQL
Main.java:30: error: cannot find symbol
			int version, DatabaseErrorHandler errorHandler) {
			             ^
  symbol:   class DatabaseErrorHandler
  location: class GSQL
Main.java:35: error: cannot find symbol
	public GSQL(Context context, String name, CursorFactory factory, int version) {
	            ^
  symbol:   class Context
  location: class GSQL
Main.java:35: error: cannot find symbol
	public GSQL(Context context, String name, CursorFactory factory, int version) {
	                                          ^
  symbol:   class CursorFactory
  location: class GSQL
Main.java:52: error: cannot find symbol
	public void onCreate(SQLiteDatabase db) {
	                     ^
  symbol:   class SQLiteDatabase
  location: class GSQL
Main.java:58: error: cannot find symbol
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
	                      ^
  symbol:   class SQLiteDatabase
  location: class GSQL
Main.java:28: error: cannot find symbol
	@SuppressLint("NewApi")
	 ^
  symbol:   class SuppressLint
  location: class GSQL
Main.java:14: error: cannot find symbol
	public static GSQL DBHelper = new GSQL((Context)(new Object()) , "GraphSQL.db", null, 1);
	                                        ^
  symbol:   class Context
  location: class GSQL
Main.java:15: error: cannot find symbol
	public static SQLiteDatabase SDB = DBHelper.getWritableDatabase();
	                                           ^
  symbol:   method getWritableDatabase()
  location: variable DBHelper of type GSQL
Main.java:51: error: method does not override or implement a method from a supertype
	@Override
	^
Main.java:61: error: cannot find symbol
		Log.w("SQLite", "Updated version " + oldVersion + " on version " + newVersion);
		^
  symbol:   variable Log
  location: class GSQL
Main.java:57: error: method does not override or implement a method from a supertype
	@Override
	^
25 errors

Standard output is empty