当前位置: 代码迷 >> Android >> android SQLite设计 设计就出错了 帮解决 多谢
  详细解决方案

android SQLite设计 设计就出错了 帮解决 多谢

热度:142   发布时间:2016-05-01 22:26:00.0
android SQLite设计 设计就出错了 帮解决 谢谢
新那Android的项目,我只贴出Activity类和连接数据库类
Java code
ActivityMian.javapackage 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.javapackage 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    }}
  相关解决方案