关于android的sqlite问题,关于SQlite的问题

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

package sqliteshuju;

import android.content.Context;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteDatabase.CursorFactory;

import android.database.sqlite.SQLiteOpenHelper;

public class sqlitetext extends SQLiteOpenHelper{

private static final int VERSION =1;

public sqlitetext(Context context, String name, CursorFactory factory,

int version) {

super(context, name, factory, version);

// TODO Auto-generated constructor stub

}

public sqlitetext(Context context, String name){

this(context,name, VERSION);

}

public sqlitetext(Context context,String name,int version){

this(context,name,null,VERSION);

}

@Override

public void onCreate(SQLiteDatabase db) {

// TODO Auto-generated method stub

db.execSQL("Create table user(id int,name varchar(20))");

}

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

// TODO Auto-generated method stub platform-

System.out.println("ssss");

}

}

-----------------------------------------

public class Youxi6Activity extends Activity {

private Button chuangjian=null;

private Button charu=null;

private TextView text=null;

/** Called when the activity is first created. */

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

chuangjian=(Button)findViewById(R.id.chuangjian);

charu=(Button)findViewById(R.id.charu);

text=(TextView)findViewById(R.id.ceshi);

chuangjian.setOnClickListener(new chuangjianshujuku());

charu.setOnClickListener(new charushuju());

}

class chuangjianshujuku implements OnClickListener{

public void onClick(View v) {

// TODO Auto-generated method stub

sqlitetext st=new sqlitetext(Youxi6Activity.this,"sqlshujuku");

SQLiteDatabase db=st.getReadableDatabase();

}

}

class charushuju implements OnClickListener{

public void onClick(View v) {

// TODO Auto-generated method stub

ContentValues cv=new ContentValues();

cv.put("id", 1);

cv.put("name", "yuandaw");

sqlitetext st=new sqlitetext(Youxi6Activity.this,"sqlshujuku");

SQLiteDatabase db=st.getWritableDatabase();

db.insert("user", null, cv);

text.setText("yuandaw");

}

}

}

之后我在cmd中进入到数据库输入命令什么也出不来 郁闷死了！！

sqlite3 sqlshujuku

SQLite version 3.5.9

Enter ".help" for instructions

sqlite> .schema

.schema

CREATE TABLE android_metadata (locale TEXT);

CREATE TABLE user(id int,name varchar(20));

sqlite> select * from user