/**
以下是一个SQLiteOpenHelper类
*/
public class DataBaseHelper extends SQLiteOpenHelper
{
private static final String CREAT_TABLE_SQL = "CREAT TABLE CollTbl(_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,url TEXT,dest TEXT)";
private SQLiteDatabase db;
private static final String DB_NAME = "coll.db";
private static final String TBL_NAME = "CollTbl"; DataBaseHelper(Context c)
{
super(c,DB_NAME,null,2);
}
@Override
public void onCreate(SQLiteDatabase db)
{
// TODO Auto-generated method stub
this.db = db;
db.execSQL(CREAT_TABLE_SQL);
}
........
}
/**
下面是mainActivity
*/
public class AddActivity extends Activity{
private EditText name_text,url_text,desc_edit;
private Button add_button;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.web);
setTitle("添加收藏信息");
name_text = (EditText) findViewById(R.id.editName);
url_text = (EditText) findViewById(R.id.editUrl);
desc_edit = (EditText) findViewById(R.id.editDesc);
add_button = (Button) findViewById(R.id.addButton);
add_button.setOnClickListener(new OnClickListener()
{
@Override
public void onClick(View v)
{
String name = name_text.getText().toString();
String url = url_text.getText().toString();
String desc = desc_edit.getText().toString();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("url", url);
values.put("desc", desc);
}
});
}
仿造一个文档的例子 试试android的数据库操作 结果悲剧了,每次按一下添加按钮(add_button)就会报错提示force close 查看了下LOG-->Failure 1(near "CREAT":syntax error)on xxx when preparing 'CREAT TABLE CollTbl(_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,url TEXT,dest TEXT)'这是不是说明时creat table时出错了呢? 但是这个creat sql语句和文档上的一样 应该不会有错的 求解释.
以下是一个SQLiteOpenHelper类
*/
public class DataBaseHelper extends SQLiteOpenHelper
{
private static final String CREAT_TABLE_SQL = "CREAT TABLE CollTbl(_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,url TEXT,dest TEXT)";
private SQLiteDatabase db;
private static final String DB_NAME = "coll.db";
private static final String TBL_NAME = "CollTbl"; DataBaseHelper(Context c)
{
super(c,DB_NAME,null,2);
}
@Override
public void onCreate(SQLiteDatabase db)
{
// TODO Auto-generated method stub
this.db = db;
db.execSQL(CREAT_TABLE_SQL);
}
........
}
/**
下面是mainActivity
*/
public class AddActivity extends Activity{
private EditText name_text,url_text,desc_edit;
private Button add_button;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.web);
setTitle("添加收藏信息");
name_text = (EditText) findViewById(R.id.editName);
url_text = (EditText) findViewById(R.id.editUrl);
desc_edit = (EditText) findViewById(R.id.editDesc);
add_button = (Button) findViewById(R.id.addButton);
add_button.setOnClickListener(new OnClickListener()
{
@Override
public void onClick(View v)
{
String name = name_text.getText().toString();
String url = url_text.getText().toString();
String desc = desc_edit.getText().toString();
ContentValues values = new ContentValues();
values.put("name", name);
values.put("url", url);
values.put("desc", desc);
}
});
}
仿造一个文档的例子 试试android的数据库操作 结果悲剧了,每次按一下添加按钮(add_button)就会报错提示force close 查看了下LOG-->Failure 1(near "CREAT":syntax error)on xxx when preparing 'CREAT TABLE CollTbl(_id INTEGER PRIMARY KEY AUTOINCREMENT,name TEXT,url TEXT,dest TEXT)'这是不是说明时creat table时出错了呢? 但是这个creat sql语句和文档上的一样 应该不会有错的 求解释.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货