哎，搞了大半天了，数据库的表就是不出来。。大家都看看吧，
package mars.sqlites.db;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;
public class DatabaseHelper extends SQLiteOpenHelper {
private static final int VERSION = 1;
public DatabaseHelper(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
}
public DatabaseHelper(Context context, String name) {
this(context, name, VERSION);
}
public DatabaseHelper(Context context, String name, int version) {
this(context, name, null, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
try {
db.execSQL("create table teacher(id int,name varchar(20))");
db.endTransaction();
} catch (Exception e) {
e.printStackTrace();
}
System.out.println("create a database");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
}
}
=========================================================
package mars.sqlites;
import mars.sqlites.db.DatabaseHelper;
import android.app.Activity;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
public class SQLiteActivity extends Activity {
private Button createButton = null;
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
createButton = (Button)findViewById(R.id.create);
createButton.setOnClickListener(new CreateListener());
}
class CreateListener implements OnClickListener{
@Override
public void onClick(View v) {
DatabaseHelper dbhelper = new DatabaseHelper(SQLiteActivity.this, "mars_db");
SQLiteDatabase db = dbhelper.getReadableDatabase();
}
}
}
你进入databases目录下
[code="java"]sqlite3 mars_db 或者 sqlite mars_db ,试试[/code]
你怎么使用sqlites命令，有这个命令吗？
应该是sqlite 【dbname】，如果是sqlite3的话就sqlite3 【dbname】
与"sqlites"目录名没啥关系
你的mars_db已经建出来了，你继续写数据库操作代码，比如你可以先用代码试下select * from teacher看看有没有结果呢