@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
final String x="";
helper = new NotesHelper(this);
init();
try{
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery( "select SUM("+PAY+") AS fullname from "+TABLE_NAME, null );
String sum = cursor.getString(cursor.getColumnIndex("fullname")); //พอมีคำสั่งนี้แอพไม่ทำงานครับ
textView3.setText(""+ sum);
}finally{
helper.close();
}
}
//ต้องสร้างตารางfullnameในDatabaseไหมครับ
อันนี้ Database
public class NotesHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "simple_sqlite.db";
private static final int DATABASE_VERSION = 1;
public NotesHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME +"

_ID INTEGER PRIMARY KEY AUTOINCREMENT, " + TIME + " INTEGER, "+CONTENT+" TEXT," + PAY + " INTEGER);");
}
แสดงผลบวกยังไงครับ android sqlite
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Toolbar toolbar = findViewById(R.id.toolbar);
setSupportActionBar(toolbar);
final String x="";
helper = new NotesHelper(this);
init();
try{
SQLiteDatabase db = helper.getReadableDatabase();
Cursor cursor = db.rawQuery( "select SUM("+PAY+") AS fullname from "+TABLE_NAME, null );
String sum = cursor.getString(cursor.getColumnIndex("fullname")); //พอมีคำสั่งนี้แอพไม่ทำงานครับ
textView3.setText(""+ sum);
}finally{
helper.close();
}
}
//ต้องสร้างตารางfullnameในDatabaseไหมครับ
อันนี้ Database
public class NotesHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "simple_sqlite.db";
private static final int DATABASE_VERSION = 1;
public NotesHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE " + TABLE_NAME +"
}