合肥師范android實驗報告材料實驗五

1、實驗報告課程名稱：移動設(shè)備平臺開發(fā)院 系：計算機學(xué)院專業(yè)班級：軟件工程學(xué) 號：學(xué)生：開課時間：2017至2018學(xué)年第 一學(xué)期師學(xué)院計算機學(xué)院移動設(shè)備平臺開發(fā)課程驗證性實驗報告實驗名稱用戶登錄注冊數(shù)據(jù)庫版功能實現(xiàn)實驗時間2017. 10.31學(xué)生實驗地點實驗室同組人員無專業(yè)班級軟件一班1、實驗?zāi)康模?1) .設(shè)計登錄界面和注冊頁面；(2) .實現(xiàn)用戶的注冊(存入到數(shù)據(jù)庫)；(3) .從數(shù)據(jù)庫中讀入數(shù)據(jù)，實現(xiàn)登錄；(4) .登錄成功后來到歡迎頁；2、實驗主要儀器設(shè)備和材料：硬件：微型計算機軟件：Eclipse、JDK SDK ADT3 實驗原理：An droid基本類的使用SQLite數(shù)據(jù)庫的基

2、本使用，創(chuàng)建數(shù)據(jù)庫，實現(xiàn)增刪改查4、實驗步驟和代碼：(1) .倉 U建登錄頁面 logi n ma in .xml , welcome mai n.xml比較簡單，不復(fù)制代碼了(2) .創(chuàng)建MyDatabaseHelper,管理數(shù)據(jù)庫publicclass MyDatabaseHelperextends SQLiteOpenHelperprivateContextmContext ;privatefinalstaticStringCREATE_USER = "createtable User(" +"id integerprimarykey autoincreme

3、nt,"+"username varchar(30),"+"password varchar(30)"public MyDatabaseHelper(Context context, String name, CursorFactory factory,int version) super (context, name, factory, version);/ TODOAuto-generated constructor stub mContext = context;Overridepublic void onCreate(SQLiteDat

4、abase db) / TODOAuto-generated method stub db.execSQL( CREATE_USER);Toast. makeText ( mContext , "create database sccussful!"Toast. LENGTH_SHORT).show();Overridepublicvoid onUpgrade(SQLiteDatabase db,/TODOAuto-generated method stubint oldVersion,intnewVerison) (3).創(chuàng)建個User的javabean存儲數(shù)據(jù)priva

5、teint id ;privateStringusername ;privateStringpassword ;寫出getter和 setter方法，構(gòu)造函數(shù)(4 )注冊功能的實現(xiàn)super .onCreate(savedlnstanceState); setContentView(R .l ayout.register_main );username = (EditText)findViewByld(R.id. password = (EditText)findViewByld(R.id. register = (Button)findViewByld(R.id. myDBHelper =

6、new MyDatabaseHelper(ed_name );ed_pass );bt_register);this , "user.db", null ,1);register .setOnClickListener(new OnClickListener() Overridepublic void onClick(View argO) / TODOAuto-generated method stubString name =username .getText().toString();String pass =password .getText().toString()

7、;Users user = new Users();user.setUsername(name);user.setPassword(pass);SQLiteDatabase db= myDBHelper .getWritableDatabase();ContentValues values =new ContentValues();values.put( "username" , name);values.put( "password" , pass);db.insert( "user" , null , values);Toast.

8、 makeText (getApplicationContext(),Toast. LENGTH_SHORT).show();Intent intent =newlntent(getApplicationContext(),MainActivity. startActivity(intent););(4).登錄功能的實現(xiàn)class );protected void onCreate(Bundle savedInstanceState) super .onCreate(savedInstanceState); setContentView(R .l ayout.login_main );user

9、name = (EditText)findViewByld(R.id.password = (EditText)findViewByld(R.id.ed_name ); ed_pass );login = (Button)findViewByld(R.id.bt_login );myDBHelper = new MyDatabaseHelper(this , "user.db" , null ,1);login .setOnClickListener(new OnClickListener() Overridepublic void onClick(View arg0) /

10、 TODOAuto-generated method stubString usernameString =username .getText().toString();String passwordString =password .getText().toString();SQLiteDatabase db =myDBHelper .getWritableDatabase();newString sql= "select * from user where username=? and password=?" Cursor cursor=db.rawQuery(sql,

11、true )welcome_main );StringusernameString,passwordString);if (cursor.moveToFirst()= setContentView(R .1 ayout.cursor.close(); elseToast. makeText (getApplicationContext(),Toast. LENGTH_LONG).show(););5、實驗現(xiàn)象、實驗數(shù)據(jù)記錄:(1)注冊界面：(2).登錄頁面H EaBM 小込口mtc 凸 邁FM歡心登陸F-!0FM&TH 11«4Wl工(3).成功頁面0wi寺品持顒kiMH.«»J13 A"'a * io 冊Qo電I® ® ® <j 1更0Tf蓼耐FT W徒錄