新那Android的项目,我只贴出Activity类和连接数据库类
- Java code
ActivityMian.java package cn.nit.android; import android.app.Activity; import android.content.Context; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.os.Bundle; import android.util.Log; import android.view.View; import android.widget.Button; public class ActivityMain extends Activity implements Button.OnClickListener { /** Called when the activity is first created. */ private static String DATABASE_NAME = "Android.db";//数据库名 private static int DATABASE_VERSION = 1; private static String TABLE_NAME="android"; private static String TITLE = "title"; private static String BODY = "body"; private Button delButton,delDBButton,insertButton,reCreateButton,selectButton; private DatabaseHelper mOpenHelper; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setLayoutShow(R.layout.main); UIinit(); logic(); } private void UIinit() { delButton = (Button)findViewById(R.id.delButton); delDBButton = (Button)findViewById(R.id.delDBButton); insertButton = (Button)findViewById(R.id.insertButton); reCreateButton = (Button)findViewById(R.id.reCreateButton); selectButton = (Button)findViewById(R.id.selectButton); mOpenHelper = new DatabaseHelper(this); } private void logic(){ delButton.setOnClickListener(this); delDBButton.setOnClickListener(this); insertButton.setOnClickListener(this); reCreateButton.setOnClickListener(this); selectButton.setOnClickListener(this); } private void setLayoutShow(int layoutID){ setContentView(layoutID); } @Override public void onClick(View v) { // TODO Auto-generated method stub switch(v.getId()){ case R.id.delButton: delItem(); break; case R.id.delDBButton: delDB(); break; case R.id.insertButton: insertItem(); break; case R.id.reCreateButton: createDB(); break; case R.id.selectButton: selectItem(); break; } } private void createDB() { // TODO Auto-generated method stub } private void selectItem() { // TODO Auto-generated method stub } private void insertItem() { // TODO Auto-generated method stub SQLiteDatabase db = mOpenHelper.getWritableDatabase();//负责得到一个可写的数据库 String sql1 = "insert into"+TABLE_NAME+"("+TITLE+","+BODY+")value('haiyang','android的发展迅速1'"; String sql2 = "insert into"+TABLE_NAME+"("+TITLE+","+BODY+")value('icesky','android的发展迅速2'"; try{ Log.i("haiyang:sql", sql1); Log.i("haiyang:sq2", sql2); db.execSQL(sql1); db.execSQL(sql1); setTitle("插入两条数据成功"); }catch(SQLException e){ setTitle("插入两条数据失败"); } } private void delDB() { // TODO Auto-generated method stub } private void delItem() { // TODO Auto-generated method stub } }
- Java code
DatabaseHelper.java package cn.nit.android; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class DatabaseHelper extends SQLiteOpenHelper{ private static String DATABASE_NAME = "Android.db";//数据库名 private static int DATABASE_VERSION = 1; private static String TABLE_NAME="android"; private static String TITLE = "title"; private static String BODY = "body"; DatabaseHelper(Context context){ super(context,DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub String sql = "create table"+TABLE_NAME+"("+TITLE+"text not null,"+BODY+"text not null"+");"; Log.i("haiyang:createDB=",sql); db.execSQL(sql); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub } }