MainActivity.java
package com.example.sqlite;
import java.util.ArrayList;
import java.util.List;
import android.app.Activity;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.ArrayAdapter;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.TextView;
import android.widget.Toast;
public class MainActivity extends Activity implements OnClickListener{
private static final String TAG="Add";
private static final ListAdapter ListAdapter = null;
private EditText ecode,ename,ebirth;
private Button badd,bdel,bupdate,bsele;
private SQLiteDatabase db=null;
private TextView tedatashow;
private ListView datashow;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
ecode=(EditText)findViewById(R.id.ecode);
ename=(EditText)findViewById(R.id.ename);
ebirth=(EditText)findViewById(R.id.ebirth);
badd=(Button)findViewById(R.id.badd);
bdel=(Button)findViewById(R.id.bdel);
bupdate=(Button)findViewById(R.id.bupdate);
bsele=(Button)findViewById(R.id.bsele);
tedatashow=(TextView)findViewById(R.id.tedatashow);
datashow=(ListView)findViewById(R.id.datashow);
badd.setOnClickListener((android.view.View.OnClickListener) this);
bdel.setOnClickListener((android.view.View.OnClickListener) this);
bsele.setOnClickListener((android.view.View.OnClickListener) this);
bupdate.setOnClickListener((android.view.View.OnClickListener) this);
}
public void onClick(View v)
{
// TODO Auto-generated method stub
MyDBHelper helper=new MyDBHelper(this);
db=helper.getWritableDatabase();
if(v==badd)
{
if(ecode.getText().toString().trim().length()!=0 && ename.getText().toString().trim().length()!=0 && ebirth.getText().toString().trim().length()!=0)
{
try
{
String sql="INSERT INTO user(ecode,ename,ebirth)" +"VALUES('"+ecode.getText()+"','" +ename.getText()+"','" +ebirth.getText()+"')";
db.execSQL(sql);
Toast.makeText(this, "添加成功!", Toast.LENGTH_LONG).show();
ecode.setText("");
ename.setText("");
ebirth.setText("");
}
catch(Exception e)
{
Toast.makeText(this, "出錯了!"+ e.getMessage(),Toast.LENGTH_LONG).show();
}
}
else
Toast.makeText(this, "學號和姓名出生日期不能為空!", Toast.LENGTH_LONG).show();
}
if(v==bdel)
{
if(ecode.getText().toString().trim().length()!=0)
{
try
{
String sql="delete from user where ecode='"+ecode.getText()+"'";
db.execSQL(sql);
Toast.makeText(this, "成功刪除!", Toast.LENGTH_LONG).show();
ecode.setText("");
}
catch(Exception e)
{
Toast.makeText(this, "出錯了!", Toast.LENGTH_LONG).show();
}
}
}
if(v==bupdate)
{
if(ecode.getText().toString().trim().length()!=0 && ename.getText().toString().trim().length()!=0 && ebirth.getText().toString().trim().length()!=0)
{
try
{
String sql="update user set ecode='"+ecode.getText() +"',ename='"+ename.getText()+"',birthday='" +ebirth.getText()+"'where code='" +ecode.getText()+"''";
db.execSQL(sql);
Toast.makeText(this, "成功更新!", Toast.LENGTH_LONG).show();
ecode.setText("");
ename.setText("");
ebirth.setText("");
}
catch(Exception e)
{
Toast.makeText(this, "出錯了!"+e.getMessage(),Toast.LENGTH_LONG).show();
}
}
else
Toast.makeText(this, "學號姓名出生日期不能為空!", Toast.LENGTH_LONG).show();
}
if(v==bsele)
{
if(ecode.getText().toString().trim().length()!=0)
{
try
{
List all=new ArrayList();
String sql="select * from user where ecode =? or ename =? or ebirth =? ";
Cursor result=this.db.rawQuery(sql, null);
for(result.moveToFirst();!result.isAfterLast();result.moveToNext())
{
all.add("["+result.getString(0)+"]"+""+result.getString(1)+","+result.getString(2));
}
datashow.setAdapter(ListAdapter);
new ArrayAdapter(this, android.R.layout.simple_expandable_list_item_1,all);
}
catch(Exception f)
{
Toast.makeText(this, "顯示不了", Toast.LENGTH_LONG).show();
}
}
}
db.close();
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
}
MyDBHelper.java
package com.example.sqlite;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
public class MyDBHelper extends SQLiteOpenHelper{
public MyDBHelper(Context context)
{
super(context,"mvdb.db",null,1);
}
public void onCreate(SQLiteDatabase db)
{
String sql="create table user(ecode text,ename text,ebirth text);";
db.execSQL(sql);
}
public void onUpgrade(SQLiteDatabase db,int arg1,int arg2)
{
String sql="create table user(ecode text,ename text,ebirth text);";
db.execSQL(sql);
this.onCreate(db);
}
}
如果需要更新數據庫,需要每次將版本升高,你的版本始終都是一,還有,建議你將數據庫的操作封裝成工具類,這樣清晰