level 5
江心磐
楼主
辅助类DatabaseHelper 如下:
package com.example.administrator.myapp1;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Administrator on 2016-05-31.
*/
public class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory,
int version) {
super(context, name, factory, version);
}
//辅助类建立时运行该方法
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "CREATE TABLE CARD (_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , fileName VARCHAR, description VARCHAR)";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
实现代码:
String dbname="db_sds";
String tablename_card="CARD";
String fileName="fileName";
String description="description";
DatabaseHelper mOpenHelper=new DatabaseHelper(this,dbname,null,124);
SQLiteDatabase db=mOpenHelper.getWritableDatabase();
String sql1="insert into "+tablename_card+"("+fileName+","+description+") values('lilei','man');";
textView.setText(sql1);
db.execSQL(sql1);
setTitle("插入成功");
按理说,DatabaseHelper mOpenHelper=new DatabaseHelper(this,dbname,null,124);这句应该是创建一个名为dbname的数据库,可是我试了出错。而如果dbname换成tablename_card就没问题,可是我现在是在创建数据库,为什么要用表名才正确?
2016年06月01日 07点06分
1
package com.example.administrator.myapp1;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
/**
* Created by Administrator on 2016-05-31.
*/
public class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory,
int version) {
super(context, name, factory, version);
}
//辅助类建立时运行该方法
@Override
public void onCreate(SQLiteDatabase db) {
String sql = "CREATE TABLE CARD (_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL , fileName VARCHAR, description VARCHAR)";
db.execSQL(sql);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
实现代码:
String dbname="db_sds";
String tablename_card="CARD";
String fileName="fileName";
String description="description";
DatabaseHelper mOpenHelper=new DatabaseHelper(this,dbname,null,124);
SQLiteDatabase db=mOpenHelper.getWritableDatabase();
String sql1="insert into "+tablename_card+"("+fileName+","+description+") values('lilei','man');";
textView.setText(sql1);
db.execSQL(sql1);
setTitle("插入成功");
按理说,DatabaseHelper mOpenHelper=new DatabaseHelper(this,dbname,null,124);这句应该是创建一个名为dbname的数据库,可是我试了出错。而如果dbname换成tablename_card就没问题,可是我现在是在创建数据库,为什么要用表名才正确?