msdalp

public synchronized boolean setData(List<YourObject> _objects) {
        final SQLiteDatabase db = this.getWritableDatabase();
        boolean retval = false;
        try {
            db.delete(SQL.DATA, null, null);
            for (YourObject object : _objects) {
                ContentValues contentValues = new ContentValues();
                contentValues.put("ID", object.id);
                contentValues.put("NAME", object.name);
                contentValues.put("ABBR", object.abbr);

msdalp

public synchronized boolean setData(List<YourObject> _objects) {
        final SQLiteDatabase db = this.getWritableDatabase();
        final String INSERT_DATA = "INSERT INTO table_data VALUES (?,?,?,?);";
        boolean retval = false;
        try {
            db.delete(SQL.TABLE_DATA, null, null);
            SQLiteStatement statement = db.compileStatement(INSERT_DATA);
            db.beginTransaction();
            for (YourObject object : _objects) {
                statement.clearBindings();

msdalp

public synchronized boolean addData(List<YourObject> _objects) {
        final SQLiteDatabase db = this.getWritableDatabase();
        boolean retval = false;
        try {
            for (YourObject object : _objects) {
                ContentValues contentValues = new ContentValues();
                contentValues.put("ID", object.id);
                contentValues.put("DATA_ID", object.dataId);
                contentValues.put("VALUE", object.value);
                db.insert("data",null,contentValues);

msdalp

public synchronized String getDataValue(long _id) {
        final SQLiteDatabase db = this.getReadableDatabase();
        String retval = null;
        try {
            Cursor cursor = db.query("data", new String[]{"VALUE"},
                    "ID = ?", new String[]{String.valueOf(_id)}, null, null, null);
            if (cursor != null) {
                if (cursor.moveToFirst()) {
                    do {
                        retval = cursor.getString(0);

msdalp

Cursor cursor = getReadableDatabase().
  rawQuery("select * from data where ID = ?", new String[] { _id });

database.query("data", 
  new String[] { ID, DATA_ID, VALUE }, 
  null, null, null, null, null);

msdalp

public class MyDb extends SQLiteOpenHelper {
 
    public static final String TAG = "MyDb";
    public static final int VERSION = 1;
    public static final String DATABASENAME = "mydb";
    public MyDb(Context context) {
        super(context, DATABASENAME, null, VERSION);
    }
 
    @Override

msdalp

package com.test.db;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import java.util.LinkedList;
import java.util.List;

public class MainActivity extends Activity {

msdalp

package com.test.db;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
import java.util.List;
import com.test.db.MainActivity.Data;

msdalp

package com.msd.jetty;

import com.google.gson.Gson;
import com.google.gson.GsonBuilder;
import org.eclipse.jetty.server.Server;
import org.eclipse.jetty.servlet.ServletContextHandler;
import org.eclipse.jetty.servlet.ServletHolder;

public class Jetty extends Server {

msdalp

package com.msd.jetty;


import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

@SuppressWarnings("serial")