Bank Security
public class CriadorBanco extends SQLiteOpenHelper {
static final String NOME_BANCO = "pont.db";
static final String TABELA = "pontuacoes";
static final String ID = "_id";
static final String GAMER = "player";
static final String DESAFIO = "desafio";
static final String PONTUACAO = "pontos";
static final int VERSAO = 1;
public CriadorBanco (Context context){
super(context, NOME_BANCO, null, VERSAO);
}
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "CREATE TABLE" + TABELA + "("
+ ID + "integer primary key autoincrement,"
+ GAMER + "text,"
+ DESAFIO + "text,"
+ PONTUACAO + "text,"
+")";
*db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS" + TABELA);
onCreate(db);
}
}
Activity Score
public class Pontuacao extends AppCompatActivity {
private ListView pontuacaodesafio1;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.pontuacao);
ControladorBanco crud = new ControladorBanco(getBaseContext());
*Cursor cursor = crud.carregaDados();
String[] nomeCampos = new String[] {CriadorBanco.ID, CriadorBanco.GAMER, CriadorBanco.DESAFIO, CriadorBanco.PONTUACAO};
int[] idViews = new int[] {R.id.idGamer, R.id.Gamer, R.id.NDesafio, R.id.Pontuacao};
SimpleCursorAdapter adaptador = new SimpleCursorAdapter(getBaseContext(),
R.layout.pontuacao_layout,cursor,nomeCampos,idViews, 0);
pontuacaodesafio1 = (ListView)findViewById(R.id.pontuacaodesafio1);
pontuacaodesafio1.setAdapter(adaptador);
}
}
Bank Controller
public class ControladorBanco {
private SQLiteDatabase db;
private CriadorBanco banco;
public ControladorBanco (Context context){
banco = new CriadorBanco(context);
}
public String insereDado(String player, String desafio, String pontos){
ContentValues valores;
long resultado;
db = banco.getWritableDatabase();
valores = new ContentValues();
valores.put(CriadorBanco.GAMER, player);
valores.put(CriadorBanco.DESAFIO, desafio);
valores.put(CriadorBanco.PONTUACAO, pontos);
resultado = db.insert(CriadorBanco.TABELA, null, valores);
db.close();
if (resultado ==-1)
return "Tente Novamente";
else
return "Pontuação Salva";
}
public Cursor carregaDados(){
Cursor cursor;
String[] campos = {banco.ID, banco.GAMER, banco.DESAFIO, banco.PONTUACAO};
*db = banco.getReadableDatabase();
cursor = db.query(banco.TABELA, campos, null, null, null, null, null);
if(cursor!=null){
cursor.moveToFirst();
}
db.close();
return cursor;
}
}
The error:
E/AndroidRuntime: FATAL EXCEPTION: main
Process: br.com.mscp.desafio, PID: 2435
java.lang.RuntimeException: Unable to start activity ComponentInfo{br.com.mscp.desafio/br.com.mscp.desafio.Pontuacao}: android.database.sqlite.SQLiteException: near "TABLEpontuacoes": syntax error (code 1): , while compiling: CREATE TABLEpontuacoes(_idinteger primary key autoincrement,playertext,desafiotext,pontostext,)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2665)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726)
at android.app.ActivityThread.-wrap12(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:154)
at android.app.ActivityThread.main(ActivityThread.java:6119)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
Caused by: android.database.sqlite.SQLiteException: near "TABLEpontuacoes": syntax error (code 1): , while compiling: CREATE TABLEpontuacoes(_idinteger primary key autoincrement,playertext,desafiotext,pontostext,)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)
at br.com.mscp.desafio.CriadorBanco.onCreate(CriadorBanco.java:29)
at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)
at android.database.sqlite.SQLiteOpenHelper.getReadableDatabase(SQLiteOpenHelper.java:187)
at br.com.mscp.desafio.ControladorBanco.carregaDados(ControladorBanco.java:39)
at br.com.mscp.desafio.Pontuacao.onCreate(Pontuacao.java:18)
at android.app.Activity.performCreate(Activity.java:6679)
at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1118)
at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2618)
at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726)
at android.app.ActivityThread.-wrap12(ActivityThread.java)
at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477)
at android.os.Handler.dispatchMessage(Handler.java:102)
at android.os.Looper.loop(Looper.java:154)
at android.app.ActivityThread.main(ActivityThread.java:6119)
at java.lang.reflect.Method.invoke(Native Method)
at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
Application terminated.