问题描述
这是我参考别人的代码的，明明一模一样，为什么在我的android项目里就无法正常运行，这是我的毕业论文，马上要检查了，求各位大神帮帮忙。packagecom.example.re;importcom.example.re.DateBaseConfig;importandroid.content.ContentValues;importandroid.content.Context;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.database.sqlite.SQLiteOpenHelper;publicclassSQLiteHelperextendsSQLiteOpenHelper{privatestaticfinalStringm_DataBaseName="infDateBase";privatestaticfinalintm_Version=1;publicSQLiteHelper(Contextcontext){//创建一个名为GetDataBaseName的数据库super(context,GetDataBaseName(),null,GetVersion());}@OverridepublicvoidonCreate(SQLiteDatabasearg0){//TODOAuto-generatedmethodstub}@OverridepublicvoidonUpgrade(SQLiteDatabasearg0,intarg1,intarg2){//TODOAuto-generatedmethodstub}publicvoidInit(SQLiteDatabasearg0){String_SqlText="Select*Fromsqlite_masterWheretype='table'ANDname='ranking'";Cursor_Cursor=arg0.rawQuery(_SqlText,null);//Log.i("你好","有表");if(_Cursor.getCount()==0){//Log.i("你好","没ranking表");_SqlText="CreateTABLEranking([UserName]varchar(10)NOTNULL,[Score]integerNOTNULL"+",[Date]varchar(50)NOTNULL)";arg0.execSQL(_SqlText);//Date_date=newDate();ContentValues_ContentValues=newContentValues();_ContentValues.put("UserName","mYI");_ContentValues.put("Score",1);//SimpleDateFormatformat=newSimpleDateFormat("yyyy-MM-ddHH:mm:ss");_ContentValues.put("Date","2013年10月1日");arg0.insert("ranking",null,_ContentValues);}}publicstaticStringGetDataBaseName(){returnm_DataBaseName;}publicstaticintGetVersion(){returnm_Version;}}
下面是RankActivity的代码，我试过将protectedvoidonStart（）的代码注释掉之后就可以到处界面，到底哪里错了？packagecom.example.re;importandroid.app.Activity;importandroid.database.Cursor;importandroid.database.sqlite.SQLiteDatabase;importandroid.os.Bundle;importandroid.view.View;importandroid.widget.TextView;//importjava.io.InputStream;importcom.example.eluosifangkuai.R;importcom.example.re.SQLiteHelper;publicclassRankActivityextendsActivity{privateViewm_view;privateTextViewm_textview_ranking_num;privateTextViewm_textview_ranking_name;privateTextViewm_textview_ranking_score;privateTextViewm_textview_ranking_date;privateSQLiteHelperm_SqLiteHelper=newSQLiteHelper(this);privateSQLiteDatabasem_SQLiteDatabase;//@OverrideprotectedvoidonCreate(BundlesavedInstanceState){//TODOAuto-generatedmethodstubsuper.onCreate(savedInstanceState);setContentView(R.layout.activity_ranking);m_view=(View)findViewById(R.id.RankingActivity);m_textview_ranking_num=(TextView)findViewById(R.id.textview_ranking1);m_textview_ranking_name=(TextView)findViewById(R.id.textview_ranking2);m_textview_ranking_score=(TextView)findViewById(R.id.textview_ranking3);m_textview_ranking_date=(TextView)findViewById(R.id.textview_ranking4);m_SQLiteDatabase=m_SqLiteHelper.getWritableDatabase();}//@OverrideprotectedvoidonStart(){//TODOAuto-generatedmethodstubintnum=0;Stringstr;//LoadBkGd();m_textview_ranking_num.setText("");m_textview_ranking_name.setText("");m_textview_ranking_score.setText("");m_textview_ranking_date.setText("");String_SqlText="Select*FromrankingorderbyScoredesc";Cursor_CursorB=m_SQLiteDatabase.rawQuery(_SqlText,null);while(_CursorB.moveToNext()){num++;m_textview_ranking_num.setText(m_textview_ranking_num.getText().toString()+num+"n");str=_CursorB.getString(_CursorB.getColumnIndex("UserName"))+"n";m_textview_ranking_name.setText(m_textview_ranking_name.getText().toString()+str);str=_CursorB.getInt(_CursorB.getColumnIndex("Score"))+"n";m_textview_ranking_score.setText(m_textview_ranking_score.getText().toString()+str);str=_CursorB.getString(_CursorB.getColumnIndex("Date"))+"n";m_textview_ranking_date.setText(m_textview_ranking_date.getText().toString()+str);}super.onStart();}}
解决方案
解决方案二：
找到了，我太傻了，漏了一句这个m_SqLiteHelper.Init(m_SQLiteDatabase);