android简单例子

⑴ 求一个 android 数据库操作 的小例子（增 删，查看）

package com.example.androiddbtest;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class SqliteOpenHelperTest extends SQLiteOpenHelper {
public SqliteOpenHelperTest(Context context, String name,
CursorFactory factory, int version) {
super(context, name, factory, version);
// TODO Auto-generated constructor stub
}

@Override
public void onCreate(SQLiteDatabase arg0) {
// TODO 创建数据库后，对数据库的操作
arg0.execSQL("CREATE TABLE mytable (_id INTEGER , name varchar(20));");
Log.i("sqlite", "创建表");
}

/**
* // TODO 更改数据库版本的操作
* arg1 旧版本号
* arg2 新版本号
*/
@Override
public void onUpgrade(SQLiteDatabase arg0, int arg1, int arg2) {
// TODO Auto-generated method stub
Log.i("sqlite", "更新数据库");
}

@Override
public void onOpen(SQLiteDatabase db) {
super.onOpen(db);
// TODO 每次成功打开数据库后首先被执行
}
}

package com.example.androiddbtest;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.Toast;

public class SQLiteTestActivity extends Activity {
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.sqlite_mian);

Button bt1 = (Button) findViewById(R.id.sqbtn1);
Button bt2 = (Button) findViewById(R.id.sqbtn2);
Button bt4 = (Button) findViewById(R.id.sqbtn4);
Button bt5 = (Button) findViewById(R.id.sqbtn5);
Button bt3 = (Button) findViewById(R.id.sqbtn3);

bt1.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
Log.i("sqlite", "创建testdb");
SqliteOpenHelperTest soh = new SqliteOpenHelperTest(SQLiteTestActivity.this, "mytestdb", null, 1);
SQLiteDatabase db = soh.getWritableDatabase();
db.execSQL("insert into mytable(_id,name) values(2,'bbbbb')");
ContentValues cv = new ContentValues();
cv.put("_id", 1);
cv.put("name", "aaaaa");
db.insert("mytable", null, cv);
db.close();
if (db != null) {
db.close();
}
Toast.makeText(SQLiteTestActivity.this, "存取信息成功!", Toast.LENGTH_SHORT)
.show();
}
});
bt4.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
SqliteOpenHelperTest soh = new SqliteOpenHelperTest(
SQLiteTestActivity.this, "mytestdb", null, 1);
SQLiteDatabase db = soh.getWritableDatabase();
ContentValues cv = new ContentValues();
cv.put("name", "dddddddddddddd");
db.update("mytable", cv, "_id=?", new String[] { "2" });
db.close();
Toast.makeText(SQLiteTestActivity.this, "修改信息成功!", Toast.LENGTH_SHORT)
.show();
}
});
bt2.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
SqliteOpenHelperTest soh = new SqliteOpenHelperTest(
SQLiteTestActivity.this, "mytestdb", null, 1);
SQLiteDatabase db = soh.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from mytable where _id=?",new String[] { "2" });
int count = cursor.getColumnCount();
Toast.makeText(SQLiteTestActivity.this,"数据总共:" + count , Toast.LENGTH_SHORT).show();
while (cursor.moveToNext()) {
Toast.makeText(SQLiteTestActivity.this,
"_id:" + cursor.getInt(0) + "。name:" + cursor.getString(1),Toast.LENGTH_SHORT).show();
}
if (soh != null) {
soh.close();
}
}
});
bt5.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
SQLiteTestActivity.this.startActivity(new Intent(SQLiteTestActivity.this,
SqliteListViewActivity.class));
}
});
bt3.setOnClickListener(new OnClickListener() {
@Override
public void onClick(View arg0) {
SqliteOpenHelperTest soh = new SqliteOpenHelperTest(
SQLiteTestActivity.this, "mytestdb", null, 1);
SQLiteDatabase db = soh.getWritableDatabase();
db.delete("mytable", "_id=?", new String[] { "1" });
db.close();
Toast.makeText(SQLiteTestActivity.this, "清除id为1的信息成功!",
Toast.LENGTH_SHORT).show();
}
});
}
}

package com.example.androiddbtest;
import android.app.ListActivity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.support.v4.widget.SimpleCursorAdapter;
import android.view.ContextMenu;
import android.view.ContextMenu.ContextMenuInfo;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnCreateContextMenuListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;

public class SqliteListViewActivity extends ListActivity {
private ListView listView;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);

setContentView(R.layout.sqlitelistview_main);
SqliteOpenHelperTest soh = new SqliteOpenHelperTest(
SqliteListViewActivity.this, "mytestdb", null, 1);
SQLiteDatabase db = soh.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from mytable where _id=?",new String[] { "2" });

SimpleCursorAdapter adapter = new SimpleCursorAdapter(
SqliteListViewActivity.this,android.R.layout.simple_list_item_2,
cursor, new String[] {"_id", "name" }, new int[] { android.R.id.text1,android.R.id.text2 }, 0);

ListView listView = (ListView) findViewById(android.R.id.list); listView.setAdapter(adapter);
listView.setOnItemClickListener(new OnItemClickListener() {
public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
long arg3) {

SqliteListViewActivity.this.listView = (ListView) arg0;
ListView templist = (ListView) arg0;
View mView = templist.getChildAt(arg2);
TextView t1 = (TextView) mView.findViewById(android.R.id.text1);
TextView t2 = (TextView) mView.findViewById(android.R.id.text2);
String mytitle = t1.getText().toString();
String mycontent = t2.getText().toString();

Toast.makeText(
SqliteListViewActivity.this,
"项目被点击~~~" + mytitle + "~~~" + mycontent
+ "~~~" + arg2, Toast.LENGTH_SHORT).show();
}
});

// 添加长按点击
listView.(new OnCreateContextMenuListener() {
public void onCreateContextMenu(ContextMenu menu, View v,
ContextMenuInfo menuInfo) {
menu.setHeaderTitle("确定删除？");
menu.add(0, 0, 0, "OK");
menu.add(0, 1, 0, "Cancel");
Toast.makeText(SqliteListViewActivity.this,"长按点击~~~", Toast.LENGTH_SHORT).show();
}
});

}
@Override
public boolean onContextItemSelected(MenuItem item) {
//ContextMenuInfo menuInfo = (ContextMenuInfo) item.getMenuInfo();
AdapterView.AdapterContextMenuInfo info = (AdapterView.AdapterContextMenuInfo) item.getMenuInfo();
int id = (int) info.id;// 这里的info.id对应的就是数据库中_id的值

switch (item.getItemId()) {
case 0:
ListView templist = listView;
View mView = templist.getChildAt(id);
TextView t1 = (TextView) mView.findViewById(android.R.id.text1);
TextView t2 = (TextView) mView.findViewById(android.R.id.text2);
String mytitle = t1.getText().toString();
String mycontent = t2.getText().toString();
Toast.makeText(
SqliteListViewActivity.this,
"onContextItemSelected~~~" + mytitle + "~~~" + mycontent , Toast.LENGTH_SHORT).show();
break;
case 1:
Toast.makeText(
SqliteListViewActivity.this, id +
"~~~选择了取消", Toast.LENGTH_SHORT).show();
break;
}

return super.onContextItemSelected(item);
}
}

res\layout 下的xml

sqlite_mian.xml

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:layout_width="match_parent"
android:layout_height="match_parent"
android:orientation="vertical" >

<Button
android:id="@+id/sqbtn1"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="存取信息" />

<Button
android:id="@+id/sqbtn4"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="修改信息" />
<Button
android:id="@+id/sqbtn2"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="读取信息" />

<Button
android:id="@+id/sqbtn5"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="展示信息" />
<Button
android:id="@+id/sqbtn3"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="清除信息" />

</LinearLayout>

sqlitelistview_main.xml
<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
android:id="@+id/LinearLayout01"
android:layout_width="fill_parent"
android:layout_height="wrap_content"
android:orientation="vertical" >

<ListView
android:id="@id/android:list"
android:layout_width="fill_parent"
android:layout_height="wrap_content"/>

<TextView
android:id="@id/android:empty"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:text="NO DATA" />

</LinearLayout>

AndroidManifest.xml

<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="com.example.androiddbtest"
android:versionCode="1"
android:versionName="1.0" >

<uses-sdk
android:minSdkVersion="8"
android:targetSdkVersion="15" />

<!-- 在SDCard中创建与删除文件权限 -->
<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS" />
<!-- 往SDCard写入数据权限 -->
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

<application
android:icon="@drawable/ic_launcher"
android:label="@string/app_name"
android:theme="@style/AppTheme" >
<activity
android:name=".SQLiteTestActivity"
android:label="@string/title_activity_main" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>

<activity android:name=".SqliteListViewActivity" >
</activity>

</application>

</manifest>

其他的strings.xml这类的，你自己看着配配吧，没啥东西

⑵ android 声控游戏怎么开发的 ，有什么简单的例子没

你好！
一般都是做音量大小识别来进行控制
你可以看看Android中录音的那几个类
希望对你有所帮助，望采纳。

⑶ Android开发中用View做一个最简单的显示图片的例子，只显示图片，简短的！谢谢了！

这个很简单！源代码发给你！