android小项目打地鼠（五）

打地鼠1.0版本已经完成，算一期工程完成了吧。0.9版本实现了数据的存储，1.0版本做了不少测试，修复了一些bug，优化了一下代码。

代码多，贴出来太占地方了，就把和0.9版本相关的数据库方面的文件贴一下。

DBHelper.java

package com.fsy.hitmouse;import android.content.Context;import android.database.sqlite.SQLiteDatabase;import android.database.sqlite.SQLiteOpenHelper;import android.database.sqlite.SQLiteDatabase.CursorFactory;/** * 管理记录数据库 * @author Fsy * */public class DBHelper extends SQLiteOpenHelper{private static int VERSION = 1;public DBHelper(Context context, String name, CursorFactory factory,int version) {super(context, name, factory, version);}public DBHelper(Context context, String name, int version) {this(context, name,null, version);}public DBHelper(Context context, String name) {this(context, name,VERSION);}@Overridepublic void onCreate(SQLiteDatabase db) {db.execSQL("create table winner(name varchar(20),score int)");Manage.DB_flag = true;}@Overridepublic void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {}}

InputActivity.java

package com.fsy.hitmouse;import android.app.Activity;import android.content.ContentValues;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.EditText;/** * 输入玩家信息的Activity * @author Fsy * */public class InputActivity extends Activity{Button b;EditText editText;String name;boolean flag;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState); setContentView(R.layout.input);setTitle(" 给力啊    果然犀利~ ");editText = (EditText)findViewById(R.id.winner_name);b = (Button)findViewById(R.id.button_yes);b.setOnClickListener(new OnClickListener() {public void onClick(View v) {flag = false;if (!(name=editText.getText().toString()).equals("")) {ContentValues values = new ContentValues();values.put("name", name);values.put("score", Manage.score);Manage.activitymain.dbwrite.insert("winner", null, values);flag = true;}if(flag){finish();}}});}}

ListScoreActivity.java

package com.fsy.hitmouse;import android.app.Activity;import android.database.Cursor;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.TextView;/** * 列出排名的Activity * @author Fsy * */public class ListScoreActivity extends Activity{/** * 排名，共5个 */TextView t[];Button b;String name;String score;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setTitle("打地鼠英雄榜");setContentView(R.layout.list_score);t = new TextView[5];t[0]= (TextView)findViewById(R.id.text1);t[1]= (TextView)findViewById(R.id.text2);t[2]= (TextView)findViewById(R.id.text3);t[3]= (TextView)findViewById(R.id.text4);t[4]= (TextView)findViewById(R.id.text5);Cursor cursor = Manage.activitymain.dbread.query("winner", null, null, null, null, null, "score desc");int temp=0;while(cursor.moveToNext()){name = cursor.getString(cursor.getColumnIndex("name"));score = cursor.getString(cursor.getColumnIndex("score"));if(temp>4) break;t[temp].setText(name+"    "+score);temp++;}b= (Button)findViewById(R.id.button_list);b.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {finish();}});}}

ScoreActivity.java

package com.fsy.hitmouse;import android.app.Activity;import android.os.Bundle;import android.view.View;import android.view.View.OnClickListener;import android.widget.Button;import android.widget.TextView;/** * 未破纪录的玩家分数Activity * @author Fsy * */public class ScoreActivity extends Activity{TextView text;Button b;@Overrideprotected void onCreate(Bundle savedInstanceState) {super.onCreate(savedInstanceState);setTitle("还差一点，没破记录");setContentView(R.layout.score);text = (TextView)findViewById(R.id.text_show_score);text.setText("你的分数为： "+Manage.score);b= (Button)findViewById(R.id.button_show_score);b.setOnClickListener(new OnClickListener() {@Overridepublic void onClick(View v) {finish();}});}}

TimeHandler.java

package com.fsy.hitmouse;import android.content.ContentValues;import android.content.Intent;import android.database.Cursor;import android.os.Handler;import android.os.Looper;import android.os.Message;/** * 管理进度条更新的Handler * @author Fsy * */public class TimeHandler extends Handler{Intent t;public TimeHandler(Looper looper) {super(looper);}@Overridepublic void handleMessage(Message msg) {Manage.activitymain.progressbar.setProgress(Manage.passed_time);//处理第一次创建数据库时表为空的情况，应该还有更好的解决方法？if(Manage.DB_flag){ContentValues values = new ContentValues();values.put("name", "fsy");values.put("score", 0);Manage.activitymain.dbwrite.insert("winner", null, values);Manage.DB_flag = false;}if (Manage.passed_time>=100) {Manage.make_mouse = false;Cursor cursor = Manage.activitymain.dbread.query("winner", null, null, null, null, null, "score desc");int counter=0;while(cursor.moveToNext()){if(counter == 5){break;}if (Manage.score >cursor.getInt(cursor.getColumnIndex("score"))) {t = new Intent();t.setClass(Manage.activitymain, InputActivity.class);Manage.activitymain.startActivity(t);break;}counter++;}if(counter == 5){t = new Intent();t.setClass(Manage.activitymain, ScoreActivity.class);Manage.activitymain.startActivity(t);}}}}

更多相关文章

随机推荐