关于sqlite数据库的异常,小弟我该如何解决呢,刚接触android开发
关于sqlite数据库的错误,我该怎么解决呢,刚接触android开发
数据库测试类
public class BihuaServiceTest extends AndroidTestCase{
private static final String TAG="BihuaServiceTest";
public void testCreateDB()throws Throwable{
MyOpenHelper myopenhelper=new MyOpenHelper(this.getContext());
myopenhelper.getWritableDatabase();//第一次调用该方法就会创建数据库
}
public BihuaServiceTest(){}
//测试增加
public void testAdd()throws Throwable
{
BihuaService biHuaService=new BihuaService(this.getContext());
Bihua bihua=new Bihua();
bihua.setBiduan("横");
bihua.setBiduanxl("1");
bihua.setZimu("a");
biHuaService.Add(bihua);
bihua=new Bihua();
bihua.setBiduan("竖");
bihua.setBiduanxl("2");
bihua.setZimu("b");
biHuaService.Add(bihua);
bihua=new Bihua();
bihua.setBiduan("撇");
bihua.setBiduanxl("3");
bihua.setZimu("c");
biHuaService.Add(bihua);
}
public void testDelete()throws Throwable{
BihuaService bihuaService=new BihuaService(this.getContext());
bihuaService.Delete("撇");
}
//测试查询
public void testFind() throws Throwable
{
BihuaService bihuaService=new BihuaService(this.getContext());
String result=bihuaService.Find("1");
Log.i(TAG, result);
}
}
下面是MyOpenHelper类
public class MyOpenHelper extends SQLiteOpenHelper {
public static final String DBNAME="androidybhy.db";
public static final int VERSION=1;
public static final String CREATETB1="CREATE TABLE bihua (biduan string , biduanxl string ,zimu string)";
public static final String CREATETB2="CREATE TABLE Word (ziti string , bihuashumu string ,bihuaxulie string)";
public static final String CREATETB3="CREATE TABLE zib (zi string ,tz string ,bh int)";
public static final String CREATETB4="CREATE TABLE ziyinyi (zi string ,pinyin string ,ziyi string , yingyu string ,bihua string, bushou string,shuxing string)";
public MyOpenHelper(Context context) {
super(context, DBNAME, null, VERSION);
// TODO 自动生成的构造函数存根
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATETB1);
db.execSQL(CREATETB2);
db.execSQL(CREATETB3);
db.execSQL(CREATETB4);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
下面是activity里面的部分内容
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button button;
button=(Button)findViewById(R.id.testsqlite);
// button.setOnClickListener(new OnClickListener(){
// @Override
// public void onClick(View v) {
// //@SuppressWarnings("unused")
// BihuaServiceTest bihuaServiceTest=new BihuaServiceTest(this);
数据库测试类
public class BihuaServiceTest extends AndroidTestCase{
private static final String TAG="BihuaServiceTest";
public void testCreateDB()throws Throwable{
MyOpenHelper myopenhelper=new MyOpenHelper(this.getContext());
myopenhelper.getWritableDatabase();//第一次调用该方法就会创建数据库
}
public BihuaServiceTest(){}
//测试增加
public void testAdd()throws Throwable
{
BihuaService biHuaService=new BihuaService(this.getContext());
Bihua bihua=new Bihua();
bihua.setBiduan("横");
bihua.setBiduanxl("1");
bihua.setZimu("a");
biHuaService.Add(bihua);
bihua=new Bihua();
bihua.setBiduan("竖");
bihua.setBiduanxl("2");
bihua.setZimu("b");
biHuaService.Add(bihua);
bihua=new Bihua();
bihua.setBiduan("撇");
bihua.setBiduanxl("3");
bihua.setZimu("c");
biHuaService.Add(bihua);
}
public void testDelete()throws Throwable{
BihuaService bihuaService=new BihuaService(this.getContext());
bihuaService.Delete("撇");
}
//测试查询
public void testFind() throws Throwable
{
BihuaService bihuaService=new BihuaService(this.getContext());
String result=bihuaService.Find("1");
Log.i(TAG, result);
}
}
下面是MyOpenHelper类
public class MyOpenHelper extends SQLiteOpenHelper {
public static final String DBNAME="androidybhy.db";
public static final int VERSION=1;
public static final String CREATETB1="CREATE TABLE bihua (biduan string , biduanxl string ,zimu string)";
public static final String CREATETB2="CREATE TABLE Word (ziti string , bihuashumu string ,bihuaxulie string)";
public static final String CREATETB3="CREATE TABLE zib (zi string ,tz string ,bh int)";
public static final String CREATETB4="CREATE TABLE ziyinyi (zi string ,pinyin string ,ziyi string , yingyu string ,bihua string, bushou string,shuxing string)";
public MyOpenHelper(Context context) {
super(context, DBNAME, null, VERSION);
// TODO 自动生成的构造函数存根
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATETB1);
db.execSQL(CREATETB2);
db.execSQL(CREATETB3);
db.execSQL(CREATETB4);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
下面是activity里面的部分内容
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
Button button;
button=(Button)findViewById(R.id.testsqlite);
// button.setOnClickListener(new OnClickListener(){
// @Override
// public void onClick(View v) {
// //@SuppressWarnings("unused")
// BihuaServiceTest bihuaServiceTest=new BihuaServiceTest(this);