Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Update CustomSqlite.java to call "SELECT sqlite_version()". |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
71a3449ef6c12645b7a35486d12d9a0f |
| User & Date: | dan 2013-12-18 17:36:15 |
Context
|
2013-12-18
| ||
| 18:04 | Add a dummy version (equivalent to BINARY) of collation sequence LOCALIZED to all new database handles. Now a simple "SELECT sqlite_version()" works. check-in: 87449ff921 user: dan tags: trunk | |
| 17:36 | Update CustomSqlite.java to call "SELECT sqlite_version()". check-in: 71a3449ef6 user: dan tags: trunk | |
| 17:23 | Commit the various hacks to android files made outside of fossil. check-in: 7e57f15de2 user: dan tags: trunk | |
Changes
Changes to res/layout/main.xml.
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="Hello World, CustomSqlite"
/>
</LinearLayout>
|
> > > > > > > > > > > > > > |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:orientation="vertical"
android:layout_width="fill_parent"
android:layout_height="fill_parent"
>
<TextView
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="Hello World, CustomSqlite"
/>
<TextView
android:id="@+id/tv_widget"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:text="this text should be replaced by the sqlite version"
/>
<Button
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="Find SQLite version"
android:onClick="find_version"
/>
</LinearLayout>
|
Changes to src/org/sqlite/app/customsqlite/CustomSqlite.java.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
package org.sqlite.app.customsqlite;
import android.app.Activity;
import android.os.Bundle;
public class CustomSqlite extends Activity
{
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState)
{
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
}
}
|
> > > > > > > > > > > > | > > > > > > > > > > > > > > > > > > > > > > > > > > > |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
package org.sqlite.app.customsqlite; import android.app.Activity; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.TextView; import org.sqlite.database.sqlite.SQLiteDatabase; import org.sqlite.database.sqlite.SQLiteStatement; /* import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteStatement; */ public class CustomSqlite extends Activity { /** Called when the activity is first created. */ @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); } public void find_version(View view){ System.loadLibrary("sqliteX"); SQLiteDatabase db = null; SQLiteStatement st; String res; TextView tv = (TextView)findViewById(R.id.tv_widget); tv.setText("<attempting to access sqlite...>"); try { db = SQLiteDatabase.openOrCreateDatabase(":memory:", null); st = db.compileStatement("SELECT sqlite_version()"); res = st.simpleQueryForString(); tv.setText(res); }catch(Exception e){ Log.e("Error", "Error", e); tv.setText(e.toString()); } finally { if (db != null) db.close(); } } } |