public class Datenbankseite extends Activity {
    
    public EditText searchText;
    public SQLiteDatabase db;
    public Cursor cursor;
    public ListAdapter adapter;
    public ListView employeeList;
    
    
    /** Called when the activity is first created. */
    
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(null);
        setContentView(R.layout.datenbankseite);
        db = (new maerklinanw(this)).getWritableDatabase();
        searchText = (EditText) findViewById (R.id.searchText);
        employeeList = (ListView) findViewById (R.id.list);
    }
   
    
    
    public void search(View view) {
        
        // || is the concatenation operation in SQLite
        cursor = db.rawQuery("SELECT _id, firstName, lastName, title FROM employee WHERE firstName || ' ' || lastName LIKE ?", 
                        new String[]{"%" + searchText.getText().toString() + "%"});
        adapter = new SimpleCursorAdapter(
                this, 
                R.layout.maerklin, 
                cursor, 
                new String[] {"firstName", "lastName", "title"}, 
                new int[] {R.id.firstName, R.id.lastName, R.id.title});
        employeeList.setAdapter(adapter);
    }
    
    
}

public class maerklinanw extends SQLiteOpenHelper {

    public static final String DATABASE_NAME = "employee_directory";
    
    public maerklinanw(Context context) {
        super(context, DATABASE_NAME, null, 1);
    }
    
    
    @Override
    public void onCreate(SQLiteDatabase db) {
        /*
         * Create the employee table and populate it with sample data.
         * In step 6, we will move these hardcoded statements to an XML document.
         */
        
        String sql = "CREATE TABLE IF NOT EXISTS employee (" +
                        "_id INTEGER PRIMARY KEY AUTOINCREMENT, " +
                        "firstName TEXT, " +
                        "lastName TEXT, " +
                        "title TEXT)";
        db.execSQL(sql);
        
        ContentValues values = new ContentValues();

        values.put("firstName", "John");
        values.put("lastName", "Zimmermähn");
        values.put("title", "Designer");
        db.insert("employee", "lastName", values);
        
        values.put("firstName", "Robert");
        values.put("lastName", "Jackson");
        values.put("title", "VP Engineering");
        db.insert("employee", "lastName", values);
    }
        
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        db.execSQL("DROP TABLE IF EXISTS employees");
        onCreate(db);
    }
    
}