谁能给我发一个安卓带有SQLite数据库连接的能跑起来的小程序啊万分感谢。

Sqlite3是android自带的一种轻型的数据库，使用的话也是很方便的。 下面是例子： package yeshusqlite3; import androidappActivity; import androidcontentContentValues; import androiddatabaseCursor; import androiddatabasesqliteSQLiteDatabase; import androidosBundle; import androidviewView; import androidviewViewOnClickListener; import androidwidgetButton; import androidwidgetEditText; public class sqlite3 extends Activity { private Button createdatabase; private Button updatedatabase; private Button insert; private Button update; private Button select; private Button delete; private EditText edittext01; private EditText edittext02; private String name; private int id; private String dbname; / Called when the activity is first created / @Override public void onCreate(Bundle savedInstanceState) { superonCreate(savedInstanceState); setContentView(Rlayoutmain); createdatabase = (Button) findViewById(Ridxxx); updatedatabase = (Button)findViewById(RidButton02); insert = (Button)findViewById(RidButton03); update = (Button)findViewById(RidButton04); select = (Button)findViewById(RidButton05); delete = (Button)findViewById(RidButton06); edittext01 = (EditText)findViewById(RidEditText01); edittext02 = (EditText)findViewById(RidEditText02); createdatabasesetOnClickListener(new OnClickListener_create()); updatedatabasesetOnClickListener(new OnClickListener_updatedatabase()); insertsetOnClickListener(new OnClickListener_insert()); updatesetOnClickListener(new OnClickListener_update()); selectsetOnClickListener(new OnClickListener_select()); deletesetOnClickListener(new OnClickListener_delete()); } class OnClickListener_delete implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub id = IntegerparseInt(edittext01getText()toString()); Data temp = new Data(sqlite3this, "data_yeshu"); SQLiteDatabase db = tempgetWritableDatabase(); dbdelete("user", "id=", new String[]{id+""}); } } class OnClickListener_insert implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub name = edittext02getText()toString(); id = IntegerparseInt(edittext01getText()toString()); Data temp = new Data(sqlite3this, "data_yeshu"); SQLiteDatabase db = tempgetWritableDatabase(); ContentValues value = new ContentValues(); valueput("id", id); valueput("name", name); dbinsert("user", null, value); Systemoutprintln("insert"); } } class OnClickListener_update implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub name = edittext02getText()toString(); id = IntegerparseInt(edittext01getText()toString()); Data temp = new Data(sqlite3this, "data_yeshu"); SQLiteDatabase db = tempgetWritableDatabase(); ContentValues value = new ContentValues(); valueput("name", name); dbupdate("user", value, "id=", new String[]{id+""}); } } class OnClickListener_updatedatabase implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub Data temp = new Data(sqlite3this, "data_yeshu", 2); SQLiteDatabase db = tempgetReadableDatabase(); } } class OnClickListener_select implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub Data temp = new Data(sqlite3this, "data_yeshu"); SQLiteDatabase db = tempgetReadableDatabase(); Cursor cursor = dbquery("user", new String[]{"id", "name"}, "id=", new String[]{"1"}, null, null, null); while(cursormoveToNext()) { Systemoutprintln(cursorgetShort(cursorgetColumnIndex("id"))); Systemoutprintln(cursorgetString(cursorgetColumnIndex("name"))); } } } class OnClickListener_create implements OnClickListener { public void onClick(View v) { // TODO Auto-generated method stub Data temp = new Data(sqlite3this, "data_yeshu"); SQLiteDatabase db = tempgetReadableDatabase(); } } } ================================ package yeshusqlite3; import androidcontentContext; import androiddatabasesqliteSQLiteDatabase; import androiddatabasesqliteSQLiteDatabaseCursorFactory; import androiddatabasesqliteSQLiteOpenHelper; public class Data extends SQLiteOpenHelper { private static final int VERSION = 1; public Data(Context context, String name, CursorFactory factory, int version) { super(context, name, factory, version); // TODO Auto-generated constructor stub } public Data(Context context, String name, int version) { this(context, name, null, version); } public Data(Context context , String name) { this(context, name, null, VERSION); } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub Systemoutprintln("create a new database"); dbexecSQL("create table user(id int, name VERCHAR(20))"); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub Systemoutprintln("update a database"); } }

小程序是无法直接连数据库，需要一个服务端web应用程序，提供>

SQL是Structured Query Language(结构化查询语言)的缩写。SQL是专为数据库而建立的 *** 作命令集，是一种功能齐全的数据库语言。在使用它时，只需要发出"做什么"的命令，"怎么做"是不用使用者考虑的。

SQL功能强大、简单易学、使用方便，已经成为了数据库 *** 作的基础，并且现在几乎所有的数据库均支持SQL。

SQL数据库的数据体系结构基本上是三级结构，但使用术语与传统关系模型术语不同。在SQL中，关系模式(模式)称为"基本表"(base table);存储模式(内模式)称为"存储文件"(stored file);子模式(外模式)称为"视图"(view);元组称为"行"(row);属性称为"列"(column)。名称对称如^00100009a^。

以上就是关于谁能给我发一个安卓带有SQLite数据库连接的能跑起来的小程序啊万分感谢。全部的内容，包括:谁能给我发一个安卓带有SQLite数据库连接的能跑起来的小程序啊万分感谢。、微信小程序怎么获取Sql数据库的数据、等相关内容解答，如果想了解更多相关内容，可以关注我们，你们的支持是我们更新的动力！